ITE CHAP 1 Test Review

A data label

A ____ in a pie chart identifies the pie slices.

field

A ____ is a single piece of information that is stored in every record.

validation list

A _____ is a list of values that are acceptable for a range of cells.

green

A _____ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.

chart area

A chart and all of its elements is known as the ____.

A data point

A chart value that originates in a worksheet cell is referred to as____.

Trace Precedents command

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the _____.

determining the Future value (Fv)

A data tables is useful for all of the following except for _____.

data

A defined name provides a logical reference to ____.

cell style

A defined set of formatting characteristics for a cell, such as fonts, font sizes, number formats, cell borders, and cell shading is known as a(n)_____.

Cell style

A defined set of formatting characteristics such as font, font size, and font color are known as a___.

another location in the worksheet or the company intranet

A hyperlink in a worksheet may take you to which of the following locations _____.

Goal seek

A method to find a specific value for a cell by adjusting the value of one other cell is _____.

Theme

A predesigned set of colors, fonts, lines, and fill effects that look good together and can be applied to you workbook is a _____.

theme

A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied across all Office 2016 applications is called a ______.

data table

A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it east to calculate multiple versions in one operation is a(n) ____.

list

A series of rows that contains related data is known as a _____.

Data validation

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called _______.

Label

A text value in Excel is also referred to as a____.

text and headings

A theme combines font sets for _____.

defined name

A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value is called a _____.

absolute cell reference

A(n) _____ refers to a cell by its fixed position in the worksheet.

=sign

All formulas begin with a(n)_____.

Select the range, click in the Formula bar, and then type the name

All of the following are methods to define a name for a cell or group of cells except:______.

formula

An advantage to naming a range of cells is that you can use the name in a _____.

VLOOKUP

An excel function that looks up values in a table array arranged as vertical columns in the _____ function.

tracer arrow

An indicator that shows the relationship between the active cell and its related cell is called a(n) ____.

database

An organized collection of facts related to a specific topic is known as a _____.

Cell Styles

Apply styles to cells, such as Headings and Titles and Data and Model, by using the command in the Styles group.

with two or more cells

AutoFill will fill a series when you establish a pattern ___.

orientation and page breaks

Before printing or distributing a large worksheet, the Print Preview option enables you to see _____.

.xlsx

By default, Excel 2016 filed are saved in the native Microsoft Excel Workbook file format with the following file extension.

precedent cells

Cells that are referred to by a formula in another cell are called _____.

hyperlink

Clicking a _____ will take you to another location in the worksheet, another file location, a webpage on the intranet, or to your organization's Internet.

two decimal places

Comma Style format displays a number with____.

uppercase and lowercase letters

Defined names can contain _____.

Defined names can contain spaces

Each of the following is a rule for defining names except: _____.

relationships

Excel's Formula Auditing features can show ____ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.

mixing Colors and Fonts from any of the supplied themes

Fonts are associated with different themes and can be customized by ____.

in ascending order

For lookup functions to work properly, the data in the table array must be sorted ____.

Ctrl

Hold down the___ key to select nonadjacent cells.

It is a green plus sign

How can you identify the Chart Elements button when you select a chart?

Even rows are formatted differently from odd rows

How do banded rows display?

Row numbers display in blue

How do you know if some rows of a table have been hidden from view when a filter is invoked?

Text and graphics

Hyperlinks can be attached to which of the following items?

a background color

If a sheet tab has ____ you know that it is not selected.

Modify the hyperlink to reflect the change

If the file to which a hyperlink refers to is moved to renamed, or a webpage to which a hyperlink refers has a new address, which of the following do you need to do the hyperlink to make it work correctly.

the pie slices will be automatically updated

If you edit data in a worksheet that is associated with a pie chart ____.

And comparison operator

If you want every one of the comparison criteria that you specify to be true, you would use the _____.

numbers

In Excel 2016, row heading are identified by_____.

Set cell

In Goal Seek, the____ box contains the formula that calculates the information you seek.

To value

In Goal Seek, you enter the specific value that you want to achieve in the _____ box.

Paste Special command to display commands for Paste Values

In a cell that contains a function, to copy the VALUE to another to cell-rather than the function-use the _____.

Print Titles and Scale to Fit

In a large worksheet, which two Excel commands help to make the worksheets attractive and easier to read?

The x-axis

In a line chart, which of the following resides along the bottom of the chart?

table array

In a lookup formula, the defined range is referred to as the ____.

rate

In the Excel PMT function, the term used to indicate the interest rate for a loan is called _____.

On the title bar

In the Excel window, where does [Group] display when worksheets are grouped?

extracting

Instead of displaying a filtered list, you can copy the results of a filter to another area of you worksheet for comparison purposes; this action is known as ______.

The hyphen key and the forward slash key

On your keyboard, which two symbols function identically in date formats?

commas

Saving an Excel worksheet as a CSV file separated the cells of each row with _____.

tab delimited text file

Saving an Excel worksheet as a ____ separated the cells of each row with tab characters.

horizontal and vertical

Scaling reduces the _____ size of the printed data by a percentage or by the number of pages you specify.

underlined

Sheet tab names are _____ when they are grouped

detail

Subtotaled rows that are totaled and summarized are referred to as ____ data.

Comparison operators

Symbols used in search criteria. (>, <, =, >=, <=, <>)

contain a number

The COUNT function counts the number of cells in a range that ____.

the range of cells to check and the criteria

The COUNTIF function has two arguments____.

yellow diamond

The Error checking button displays as a ______.

zero

The Future value (Fv) at the end of the time period in an Excel function is usually ______ for loans.

the middle value in a range of cells

The MEDIAN function finds____.

blue dashed lines and the page number on the worksheet

The Page Break view shows where the page breaks will occur by displaying ____.

zero decimal places

The Percent Style button formats selected cells as a percentage with_____.

HLOOKUP

The ____ function looks up values in a table array arranged in horizontal rows.

Clipboard

The ____ is the temporary storage location for cell contents copied from a worksheet.

Error checking

The _____ command checks for common errors that occur when using formulas.

interest

The amount charged for the use of borrowed money is called ____.

General

The default number format for cells is the____ number format.

List

The defined table range will automatically display as the _____ range in the Advanced Filter dialog box.

field

The first step in adding subtotals to a group or list is to sort the data by the ______ for which you want to create a subtotal.

Ctrl+F2

The keyboard shortcut to display Print Preview is____.

scope

The location within which a defined name is recognized without qualification is referred to as the ____.

show and hide

The outline bar along the left side of a worksheet enabled you to _____ levels of detail with a single mouse click.

panes

The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lined as a result of using the Freeze Panes command are referred to as _____.

what-if analysis

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as _____.

What-If Analysis

The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called _____.

F4

The quickest way to repeat an action in Excel is the ____ function key.

principal

The total amount that a series of future payment is worth is called the ______.

y-axis

The value axis is also known as the___.

status bar

The____ displays the current cell mode, the page number, and the zoom buttons.

Sparklines

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called___.

custom filter

To apply complex criteria to a single column, use a(n)

File

To display the document properties, click the____ tab.

Freeze Panes

To freeze column and row titles on the screen so that they are visible while you scroll, which of the following command(s) would you use?

Go To

To move to a specific cell or range of cells in a large worksheet use the ____ command.

Go To Special

To move to cells that have special characteristics, are blank, or contain constants, use the _____ command.

red diamond

To rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the _____.

Save as

To save an Excel file in another file format, use the ____ command.

one-variable data table

To see how different interest rated affect a monthly payment, use a _____.

two-variable data table

To see how different interest rates and different payment periods will affect a monthly payment, use a _____.

Shift; drag a corner sizing handle

To size a chart proportionately, hold down the _____ key and ______.

Arrange All

To tile multiple open worksheets on the screen, use the ____ command.

Up to 360 degrees

To what extent can a pie chart be rotated?

Custom filter

Use a(n) ____ to apply complex criteria to a single column.

Ctrl

Use the ____ key to select A5:A8 and D5:D8.

Trace Error

Use the _____ command t locate and resolve an error in a formula.

Press and hold for a few seconds

Using a touchscreen, which of the following actions is the same as right-clicking the mouse?

What-If Analysis

Using various interest rates to determine the amount of loan payments is an example of using _____.

Sheet1, Sheet2, etc.

What are the default names of worksheets?

Format and Design

What are the two contextual tabs that display under Chart Tools when a chart is selected?

The value of a cell relative to other cells

What does a data bar in a cell represent?

Vertical or horizontal bars

What is a pane bounded by?

A worksheet where totals from other worksheets are displayed

What is a summary sheet?

A series of rows and columns that contains related data that can be managed independently from other data in a worksheet

What is an Excel table?

Ctrl+E

What is the keyboard shortcut for flash fill?

a colored border with small boxes on each side

When a cell is part of an active formula, it is surrounded with ____.

dotted lines

When formatting a worksheet to be printed, ____ show where page breaks are located.

vertical dotted line between columns

When preparing a document for printing, a ___ indicated that only the columns to the left will be printed on the first page.

Tap the item

When using a touchscreen, which of the following actions is the same as clicking an item?

It is centered on the page

When you print a chart sheet, how is it automatically formatted?

Formula AutoComplete list

When you start typing a formula, such as =SUM (B Excel will display the ______, which contains all of Excel's built in functions starting with the letter B.

The cell below

When you type data in a cell and press Enter, what cell becomes the active cell?

left-alined

When you type text in a cell it is____.

Lower area of the workbook window

Where do sheet tabs display in a workbook?

The computer's clock

Where does Excel's NOW function retrieve the date from?

On the mini toolbar and the Home tab

Where is the Format Painter button located?

In the lower right corner of a selected cell

Where is the fill handle located?

Flash Fill

Which of the following Excel features recognizes a pattern in the data of a worksheet?

Excel Template, Excel 97-2003 Workbook, CSV or tab delimited

Which of the following are some frequently and commonly used file formats for Excel?

Record

Which of the following describes all of the categories of data pertaining to one person, plan, thing, event, or idea within a table row?

A line chart

Which of the following displays trends over time?

Move Chart button

Which of the following does not display to the right side of a selected chart?

CSV

Which of the following file formats is commonly used to import data into a database program?

It remains constant even when the workbook is opened

Which of the following if FALSE about the NOW function?

Ctrl+=

Which of the following if NOT a way to insert the SUM function into a cell?

It can contain only one worksheet

Which of the following is FALSE about a workbook?

The active worksheet tab displays in red font

Which of the following is FALSE about worksheet tabs?

By using a Function button on the status bar

Which of the following is NOT a way to create a formula?

Maximum

Which of the following is NOT one of the default calculations displayed by AutoCalculate?

Three decimal places

Which of the following is NOT part of the Accounting Number Format?

It shows the relationship of each part of a whole

Which of the following is TRUE about a pie chart?

General format, Calibri, 11 pt

Which of the following is the default number format in Excel 2016?

Expressions within parentheses

Which of the following is the first order of operations?

Exponentiation

Which of the following is the second order of operations?

The y-axis

Which of the following resides along the left side of a column chart?

Height

Which of then following is NOT one of the three spatial dimensions of 3-D?

$

Which symbol represents that a cell is an absolute cell reference in a function or formula?

#

Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?

Format as Table

You can create a custom table style by clicking ____.

scaling

You can force the data in a worksheet into a selected number of pages using the _____ command.

.txt

You can save an Excel file as a text file with which of the following file extensions?

printing paper copies, sending the file electronically, or posting the file to the web or a shared workspace

You can share worksheets or workbooks with others by ____.

two ranges

You must select ____ on a worksheet to create a pie chart.

Filtering

____ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.

F7

____ is the keyboard shortcut for the Spelling command.

Precedent

_____ cells are cells that are referred to by a formula in another cell.

Trace Dependents command

_____ displays arrows that indicate what cells are affected by the value of the currently selected cell.

A data series

_____ is a group of related data points represented by data markers.

Rounding

_____ is a procedure that determines which digit to the right of a number will be the last to be displayed.

Goal Seek

_____ is an Excel tool that finds the input needed to arrive at a desired result.

Auditing

_____ is the process of examining a worksheet for errors in formulas.

ScreenTip

_____ that will display when the cell is selected and that provides instructions to the person entering data.

Lookup

______ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.