This quiz is to test your knowledge and understanding of the two Excel trainings we have provided.
Countif
Sum
Total
Count
Rate this question:
Join
Concatenate
Text to Columns
Find/Replace
Rate this question:
Only in the top row
In any cell
Only in headers
In any cell that has a value in it
Rate this question:
Automate repetitive tasks.
Will auto-sum all the Number/Currency formatted cells in your workbook.
Create a table of all the data you have selected.
Can be used on any set of data no matter of the formatting.
Rate this question:
True
False
Rate this question:
Selects all of the data to the right until a blank cell is encountered
Selects the entire row
Activates the task bar
Opens Excel Options
Rate this question:
Right
Left
Rate this question:
Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_false, enter a Value_if_true
Click the fx button, search for/open up the IF function, enter a Value_if_true, enter a Logical_test, enter a Value_if_false
Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_true, enter a Value_if_false
Click the fx button, search for/open up the IF function, enter a Value_if_true, enter a Value_if_false, enter a Logical_test
Rate this question:
Gives your results back in currency format
Gives your results back in accounting format
Creates a fixed array for your formula
Creates an array for when using multiple formulas for a single solution
Rate this question:
Above the document and below the ribbon
In the Review Ribbon
With Excel Options
Above the Taskbar and below the document
Rate this question:
True
False
Rate this question:
It can show up differently to a customer based on their theme
It can overwrite formulas
It is so complicated to setup that it is easy to miss a step
It overlays other formatting in the same cells
Rate this question:
Right with Conditional Formatting
Left with Delimiters
Text to Columns with Fixed Width
Text to Columns with Delimiters
Rate this question:
Quiz Review Timeline (Updated): Mar 15, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Excel 2007 Intermediate Course Short Quiz
This short quiz for the Excel 2007 Intermediate Course assesses key functionalities such as formula calculation, cell operations, and data management. It verifies understanding of...
Questions:
13 |
Attempts:
427 |
Last updated:
Mar 17, 2023
|
Excel 2007 (Pre Test)
The 'Excel 2007 (Pre Test)' assesses user proficiency in using Excel 2007, covering topics like addition of rows and columns, Goal Seek, function syntax, chart updating, cell...
Questions:
15 |
Attempts:
118 |
Last updated:
Mar 11, 2024
|
Spreadsheet Styles, Themes And Tables Quiz #6
Spreadsheet Styles, Themes and Tables Quiz #6 explores Excel 2007 features like Quick Styles, Live Preview, and custom cell formatting. It assesses understanding of interface...
Questions:
14 |
Attempts:
127 |
Last updated:
May 01, 2024
|
Excel 2007 Advanced Post Test
The 'Excel 2007 Advanced Post Test' assesses advanced skills in Excel 2007, including data formatting, cell content rotation, and use of the AutoSum feature. It is designed to...
Questions:
15 |
Attempts:
289 |
Last updated:
Mar 20, 2023
|
2nd Yr MS EXCEL 2007
Some people have had computers with them but are still unable to make maximum use of the excel sheet. As a second year student you should by now know how to use Microsoft...
Questions:
39 |
Attempts:
422 |
Last updated:
Sep 05, 2023
|
Computer Applications- Microsoft Excel: Microsoft Excel 2007 Basics
Explore the fundamentals of Microsoft Excel 2007, including interface navigation with the Office Button, understanding cells, rows, and columns, and data entry techniques. This...
Questions:
15 |
Attempts:
600 |
Last updated:
Apr 18, 2023
|
Wait!
Here's an interesting quiz for you.