MS-Excel MCQ Set-2

---

1. A typical worksheet has …. Number of columns
A) 128
B) 256
C) 512
D) 1024
Answer : B

2. How many characters can be typed in a single cell in Excel?
A) 256
B) 1024
C) 32,000
D) 65,535
Answer : D

3. A worksheet can have a maximum of …. Number of rows
A) 256
B)1024
C) 32,000
D) 65,535
Answer : D

4. Which of the following is not an example of a value?
A) 350
B) May 10, 2001
C) 57%
D) Serial Number 50771
Answer : D

5. The chart wizard term data series refers to
A) A chart legend
B) A collection of chart data markers
C) A set of values you plot in a chart
D) A data label
Answer : B

6. Which option is not in the Data Menu in MS Excel ?
A) Validation
B) Filter
C) Freeze Pane
D) Sort
Answer : C

7. When using the Function, which reference operator is used to give the range?
A) ;
B) &
C):
D) =
Answer : C

8. What is the feature of inserting cells by dragging numbers in MS Excel ?
A) Auto Correct
B) Auto Text
C) Auto Fill
D) Auto Cell
Answer : C

9. Which of the options is in the Tool Menu in MS.Excel ?
A) Formula Auditing
B) Goal Seek
C) Scenarios
D) All of these
Answer : D

10. Which function is used to calculate Rate of Return, Loan, Amount and Future Value ?
A) Statistical function
B) Financial function
C) Logical function
D) Mathematical function
Answer : B

11. What is the shortcut key to insert current date in cell ?
A) Ctrl +;
B) Ctrl + T
C) Ctrl + D
D) Ctrl + /
Answer : A

12. In M.S. Excel if Day Formula is imposed, answer to 5/3/2017 will be printed ______
A) 5
B) 3
C) 2017
D) 5 mar
Answer : B

13. Which symbol do you use to start formula in MS Excel?
A) %
B) =
C) +
D) <>
Answer : B

14. Which of these functions is used to remove more than one space?
A) Trim
B) Char
C) Len
D) Int
Answer : A

15. In MS Excel cell, values 29, 19, 27, 39 and 20 are written from A6 to A11. Then what will be the value of = MAX (A6: A11)?
A) 29
B) 39
C) 21
D) 20
Answer : B

16. Which chart would be useful to compare the sales price of two different branches of a distributor?
A) Scatter Chart
B) Bar Chart
C) Doughnut Chart
D) Area Chart
Answer : C

17. Which of these statements is correct?
A) = POWER(2*3)
B) = POWER(2^3)
C) = POWER(2,3)
D) = POWER(2:3)
Answer : C

18. Which of these is not an operator in MS Excel?
A) Text Concatenation Operator
B) Reference Operator
C) Arithmetic Operator
D) Logical Operator
Answer : D

19. Where does the active cell’s contents display in Excel?
A) Name Box
B) Row Headings
C) Formula Bar
D) Task Pane
Answer : C

20. How many steps are there to create charts in MS Excel?
A) 2
B) 3
C) 4
D) 5
Answer : C