MS Excel MCQs

What type of chart will you use to compare performance of sales of two products ?

1. Pie Chart
2. Line Chart
3. Column Chart
4. None

Which feature is used to make selected sentence to All Captital Letters or All Small Letters ?

1. Change case
2. Change letter
3. Change sentence
4. Change word

Which of these key are used to apply outline border to the selected cell in MS Excel?

1. CTRL+SHIFT+ %
2. CTRL+SHIFT+ &
3. CTRL+SHIFT+ ~
4. CTRL+SHIFT+ $

Another name for a pre programmed formula in excel is __

1. Cell
2. Graph
3. Function
4. Range

Which of following function is used to sum the values in a range that meet criteria that you specify

1. SUM
2. SUMIF
3. SUMALL
4. SUMANY

What type of chart is useful for comparing values over categories?

1. Line Chart
2. Column Chart
3. Pie Chart
4. None

The columns of a table correspond to:

1. Table
2. Record
3. Field
4. Cell

The total number of rows in a worksheet?

1. Unlimited
2. 65,535
3. 1,048,576
4. 1,068,576

When the CPU detects an interrupt, then it saves its?

1. previous State
2. Next State
3. Current State
4. Both A and B

Which feature is used to wrap extra-long text into multiple lines in MS Excel ?

1. wrap text
2. text wrap
3. letter warp
4. word wrap