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.
A) Cell
B) Row
C) Paragraph
D) Column
A) Press Enter
B) Press Page Down
C) Click the upward scroll arrow
D) Press Page Up
A) #####
B) #DIV
C) Error
D) #VALUE
A) File tab-->Info
B) File tab-->Save
C) File tab-->Save As
D) Home tab-->Editing group-->File Name
A) Insert tab-->Help group
B) Help tab-->Microsoft Excel Help
C) File tab-->Help
D) None of the above
A) Choose Data tab -->Edit-->Cut
B) Select the contents of the cell that contains the data
C) Click the destination cell
D) Open the clipboard
A) Conditional Formatting
B) Cell Styles
C) Sort feature
D) Text to Columns wizard
A) Redo
B) Undo
C) Replace
D) Edit
A) Double-click on the row
B) From the Insert tab -->Choose Line
C) Select where you want the row and then from the Home tab -->Choose Insert-->Insert Cells
D) From the Home tab in the Cells group -->Choose Insert-->Insert Sheet Rows
A) A cell's coordinates
B) The same thing as a cell name
C) A built-in formula
D) The result of a formula
A) $A9
B) A$9
C) $A$9
D) A9
A) AND
B) &
C) #
D) !
A) Organize large amounts of data
B) Create PivotCharts that show a graphical representation of large amounts of data
C) Easily change the layout of the report
D) All of the above
A) Quickly format a range of cells with a predefined group of formats.
B) Specify a custom-designed layout for a range of cells.
C) Quickly format a single cell.
D) Alter the formula in a cell.
A) Select the worksheet, and then from the Page Layout tab-->Select Arrange
B) Double-click the worksheet tab
C) From the Home tab-->Enter new name in the Name box
D) All of the above
A) From the View tab-->Workbook Views group-->Select Page Layout-->Enter the headers in the worksheet
B) From the Insert tab in the Text group-->Select Header & Footer
C) From the Page Layout tab in the Page Setup group-->Select Print Titles-->Select Header and Footer tab
D) All of the above
A) CTRL key
B) Selecting each cell while holding down the CTRL key
C) The ALT key
D) None of the above
A) Choose File tab-->Print
B) From the Page Layout tab-->Page Setup group-->Select Range
C) Select the range of cells
D) Select a single cell
A) From the Data tab-->Data Tools group-->Split
B) From the View tab-->Workbook Views group-->Custom Split View
C) From the View tab-->Windows group-->Split
D) From the Insert tab-->Hyperlink group-->Split
A) From the View tab-->Windows group-->Freeze Panes
B) From the Data tab-->Data Tools group-->Remove Duplicates
C) From the View tab-->Workbook Views Group-->Full Screen
D) From the Insert Tab-->Sparklines group--> Line
Wait!
Here's an interesting quiz for you.