Assessment For MS® Office Excel 2010

20 Questions | By Tlafferty | Last updated: Mar 21, 2022 | Total Attempts: 960

Questions

Settings

Create your own Quiz

Take this assessment to determine which level of Excel training you will need to attend. There is no pass or fail. Do not navigate away from the test or the test will become invalid. The assessment consists of 20 questions. Select the most correct answer of the available options.

Questions and Answers

1.

Which is NOT a basic element of a spreadsheet?
- A.
  
  A) Cell
- B.
  
  B) Row
- C.
  
  C) Paragraph
- D.
  
  D) Column
2.

To move one cell down from the active cell, you can:
- A.
  
  A) Press Enter
- B.
  
  B) Press Page Down
- C.
  
  C) Click the upward scroll arrow
- D.
  
  D) Press Page Up
3.

A formatted number that doesn't fit in a cell looks like:
- A.
  
  A) #####
- B.
  
  B) #DIV
- C.
  
  C) Error
- D.
  
  D) #VALUE
4.

To save an existing workbook with a new name, choose:
- A.
  
  A) File tab-->Info
- B.
  
  B) File tab-->Save
- C.
  
  C) File tab-->Save As
- D.
  
  D) Home tab-->Editing group-->File Name
5.

To open the Excel help system, choose
- A.
  
  A) Insert tab-->Help group
- B.
  
  B) Help tab-->Microsoft Excel Help
- C.
  
  C) File tab-->Help
- D.
  
  D) None of the above
6.

Whether you want to cut, copy, or move data, what's the first thing you must do?
- A.
  
  A) Choose Data tab -->Edit-->Cut
- B.
  
  B) Select the contents of the cell that contains the data
- C.
  
  C) Click the destination cell
- D.
  
  D) Open the clipboard
7.

Data can be arranged in ascending or descending order by using:
- A.
  
  A) Conditional Formatting
- B.
  
  B) Cell Styles
- C.
  
  C) Sort feature
- D.
  
  D) Text to Columns wizard
8.

Which option do you use if you want to restore something you accidentally deleted?
- A.
  
  A) Redo
- B.
  
  B) Undo
- C.
  
  C) Replace
- D.
  
  D) Edit
9.

To insert a new row:
- A.
  
  A) Double-click on the row
- B.
  
  B) From the Insert tab -->Choose Line
- C.
  
  C) Select where you want the row and then from the Home tab -->Choose Insert-->Insert Cells
- D.
  
  D) From the Home tab in the Cells group -->Choose Insert-->Insert Sheet Rows
10.

Which description best describes a function in Excel?
- A.
  
  A) A cell's coordinates
- B.
  
  B) The same thing as a cell name
- C.
  
  C) A built-in formula
- D.
  
  D) The result of a formula
11.

You have selected cell D12 and, in that cell, you want to create an absolute reference to cell A9. Which one is an absolute reference to cell A9?
- A.
  
  A) $A9
- B.
  
  B) A$9
- C.
  
  C) $A$9
- D.
  
  D) A9
12.

What symbol or phrase is used when concatenating data (joining two character strings together)?
- A.
  
  A) AND
- B.
  
  B) &
- C.
  
  C) #
- D.
  
  D) !
13.

PivotTable reports allow you to:
- A.
  
  A) Organize large amounts of data
- B.
  
  B) Create PivotCharts that show a graphical representation of large amounts of data
- C.
  
  C) Easily change the layout of the report
- D.
  
  D) All of the above
14.

Apply an AutoFormat when you want to:
- A.
  
  A) Quickly format a range of cells with a predefined group of formats.
- B.
  
  B) Specify a custom-designed layout for a range of cells.
- C.
  
  C) Quickly format a single cell.
- D.
  
  D) Alter the formula in a cell.
15.

Which one can be the first step for renaming a worksheet tab?
- A.
  
  A) Select the worksheet, and then from the Page Layout tab-->Select Arrange
- B.
  
  B) Double-click the worksheet tab
- C.
  
  C) From the Home tab-->Enter new name in the Name box
- D.
  
  D) All of the above
16.

To add a header or footer to a worksheet, choose:
- A.
  
  A) From the View tab-->Workbook Views group-->Select Page Layout-->Enter the headers in the worksheet
- B.
  
  B) From the Insert tab in the Text group-->Select Header & Footer
- C.
  
  C) From the Page Layout tab in the Page Setup group-->Select Print Titles-->Select Header and Footer tab
- D.
  
  D) All of the above
17.

How do you select multiple cells that are not adjacent to each other?
- A.
  
  A) CTRL key
- B.
  
  B) Selecting each cell while holding down the CTRL key
- C.
  
  C) The ALT key
- D.
  
  D) None of the above
18.

To print a range of cells, you must first:
- A.
  
  A) Choose File tab-->Print
- B.
  
  B) From the Page Layout tab-->Page Setup group-->Select Range
- C.
  
  C) Select the range of cells
- D.
  
  D) Select a single cell
19.

Which tab choice do you use to split a worksheet?
- A.
  
  A) From the Data tab-->Data Tools group-->Split
- B.
  
  B) From the View tab-->Workbook Views group-->Custom Split View
- C.
  
  C) From the View tab-->Windows group-->Split
- D.
  
  D) From the Insert tab-->Hyperlink group-->Split
20.

To freeze rows and columns, choose:
- A.
  
  A) From the View tab-->Windows group-->Freeze Panes
- B.
  
  B) From the Data tab-->Data Tools group-->Remove Duplicates
- C.
  
  C) From the View tab-->Workbook Views Group-->Full Screen
- D.
  
  D) From the Insert Tab-->Sparklines group--> Line