05th
May

# MS Excel MCQ

• 05th May, 2021
• 874 Followers

## MS Excel MCQ Quiz

Following are mostly asked Ms excel MCQ test that are designed for professionals like you to crack you interviews. You can take this Ms excel online test before appearing to you real interview. This Ms excel quiz there are around 30+ multiple choice questions on Ms excel with four options.

### 1) What is Microsoft Excel?

• B. language
• C. framework
• D. None of the above

### 2) What is the use of the formula palette in MS Excel?

• A. Format cells containing numbers
• B. Create and edit formula containing functions
• C. Enter assumptions data
• D. Copy a range of cells

### 3) In MS Excel, What is worksheet?

• A. A worksheet is a collection of cells where you keep and manipulate the data.
• B. A worksheet is a collection of workbook.
• C. Both A and B
• D. All of the above

### 4) What is cell in MS Excel?

• A. intersection area of a row and column
• B. row
• C. column
• D. All of the above

### 5) What do you mean by Function in MS Excel?

• A. A function is a predefined formula that performs calculations using specific values in a particular order.
• B. A function is a user defined formula that performs calculations using specific values in a particular order.
• C. Expression
• D. None of the above

### 6) Function's Arguments can refer to ___ and must be enclosed within parentheses.

• A. individual cells
• B. cell ranges
• C. Both A and B
• D. None of the above

• A. COUNT()
• B. AVERAGE()
• C. RANGE()
• D. ROUND()

### 8) __ function determines the highest cell value included in the argument.

• A. MAX()
• B. MIN()
• C. MAXIMUM()
• D. None of the above

### 9) Which of the following function adds all of the values of the cells in the argument?

• A. SUM()
• C. COUNT()
• D. All of the above

• A. 3B
• B. B3
• C. B12
• D. 123AB

### 11) Cell Range from A1 to A10 is denoted as:

• A. A1:A10
• B. 10A:A1
• C. 10A:1A
• D. All of the above

### 12) Which of the following is syntax for the IF() in MS Excel?

• A. IF(CellName="VALUE" ,"PRINT to DO","ELSE PRINT to DO")
• B. IF(B3>="35" ,"Promoted","Failed")
• C. IF(B3<="35" ,"Failed","Passed")
• D. All of the above

### 13) What is the use of the PRODUCT() in MS Excel?

• A. Add multiple cells values together. For example, =PRODUCT(A1:A30)
• B. Multiples multiple cells values together. For example, =PRODUCT(A1:A30)
• C. Both A and B
• D. None of the above

### 14) If the value of A2 is 4.7614, then what will be the calculated value of ROUND(A2,2) in MS Excel?

• A. 4.76
• B. 4.761
• C. 47.61
• D. All of the above

• A. Formula
• B. Sorting
• C. Filtering
• D. Pivot

### 16) Statistical calculations and preparation of tables and graphs can be done using __.

• B. Excel
• D. Power Point

• A. Arranging
• B. Autofill
• C. Sorting
• D. Filtering

### 18) The ____ feature of MS Excel quickly completes a series of data?

• A. Auto Complete
• B. Auto Fill
• C. Fill Handle
• D. Sorting

### 19) Which type of chart is useful for single series of data?

• A. Column Chart
• B. Line Chart
• C. Pie Chart
• D. Cone Chart

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

• A. Column Chart
• B. Line Chart
• C. Pie Chart
• D. Both A and B

### 21) Which type of chart is used to compare performance of sales of two products?

• A. Column Chart
• B. Line Chart
• C. Pie Chart
• D. Both A and B

• A. Cells
• B. Numbers
• C. Letters
• D. Columns

### 23) What is a rectangular box in a MS EXCEL Spreadsheet called?

• A. Row
• B. Cell
• C. Column
• D. None of the above

• A. +
• B. -
• C. =
• D. *

• A. +
• B. -
• C. =
• D. *

• A. (B2:F5)
• B. B2-F5
• C. B2:5F
• D. F5:B2

### 27) When is a MS Excel Spreadsheet used?

• A. Making a Drawing
• C. For Baking a Cake
• D. For Collecting Information

### 28) Located on the left side or the entry bar, displays the active cell reference:

• A. Entry Bar
• B. Name Box
• C. Cell Reference
• D. None of the above

### 29) A program using a table comprising of rows, columns and cells

• A. MS Word
• B. MS PowerPoint
• C. MS Outlook
• D. MS Excel

### 30) Key combination to move to the adjacent cell on the left

• A. Shift + Tab
• B. Ctrl + Home
• C. Ctrl + G
• D. None of the above

Valid name is required.

Valid name is required.

Valid email id is required.

01st
May

01st
May

01st
May

01st
May

01st
Apr

01st
Jul