

MCQOPTIONS
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. | |