PSC Exam Questions Ms-Excel MCQ Set 1 Solved

PSC Exam Questions Ms-Excel MCQ Set 1

1. Which of the following term describes explanatory text attached to a cell?
A. Context     B. Callout     C. Comment     D. Dialog     E. None of these
➤ Answer: Click hereC. Comment
2. Which of the following function displays row data in a column or column data in a row?
A. Hyperlink     B. Index C.     Transpose     D. Sum         E. None of these
➤ Answer: Click hereC. Transpose
3. Macros can be executed from the ____ menu.
A. Insert     B. Tools     C. Edit         D. Data         E. None of these
➤ Answer: Click hereB. Tools
4. A function inside another function is called a _____ function.
A. Nested     B. Round     C. Sum         D. Text         E. None of these
➤ Answer: Click hereA. Nested
5. Which of the following function is used to enter current time in a worksheet cell?
A. =today()     B. =now()     C. =time()     D. =currentTime()     E. None of these
➤ Answer: Click hereB. =now()
6. Which of the following is the keyboard shortcut for creating a chart from the selected cells?
A. F3         B. F5         C. F7         D. F12         E. F11
➤ Answer: Click hereE. F11
7. Which of the following keyboard shortcut is used to edit existing Excel data?
A. F2         B. F3         C. F1         D. F4         E. F5
➤ Answer: Click hereA. F2
8. A value used in a formula that does not change is called a _______
A. Static     B. Cell         C. Variable     D. Constant     E. Dynamic
➤ Answer: Click hereD. Constant
9. Which of the following is used to convert existing Excel worksheet data and charts to HTML document?
A. External Wizard
B. Intranet Wizard
C. Import Wizard
D. Export Wizard    
E. Internet Assistant Wizard
➤ Answer: Click hereE. Internet Assistant Wizard
10. Which of the following term refers to a set of values that Excel saves and can substitute automatically on your worksheet?
A. Range     B. Scenario     C. Nested     D. What-if analysis     E. None of these
➤ Answer: Click hereB. Scenario
11. In Excel, a typical worksheet has _____ number of columns.
A. 12,384     B. 15,684     C. 16,384         D. 13,484    E. None of these
➤ Answer: Click hereC. 16,384 Columns
12. In Excel, a typical worksheet has _____ number of rows.
A. 1,048,576    B. 1,015,684    C. 1,016,384    D. 1,013,484    E. None of these
➤ Answer: Click hereA. 1,048,576
13. Which of the following symbol is used before a number to make it a label?
A. ” (quote)     B. = (equal)     C. _ (underscore)     D. ‘ (apostrophe)     E. None of these
➤ Answer: Click hereD. ‘ (apostrophe)
14. In Excel, a typical worksheet has _______ column width
A. 250 Characters
B. 512 Characters
C. 255 Characters
D. 612 Characters
E. None of these
➤ Answer: Click hereC. 255 Characters
15. Which of the following is the maximum limit of the height of a row in an Excel Sheet?
A. 209 points     B. 309 points     C. 509 points     D. 409 points     E. None of these
➤ Answer: Click hereD. 409 points
16. What is the maximum number of line feeds per cell in an Excel Sheet?
A. 253         B. 250         C. 257         D. 212         E. 211
➤ Answer: Click hereA. 253
17. What is the maximum limit of characters in a header or footer in an Excel Sheet?
A. 253         B. 255         C. 257         D. 212         E. 211
➤ Answer: Click hereB. 255
18. What is the minimum Zoom range in an Excel Sheet?
A. 8%         B. 10%         C. 12%         D. 20%         E. None of these
➤ Answer: Click hereB. 10%
19. What is the maximum Zoom range in an Excel Sheet?
A. 100%     B. 200%     C. 300%     D. 400%     E. None of these
➤ Answer: Click hereD. 400%
20. What is the maximum limit of available worksheet functions?
A. 141         B. 231         C. 341         D. 421         E. None of these
➤ Answer: Click hereC. 341