Explore topic-wise MCQs in MS Excel.

This section includes 162 Mcqs, each offering curated multiple-choice questions to sharpen your MS Excel knowledge and support exam preparation. Choose a topic below to get started.

101.

What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

A. Spreadsheet program
B. Database program
C. Word processor program
D. Desktop publisher program
Answer» B. Database program
102.

You can use the horizontal and vertical scroll bars to

A. Split a worksheet into two panes
B. View different rows and columns
C. Edit the contents of a cell
D. View different worksheets
Answer» C. Edit the contents of a cell
103.

To edit data in an embedded Excel worksheet object in a Word document

A. Use the Excel menu bar and toolbars inside the word application
B. Edit the hyperlink
C. Edit the data in a Excel source application
D. Use the Word menu bar and toolbars
Answer» B. Edit the hyperlink
104.

Status indicators are located on the

A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Formatting toolbar
Answer» D. Formatting toolbar
105.

You can open the scenario Manager dialog box by choosing scenarios from the .. menu.

A. View
B. Insert
C. Format
D. Tools
Answer» E.
106.

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

A. Use Ctrl to select all three cells, then click the paste button on the standard toolbar
B. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
C. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
D. All of above
Answer» D. All of above
107.

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
Answer» C. Hold titles command on the edit menu
108.

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
Answer» C. The font color for text in the cell is red
109.

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
Answer» B. The height of the printed character
110.

When you link data maintained in Excel workbook to a Word document

A. The Word document cannot be edited
B. The Word document contains a reference to the original source application
C. The word document must contain a hyperlink
D. The word document contains a copy of the actual data
Answer» C. The word document must contain a hyperlink
111.

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
Answer» D. The alt+enter key
112.

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
Answer» E.
113.

Hyperlinks cannot be

A. Special shapes like stars and banners
B. Drawing objects like rectangles ovals
C. Pictures
D. All can be hyperlinks
Answer» E.
114.

when you work with large worksheets, you may need to

A. size the worksheet to fit on the specific number of pages
B. add and remove page breaks
C. specify only certain print areas
D. all of above
Answer» E.
115.

What symbol is used before a number to make it a label?

A. (quote)
B. = (equal)
C. _ (underscore)
D. (apostrophe)
Answer» C. _ (underscore)
116.

Which of the following is an absolute cell reference?

A. !A!1
B. $A$1
C. #a#1
D. A1
Answer» C. #a#1
117.

The default header for a worksheet is

A. Your name
B. The date and time
C. None
D. The sheet tab name
Answer» D. The sheet tab name
118.

This type of software is similar to an accountant s worksheet

A. Word processing
B. Database
C. Spreadsheets
D. Graphics
Answer» D. Graphics
119.

When you group worksheets

A. You can enter variable data on multiple worksheets at one time
B. You can print more than one worksheet at a time
C. You can enter common data, formats, and formulas on multiple worksheets at one time
D. b, and c
Answer» E.
120.

You can use the format painter multiple times before you turn it off by

A. You can use the format painter button only one time when you click it
B. Double clicking the format painter button
C. Pressing the Ctrl key and clicking the format painter button
D. Pressing Alt key and clicking the format painter button
Answer» C. Pressing the Ctrl key and clicking the format painter button
121.

You can not link Excel worksheet data to a Word document

A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer» E.
122.

A worksheet range is a

A. A command used for data modeling
B. A range of values such as from 23 to 234
C. A group of cells
D. A group of worksheets
Answer» D. A group of worksheets
123.

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
Answer» E.
124.

You can copy data or formulas

A. With the copy, paste and cut commands on the edit menu
B. With commands on a shortcut menu
C. With buttons on the standard toolbar
D. All of the above
Answer» E.
125.

Rounding errors can occur

A. When you use multiplication, division or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because Excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places than the calculated results
Answer» B. When you use addition and subtraction in a formula
126.

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
Answer» C. To compare data points
127.

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
Answer» E.
128.

You can open the Sort dialog box by choosing Sort from the .. menu

A. View
B. Format
C. Tools
D. Data
Answer» E.
129.

Tab scrolling button

A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheets tabs
Answer» E.
130.

Getting data from a cell located in a different sheet is called

A. Accessing
B. Referencing
C. Updating
D. Functioning
Answer» C. Updating
131.

The Chart wizard term data categories refers to;

A. A chart plot area
B. A horizontal axis
C. The organization of individual values with a chart s data series
D. The data range that supply chart data
Answer» C. The organization of individual values with a chart s data series
132.

The chart wizard term data series refers to

A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
Answer» C. A set of values you plot in a chart
133.

Which of the following is not an example of a value?

A. 350
B. May 10, 2001
C. 57%
D. Serial Number 50771
Answer» E.
134.

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
Answer» E.
135.

Which elements of worksheet can be protected from accidental modification

A. Contents
B. Objects
C. Scenarios
D. All of above
Answer» E.
136.

You can select a single range of cells by

A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
Answer» E.
137.

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
Answer» C. Selecting Edit>Edit Cell from the menu
138.

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
Answer» B. Press Ctrl+F5
139.

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
Answer» D. click the comment command on the view menu
140.

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
Answer» B. Click the office links button on the standard toolbar
141.

The auto calculate feature

A. Can only add values in a range of cells
B. Provides a quick way to view the result of an arithmetic operation on a range of cells
C. Automatically creates formulas and adds them to a worksheet
D. A and c
Answer» C. Automatically creates formulas and adds them to a worksheet
142.

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
Answer» D. Cell locator coordinates
143.

You can use drag-and-drop to embed excel worksheet data in a word document

A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D. None of above
Answer» B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
144.

A worksheet can have a maximum of . Number of rows

A. 256
B. 1024
C. 32,000
D. 65,535
Answer» E.
145.

Which of the following is the latest version of Excel

A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer» E.
146.

To copy cell contents using drag and drop press the

A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer» E.
147.

Which of the following is not a worksheet design criterion?

A. Efficiency
B. Aditibility
C. Description
D. Clarity
Answer» D. Clarity
148.

Comments can be added to cells using

A. Edit > Comments
B. Insert > Comments
C. File > Comments
D. View > Comments
Answer» C. File > Comments
149.

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
Answer» E.
150.

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
Answer» E.