Microsoft Excel 2010 MCQ Test: Quiz

30 Questions | By Steph123 | Updated: Mar 22, 2022 | Attempts: 1523

Questions

Settings

Feedback

During the Quiz End of Quiz

Play as

Quiz Flashcard

Create your own Quiz

Microsoft Excel 2010 MCQ Test: Quiz - Quiz

Can you pass this Microsoft Excel 2010 MCQ quiz? Microsoft excel is quite a complex tool for most users to understand out of all the Microsoft packages. One of the reasons this is true is the complex techniques involved and its ability to handle different data types. In the quiz provided, you will get to polish up your understanding of using Excel. Do check it out and see how well you do!

Questions and Answers

1.

What is a worksheet tab in Excel 2007?
- A.
  
  A worksheet tab is used to access tools associated with the worksheet
- B.
  
  A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
- C.
  
  A worksheet tab is used to get help when working with Microsoft Excel 2007
- D.
  
  A worksheet tab is used to move from one cell to the next cell in a worksheet
2.

Tables created through Excel's table feature allow users to filter columns by different values.
- A.
  
  True
- B.
  
  False
3.

Pivot tables allow filtering of table information by different values in column and row headers.
- A.
  
  True
- B.
  
  False
- C.
  
  Only when using Excel 2003 or earlier versions
4.

Creating tables is as easy as highlighting cells that have already been filled in appropriately, followed by clicking on the Insert tab and then clicking on the table button.
- A.
  
  No, highlighting cells disables the ability to create tables
- B.
  
  Yes, it is that simple, but the highlighted cells must have numerical data
- C.
  
  No, you go to the home tab and then click on the table button
- D.
  
  Yes, it is that simple, but the highlighted selection should not contain any blank cells
5.

Once data in a table gets filtered, you can neither unfilter the table nor get the table back to the original settings.
- A.
  
  False, you may change filters up to three times
- B.
  
  True
- C.
  
  False, you may change filters as many times as you please without limits
- D.
  
  False, tables cannot be filtered
6.

Which pivot table layout allows the dragging of fields to the grid in a spreadsheet?
- A.
  
  Default Pivot Table Layout
- B.
  
  Classic Pivot Table Layout
- C.
  
  Master Pivot Table Layout
- D.
  
  Operation Geronimo Layout
7.

For a table to work properly, the top row should have column headings.
- A.
  
  True
- B.
  
  False, only rows may have headings
- C.
  
  False
8.

Pivot tables that have been created can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.
- A.
  
  True
- B.
  
  False, pivot tables do not contain enough information for graphs or charts
- C.
  
  False, only regular tables may be used to create graphs or charts
9.

What is the function of the Formulas tab in Microsoft Excel 2007?
- A.
  
  The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically
- B.
  
  The Formulas tab contain only the most common formulas supported by Excel
- C.
  
  The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab
- D.
  
  The Formulas tab is used for automatic creation of a complete formula without any user interaction at all
10.

Which of the following Excel features allows you to summarize the data in a large table?
- A.
  
  Data Validation
- B.
  
  Conditional Formatting
- C.
  
  Pivot Table
- D.
  
  Hyperlink
11.

When number signs (#####) are displayed in the cell, it means:
- A.
  
  There are too many characters in the cell to be displayed with the current cell width
- B.
  
  The formula in the cell is wrong
- C.
  
  The decimal point placement in the cell is wrong
- D.
  
  All of the above
12.

What does the Format Painter button do?
- A.
  
  Only changes the color of each cell
- B.
  
  Only changes the color of a group of cells that you choose
- C.
  
  Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.
- D.
  
  Only copies formulas from one cell or group of cells to another.
13.

By default, each workbook automatically has 3 sheets labeled on the bottom tabs: Sheet 1, Sheet 2, Sheet 3. To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, what has to be done?
- A.
  
  Right click on sheet 2 and select insert
- B.
  
  Right click on sheet 1 and select insert
- C.
  
  Right click on sheet 3 and select insert
- D.
  
  None of the above
14.

When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?
- A.
  
  Seperate the page into two for easier printing
- B.
  
  Use the Fit to Page option
- C.
  
  Highlight all cells to print and print selection
- D.
  
  None of the above
15.

Once data is entered into a cell, can it be edited?
- A.
  
  Yes, but the file must be saved with a different file name
- B.
  
  No, once a file is saved, cell data cannot be changed
- C.
  
  Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
- D.
  
  No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
16.

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- A.
  
  Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
  
  Right click on the spreadsheet tab and select DELETE
- C.
  
  Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
17.

What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?
- A.
  
  F3
- B.
  
  F5
- C.
  
  F7
- D.
  
  F9
- E.
  
  F11
- F.
  
  F13
18.

Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
  
  Count
- B.
  
  Average
- C.
  
  Sum
19.

Which of these will NOT select all the cells in a document?
- A.
  
  Clicking three times with the right mouse button in the spreadsheet
- B.
  
  Using the Edit - Select All menu item
- C.
  
  Pressing CTRL + A on the keyboard
20.

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

Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
- B.
- C.
22.

Which of the following will NOT set text in selected cells to ITALICS?
- A.
  
  Pressing CTRL + I on the keyboard
- B.
  
  Using the Tools - Wizard - Web Form menu item
- C.
  
  Using the Format - Cells - Font menu item
23.

Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
  
  Yes
- B.
  
  No
24.

How do you turn off automatic calculation for a spreadsheet?
- A.
  
  You cannot turn off automatic calculation - its built into the spreadsheet / workbook.
- B.
  
  Right click on the spreadsheet tab and select MANUAL CALCULATION.
- C.
  
  Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.
25.

What is the keyboard shortcut (button or buttons to be pressed) to Complete a cell entry and move up in the selection?
- A.
  
  CTRL+TAB
- B.
  
  SHIFT+TAB
- C.
  
  ALT+TAB
- D.
  
  SHIFT+ENTER
- E.
  
  CTRL+ENTER
- F.
  
  ALT+ENTER