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) File tab-->Info
B) File tab-->Save
C) File tab-->Save As
D) Home tab-->Editing group-->File Name
Rate this question:
A) #####
B) #DIV
C) Error
D) #VALUE
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:
A) Redo
B) Undo
C) Replace
D) Edit
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) 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) $A9
B) A$9
C) $A$9
D) A9
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) Press Enter
B) Press Page Down
C) Click the upward scroll arrow
D) Press Page Up
Rate this question:
A) Conditional Formatting
B) Cell Styles
C) Sort feature
D) Text to Columns wizard
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) Insert tab-->Help group
B) Help tab-->Microsoft Excel Help
C) File tab-->Help
D) None of the above
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 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) 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 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) 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:
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.
The Microsoft Excel 2010 Quiz! Trivia
Are you ready to test your Microsoft Excel 2010 knowledge? There is so much that one can do when they understand how to use spreadsheets correctly. Is it possible to have a...
Questions:
10 |
Attempts:
2035 |
Last updated:
Mar 21, 2023
|
Microsoft Excel 2010 Test Questions And Answers
How well do you know Microsoft Excel 2010? Could you pass this " Microsoft Excel 2010 Test with informative questions and answers?" With this quiz, it is necessary to...
Questions:
25 |
Attempts:
26861 |
Last updated:
Feb 07, 2024
|
Microsoft Excel 2010 MCQ Test: 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...
Questions:
30 |
Attempts:
3424 |
Last updated:
Mar 22, 2023
|
Excel 2010 Advance Post Test
The 'Excel 2010 Advance Post Test' assesses advanced skills in Microsoft Excel 2010, focusing on functions like LOOKUP and file formats, and understanding of Excel symbols and...
Questions:
17 |
Attempts:
405 |
Last updated:
Mar 18, 2023
|
MS Excel 2010 Skills Assessment! Trivia Quiz
This quiz is designed to provide an assessment of team members' level of competency in key features and functions of Excel 2010. The results of this quiz will be used to...
Questions:
20 |
Attempts:
13663 |
Last updated:
Jan 24, 2024
|
Ms Office Excel 2007/2010 Intermediate - Pre Test
This pre-test assesses intermediate skills in MS Office Excel 2007\/2010, focusing on file extensions, shortcuts, functions, and formulas. It evaluates the user's ability to...
Questions:
11 |
Attempts:
352 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.