1. . The default alignment of text in Excel is __________.
(A) centered
(B) left
(C) right
(D) justify
2. . The default alignment of numbers in Excel is __________.
(A) centered
(B) left
(C) justify
(D) right
3. . To enter data on a new line within a cell, the shortcut key is used.
(A) Ctrl + Enter
(B) Alt + Enter
(C) Shift + Enter
(D) None of above
4. . To enter the current date and time in a cell the function is used.
(A) None of these
(B) Today
(C) Date
(D) Now
5. . Example of Arithmetic operators is __________.
(A) >< =
(B) None of above
(C) And Or Not
(D) + - * / ^
6. . Example of Relational operators is __________.
< =')"> (A) And Or Not
< =')"> (B) + - * / ^
< =')"> (C) >< =
< =')"> (D) None of these
7. . Example of Logical operators is __________.
(A) >< =
(B) + - * / ^
(C) None of these
(D) And Or Not
8. . Identify the symbol for exponential power.
(A) *
(B) ^
(C) /
(D) =
9. . Identify the symbol for multiplication.
**Answer: (a) ***
(A) *
(B) /
(C) ^
(D) =
10. . Identify the symbol for division.
(A) *
(B) /
(C) ^
(D) \
11. . The correct example of a cell address.
(A) 11 22
(B) 911
(C) 15A
(D) A15
12. . When you accidentally erased a record in a sheet, the command is used to restore.
(A) Insert
(B) Copy
(C) Undo
(D) Replace
13. . The shortcut key to edit a cell entry is __________.
(A) F1
(B) F2
(C) F3
(D) F4
14. . The keyboard shortcut to open Format Cells dialogue box is __________.
(A) Ctrl + 1
(B) Ctrl + 2
(C) Ctrl + 3
(D) Ctrl + 4
15. . Which symbol is used in cells range?
(A) ;
(B)
(C) “
(D) ?
16. . Correct example of cells range from A1 to F10 is __________.
(A) A1-F10
(B) A1; F10
(C) A1.F10
(D) A1: F10
17. . You can copy cell formats from one cell to another by using the __________.
(A) Backspace key
(B) Default
(C) Format painter
(D) Formatting toolbar
18. . To insert two columns between column C and D you would __________.
(A) select column C
(B) select column D, E, F
(C) select column C, D, E
(D) select column D
19. . The default extension of MS Excel file is __________.
(A) xlsx
(B) xlw
(C) xcl
(D) exl
20. . The process of arranging the items of a column in some sequence is known as __________.
(A) arranging
(B) auto fill
(C) filtering
(D) sorting
21. . The feature of MS Excel quickly completes a series of data.
(A) Filtering
(B) Auto Complete
(C) Sorting
(D) Auto Fill
22. . The keyboard shortcut to get print out of an Excel sheet is __________.
(A) Ctrl + P
(B) Ctrl + E
(C) Ctrl + R
(D) Ctrl + T
23. . If you require more than one hard copies of the worksheet, then enter it in field.
(A) Number of Copies
(B) Copies
(C) Copy
(D) none of above
24. . You can print __________.
(A) Selection
(B) An entire workbook
(C) All of these
(D) A single worksheet
25. . To exit from MS Excel program the shortcut is used.
(A) Shift + F4
(B) Ctrl + F4
(C) Alt + F4
(D) Alt + Ctrl + F4