Coastal Construction Assessment - Microsoft Excel
Settings
- 1.What is a worksheet tab in Excel 2007?
- A.
A worksheet tab is used to access tools associated with the worksheet
- B.
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
- C.
A worksheet tab is used to get help when working with Microsoft Excel 2007
- D.
A worksheet tab is used to move from one cell to the next cell in a worksheet
- 2.True or False: Tables created through Excel's table feature allow users to filter columns by different values.
- A.
True
- B.
False
- 3.True or False: Pivot tables allow filtering of table information by different values in column and row headers.
- A.
True
- B.
False
- C.
Only when using Excel 2003 or earlier versions
- 4.Creating tables is as easy as highlighting cells that have already been filled in appropiately, followed by clicking on the insert tab and then clicking on the table button.
- A.
No, highlighting cells disables the ability to create tables
- B.
Yes, it is that simple, but the highlighted cells must have numerical data
- C.
No, you go to the home tab and then click on the table button
- D.
Yes, it is that simple, but the highlighted selection should not contain any blank cells
- 5.Once data in a table gets filtered, you can neither unfilter the table nor get the table back to the original settings.
- A.
False, you may change filters up to three times
- B.
True
- C.
False, you may change filters as many times as you please without limits
- D.
False, tables cannot be filtered
- 6.Which pivot table layout allows the dragging of fields to the grid in a spreadsheet?
- A.
Default Pivot Table Layout
- B.
Classic Pivot Table Layout
- C.
Master Pivot Table Layout
- D.
Operation Geronimo Layout
- 7.True or False: For a table to work properly, the top row should have column headings.
- A.
True
- B.
False, only rows may have headings
- C.
False
- 8.True or False: Pivot tables that have been created can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.
- A.
True
- B.
False, pivot tables do not contain enough information for graphs or charts
- C.
False, only regular tables may be used to create graphs or charts
- 9.What is the function of the Formulas tab in Microsoft Excel 2007?
- A.
The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically
- B.
The Formulas tab contain only the most common formulas supported by Excel
- C.
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
- D.
The Formulas tab is used for automatic creation of a complete formula without any user interaction at all
- 10.Which of the following Excel features allows you to summarize the data in a large table?
- A.
Data Validation
- B.
Conditional Formatting
- C.
Pivot Table
- D.
Hyperlink
- 11.When number signs (#####) are displayed in the cell, it means:
- A.
There are too many characters in the cell to be displayed with the current cell width
- B.
The formula in the cell is wrong
- C.
The decimal point placement in the cell is wrong
- D.
All of the above
- 12.What does the Format Painter button do?
- A.
Only changes the color of each cell
- B.
Only changes the color of a group of cells that you choose
- C.
Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.
- D.
Only copies formulas from one cell or group of cells to another.
- 13.By default, each workbook automatically has 3 sheets labeled on the bottom tabs: Sheet 1, Sheet 2, Sheet 3. To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, what has to be done?
- A.
Right click on sheet 2 and select insert
- B.
Right click on sheet 1 and select insert
- C.
Right click on sheet 3 and select insert
- D.
None of the above
- 14.When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?
- A.
Seperate the page into two for easier printing
- B.
Use the Fit to Page option
- C.
Highlight all cells to print and print selection
- D.
None of the above
- 15.Once data is entered into a cell, can it be edited?
- A.
Yes, but the file must be saved with a different file name
- B.
No, once a file is saved, cell data cannot be changed
- C.
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
- D.
No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
- 16.A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
- 17.What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?
- A.
F3
- B.
F5
- C.
F7
- D.
F9
- E.
F11
- F.
F13
- 18.Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
Count
- B.
Average
- C.
Sum
- 19.Which of these will NOT select all the cells in a document?
- A.
Clicking three times with the right mouse button in the spreadsheet
- B.
Using the Edit - Select All menu item
- C.
Pressing CTRL + A on the keyboard
- 20.
![When you see a cell with a red triangle in the top right corner, what does this signify?]( "When you see a cell with a red triangle in the top right corner, what does this signify?")
When you see a cell with a red triangle in the top right corner, what does this signify?- A.
There is an error in the cell
- B.
There is a comment associated with the cell
- C.
The font color for text in the cell is red
- D.
A formula cannot be entered into the cell
- 21.Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
![]()
- B.
![]()
- C.
![]()
- 22.Which of the following will NOT set text in selected cells to ITALICS?
- A.
Pressing CTRL + I on the keyboard
- B.
Using the Tools - Wizard - Web Form menu item
- C.
Using the Format - Cells - Font menu item
- 23.Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
Yes
- B.
No
- 24.How do you turn off automatic calculation for a spreadsheet ?
- A.
You cannot turn off automatic calculation - its built into the spreadsheet / workbook.
- B.
Right click on the spreadsheet tab and select MANUAL CALCULATION.
- C.
Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.
- 25.What is the keyboard shortcut (button or buttons to be pressed) to Complete a cell entry and move up in the selection ?
- A.
CTRL+TAB
- B.
SHIFT+TAB
- C.
ALT+TAB
- D.
SHIFT+ENTER
- E.
CTRL+ENTER
- F.
ALT+ENTER
- 26.When working with a chart, which of the following will allow you to change the spacing of tick marks and labels on the category axis ? Click on the desired axis and go to:
- A.
FORMAT - SELECTED AXIS - SCALE - Select options required
- B.
FORMAT - CHART - AXIS - SCALE - Select options required
- C.
Format Tab - Format Selection - Axis Options - Select options required
- 27.What does the following error mean - #REF! ?
- A.
The #REF! error value occurs when a cell reference is not valid.
- B.
The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.
- C.
The #REF! error value occurs when a cell has been formatted as a currency but contains text.
- 28.Which feature in Excel allows you to view two spreadsheets in one window?
- A.
Freeze panes
- B.
Split
- C.
View side by side
- 29.What must first be created before copying the results of an advanced filter to another location?
- A.
Criteria range
- B.
Output range
- C.
Setup range
- D.
Filter range
- 30.Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?
- A.
ROUND
- B.
ROUNDUP
- C.
ROUNDDOWN
- D.
RAND
.gif)
Back to top