This quiz assesses knowledge of Microsoft Excel 2007, focusing on worksheet tabs, table creation, and pivot tables. It tests practical skills in navigating and utilizing Excel features for data management and analysis, essential for both academic and professional settings.
Rate this question:
Pressing CTRL + I on the keyboard
Using the Tools - Wizard - Web Form menu item
Using the Format - Cells - Font menu item
Rate this question:
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
There are too many characters in the cell to be displayed with the current cell width
The formula in the cell is wrong
The decimal point placement in the cell is wrong
All of the above
Rate this question:
Yes
No
Rate this question:
A worksheet tab is used to access tools associated with the worksheet
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
A worksheet tab is used to get help when working with Microsoft Excel 2007
A worksheet tab is used to move from one cell to the next cell in a worksheet
Rate this question:
False, you may change filters up to three times
True
False, you may change filters as many times as you please without limits
False, tables cannot be filtered
True
False
Rate this question:
Seperate the page into two for easier printing
Use the Fit to Page option
Highlight all cells to print and print selection
None of the above
Rate this question:
The #REF! error value occurs when a cell reference is not valid.
The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.
The #REF! error value occurs when a cell has been formatted as a currency but contains text.
Rate this question:
Clicking three times with the right mouse button in the spreadsheet
Using the Edit - Select All menu item
Pressing CTRL + A on the keyboard
Rate this question:
Count
Average
Sum
Rate this question:
There is an error in the cell
There is a comment associated with the cell
The font color for text in the cell is red
A formula cannot be entered into the cell
Rate this question:
The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically
The Formulas tab contain only the most common formulas supported by Excel
The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab
The Formulas tab is used for automatic creation of a complete formula without any user interaction at all
Rate this question:
F3
F5
F7
F9
F11
F13
Rate this question:
True
False, pivot tables do not contain enough information for graphs or charts
False, only regular tables may be used to create graphs or charts
Rate this question:
Only changes the color of each cell
Only changes the color of a group of cells that you choose
Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.
Only copies formulas from one cell or group of cells to another.
Rate this question:
True
False
Only when using Excel 2003 or earlier versions
Rate this question:
Right click on sheet 2 and select insert
Right click on sheet 1 and select insert
Right click on sheet 3 and select insert
None of the above
Rate this question:
CTRL+TAB
SHIFT+TAB
ALT+TAB
SHIFT+ENTER
CTRL+ENTER
ALT+ENTER
Rate this question:
Data Validation
Conditional Formatting
Pivot Table
Hyperlink
Rate this question:
You cannot turn off automatic calculation - its built into the spreadsheet / workbook.
Right click on the spreadsheet tab and select MANUAL CALCULATION.
Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.
Rate this question:
True
False, only rows may have headings
False
Rate this question:
No, highlighting cells disables the ability to create tables
Yes, it is that simple, but the highlighted cells must have numerical data
No, you go to the home tab and then click on the table button
Yes, it is that simple, but the highlighted selection should not contain any blank cells
Rate this question:
Default Pivot Table Layout
Classic Pivot Table Layout
Master Pivot Table Layout
Operation Geronimo Layout
Rate this question:
FORMAT - SELECTED AXIS - SCALE - Select options required
FORMAT - CHART - AXIS - SCALE - Select options required
Format Tab - Format Selection - Axis Options - Select options required
Rate this question:
Freeze panes
Split
View side by side
Rate this question:
Criteria range
Output range
Setup range
Filter range
Rate this question:
ROUND
ROUNDUP
ROUNDDOWN
RAND
Rate this question:
Quiz Review Timeline (Updated): Jul 31, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Microsoft Excel 2007 Test: 4th Grade Quiz!
Microsoft Excel 2007 has many features that can’t be taught at one go and are taught progressively throughout our school years. Do you know the basics of how to use an...
Questions:
24 |
Attempts:
744 |
Last updated:
Apr 02, 2025
|
Business Analyst Excel Quiz
A business analyst uses excel software as his main tool of modeling to achieve a certain level of record keeping and reporting required to be informed, up-to-date, and able to...
Questions:
10 |
Attempts:
724 |
Last updated:
Mar 21, 2023
|
Microsoft Excel 2016 Test
Comparing Excel 2016 with 2013 and 2010, you might still come to notice quite a similarity and a little bit of familiarity. Nonetheless, working on the excel 2016 brings you...
Questions:
10 |
Attempts:
5876 |
Last updated:
Mar 22, 2023
|
Identify The Proficiency Of Microsoft Excel Quiz
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions:
122 |
Attempts:
194 |
Last updated:
Mar 21, 2023
|
End Of Term - Year 9
This quiz assesses knowledge on Microsoft Excel, covering topics like sheet management, formula results, and cell formatting for Year 9 students.
Questions:
28 |
Attempts:
119 |
Last updated:
Mar 21, 2023
|
Take The Ultimate Quiz On Microsoft Excel!
Looking for a quiz that can test your Excel knowledge? This Microsoft Excel Quiz is designed to test and enhance your knowledge of one of the most widely used spreadsheet software...
Questions:
19 |
Attempts:
1281 |
Last updated:
Oct 25, 2024
|
Wait!
Here's an interesting quiz for you.