Microsoft Excel Final Chapters 1-11
An ____ Report shows the answer that Solver found, which constraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem withing those constraints.
Answer
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
AutoCalculate
When you first create a table, Excel automatically enables ____.
AutoFilter
Which of the following format symbols displays text along with numbers entered in a cell?
" " (quotation marks)
Error messages begin with the ____ symbol.
#
____ refers to cells not wide enough to display the entire entry.
#####
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
#REF!
The ____ error code indicates that a cell reference in a formula is not valid.
#REF!
The code ____ instructs Excel to insert the page number in the header or footer section.
&[Page]
Which of the following is the path to the Goal Seek button?
(DATA tab | Date Tools group
You can tap or click the 'Insert a Comment' button ____ to add a new comment to a worksheet.
(REVIEW tab | Comments group)
Which of the following format codes insures that Excel will display a decimal point in the number?
. (period)
All of the following are formats accepted for picture files EXCEPT ____.
.mp3
When you decrease the row height to ____, the row is hidden.
0
When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.
0
Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parenthesis?
0.00%;[Blue](0.00%)
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
A macro name can be up to ____ characters long.
255
When Excel follows the order of operations, the formula, 8*3+2, equals ____.
26
The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 or less than or equal to 5.
3, 4, 5
A range that spans two or more worksheets in a workbook is called a ____ range.
3-D
By default, Excel keeps a change history of ____ days for a shared workbook.
30
Which of the following patterns extends the fill series to 575, 550, 525?
625, 600
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
Which comparison operator means "not equal to"?
<>
Which of the following formulas contains an absolute cell reference?
=$B$4
Which of the following calculations multiplies 23 by 0.01?
=23%
Which of the following are valid formulas?
=3^4 =H3/H11 =11+9 =22-F15
The general form of the VLOOKUP function is ____.
=VLOOKUP(lookup_value, lookup_table, col_index_num)
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
AVERAGE
Like the AutoFilter query technique, the ____ command displays a subset of the table.
Advanced Filter
The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.
Rules Manager
Which of the following functions can you use to determine the position of the space that separates a first and last name?
SEARCH
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.
SHIFT
The ____ function is useful when you want to add values in a range only if they meet criteria.
SUMIF
____ are named combinations of values that are assigned to variables in a model.
Scenarios
____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.
Slicers
One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.
Solver
Which of the following complex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?
Solver feature
An Answer Report's ____ column indicates binding constraints.
Status
To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.
Summarize Values By
Which of the following buttons will enable two worksheets to scroll at the same time so that you can make a visual comparison of the workbooks?
Synchronous Scrolling
____ are used in XML files to describe data items.
Tags
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
The formula checker
If the contents of a cell coped using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?
Thursday, Saturday, Monday
Which of the following is an extension of the fill pattern Sunday, Tuesday?
Thursday, Saturday, Monday
The Highlight Changes command is located on the ____ menu.
Track Changes
If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.
Use Relative Reference
____ code is created automatically by the macro recorder.
VBA
The ____ function is used when a table direction is vertical.
VLOOKUP
Which of the following are types of summary functions for PivotChart report and PivotTable report data analysis?
Varp Count Count Nums Average
The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.
Watch Window
All of the following are valid Excel arithmetic operators EXCEPT ____.
^
As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in an ____ cell reference.
absolute
Names are ____ cell references.
absolute
To start a new line in a cell, press the ____ keys.
alt+enter
An ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
amortization schedule
When creating a PivotTable report, the active cell should be positioned ____.
anywhere in the range that contains the data
For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.
arguments
The left column values in a table array are called table ____.
arguments
Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.
arrow
Which of the following is the maximum number of active data tables per worksheet?
as many as you want
Data is in ____ sequence if it is in order from lowest to highest.
ascending
Cell references in a formula are called ____.
assumptions
Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.
auditing
The following sequence: 1, 1, 1, etc., is an example of an ____ series.
auto fill
In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
For each model, it is helpful to define a ____ scenario that represents the starting assumptions.
baseline
Comments can be placed at any of the following positions EXCEPT ____.
before the Supplement statement
Cell ____ can be used to distinguish the different functional parts of a worksheet.
borders
The arguments in ____ in the ScreenTip for a function are optional.
brackets
In a table, a column that contains formulas or functions is called a ____.
calculated column
A field containing computational values based on data in other fields.
calculated fields
In PivotTables, ____ fields correspond to columns in the original data.
category
To enter data in a cell, you must first select the ____.
cell
Charts can either be embedded in a worksheet or placed in a separate ____.
chart sheet
Using the Excel spell checker, you can ____.
check the spelling in a single cell check the spelling of words in a selected range add words to the dictionary
A ____ reference is a formula that depends on its own value.
circular
When a cell contains a ____ reference, it means that one of its defining values is itself.
circular
What effect does the Accounting Number Format have on the selected cells?
displays cell contents with two decimal places that align vertically
When a formula fails to pass one of the rules and background formula checking if enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.
green triangle
You can drill all of the following down through a workbook EXCEPT ____.
groupings
A ____ is text and graphics that print at the top of each page.
header
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
hide
Which of the following are true about the ROUND function?
if the number of digits argument is greater than zero, then the number is rounded to the specified number of digits to the right of the decimal point if the number of digits is equal to zero, then the number is rounded to the nearest integer if the number of digits argument is less than zero, then the number is rounded to the specified number of digits to the left of the decimal point
Only images that are ____ are free for anyone to use without permission.
in the public domain
Which are types of fields used by PivotTables?
index data category summary
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
Which of the following is a method of entering functions?
keyboard, touch gesture, or pointer the Sum menu the Insert Function box in the formula bar the Name box area in the formula bar
By default, text is ____ in a cell.
left-aligned
Passwords in Excel can contain ____.
letters numbers spaces up to 30 characters
Elements in a SmartArt graphic are grouped in ____.
levels
A ____ is a reference to a cell or range of cells in another workbook.
link
The arguments in an IF function are ____.
logical_test value_if_true value_if_false
A ____ is created by performing a set of steps and recording the steps as they are performed.
macro
An Excel ____ is a procedure composed of a VBA code.
macro
The ____ prefix is a standard prefix for email hyperlinks, which Excel adds automatically.
mailto:
Shared workbooks must be ____ within the number of days specified to record the change history.
merged
Combining two or more selected cells into one cell is called ____ cells.
merging
Which of the following are PMT function arguments?
monthly interest rate number of payments loan amount
A cell ____ often is created from column or row titles.
name
Rather than manually setting a print area each time you want to print a range, you can ____ the range.
name
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
nested
You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.
none of the above
The default view in Excel is called ____ view.
normal
Which of the following fill actions can you perform by dragging the fill handle?
number, number, number, etc. month, month, month, etc.
A workbook contains ____ worksheet by default.
one
With an ____data table you can vary the value in one cell.
one-input
If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.
orientation
Headers, footers, and margins are all ____ options.
page setup
A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.
password
You should create a ____ when you want to keep others from changing the worksheet from protected to unprotected.
password
A cell containing a formula that references other cells is said to have ____.
precedents
A series of precise instructions for a computer to accomplish a task is called a ____.
procedure
When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.
protect
A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.
query
____ ensures that users do not change values inadvertently that are critical to the worksheet.
Cell protection
To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.
Convert to Range
Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.
Convert to Shapes
The summary function that calculates the number of data values in a PivotTable report is ____.
Count
____ format codes allow you to specify how a cell entry assigned a format will appear.
Custom
Which of the following are database functions?
DAVERAGE DSUM
You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.
Delete
You can click the ____ command on the shortcut menu to remove a comment from a worksheet.
Delete Comment
____ a shape within a SmartArt graphic means moving it to a lower level.
Demoting
Which of the following is the default security option for workbooks containing macros?
Disable all macros with notification
The ____ should be used before sharing a workbook publicly.
Document Inspector
____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Double-click or double-tap
The ____ button allows you to move through a formula step by step.
Evaluate Formula
You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.
Excel Options
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Goal
The ____ function is used when a table direction is horizontal.
HLOOKUP
Webpages use a file format called ____.
HTML
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
Which of the following is NOT a SmartArt graphic category?
Microsoft.com
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
The ____ style is the format style that Excel initially assigns to all cells in a workbook.
Normal
Which of the following are effective workbook collaboration options?
distributing a workbook to others physically or electronically sharing a workbook participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Qtr2
The ____ value is a number from 0 to 1 that measures the strength of a trend.
R-squared
A number from 0 to 1 that measures the strength of a trend.
R-squared value
It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.
ROUND
To prevent round-off errors, use the ____ function.
ROUND
The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.
fill handle
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
filtering
A ____ is text and graphics that print at the bottom of every page.
footer
Predicting data values that are outside the data set.
forecasting
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
You can ____ comments.
format resize copy move
A ____ is a pre-written formula that is built into Excel.
function
____ text often provides a strong visual appeal.
Rotated
Names are ____ to the workbook.
global
A ____ total sums all of the data in a row or column.
grand
____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.
Row banding
With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.
quotation marks
A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
range
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
range finder
In a table, or database, the data related to each person or item is called a ____.
record
A ____ reference is an adjusted cell reference in a copied and pasted formula.
relative
The adjusted cell references in a copied and pasted formula are called ___ cell references.
relative
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
right arrow
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
Changes to category fields are correspondingly made to these in the PivotTable report.
row fields
Excel allows you to take a ____ of any open window and add it to a workbook.
screen shot
Point mode allows you to ____.
select cells for use in a formula using the mouse pointer
You can insert a ____ at the bottom of a table.
total row
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
trace error
When the copies of a workbook to be merged into a single workbook are made, ____ must be enabled.
track changes sharing
If either ____ or sharing is enabled, Excel enables the other by default.
tracking
In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.
transposed
A ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables.
trend
A ____ is a visual way to show how two variables relate to each other.
trendline
A visual way to relate two variables.
trendline
You can enable or disable macros with options in the ____ dialog box.
trust center
When working with a large worksheet, you can split the window into ____ panes.
two or four
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
unprotected
Data tables must be built in an ____ area of a worksheet.
unused
A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.
virus
When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.
workbook
An Excel ____ allows data to be summarized and charted easily.
worksheet
Excel allows you to share and collaborate with others through a variety of features, depending on ____.
your resources collaborators' resources your preferences collaborators' preferences
You can customize a format code in a cell entry to specify how ____ are displayed in a cell.
zeros positive numbers text negative numbers
____ a shape within a SmartArt graphic means moving it to a higher level.
Promoting
Each copy of a workbook to be merged must have a different ____.
file name
Which of the following is NOT a type of data validation criteria you can assign to a cell?
Bold style formatting
To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the '____' command.
Circle Invalid Data
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
You should use a ____ chart to compare values side by side, broken down by category.
Clustered Column
____ means working together in cooperation on a document with other Excel users.
Collaboration
____ are descriptions which do not regularly appear as part of a worksheet's data.
Comments
____ work well when multiple people are collaborating and commenting on a worksheet.
Comments
____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
Conditional
____ records allows you to pull data from a table so that you can analyze or manipulate the data further.
Extracting
You can click the ScreenTip button in the ____ dialog box to add ScreenTip text to a hyperlink.
Insert Hyperlink
Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?
Iterations
The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.
MATCH
The ____ function displays the highest value in a range.
MAX
The ____ function determines the lowest number in a range.
MIN
Which of the following functions can you use to convert names entered in all uppercase to mixed case?
PROPER
The ____ function returns the present value of an annuity.
PV
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page layout
Which of the following commands can you use to replace a formula with a text value?
Past Values
A ____ report is an interactive chart that allows users to change the groupings that graphically present data.
PivotChart
An interactive chart that graphically presents data.
PivotChart report
Using ____, a user with little knowledge of formulas, functions, and ranges can complete powerful what-if-analyses of a set of data.
PivotCharts PivotTables trendlines slicers
Drawn from data in worksheet columns.
PivotTable fields
A ____ is an interactive view of worksheet data.
PivotTable report
An interactive view of worksheet data.
PivotTable report
A screen ____ is a portion, usually of one object or section of a window, of the screen.
clipping
Which of the following are names for a step-by-step description of a computerized task?
code program procedure
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon (:)
Changes to series fields in a PivotChart report appear as changes to these in the PivotTable report.
column fields
The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.
consolidation
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
An Answer Report shows original and final values of the target cell and changing cells plus ____.
constraints
The basics of using VBA to create a data entry form include ____.
creating a user interface setting the properties writing the code
The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.
criteria
If you deselect an item from the filter menu, it is called the filter ____.
criterion
To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.
ctrl
To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.
ctrl
To select noncontinuous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
ctrl
You should hold down the ____ key to select the nonadjacent cells.
ctrl
Pressing the ____ keyboard shortcut key(s) selects cell A1.
ctrl+home
In a PivotTable, fields ____ correspond to summary values of original data across categories.
data
You choose a ____ to automate data analysis.
data table
A ____ file contains data fields separated by a selected character.
delimited
A cell whose value relies on another referenced cell is said to be a ____ of that referenced cell.
dependent
Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.
dependents
A ____ is an attachment to a file or email message that vouches for its authenticity.
digital certificate
What effect does the Comma Style format have on the selected cells?
displays cell contents with two decimal places and commas as thousands separators
Which of the following are guidelines for creating a table in Excel?
do not enter more than one table per worksheet maintain at least one blank row between a table and other worksheet entries do not use blank rows or rows with repeating characters to separate the column headings (field names) from the data place column headings (field names) in the first row of the table
Which of the following are formatting symbols?
dollar sign ($) comma (,) percent sign (%)
When you insert a manual page break, Excel displays a ____ line between pages.
dotted
Which of the following chart types cannot include trendlines?
doughnut pie
Using the mouse to move or copy cells is called ____.
drag and drop
PivotTables are ____ by nature.
dynamic
Clicking the ____ box completes an entry.
enter
The ____ preceding a formula alerts Excel that you entering a formula or function and not text.
equal sign (=)
In Excel, a number can contain the characters ____.
everything
The +/- buttons ____ a field across categories.
expand and collapse
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
Imported data that maintains a refresh-able link to its external source is called ____ data.
external
Each row of an Excel worksheet used to create a table can store a record, and each column can store a ____.
field
You can name a range by ____.
selecting a cell or range, typing the name in the Name box, and pressing the ENTER key selecting a cell or range, typing the name in the formula bar, and pressing the ENTER key selecting a cell or range, tapping or clicking the Define Name button (FORMULAS tab | Define Names group)
Which of the following is not a valid format symbol?
semi-colon (;)
Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.
sheet name location workbook name
Excel treats ____ as graphic objects that can be moved, resized, and formatted.
slicers
Graphic objects used to filter data.
slicers
You can connect ____ to more than one PivotTable to filter the data.
slicers
The field or fields selected for sorting records are called ____ keys.
sort
A (n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
sparkline
A Word document often contains data stored in a ____ that can be copied and pasted into an Excel worksheet.
table
A ____ should be formatted so that the records are easily distinguished.
table
A worksheet's row-and-column structure can be used to organize and store a ____.
table
When Excel imports a database table, the data is placed in an Excel ____.
table
XML data always is imported as a ____.
table
The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.
table array
A ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.
template
You should create good ____ to ensure your workbooks are free of errors.
test data
A ____ contains little or no formatting.
text file
You can add text to a SmartArt graphic by using the ____.
text pane
Which of the following steps must be taken in preparation for working with macros in Excel?
the DEVELOPER tab must be made available on the ribbon a security setting must be modified to enable macros all worksheets must be unprotected the workbook that includes macros must be saved as an Excel Macro-Enabled Workbook file type
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
Which of the following are true about macros?
they save time they ensure consistency they automate repetitive tasks they reduce formatting conformity
