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. You cannot create syntactically correct formulas in Excel, unless?

 The formula exists in a single cell.
The formula contains one of the following: <, >, <>.
The formula begins with a equal sign.
The formula contains text.

3. Built-in functions are accessible in all of the following ways, except?

 The paste function command on the Tool Bar.
 The Formula Palette.
 Open the Tools menu then select Shortcuts, then function.
Open the Insert menu and select Function.

4.  Absolute references in formulas can what?

 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. How do you delete a formula from one cell and then move it to a destination cell?

 Select Copy from the Edit menu and then paste the copied formula into the desired cell.
 Right click on the cell containing the formula, select copy, and then paste the formula into the desired.
 Use drag and fill to get the formula to the desired cell.
None of the above.

6. How does one use conditional formatting?

 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. Excel users can insert a chart into an Excel spreadsheet in all of the following ways, except?

 Open the Insert Menu; select Chart and follow the wizard.
 Open the Chart menu, select Insert, and then click OK.
 Select the data to be charted and click on the chart shortcut tool on the standard Tool Bar.
 Select the data to be charted and open the Insert Menu; select Chart

8.   When creating an Excel Spreadsheet one can format what?

 Individual cells.
 Entire Rows.
 Entire Columns.
All of the above.

9.   When inserting WordArt into a Excel spreadsheet, one must?

 Merge and center cells where WordArt will appear.
 Insert rows above data where WordArt will appear.
 Open the Insert menu and select Picture or use the WordArt shortcut on the Tool Bar.
 Color coordinate WordArt and any conditional formatting that may exist.

10. How does one save an Excel spreadsheet?

Select the Save option on the Tool Bar.
Select the Save option from the file menu.
Select the Save As option from the File menu.
Any of the above.