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