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
Only when using Excel 2003 or earlier versions
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
False, you may change filters up to three times
False, you may change filters as many times as you please without limits
False, tables cannot be filtered
Default Pivot Table Layout
Classic Pivot Table Layout
Master Pivot Table Layout
Operation Geronimo Layout
False, only rows may have headings
False, pivot tables do not contain enough information for graphs or charts
False, only regular tables may be used to create graphs or charts
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
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
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.
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
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
Yes, but the file must be saved with a different file name
No, once a file is saved, cell data cannot be changed
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
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
Clicking three times with the right mouse button in the spreadsheet
Using the Edit - Select All menu item
Pressing CTRL + A on the keyboard
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
Pressing CTRL + I on the keyboard
Using the Tools - Wizard - Web Form menu item
Using the Format - Cells - Font menu item
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.
FORMAT - SELECTED AXIS - SCALE - Select options required
FORMAT - CHART - AXIS - SCALE - Select options required
Format Tab - Format Selection - Axis Options - Select options required
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.
View side by side