Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer

a. format cells containing numbers

b. create and edit formulas containing functions

c. entered assumptions data

d. copy a range of cells

a. Format Report

b. Pivot Table

c. Refresh Data

d. Show Detail

a. Formula

b. Field

c. Data

d. Query Correct Answer:

a. Formula

b. Function

c. Series

d. Syntax

a. F1 key

b. F2 key

c. F3 key

d. F4 key

a. G1-G10

b. B1.G10

c. B1;G10

d. B1:G10

a. Go to File-Save As – Save As Type – Excel worksheet

b. Right click on the spreadsheet tab and select DELETE

c. Right click on the spreadsheet and select Insert – Entire Column

d. None of above

a. Goal Seek

b. Scenario Summary report

c. Forecasting

d. Trend line

a. gradient

b. pattern

c. solid

d. texture

a. Graphic program

b. None of these

c. Word processor

d. A spreadsheet

a. HTML

b. Pivot Table Field List

c. Pivot Table List

d. Pivot Table Report

a. 10

b. 100

c. 300

d. 500

a. Standard

b. Formatting

c. Drawing

d. Reviewing

a. Choose Vertical on Text alignment in Format Cells dialog box

b. Choose 90 Degrees in Orientation of Format Cells dialog box

c. Choose Distributed from the Vertical drop down list of Format Cells dialog box

d. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

a. Excel does not have indentation feature

b. You can specify indentation only if you turn the rulers on

c. Indentation can be set from Format Cells dialog box

d. The indentation can be specified only when printing