Computer Knowledge Quiz (MS Excel) - Set 4

sponsored links

1. ______________ moves to the previous cell in a worksheet or the previous option in a dialog box.
1. Shift+Tab
2. Ctrl+Tab
3. Alt+Tab
4. Esc+Tab
5. None of these
2. __________ are equations that preform calculations on values in your worksheet.
1. Functions
2. References
   
3. Formulas
4. Constants
5. None of these
3. In MS Excel a formula starts with 
1. A Plus Sign (+)
2. A Minus Sign (-)
3. A Greater Than Sign (>)
4. An Equal Sign (=)
5. None of these
4. Which of the following is not a term pertaining to spreadsheets ?
1. Formula
2. Cell
3. Browser
4. Character
5. None of these
5. What is the name of the package which helps to create, manipulate and analyse the data arranged in rows and columns ?
1. Application package
2. Word processing package
3. Outline package
4. Outline processors
5. Spreadsheet package
6. In ____________ tab you will find AutoSum button.
1. Formatting tab
2. Formulas tab
3. Standard tab
4. Clipboard tab
5. None of these
7. For opening and closing of the files in Excel, you can use which bar ?
1. Formatting
2. Standing
3. Title
4. Formatting or Title
5. None of these
8. The view that puts a blue line around each page that wold be printed is the __________
1. Split view
2. Page break preview
3. Print preview
4. Normal view
5. None of these
9. Which Excel feature enables predefined layouts to selected tables in the worksheet ?
1. Autoformat
2. Header and Footers
3. Undo and Redo
4. Spelling and Grammar
5. Autograph
10. What does an electronic spreadsheet consist of ?
1. Rows
2. Columns
3. Cells
4. All of these
5. None of these
11. A ____________ is rectangular grid of rows and columns used to enter data. 
1. Cell
2. Workspace
3. Worksheet
4. Spreadsheet
5. Both 3 and 4
12. A, B, C, D, E etc., are used to describe ____________
1. Columns
2. Rows
3. Cells
4. Mixed addressing
5. None of these
13. 1, 2, 3, 4, 5, etc., are used to describe ________________
1. Columns
2. Rows
3. Cells
4. Mixed addressing
5. None of these
14. _____________ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.
1. Rows
2. Cells
3. Columns
4. Headings
5. Range
15. Which of the following is not a valid funciton ?
1. PI ( )
2. SUM ( )
3. 10 (SUM)
4. AND ( )
5. None of these

Read Set 1 from HERE

Read Set 2 from HERE

Read Set 3 from HERE

sponsored links