InterviewSolution
Saved Bookmarks
| 1. |
B. Fill in the blanks to complete the following sentences: 1.Thebox 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 arecolumns androws.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 anothershortcut key is used.9. The----------------in a formula are automatically updated when it is copied toother cells in a spreadsheet.10. Thecell references in a formula always refer to the same cell or cell range in a formula.11. Thesymbolis used to designate an absolute cell reference.12. Ais a pre-defined formula that helps perform common mathematical functions.13. Thefunction finds maximum value in a range passed to it as an argument.14. Text arealigned 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 thedialog box. |
| 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. | |