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

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

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

To move a screen to the left press ____.

You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company s sales to send to the General Manager. Below is the worksheet that you have created so far. Write the complete formulas for finding the Yearly Sales figures for the three stores.

Excel recognizes an entry as a value if it is a number or it begins with ____.

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. Please write a formula for finding the difference between the two test scores for each student and add it in to the spreadsheet.

Describe calculation operators, including the different types of calculation operators.

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

Labels are numbers, formulas, and functions that can be used in calculations.

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

____________________ are equations in a worksheet.

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon .

You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company s sales to send to the General Manager. Below is the worksheet that you have created so far. Write the complete formulas for the Total row, which contains the total sales in all of the three stores in each quarter.

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

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

Clicking the ____________________ button sums the adjacent range above or to the left.

Discuss the advantages of using Excel worksheets.

When the paper orientation is portrait , the contents will print across the length of the page instead of across the width.

Tools on the Page Layout tab include a Page Setup group, where you can adjust print orientation, paper size, and page breaks.