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.