1. When a new workbook is opened in Excel, which of the following is true?

 Formulas already exist in all worksheets.
 Three blank worksheets appear by default.
 The open worksheet is already scaled for printing
 The workbook is automatically saved when you close it.

2. Which of the following is true about entering formulas in Excel?

 Formulas can only exist in a single cell.
 Formulas must contain one of the following: <, >, <>.
All formulas must begin with an = sign.
Formulas may not contain text.

3. When using built-in functions in Excel, one may...

 use shortcuts on toolbar.
 use the formula palette.
 edit built-in functions in the formula bar.
all of the above.

4.  Absolute references in formulas can...

 anchor the formula reference to a particular row.
 anchor the formula reference to a particular column.
 anchor the formula reference to a particular cell.
 all of the above

5. In order to delete a formula from one cell and move it to a destination cell, one may...

 select copy from the edit menu, and paste copied formula into desired cell.
  click on cell containing formula, select copy, and paste formula into desired cell.
  use drag and fill to get formula into desired cell.
 none of the above.

6. To use conditional formatting, one must... 

 use the format painter.
 have at least two conditions set for data.
 select at least one condition for data, and one format change.
 select the entire workbook before setting conditions for data

7. When inserting a chart into an Excel spreadsheet, one must...

  use the chart wizard.
 link the chart to the entire workbook.
 have a data set to base the chart upon.
select a pie chart.

8. When creating an Excel spreadsheet, one can format...

  individual cells.
 entire rows.
 entire columns.
all of the above.

9. When inserting word art into an Excel spreadsheet, one must...

 merge and center cells where word art will appear.
 insert rows above data where word art will appear.
 go to the insert menu, or the word art shortcut on toolbar.
 color coordinate word art and any conditional formatting that may exist.

10. In order to save an Excel spreadsheet, one may...

 select the floppy disk icon from the toolbar.
 select the save option from the file menu.
 select the save as option from the file menu.
 any of the above.