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
