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) Press Enter
B) Press Page Down
C) Click the upward scroll arrow
D) Press Page Up
Rate this question:
A) #####
B) #DIV
C) Error
D) #VALUE
Rate this question:
A) File tab-->Info
B) File tab-->Save
C) File tab-->Save As
D) Home tab-->Editing group-->File Name
Rate this question:
A) Insert tab-->Help group
B) Help tab-->Microsoft Excel Help
C) File tab-->Help
D) None of the above
Rate this question:
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
Rate this question:
A) Conditional Formatting
B) Cell Styles
C) Sort feature
D) Text to Columns wizard
Rate this question:
A) Redo
B) Undo
C) Replace
D) Edit
Rate this question:
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
Rate this question:
A) A cell's coordinates
B) The same thing as a cell name
C) A built-in formula
D) The result of a formula
Rate this question:
A) $A9
B) A$9
C) $A$9
D) A9
Rate this question:
A) AND
B) &
C) #
D) !
Rate this question:
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
Rate this question:
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.
Rate this question:
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
Rate this question:
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
Rate this question:
A) CTRL key
B) Selecting each cell while holding down the CTRL key
C) The ALT key
D) None of the above
Rate this question:
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
Rate this question:
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
Rate this question:
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
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.