Excel Midterm Review Flashcards

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

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

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

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

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

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

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

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

A table name can include

The ____ function determines the lowest number in the range

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

Conditional formats in Excel

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Which of the following formulas contains an absolute cell reference

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

____ 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

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

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

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

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

The default cell format in Excel is ____

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

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

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

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

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

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

The COUNT function _____

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

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

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

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

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

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

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 _____