Excel Ch 1-10

An underlying value that does mathematical calculations on numeric values in a worksheet is _____.

a formula

When the Markers option in the Design contextual tab is checked, ____.

a mark for each data value is placed on the sparklines

When no cells are selected and the AutoSum button is clicked, Excel first looks ____ the active cell for a suitable range to sum.

above

A cell that remains the same when it is copied or filled to other cells is a(n) _______.

absolute cell reference

Technologies that are used to help non-visual users view content are ________ technologies.

accessibility

A cell that is outlined in green and has data typed in it is the _____ cell.

active

When the Total style is applied to a group of worksheets, ________.

all worksheets in the group receive the Total style

Test that is used to provide a description on an object is _____ text.

alternative

Right-clicking a row heading displays _____.

an Options button

When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays _____.

another up-arrow icon

In a function, the range in parentheses is the ________.

argument

A(n) ________ formula would be used to calculate the sum of the values in one column multiplied by the sum of the values in another column.

array

The INDEX function ________ returns a value from a location in a table or range of cells.

array

A worksheet inserted into a workbook using the New Sheet button is inserted _____.

at the end of the Tab group

A(n) _______, the line that borders the chart plot border area, is used as a frame of reference for measurement.

axis

A _____ chart compares individual items or categories of items where the categories are displayed on the vertical axis, and the values are displayed on the horizontal axis.

bar

A cell ________ is a line that can be used to emphasize or group cells.

border

Chart buttons are displayed when the _______ of the chart is clicked.

border

A ________ in a PivotTable report is derived from formulas you create, which can include other PivotTable fields.

calculated field

The process used by Excel to compute formulas and functions and display the results is called ____.

calculation

On a chart, a(n) ________ identifies the categories of data.

category label

When identifying a cell as C12, you are using its ______ address.

cell

Clicking the Paste button places the _____ in the destination cells.

cell content and cell formatting

What values does the user need to input or confirm in the Format as Table dialog box?

cell range and "My table has headers" option

The ________ records all changes made to a workbook, who made the change, and when the data was changed.

change history

The Excel feature that allows reviewers to see the changes made by all reviewers is ______.

change tracking

A custom chart type that you can save and apply like any other chart type is a _______.

chart template

The specific design of the way data is either displayed or compared in a chart is a _____.

chart type

A(n) ________ is a control that allows a user to select one or more values in a group of choices.

check box

One way to rename a worksheet tab is by ______.

clicking the Rename Sheet option of the Format button in the Cells group on the Home tab

A screen ________ is a picture of a portion of the computer screen that can be inserted into a worksheet.

clipping

A ____ chart is useful in comparing values across categories.

clustered bar

Which symbol inserted between two cell addresses indicates a range?

colon

In a table with manual or conditional formatting, a column can be sorted only by ____.

color

A ______ chart is used to illustrate comparisons of related numbers.

column

A calculated ________ is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table.

column

The letter that displays at the top of a column is the ____.

column heading

Arguments in a function are separated by a(n) _____.

comma

Tabular data formatted as ________ can be converted into columns using the Convert Text to Columns Wizard.

comma-separated values

A ________ is a control that runs a VBA macro when clicked.

command button

A ________ is descriptive text that is added to worksheet cells without modifying the data.

comment

In VBA, a programming ________ is a statement that documents what the code does.

comment

A _____ displays as a red triangle in the upper right corner of a cell.

comment indicator

The Logical test in the function IF function must contain a(n) ________ operator.

comparison

Data can be sorted based on the ________ applied to each cell in a column.

conditional formatting

The _______ command is used to summarize and report results from separate worksheets.

consolidate

Each cell in the blue range finder is represented by a ________, which can be a column, a bar, a dot, a slice of pie, or other appropriate symbol.

data marker

An Excel workbook can contain only one ____.

data model

When creating a chart, each cell in the blue range finder is a(n) _____.

data point

In a column chart, a group of related columns represents a ________ in the chart.

data series

A(n) ________ uses a range of cells to show how changing one or two values in a formula will affect the formula's result.

data table

A file in which the data in each column is separated by an identifying character such as a comma is a ________ text file.

delimited

The character used to separate columns of text in a data table is called a ____.

delimiter

To display records in a table that meet certain criteria, you would apply a _____.

delimiter

A cell value that gets it value from the value in another cell is a(n) ________ cell.

dependent

A ________ is a worksheet with cells referred to by summary sheet formulas.

detail sheet

Tab scrolling buttons are used to _____.

display worksheets tabs that are not in view

To determine a monthly rate in the PMT function, _____.

divide the interest by 12

When the Function AutoComplete list is used to enter the MAX function into an active cell, ________.

double-click on the name of the function in the list

When data series in a chart have mixed types of data, you can use a ___________ chart to plot a second value series.

dual axis

When using the MATCH function, a value of 0 for the Match_type argument will return the first value in the specified range that is ________ the Lookup_value.

equal to

A message that informs a user that invalid data has been entered in a cell is a(n) ________.

error alert

A message that appears in a cell when a formula cannot perform the specified calculations is a(n) _____.

error value

A plus sign next to a group in a PivotTable report is a(n) _______ icon.

expand

In a database, a ________ is a category of data organized in a column.

field

The standard way that information in a file is encoded for storage is called the _____.

file type

A cell _____ color is also known as the background color.

fill

The ________ button is the arrow to the right of a header row label in a table.

filter

The PMT function has a total of ________ arguments.

five

The number of decimals places and the appearance commas, dollar signs, or other symbols are features of number ____.

format

The bar, located below the Ribbon, that displays the active cell's contents is the ____ bar.

formula

When a formula is in an active cell, the underlying formula is visible in the ____.

formula bar

The ________ of an asset, such as an investment or a home, is its value at the end of a period of time.

future value

Which symbol is the error indicator that appears in a cell having a formula that has broken a rule?____

green triangle

The horizontal and vertical lines that intersect to create cells are called ____.

gridlines

An example of a(n) ________ is http://www.microsoft.com.

hyperlink

To remove columns from a worksheet, click Delete Sheet Columns after clicking the Delete arrow _____.

in the Cells group on the Home tab

An _______ can be used in or returned by a function to indicate the position of a value in a series.

index

A message that informs a user about the types of data allowed in a cell is a(n) ________.

input message

When multiple worksheets are grouped, inserting a row ____.

inserts it into all of the worksheets in the group

The ________ must remain fixed in order to calculate the future value of an asset.

interest rate

When a worksheet is inactive, _____.

its entire tab is filled with the selected color

The Freeze Panes command is useful in working with ____.

large worksheets

A(n) ________ is a control that is compatible with earlier versions of the program.

legacy object

A ________ is a chart element used to identify the data series in the chart.

legend

A unique color or pattern identifying data markers that belong to the same data series is displayed in the chart ________.

legend

To compare more than one set of values or trends over time, use a _____ chart.

line

A(n) ________ function applies a logical test to see if a specific condition is met.

logical

A ________ can be applied to a table that can be used to reference the table in formulas or to select the table.

name

PROPER(CONCATENATE(B2," ",C2)) is an example of a _______ function.

nested

In Excel, a file that is not the current Excel 2016 format is a _______ file.

non-native

A ________ data table changes a value in a formula using input from either a row or a column.

one-variable

When an embedded chart is selected and the worksheet is printed, _____.

only the chart is printed

In a delimited text file, each row ends with a ___

paragraph mark

A chart _______ is a quantity for which the value is selected for particular circumstances.

parameter

According to the rules of operator precedence, expressions using _____ are calculated first.

parentheses

According to operator precedence, the correct order of mathematical operations is ______.

parentheses; multiplication or division; addition or subtraction

The future value of an asset can be calculated when ________ are constant over time.

payments

The ____ chart type is NOT a sparkline option.

pie

To compare the relationship of parts to a whole, use a _____ chart.

pie

Worksheet data can be consolidated by ____________.

position or category

A cell value that is referred to in a formula or function is a(n) _______ cell.

precedent

When Print is clicked from the File tab, the right side of the Print pane is a _______.

preview of the page to be printed

Details that describe an Excel file, such as the author or title, are called the document ______.

properties

Two or more adjacent in a worksheet are a(n) _____.

range

The ______ outlines all the cells referenced in a formula.

range finder

The percentage that is paid for the use of the borrowed money is the ____.

rate

In a database, a ________ is the collection of related data that displays in a row.

record

The INDEX function ________ returns the reference of a cell at the intersection of a specified row and column.

reference

Which term is used to refer to automatic adjustment of cell references in a copied formula?

relative cell reference

The Select All Sheets option appears when the user ______.

right-clicks on a sheet tab

The ________ in a PivotTable use the values to categorize the data by rows.

row labels

A ________ is a set of values that Excel can save and substitute in cells to perform a what-if analysis.

scenario

In a dual axis chart, one or more data series can be plotted on a _______ axis.

secondary vertical

Double-clicking a worksheet tab will _____.

select the tab's name

Clicking a row heading ____.

selects the row

______ is a group of numbers, text, dates, or time periods that come in succession.

series

When a cell is active, its column and row headings are ______.

shaded

The process of applying transformations to data is known as ________ data.

shaping

A _____ workbook is one in which multiple users on a network can make changes at the same time.

shared

A worksheet that only contains a chart is called a chart ______.

sheet

A screen _______ is an image of the computer screen.

shot

Sheet tab grouping can be canceled by ________.

single-clicking on any worksheet tab

A tool used with a PivotTable to filter data based on distinct values in columns is a _______.

slicer

Before you can use the Subtotal tool to display summary statistics, you must ________ the column to be subtotaled.

sort

The ________ command divides the Excel window into separate panes so that each pane can be scrolled individually.

split window

In Excel, the term worksheet and ________ mean the same thing.

spreadsheet

In VBA, a programming ________ is a line of instructions in a sub.

statement

A ________ is a group of formatting choices that can be applied in a single step.

style

A chart ________ is a prebuilt chart format that applies an overall visual look to a chart.

style

In VBA, a ____ is a set of instructions that is part of a program.

sub

A _______ is a worksheet that displays and summarizes totals from other worksheets.

summary sheet

When a selection has been made and the cut button or copy button is clicked, the selection is _____.

surrounded by a moving border

When a cell is part of an active function, it is _____.

surrounded by moving border

A ________ is a character not found on a standard keyboard.

symbol

Subtotaled data is displayed as a(n) ________ with three levels.

table

A ________ is a collection of table formatting options that can be applied to a range with a single click.

tablet style

A prebuilt workbook that already contains content and formatting which can be used as a pattern to create a new workbook is a _______.

template

A(n) ______ can be used so you do not have to start with a blank workbook.

template

A ________ file is one that stores only characters and no formatting.

text

When Clear Content is selected from the Clear button options, only the ________ is removed from the cell.

text

A ______ is an object that can be inserted on a worksheet to provide additional information.

text box

The displayed value of a cell is replaced with a series of # symbols when _______.

the column is too narrow to display the entire value

When a range is selected, the name box displays the cell address of _____.

the first cell in the range

That Freeze Panes is being used in a worksheet is indicated by ________.

the line along the border

The IF function can have a maximum of ________ argument(s).

three

A small sample image of a style displayed in a gallery is a ____.

thumbnail

A font theme consists of two fonts for ___.

title and text

In a PivotTable report, the default statistic that is calculated for each group is a(n) ____.

total

If content exists in cell B1, and a long text value is entered into cell A1, the A1 display is ______.

truncated.

A _______ data table changes one value in a formula using one input from a column and one input from a row.

two-variable

The cell content shown in the formula bar is referred to as the ____ value.

underlying

Once a worksheet is protected, you must _______ any cells to which you want to allow changes.

unlock

When a range of cells are deleted, by default the remaining cells are shifted ____.

up

When pasting a range of cells, you only need to select the ______ corner of the paste area.

upper left

A copy of Excel can be personalized by adding a(n) ________ in the Excel Options dialog box.

user name

The axis on a chart that displays the numeric data from the worksheet is the ______.

value axis

The PivotTable ________ display the summary statistics for the selected fields in the report.

values

When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of ____.

visible cells in the column that contain a number value

When Excel opens, a new blank _______ is displayed.

workbook

Select All Sheets is an option that appears when a(n) ______ is right-clicked.

worksheet tab

Pages in a workbook are referred to as ______.

worksheets

An array formula is enclosed in _______ brackets.

{ }

If there is no match when a Lookup function is employed, the ________ error value occurs.

#N/A

If the referenced cells in a formula do not contain any data, the ________ error value occurs.

#REF!

When a formula contains the wrong type of data, the ________ error value occurs.

#VALUE

Placeholders for predefined headers and footer begin with _________.

&

When a watermark is inserted into a worksheet, the field displays as ____.

&[Picture]

If a year is displayed as -2018- using a custom number format, the format used would be _____.

-yyyy-

The file extension used for a chart template is ______.

.crtx

The custom number format Mm-Dd-yyyy would display the date 2/5/18 as _____.

02/05/2018

If loan payments will be made monthly for 10 years, ________ should be entered as the Nper argument in the FV function.

120

A(n) ____ chart appears to have the length, width, and depth dimensions.

3-D

If the annual interest rate of a loan is 5% and you want to calculate the interest rate for each monthly payment, you would enter ________ as the Rate argument in the FV function.

5% / 12

If a date is typed as 7-5-17, Excel will computer it as _____.

7/5/2017

Which of the following formulas would be used to apply conditional formatting if the value in K10 is more than 5000?

=K10>5000

The _______ Excel formula accurately displays the use of a cell from another worksheet.

=May!B6

Which is an example of an Excel function?

=SUM(D6:D8)

Which cells are included in the notation A1:D1?

A1, B1, C1, and D1

The ________ function returns a value of TRUE only when ALL specified conditions are true.

AND

The ______ function is a statistical function that adds a group of values and then divides the result by the number of values in the group.

AVERAGE

The ________ function is used to calculate the average of a range of cells that meet one criterion.

AVERAGEIF

The function used to calculate the average of cells that meet multiple criteria is ______.

AVERAGEIFS

Options in the Themes group on the Page Layout tab include all of the following EXCEPT _____.

Alignment

After the fill handle is used to copy cell content, the ____ button appears to the right of selected cells.

Auto Fill Options

The Excel feature used to automatically adjust column width to the longest column entry is ______.

AutoFit

The __________ feature allows you to define intervals at which to save copies of all open Excel files.

AutoRecover

The _____ button inserts a function that sums selected cells.

AutoSum

______ can be used in a PivotTable report to visually separate the data.

Banded columns

A lookup function that returns a value from a list based on an index number is the _______.

CHOOSE

The ________ function is used to join the text from two or more cells into one cell.

CONCATENATE

The ________ function counts the number of cells that are in the entered range and contain numeric values.

COUNT

The ________ function is used to count the number of cells in a range that are not blank.

COUNTA

The ________ function is used to count the number of cells in a range that meet one specified criterion.

COUNTIF

The ________ function defines categories and how data is aggregated in an OLAP cube.

CUBEMEMBER

The _______ function defines the values derived from the cross-tabulation of the categories in an OLAP cube.

CUBEVALUE

The default font face and size for text in Excel 2016 is _____.

Calibri, size 11

Themed Cell Styles is an option in the ______ gallery.

Cell Styles

Once you create a custom cell style, you can apply it to selected cells by clicking it in the ____.

Cell Styles gallery

The Chart Elements button displays options for all of these EXCEPT _____.

Chart Caption

To generate a report of potential accessibility issues use the Accessibility ____.

Checker

All of the following are options of the Clear button EXCEPT

Clear Error Value

The cut and copy commands make use of temporary storage called the ______.

Clipboard

When formulas are displayed in a worksheet, what happens?

Column width is increased.

Which number format adds commas where appropriate and displays two decimals?

Comma

The process that combines the changes from multiple copies of a workbook into a single copy is called _____.

Compare and Merge

What is applied to a cell when the value of the cell meets a specified condition?

Conditional formatting

Non-adjacent cells can be selected in a worksheet by holding down the ______ key.

Control

_____ data between Microsoft applications makes it easy to reuse data without having to retype the data.

Copying

The keyboard shortcut to insert the current date, obtained from your computer is _____.

Ctrl + ;

Which cells are included in the sum calculated by the function =SUM(D5:G5)?

D5, E5, F5, and G5

____ rules place restrictions on the types of data that can be entered into cells.

Data validation

The TODAY and NOW functions are in the ________ category in the Function Library group of the Formulas tab.

Date & Time

From the Info view on the File tab, you can access the ________ dialog box that allows you to search for and remove comments, metadata, and other hidden elements.

Document Inspector

In addition to using the options in the Format Cells dialog box, you can apply borders to cells by using the ________ pointer.

Draw Borders

After typing the new name of a worksheet tab, press the ______ key to accept the name change.

Enter

A trendline in which the data points create a symmetric arc is a _______ trendline.

Exponential

The PivotTable _______ pane is used to change fields from rows to columns, to add or remove fields, and to change the fields used to calculate values.

Fields

___ displays only the data that satisfies specified conditions.

Filtering

________ can be used to recognize a pattern in data and then automatically have the data entered for you.

Flash fill

The _____ displays a list of functions that match the first letter typed.

Formula AutoComplete

The Unfreeze Panes option appears when the ______ button is clicked.

Freeze Panes

The ________ dialog box is where the user enters cell addresses, cell ranges, or constants to complete a function.

Function Arguments

You can use the _______ function to retrieve summary data from a PivotTable report.

GETPIVOTDATA

You can change the user name for your copy of Excel in the ________ section in the Excel Options dialog box.

General

___ is a what-if analysis tool that finds a specific value for a cell by adjusting the value of another cell.

Goal Seek

When multiple worksheet tabs are selected, the title bar displays the word ______ after the name of the workbook.

Group

The _______ function looks for a value in the top row of a table and returns a value from a row in the same column.

HLOOKUP

Options to insert a field, such as a filename, into a header or footer are in the _____ group

Header and Footer Elements

The ________ worksheet displays the entire change history and does not display again when the workbook is closed and reopened.

History

____ classify a range of data into three to five categories and display small graphics in each cell, depending on that cell's value.

Icon sets

The ________ Error alert is the most flexible and allows the user to just click OK to accept invalid data.

Information

The ________ add-in assists with analyzing and reviewing workbooks to understand their design function and data dependencies.

Inquire

The Insert WordArt button is on the ____ tab of the Ribbon.

Insert

Which date is assigned the serial number of 1?

January 1, 1900

A trendline that has data points following a nearly straight line is a(n) ________ trendline.

Linear

The result of a _______ function depends on whether a condition is true or false.

Logical

The ________ function searches for a specific item in a range and returns the relative position of the item.

MATCH

To find the biggest value in a list of numbers, use the _______ function.

MAX

The _______ function returns a specified number of characters starting from a specified position in the data.

MID

To find the smallest value in a list of numbers, use the ______ function.

MIN

The ____ dialog box is used to relocate a chart to a chartsheet.

Move Chart

A trendline that has data points following a smooth curve to show data fluctuations is a(n) _______ trendline.

Moving Average

Excel evaluates the formula =4-2*6/2+7 and performs _______ first.

Multiplication

The ______ function returns the serial number of the current date and time.

NOW

In the PMT function, the ________ argument indicates the total number of payments for a loan.

Nper

Number formats can be adjusted with options in the Styles and _____ groups on the Home tab.

Number

The ________ function returns a value of TRUE when at least one of the specified conditions is true.

OR

Workbooks can be shared directly to ___________ in Excel 2016 if you are logged into a Microsoft account.

OneDrive

Options to rotate and angle text appear when the ________ button in the Alignment group on the Home tab is clicked.

Orientation

You can only share workbooks through email command in excel if your organization uses _______.

Outlook

The ________ function calculates how much a payment will be based on constant payments and a constant interest rate.

PMT

The ________ function is used to capitalize the first letter of each word of text.

PROPER

Headers and footers are visible in the _______ view.

Page Layout

When you set a print area, the range of selected cells is named ________.

Page_Setup

Which is NOT an option in the Auto Fill Options menu?

Paste Cells

Clicking the Paste arrow opens the ________ gallery.

Paste Options

A ________ is a dynamic visual representation of data with fields assigned to the value and category axes.

PivotTable

_____ is an Excel add-in that is a powerful tool used for data analysis and to create data models.

Power Pivot

____ is an Excel add-in that allows the user to interact with data and create visualizations and presentations.

Power View

The ________ feature prevents unauthorized users from making changes to a worksheet.

Protect Sheet

The principal of a loan is entered into the ________ argument of the PMT function.

Pv

The small toolbar that contains buttons for commonly used tasks is the _______ Toolbar.

Quick Access

The Text That Contains dialog box can be accessed by clicking the ________ button.

Quick Analysis

The ________ button on the Design tab displays the locations where a title and a legend can be positioned in a chart.

Quick Layout

When a section of a worksheet displaying numeric values is selected, the ______ appears; this is used to apply conditional formatting or to insert a chart or table based on the selected content.

Quick analysis button

The _______ function returns a specified number of characters, starting from the right side of the data.

RIGHT

The ________ option in the Find and Replace dialog box replaces only the highlighted occurrence of the search string.

Replace

Which is NOT a text rotation or angle option in the Orientation list?

Reverse Vertical Text

The _______ function adds the cells in a range that meet one specified criterion.

SUMIF

The ________ function adds the cells in a range that meet multiple criteria.

SUMIFS

The ________ group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

Scale to Fit

When a range of cells is converted to a table, the default setting in the Filter gallery is ____.

Select All

The ________ tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet.

Sheet

A(n) ________ gives a visual representation of information that is used to effectively communicate ideas.

SmartArt graphic

An Excel add-in used to find solutions to a complex problem to achieve a desired goal is ______.

Solver

The COUNT function is in the ________ category of the More Functions option in the Function Library group of the Formulas tab.

Statistical

_____ functions are used to describe a collection of data such as totals, counts, and averages.

Statistical

When the data validation Error alert is set to ________, the user is prevented from entering invalid data in the cell.

Stop

When the formula =(4-2)*6/2+7 is evaluated in Excel, which will be the first mathematical operation performed?_____

Subtraction

Which is NOT a Total row summary function?

TODAY

The ________ function is a lookup function.

TRANSPOSE

A text function used to remove spaces from a string leaving a single space between words is the ________ function.

TRIM

The ________ key can be used to move from one input box to another in a dialog box.

Tab

The ______ format shows text on multiple lines within a cell.

Text wrap

____ data modifies the data from other data sources to meet your needs.

Transforming

The _______ function will convert the name Chuck to CHUCK.

UPPER

A worksheet tab can be removed from view by right-clicking the tab and selecting ______ from the shortcut menu.

Unhide

____ is a high-level programming language that can be used to write and modify macros.

VBA

The ________ function searches the first column in a table to find matching values.

VLOOKUP

The _______ function takes a serial number value and returns the day of the week.

WEEKDAY

When the data validation Error alert is set to ________, the user is given the option to proceed even if the data is invalid.

Warning

The ________ feature is used to view changes in cells that are not visible in the worksheet.

Watch Window

____ is a general term used to describe a set of tools that change the values in cells to show how those changes affect the outcome of other formulas on a worksheet.

What-if analysis