Computer Awareness Practice Set – 20 (MS Excel)

No. of questions - 20

Time - 10 min

Negative marking : -0.25 mark

1. 
The total number of rows in a worksheet?
2. 
Excel is a ____ program developed by Microsoft.
3. 
What is the default file name of Microsoft Excel file?
4. 
What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel ?
5. 
The total number of characters that a cell contains is?
6. 
Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not ?
7. 
What is the extension of a Microsoft Excel file?
8. 
Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE ?
9. 
The intersection of a column and a row in a worksheet is called ____.
10. 
Microsoft Excel is used for?
11. 
Shortcut key CTRL + D is used to ____.
12. 
What is the keyboard shortcut to switch between open Excel windows ?
13. 
How many times undo levels can be used in a worksheet ?
14. 
The total number of columns in a worksheet?
15. 
How many users can open the Excel file at the same time ?
16. 
What is the keyboard shortcut to insert a SUM formula in MS Excel ?
17. 
What is the keyboard shortcut to display the Format Cells dialog box in MS Excel ?
18. 
What is the column width in a worksheet?
19. 
How many hyperlinks can be there in a worksheet ?
20. 
What is the collection of worksheets called?
error: Content is protected !!