Microsoft Excel (MS Excel) Multiple Choice Questions (MCQs)

We have compiled a list of 100+ questions with answers from Microsoft Excel (MS Excel) that help you to check your basic knowledge of MS Excel and prepare for competitive exams. These Microsoft excel multiple choice questions with answers are prepared by the subject experts from authentic resources. Attempt all the questions and check your MS Excel knowledge online.

This category includes the topics such as concept of electronic spreadsheets, types, organization of spreadsheet applications, cells, rows, columns, worksheets, workbooks and workspaces, creating opening and saving workbooks, screen elements, editing copying moving and delete cell contents, cell formatting, using formulas, relative absolute and mixed cell references, basic functions, generating series, default options, sorting filtering data, summarizing and sub totals, charts, header footer, speller, customizing menu and toolbar, import export data, pivot table, goal seek, scenario and audit, page setting, preview and printing.

Following are the important multiple choice questions with answers from the Microsoft Excel (MS Excel) section. You can choose the correct answer from option A, B, C and D.

MS Excel MCQs Practice MCQ Question and Answer

91

This type of software is similar to an accountant's worksheet

A. Word processing

B. Database

C. Spreadsheets

D. Graphics

92

You can zoom a worksheet

A. With the mouse pointer in Print Preview

B. With the zoom button on the Print Preview toolbar

C. With the Zoom command on the view menu

D. All of the above

93

A data map is helpful

A. When you have too much data to chart

B. To show a geographic distribution of data

C. To compare data points

D. To show changes in data over time

94

when working in the page break preview, you can

A. view exactly where each page break occurs

B. add or remove page breaks

C. change the print area

D. all of above

95

You can open the Sort dialog box by choosing Sort from the _____menu

A. View

B. Format

C. Tools

D. Data

96

You can open the scenario Manager Dialog box by choosing scenarios from the _____menu.

A. View

B. Insert

C. Format

D. Tools

97

To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command on the edit menu

D. Split command on the window menu

98

When you see a cell with a red triangle in the top right corner, what does this signify?

A. There is an error in the cell

B. There is a comment associated with the cell

C. The font color for text in the cell is red

D. A formula cannot be entered into the cell

99

Weight refers to

A. The print density of characters

B. The height of the printed character

C. Upright or slanted shape

D. The design and appearance of characters

100

You can group noncontiguous worksheets with

A. The group button on the standard toolbar

B. The shift key and the mouse

C. The ctrl key and mouse

D. The alt+enter key

101

when you print preview a worksheet

A. the entire worksheet is displayed

B. the selected range is displayed

C. the active portion of the worksheet is displayed

D. a, b and c

102

When the formula bar is activated, you can see

A. The Edit Formula button

B. The Cancel button

C. The Enter button

D. All of above

103

Comments can be added to cells using

A. Edit > Comments

B. Insert > Comments

C. File > Comments

D. View > Comments

104

To delete an embedded objects, first

A. Double click the object

B. Select the object by clicking it

C. Press the Shift + Delete keys

D. Select it and then press the delete key

105

Documentation should include

A. Destination and users of the output data

B. Source of input data

C. Information on the purpose of the workbook

D. All of the above

106

Right clicking something in Excel:

A. Deletes the object

B. Nothing the right mouse button is there for left handed people

C. Opens a shortcut menu listing everything you can do to the object

D. Selects the object

107

It is acceptable ot let long text flow into adjacent cells on a worksheet when

A. Data will be entered in the adjacent cells

B. No data will be entered in the adjacent cells

C. There is nt suitable abbreviation of the text

D. Tehere is not time to format the next

108

You can use the drag and drop method to

A. Copy cell contents

B. Move cell contents

C. Add cell contents

D. a and b

109

Which elements of worksheet can be protected from accidental modification?

A. Contents

B. Objects

C. Scenarios

D. All of above

110

You can edit a cell by

A. Clicking the formula button

B. Double clicking the cell to edit it in-place

C. Selecting Edit>Edit Cell from the menu

D. None of above

111

To save a workbook, you:

A. Click the save button on the standard toolbar from the menu

B. Press Ctrl+F5

C. Click Save on the Windows Start button

D. Select Edit>Save

112

When you want to insert a blank imbedded excel object in a word document you can

A. Click the object command on the insert menu

B. Click the office links button on the standard toolbar

C. Click the create worksheet button on the formatting toolbar

D. Click the import excel command on the file menu

113

to view a cell comment

A. click the edit comment command on the insert menu

B. click the display comment command on the window menu

C. position the mouse pointer over the cell

D. click the comment command on the view menu

114

Excel uniquely identifies cells within a worksheet with a cell name

A. Cell names

B. Column numbers and row letters

C. Column letters and row numbers

D. Cell locator coordinates

115

Data can be arranged in a worksheet in a easy to understand manner using

A. auto formatting

B. applying styles

C. changing fonts

D. all of above

116

To copy cell contents using drag and drop press the

A. End key

B. Shift key

C. Ctrl key

D. Esc key

117

Which of the following is not a valid data type in excel

A. Number

B. Character

C. Label

D. Date/time

118

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

A. None of these

B. Select Format > Money from the menu

C. Click the Currency Style button on the formatting toolbar

D. You have to retype everything and manually add the dollar signs, commas, and decimals.

119

The Paste Special command lets you copy and paste:

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula

120

All worksheet formula

A. Manipulate values

B. Manipulate labels

C. Return a formula result

D. Use the addition operator

Microsoft Excel (MS Excel) Multiple Choice Questions (MCQs)

MS Excel MCQs Practice MCQ Question and Answer

91 This type of software is similar to an accountant's worksheet

Answer & Solution

92 You can zoom a worksheet

Answer & Solution

93 A data map is helpful

Answer & Solution

94 when working in the page break preview, you can

Answer & Solution

95 You can open the Sort dialog box by choosing Sort from the _____menu

Answer & Solution

96 You can open the scenario Manager Dialog box by choosing scenarios from the _____menu.

Answer & Solution

97 To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

Answer & Solution

98 When you see a cell with a red triangle in the top right corner, what does this signify?

Answer & Solution

99 Weight refers to

Answer & Solution

100 You can group noncontiguous worksheets with

Answer & Solution

101 when you print preview a worksheet

Answer & Solution

102 When the formula bar is activated, you can see

Answer & Solution

103 Comments can be added to cells using

Answer & Solution

104 To delete an embedded objects, first

Answer & Solution

105 Documentation should include

Answer & Solution

106 Right clicking something in Excel:

Answer & Solution

107 It is acceptable ot let long text flow into adjacent cells on a worksheet when

Answer & Solution

108 You can use the drag and drop method to

Answer & Solution

109 Which elements of worksheet can be protected from accidental modification?

Answer & Solution

110 You can edit a cell by

Answer & Solution

111 To save a workbook, you:

Answer & Solution

112 When you want to insert a blank imbedded excel object in a word document you can

Answer & Solution

113 to view a cell comment

Answer & Solution

114 Excel uniquely identifies cells within a worksheet with a cell name

Answer & Solution

115 Data can be arranged in a worksheet in a easy to understand manner using

Answer & Solution

116 To copy cell contents using drag and drop press the

Answer & Solution

117 Which of the following is not a valid data type in excel

Answer & Solution

118 The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

Answer & Solution

119 The Paste Special command lets you copy and paste:

Answer & Solution

120 All worksheet formula

Answer & Solution

Categories

Random Posts

Social Media

91

This type of software is similar to an accountant's worksheet

92

You can zoom a worksheet

93

A data map is helpful

94

when working in the page break preview, you can

95

You can open the Sort dialog box by choosing Sort from the _____menu

96

You can open the scenario Manager Dialog box by choosing scenarios from the _____menu.

97

To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

98

When you see a cell with a red triangle in the top right corner, what does this signify?

99

Weight refers to

100

You can group noncontiguous worksheets with

101

when you print preview a worksheet

102

When the formula bar is activated, you can see

103

Comments can be added to cells using

104

To delete an embedded objects, first

105

Documentation should include

106

Right clicking something in Excel:

107

It is acceptable ot let long text flow into adjacent cells on a worksheet when

108

You can use the drag and drop method to

109

Which elements of worksheet can be protected from accidental modification?

110

You can edit a cell by

111

To save a workbook, you:

112

When you want to insert a blank imbedded excel object in a word document you can

113

to view a cell comment

114

Excel uniquely identifies cells within a worksheet with a cell name

115

Data can be arranged in a worksheet in a easy to understand manner using

116

To copy cell contents using drag and drop press the

117

Which of the following is not a valid data type in excel

118

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

119

The Paste Special command lets you copy and paste:

120

All worksheet formula