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

121

You can enter which types of data into worksheet cells?

A. Labels, values, and formulas

B. Labels and values but not formulas

C. Values and formulas but not labels

D. Formulas only

122

Excel probably considers the cell entry January 1, 2000 to be a

A. Label

B. Value

C. Formula

D. Text string

123

Each excel file is called a workbook because

A. It can contain text and data

B. It can be modified

C. It can contain many sheets including worksheets and chart sheets

D. You have to work hard to create it

124

Which of the following is not information you can specify using the solver?

A. Input cells

B. Constraints

C. Target cell

D. Changing cells

125

When you insert an excel file into a word document. The data are

A. Hyperlinked placed in a word table

B. Linked

C. Embedded

D. Use the word menu bar and toolbars

126

Which of following is Not one of Excel's what-if function?

A. Goal seek

B. Solver

C. Scenario manager

D. Auto Outline

127

A circular reference is

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous

128

You can convert existing excel worksheet data an charts to an HTML document by using

A. FTP wizard

B. Internet assistant wizard

C. Intranet wizard

D. Import wizard

129

Which menu option can be sued to split windows into two

A. Format > window

B. View > window > split

C. Window > split

D. View > split

130

The auto fill feature

A. extends a sequential series of data

B. automatically adds range of cell values

C. applies a boarder around the selected cells

D. none of the above

131

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesn't adjust relative cell references

132

Which of the following is the latest version of Excel

A. Excel 2000

B. Excel 2002

C. Excel ME

D. Excel XP

133

When integrating word and excel, word is usually the

A. Server

B. Destination

C. Client

D. Both b and c

134

Which of the following is not a basic step in creating a worksheet?

A. Save workbook

B. Modify the worksheet

C. Enter text and data

D. Copy the worksheet

135

Text formulas:

A. Replace cell references

B. Return ASCII values of characters

C. Concatenate and manipulate text

D. Show formula error value

136

You can activate a cell by

A. Pressing the Tab key

B. Clicking the cell

C. Pressing an arrow key

D. All of the above

137

Which of the following is not a way to complete a cell entry?

A. Pressing enter

B. Pressing any arrow key on the keyboard

C. Clicking the Enter button on the Formula bar

D. Pressing spacebar

138

Which of the following will not cut information?

A. Pressing Ctrl + C

B. Selecting Edit>Cut from the menu

C. Clicking the Cut button on the standard

D. Pressing Ctrl+X

139

Which of the following methods cannot be used to enter data in a cell

A. Pressing an arrow key

B. Pressing the Tab key

C. Pressing the Esc key

D. Clicking on the formula bar

140

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

A. Press the Erase key

B. Press Esc

C. Press the Enter button

D. Press the Edit Formula button

141

Which of the following methods cannot be used to edit the contents of a cell?

A. Press the Alt key

B. Clicking the formula bar

C. Pressing the F2 key

D. Double clicking the cell

142

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A. Press Ctrl +Home

B. Press Home

C. Press Shift + Home

D. Press Alt + Home

143

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

A. Pie chart

B. Row chart

C. Line chart

D. Column chart

144

Which of the following options is not located in the Page Setup dialog box?

A. Page Break Preview.

B. Page Orientation

C. Margins

D. Headers and Footers

145

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

A. Option buttons

B. List boxes

C. Text boxes

D. Combo boxes

146

When a label is too long to fit within a worksheet cell, you typically must

A. Shorten the label

B. Increase the column width

C. Decrease the column width

D. Adjust the row height

147

When the formula bar is active, you can see

A. The edit formula button

B. The cancel button

C. The enter button

D. All of the above

148

Which button do you click to add up a series of numbers?

A. The auto sum button

B. The Formula button

C. The quick total button

D. The total button

149

To activate the previous cell in a pre-selected range, press

A. The Alt key

B. The Tab key

C. The Enter key

D. None of the above

150

Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

D. All of above

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

MS Excel MCQs Practice MCQ Question and Answer

121 You can enter which types of data into worksheet cells?

Answer & Solution

122 Excel probably considers the cell entry January 1, 2000 to be a

Answer & Solution

123 Each excel file is called a workbook because

Answer & Solution

124 Which of the following is not information you can specify using the solver?

Answer & Solution

125 When you insert an excel file into a word document. The data are

Answer & Solution

126 Which of following is Not one of Excel's what-if function?

Answer & Solution

127 A circular reference is

Answer & Solution

128 You can convert existing excel worksheet data an charts to an HTML document by using

Answer & Solution

129 Which menu option can be sued to split windows into two

Answer & Solution

130 The auto fill feature

Answer & Solution

131 When you copy a formula

Answer & Solution

132 Which of the following is the latest version of Excel

Answer & Solution

133 When integrating word and excel, word is usually the

Answer & Solution

134 Which of the following is not a basic step in creating a worksheet?

Answer & Solution

135 Text formulas:

Answer & Solution

136 You can activate a cell by

Answer & Solution

137 Which of the following is not a way to complete a cell entry?

Answer & Solution

138 Which of the following will not cut information?

Answer & Solution

139 Which of the following methods cannot be used to enter data in a cell

Answer & Solution

140 If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

Answer & Solution

141 Which of the following methods cannot be used to edit the contents of a cell?

Answer & Solution

142 Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Answer & Solution

143 You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Answer & Solution

144 Which of the following options is not located in the Page Setup dialog box?

Answer & Solution

145 Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Answer & Solution

146 When a label is too long to fit within a worksheet cell, you typically must

Answer & Solution

147 When the formula bar is active, you can see

Answer & Solution

148 Which button do you click to add up a series of numbers?

Answer & Solution

149 To activate the previous cell in a pre-selected range, press

Answer & Solution

150 Hyperlinks can be

Answer & Solution

Categories

Random Posts

Social Media

121

You can enter which types of data into worksheet cells?

122

Excel probably considers the cell entry January 1, 2000 to be a

123

Each excel file is called a workbook because

124

Which of the following is not information you can specify using the solver?

125

When you insert an excel file into a word document. The data are

126

Which of following is Not one of Excel's what-if function?

127

A circular reference is

128

You can convert existing excel worksheet data an charts to an HTML document by using

129

Which menu option can be sued to split windows into two

130

The auto fill feature

131

When you copy a formula

132

Which of the following is the latest version of Excel

133

When integrating word and excel, word is usually the

134

Which of the following is not a basic step in creating a worksheet?

135

Text formulas:

136

You can activate a cell by

137

Which of the following is not a way to complete a cell entry?

138

Which of the following will not cut information?

139

Which of the following methods cannot be used to enter data in a cell

140

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

141

Which of the following methods cannot be used to edit the contents of a cell?

142

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

143

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

144

Which of the following options is not located in the Page Setup dialog box?

145

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

146

When a label is too long to fit within a worksheet cell, you typically must

147

When the formula bar is active, you can see

148

Which button do you click to add up a series of numbers?

149

To activate the previous cell in a pre-selected range, press

150

Hyperlinks can be