Exam 15: Excel 2007 Unit A: Getting Started With Excel 2007

You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. Below is the worksheet that you have created so far. You realize that you have made an error in the spreadsheet. Gary s score for test 2 should be 76, not 67. This error needs to be remedied. Please explain how you would go about fixing this error. Make sure to note what mode Excel would need to be in and how changes to C4 would affect a formula in D4.

As shown in the figure above, item 3 points to the ____.

The Excel operator for division is ____.

The cell in which you are working is called the ____________________ cell.

Possible paper orientations for printing a worksheet are landscape and ____.

____ consist of the information needed by a function to calculate an answer.

Describe Excel's built-in recovery feature.

When the paper orientation is set on landscape, the contents will print across the width of the page.

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

In Excel, a worksheet is contained in a file called a ____.

In a worksheet, the ____ is called the formula prefix.

You can edit the contents of an active cell by ____.

You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. Below is the worksheet that you have created so far. Write formulas for finding the averages of each test.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

In Page Layout view, the dotted line indicates the print area.

Charts are updated automatically in Excel whenever data changes.

You can use the ____ key(s) on the keyboard to navigate a worksheet.

As shown in the figure above, item 1 points to the ____.

In the figure above, item 4 points to the ____ button.