by 1. What does COUNTA () function do?
A. Counts cells having alphabets
B. Counts empty cells
C. Counts cells having number
D. Counts non-empty cells
ANS. D
2. What is the short cut key to highlight the entire column?
A. Ctrl + C
B. Ctrl + Enter
C. Ctrl + Page Up
D. Ctrl + Space Bar
ANS. D
3. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. ;
ANS. A
4. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
ANS. C
5. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
ANS. D
6. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
ANS. B
7. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above
ANS. D
8. How do you display current date and time in MS Excel?
A. Date ()
B. Today ()
C. Now ()
D. Time ()
ANS. C
9. Excel displays the current cell address in the ________
A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar
ANS. C
10. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. Sheet3!A10
B. Sheet1!A10
C. Sheet3.A10
D. A10
ANS. A
11. Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
ANS. D
12. The first cell in EXCEL worksheet is labeled as
A. AA
B. A1
C. Aa
D. A0
ANS. B
13. Hyperlinks can be
A. Text
B. Drawing objects
C. Pictures
D. All of above
ANS. D
14. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl + Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
ANS. A
15. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
ANS. B
16. Which symbol must all formula begin with?
A. =
B. +
C. (
D. @
ANS. A
17. Which of the following is an mix cell reference?
A. !A$1
B. $A$1
C. #a#1
D. A$1
ANS. D
18. Which of the following formulas is not entered correctly?
A. =10+50
B. =B7*B1
C. =B7+14
D. 10+50
ANS. D
19 What is the extension of a Microsoft Excel file?
A. msxcl
B. xcl
C. xlsx
D. xlsm
ANS. C
20 What is the keyboard shortcut to insert a SUM formula in MS Excel?
A. CTRL + =
B. ALT + =
C. ALT + S
D. CTRL + ALT + =
ANS. B
21 Which symbol is used to specify the fixed columns or rows in the formula?
A. =
B. *
C. $
D. %
ANS. C
22 The currently selected cell address is displayed in ____.
A. Name Box
B. Formula Bar
C. Both A and B
D. None of the above
ANS. A
23. In Excel you can activate a cell by
a) Pressing the Tab key
b) Clicking the cell
c) Pressing an arrow key
d) All of above
ANS. D
24. You can add a hyperlink to your worksheet by pressing
a) Alt + K
b) Ctrl + H
c) Ctrl + K
d) Ctrl + Shift + K
ANS. C
25. What is the file extension of an Excel workbook?
a) .xlsx
b) .docx
c) .pptx
d) .pdf
ANS. A
26. Which of the following is not a type of chart in Excel?
a) Line chart
b) Pie chart
c) Bar chart
d) Table chart
ANS. D
27. What is the shortcut key to format a cell as currency in Excel?
a) Ctrl + Shift + $
b) Ctrl + Shift + #
c) Ctrl + Shift + @
d) Ctrl + Shift + %
ANS. A
28. What is the maximum number of rows in an Excel worksheet?
a) 1,048,576
b) 16,384
c) 65,536
d) 256
ANS. A
29. What is the maximum number of columns in an Excel worksheet?
a) 1,048,576
b) 16,384
c) 65,536
d) 256
ANS. B
30. What is the function of the Freeze Panes feature in Excel?
a) To lock a cell or range of cells
b) To split the worksheet into separate panes
c) To freeze the top row or leftmost column
d) To add a filter to a table
ANS. C
31. Which of the following is not a way to format text in Excel?
a) Bold
b) Italic
c) Underline
d) Highlight
ANS. D
32. What is the shortcut key to merge cells in Excel?
a) Alt + M
b) Ctrl + M
c) Shift + M
d) None of the above
ANS. B
33. What is the function of the AutoFill feature in Excel?
a) To copy data or formulas to adjacent cells
b) To automatically format cells based on their values
c) To insert a new worksheet
d) To create a new chart
ANS. A
34. Which of the following is not a valid data type in Excel?
a) Text
b) Numeric
c) Date/Time
d) Boolean
ANS. D
35. What is the function of the COUNTIF function in Excel?
a) To count the number of cells that meet a certain condition
b) To count the number of cells that are not blank
c) To count the number of cells in a range
d) To count the number of unique values in a range
ANS. A
36. What is the function of the SUMIF function in Excel?
a) To add a range of numbers
b) To add a range of numbers that meet a certain condition
c) To find the average of a range of numbers
d) To count the number of cells that meet a certain condition
ANS. B
other
