B. Fill in the blanks to complete the following sentences:
1.The
box displays the address of the active cell at any given time.
2.The default number of worksheets in a workbook are-------
3. In an Excel worksheet there are
columns and
rows.
4. Three types of data that can be entered in a cell are-------,-----
and------
5.
is the extension of excel files.
6.
is the shortcut key to go to next worksheet.
7. The option in the Office button menu is used to open an existing workbook.
8. To navigate from one sheet to another
shortcut key is used.
9. The----------------in a formula are automatically updated when it is copied to
other cells in a spreadsheet.
10. The
cell references in a formula always refer to the same cell or cell range in a formula.
11. The
symbolis used to designate an absolute cell reference.
12. A
is a pre-defined formula that helps perform common mathematical functions.
13. The
function finds maximum value in a range passed to it as an argument.
14. Text are
aligned and numbers are-------
aligned in excel.
15. To show a number in scientific notation we need to select Scientific category in the Number tab of the
dialog box.
Answers
Answer:
1. Name Box
2. Sheet1, Sheet2, and Sheet3 3. Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns. 4. labels, values, and formulas 5. The XLS 6. Ctrl + PgDn (page down) for moving to the sheet on the right, and Ctrl + PgUp (page up) for moving to the sheet on the left
7.(Ctrl + O) 8.