A ____ is a prewritten formula that is built into Microsoft Excel

Function

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra

Operations

Cell References that automatically adjust in a copied and pasted formula are called ____ references

Relative

One popular metaphor for visualizing a file system is an upside-down _____

Tree

When using the PMT function to calculate monthly loan payments, the interest rate and the number of payments should be based on the interest rate per month and the total ___ to pay off the loan

Months

The ___ options button lists error-checking options following the assignment of an invalid formula to a cell

Trace Error

The ___ function calculates the interest rate charged or received during each payment period

RATE

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range

AVERAGE

A table name can include

Numbers, letters, and underscores

The ____ function determines the lowest number in the range

MIN

You can use the ____ to check which cells are referenced in the formula assigned to the active cell

Range Finder

Conditional formats in Excel

Icon sets, cell highlighting, and data bars

The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent

Accounting number format

This part of the Excel screen displays the contents of the active cell

Forumla Address Bar

In Excel, _____ view allows you to create or modify a worksheet while viewing how it will look in printed format

Page Layout

To start a new line in a cell, press the ____ keys

ALT + ENTER

The _____ function calculates the amount paid into an investment or loan during each payment period

PMT

In Excel, a cell reference that remains constant when a formula is copied down a column is referred to as an _____ reference

Absolute

Excel's ____ view allows you to modify a worksheet's print layout, providing a method to quickly adjust the breaks between pages

Page Break Preview

A ______ chart provides a simple way to show trends and variations in a range of data within a single cell

Sparkline

You should use a ____ chart to show the relationship or proportion of parts to a whole

Pie

A ____ is a separate sheet in a workbook that contains only a chart

Chart Sheet

A pie chart with one of more slices offset is called a ___

Exploded Pie Chart

If the formula in a cell references a range of cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message

=REF!

____ order arranges labels in alphabetical order, from A to Z

Ascending

Information created in Excel is saved in a file called a _____

Workbook

To deselect a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ___ on the shortcut menu

Ungroup Sheets

Which of the following formulas contains an absolute cell reference

=$B$8

The ____ function is useful when you want to assign a value to a cell based on a logical test

IF

____ refers to cells not wide enough to display the entire numeric entry

#####

When you set up an Excel worksheet, you should use cell references in formulas whenever possible, rather than ___ values

Constant

_____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell

Goal

The ____ function is a logical function that returns a TRUE value if all of the logical conditions are TRUE and a false value if all the logical conditions are false

AND

When you retrieve a particular value from a lookup table, the ____ value is the value you are trying to find

Lookup

The top level of the file system in PC-nomenclature is known as the _____

Root Directory

The default cell format in Excel is ____

General

After you filter a column, the ___ Filter command becomes available so you can remove the filter and redisplay all the records

Clear

When a worksheet group is selected, the ___ includes text to indicate the sheets are in fact grouped

Title Bar

The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE

OR

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a ____ column

Calculated

Microsoft Excel's Goal Seek changes the ____ values to produce the resulting values you seek to determine

Input

One way to display formulas in Excel is by pressing this key combination

Ctrl + `

The COUNT function _____

Counts the number of cells that contain numbers within the selected range

When copying or moving cells, if data already exists in the destination cells, Excel ___

Replaces the contents

This type of excel chart is used to depict trends and change over time intervals

Line

This part of the excel screen displays the cell reference of the active cell

Name Box

By default, files created with Excel 2013 are saved with the ____ extension

.xlsx

A _____ is a group of adjacent cells in an Excel worksheet

Range

Which of the following chart types is characterized as always having one data series?

Pie

There are 3 general types of cell entries that a user can enter into the cells of an Excel worksheet. These include: texts, numbers, and _____

Formulas