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