Name: 

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

An Excel workbook has the file extension .xml.

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

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

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

In an Excel complex formula, addition and subtraction operators are calculated before multiplication and division operators.

An Excel formula can include more than one operation; for example, multiplication and addition.

Functions are organized into categories, such as Financial, Date & Time, and Statistical, based on their purpose.

To enter a function into a cell, you can manually type the function, including its arguments, into the cell.

Formatting can change the actual data of a cell.

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

You can apply formatting before or after you enter data in a cell or range.

You can change the font and font size of any cell or range using the Mini toolbar.

The horizontal axis is also called the value axis.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

Any data changed in the worksheet is automatically updated in the chart.

Moving a chart object around on a worksheet can affect the data in the worksheet.

You can create multiple charts based on the same worksheet data.

When the landscape orientation is selected, the data and chart will be positioned vertically on a page.

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

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

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

The Excel operator for division is ____.

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

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

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

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

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

The formula =(20-8)/6 equals ____.

The order of precedence in Excel formulas can be changed by using ____.

SUM and AVERAGE are examples of ____.

If you use a function alone, it always begins with the formula prefix ____.

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

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

You can create an absolute cell reference by selecting a cell address on the formula bar and then pressing ____.

An Excel template has the extension ____.

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

The ____ size is the physical size of the text.

The dialog box shown in the figure above is opened by right-clicking a cell and then clicking ____ on the shortcut menu.

As shown in the figure above, item ____ points to the Merge & Center button.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

To show how individual volume changes over time in relation to total volume, use a(n) ____.

As shown in the figure above, item ____ represents a data point.

The arrows shown in the figure above point to ____.

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.