Computer Awareness Practice Set – 20 (MS Excel)

No. of questions - 20

Time - 10 min

Negative marking : -0.25 mark

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