ACC 202 Final
In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.
A1
You could test two or more conditions and determine whether all conditions are true using the _____ function.
AND
Formulas created using the point-and-click method contain ____ references.
Absolute
To activate Solver, click Solver Add-In in the _______.
Add-Ins dialog box
Which of the following is not an Excel function category? ____ Alegbra Statistical Math & Trig Text
Algebra
When you copy a selection of cells using drag and drop, which appears before you release the mouse button?
An outline of the new location of the selected range
When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.
Arrow
____ order arranges labels in reverse alphabetical order, from A to Z
Ascending
To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.
AutoFit
Shared workbooks are usually stored in shared folders located on either a local network or the _______.
Cloud
The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.
Clustered Column Chart
The _______ tools in Excel make it simpler for groups to share the work of writing, editing, and finishing a financial report.
Collaborative
A ________ is a highly structured collection of data values organized into separate tables.
Database
One way to structure text files is to use a(n) _______
Delimiter
The encryption password is _______ the passwords that prevent users from editing a worksheet or the entire workbook.
Different from
When you copy a formula that contains an absolute reference to a new location, the reference ____.
Does not change
When combination charts have data series with vastly different values, you can create ____ charts.
Dual Axis
To switch to ____ mode, you double-click the cell.
Edit
You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.
Editing
Use data ________ to prevent hackers from gaining unauthorized access to sensitive information.
Encryption
To move one slice of a pie chart away from the pie creates a(n) ____.
Exploded pie chart
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.
External
The _____ function calculates the number of cells in a range that match criteria you specify.
COUNTIF
The ____ arrangement option layers the open workbooks on the screen.
Cascade
As a general rule, you should _____.
Center column titles, left-align text, and right-align numbers
To remove workbook protection, click the Unprotect Workbook button in the _____ group on the Review tab.
Changes
A ______ stores information about a specific characteristic of a person, place, or thing, such as a store ID.
Field
The fields you use to order your data are called sort ____
Fields
____ is the amount added to the prinicpal of a loan by the lender.
Interest
When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _____.
Legend
______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
Lookup
To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.
fill color
When you click a(n) ____, the computer switches to the file or portion of the file that it references.
hyperlink
Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____
information
The header and footer sections include a _____.
left, right, and center section
Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell
locked
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
Mixed
The ____ dialog box provides options for moving charts between worksheets and chart sheets.
Move Chart
The _____ dialog box displays all of the names in the workbook.
Name Manager
The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE.
OR
A chart sheet can contain ____.
Only one chart
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, fv and type are ____.
Optional Arguments
The _______ function calculates the amount paid into an investment or loan during each payment period.
PMT
The _______ function calculates the present value of an investment or loan.
PV
In ____ orientation, a page is taller than it is wide
Portrait
When you borrow money, the money you receive represents a _______ cash flow.
Positive
If active cell D12 contains the formula =D10+D11, cells D10 and D11 are _______ cells for D12.
Precedent
A _______ is a collection of fields.
Record
You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data.
Refresh
If you orient a one-variable table so that the input values are in the first row, you would use the _______ input cell option.
Row
Each time you create a conditional format, you are defining a conditional formatting _____.
Rule
When you _______ data, you specify which records you want to retrieve using specific criteria
Filter
The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.
Find
____ enters text based on patterns it finds in the data.
Flash Fill
You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.
Format Data Labels
Excel automatically recalculates any formula when the input cells to that _______ are changed.
Formula
The FV function stands for ____.
Future Value
Ctrl + G is used to access the ____.
Go to a location in the worksheet command
If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column, a _____ appears in the upper-left corner of the cell.
Green Triangle
A worksheet ____ is a collection of two or more selected worksheets.
Group
You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box. Click the Edit Rule button and make the appropriate changes.
Rules manager
The Insert Function dialog box has a(n) ____ option
Search
To go to column A of the current row, press ____.
Home
The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.
IF
Which of the following is a Math & Trig function? ____ Count Average Min INT
INT
The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.
IPMT
To calculate the internal rate of return, use the _______ function with the cost of the initial investment as the first cash flow value in a series.
IRR
You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.
Table Tools Design
To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet ____.
Tabs
A scenario summary report's _______ layout makes it simpler to compare the results of each scenario, and the automatic formatting makes it useful for reports and meetings.
Tabular
A ____ is a workbook that you can open with the text, formats, and formulas already built into it.
Template
When you use Excel to connect to a text file, the _______ Wizard determines whether the data is in a fixed-width format or a delimited format.
Text Import
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters.
Text Length
To capture a screen image, click the _______ tab on the ribbon, and then click the Screenshot button in the Illustrations group.
Insert
To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.
Insert
Financial functions format calculated values as currency, with _______.
negative cash flow appearing in red font
You can _____ IF functions to allow for three or more outcomes.
nest
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
nested
Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.
nonadjacent
An error value begins with a(n) _____ followed by an error name that indicates the type of error.
number sign
A pie slice is a data marker that represents ____ from a data series.
only one value
When you _____ a workbook, you control the ability users have to make changes to the file.
protect
When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.
red and green
With Goal Seek, you specify the _______ values you want.
result
To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.
tab
You can split the worksheet window into ____ separate panes.
two or four
Usually, you will want to protect a worksheet but leave some cells _____.
unlocked
To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension.
xlsm
All template files have a(n) ____ extension.
.xltx
Passwords can be up to _______ characters and can include numbers, symbols, uppercase letters, and lowercase letters.
255
The ____ criteria filter requires the records displayed to start with the specified text string.
Begins With
=IF(G22="x", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x".
Blank cell
The Format Cells dialog box has six tabs, including _____.
Border
After you select a cell with an error indicator, you can click the Error Checking _______ to display additional information about the possible error and determine if further action is needed.
Button
"AZ" is an example of a _________.
Column Heading
A(n) _______ is a limit that is placed on a Solver problem's solution.
Constraint
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.
Content
To select nonadjacent changing cells, press and hold the _______ key as you click each cell.
Ctrl
You can move to the previous or next sheet by pressing the ____ keys.
Ctrl + Page Up or Ctrl + Page Down
The NPV function is used in calculating the net present value of a transaction, which is the _______ value of all the cash inflows and outflows in the investment adjusted by the time value of money.
Current
You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell.
Settings
A _______ Excel workbook tracks the changes made by different people so everyone can examine when and where each change was made.
Shared
To move the active cell up one row, press ____.
Shift + Enter
To make it possible for other users to access and edit the same data _______, you need to share a workbook.
Simultaneously
After trying out solutions for a short time, Solver displays the _______ dialog box, which displays the message that indicates Solver has found a solution that satisfies the constraints.
Solver Results
A data _______ is any file that contains the data you want to retrieve.
Source
A(n) _____ file contains the object that is displayed in the destination file.
Source
_______ properties are properties associated with all Office files and include the author, title, and subject.
Standard
The following are Excel-supported error alert types: _____.
Stop, Warning, and Information
A __________ is a slicer that is applied to date fields. Using the timeline, you can summarize the data for ranges of time intervals from years down to minutes and seconds.
Timeline
A(n) _______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.
Tracer
To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.
Ungroup Sheets
In two-variable tables, you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.
Upper-left
The _____ function searches vertically down the first column of the lookup table.
VLOOKUP
One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.
Validation
The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.
Year to date
Aside from Solver, other Excel _______ provide the ability to perform statistical analyses, generate business reports, and retrieve financial data from the Internet.
add-ins
You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n) _______ report.
answer
A(n) _______ is a file that stores a collection of related data.
database
