ACC 202 FINAL

the DB function used to calculate the declining balance depreciation has the following syntax:

=DB(cost, salvage, life, period [month])

in excel, to merge cells A1, B1, C1, D1, and E1, _________ is the correct reference for the merged cell

A1

the _____ condition requires that all of the selected criteria be true for the record to be displayed

AND

which of the following is not a date function?

AND

which of the following is a statistical function?

AVERAGE

which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

COUNT

the ______ function calculates the number of cells in a range that match criteria you specify

COUNTIF

the ______ function returns the maximum value in the range

MAX

one of the advantages of using XML as a data source is that it allows you to attach, or ______, elements to specific cells in the workbook

bind

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

excel can be used with office ______, which are small, specialized programs that enhance the features of excel, word, powerpoint, and other programs in the office suite

apps

{=SUM(B1:B10*C1:10)} is an example of a(n)

array formula

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

____ makes it easier to enter repetitive text in cells

autocomplete

the ______ tools in excel make it simpler for groups to share the work of writing, editing, and finishing a financial report

collaborative

each range is identified with a range reference that includes the cell reference of the upper-left call of the rectangular block on the cell reference of the lower-right cell separated by a _____

colon

excel makes reading formulas simpler by _____ each cell reference in the formula and its corresponding cell in the worksheet

color coding

the fill handle copies ____

content and formats

if you want to extract only specific records when you query a database, your query would contain _____

criteria

to select nonadjacent changing cells, press and hold the ____ key as you click each cell

ctrl

once you enter an array formula, excel will enclose the formula in a set of _____

curly braces

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

the encryption password is ______ the passwords that prevent users from editing a worksheet or the entire workbook

different from

a(n) ______ certificate is another name for a digital ID

digital

if you trust the provider of course files, you can choose to _____ the content, which allows the external reference formulas to function and updates the links in the destination workbook

enable

once workbook sharing is removed, the contents of the tracking log are _____, and there is no way to retrieve the history of edits made to the document

erased

which of the following takes precedence over multiplication?

exponentiation

a formula can include a reference to another workbook (called an ______ reference), which creates a set of linked workbooks

external

a link is a connection between two _____ allowing information to be transferred from one to the other

files

when you _____ data, you specify which records you want to retrieve using specific criteria

filter

italic, bold, bold italic, and underline are examples of ____

font styles

______ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet

freezing

unless you specify a format, excel will apply the ____ format to all columns

general

a worksheet ______ is a collection of two or more selected worksheets

group

to go to column A of the current row, press _____

home

to highlight duplicate values, in the styles group on the ____ tab, click the conditional formatting button, point to highlight cell rules, and then click duplicate values

home

____ messages appear as screen tips next to the active cell

input

sometimes when you build a worksheet for other users, you may decide to add a(n) _______ message to a cell even if you do not validate the data in that cell

input

to _____ a series, the cells between the first and last cells in the series must be blank

interpolate

the header and footer sections include a _______

left, right, and center section

in a(n) ______ trend, the values change by a constant amount

linear

with the DATEIF function, the ______ interval code means months

m

the conditional formatting button provides access to the ____

manage rules option

to avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point

manual page break

_________ merges each of the rows in the selected range across the columns in the range

merge across

the _____ function calculates the number of payment periods in an investment or loan

NPER

to calculate the payment required to pay off a loan in a predetermined amount of time, use the ____ function

PMT

the _____ function takes only these arguments: cost, salvage, and life

SLN

the ______ function adds the values in a range that match criteria you specify

SUMIF

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

if all of the logical conditions are true, the AND function returns the logical value ______

TRUE

excel assigns the name ____ to the first excel table created in a workbook

Table1

_______ 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

before using scenario manager, you should assign _____ to all the input and result cells you intend to use in your scenarios

names

you can ______ IF functions to allow for three or more outcomes

nest

in the format cells dialog box, the ______ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays

number

because excel stores dates and times as ______, you can apply different formats without affecting the date and time value

numbers

______ data tables are useful in calculating any number of results when a single input cell is changed within them

one-variable

in the following figure, fv and type are ______ PMT (rate, nper, pv, [fv], [type])

optional arguments

an edit can be accepted to keep its new value, or you can reject an edit to return to the ______ value

original

______ displays the location of the different page breaks within the worksheet

page break preview

the _____ is the only one of the following charts to compare relative values from different categories to the whole

pie

in _______ orientation, a page is taller than it is wide

portrait

the amount of money being loaned is known as the _____

principal

in excel, a collection of similar data can be structured in a(n) ______ rows and columns

range

marking a workbook as final makes the workbook _____, discouraging a user from making any changes to it

read-only

to delete the hyperlink but keep the text, right-click the hyperlink cell, and then click _____ hyperlink

remove

the _______ formatting only option retrieves the text from a web query along with simple formatting, but not advanced formatting such as hyperlinks or complicated table structures

rich text

you can edit existing conditional formatting _____ from the conditional formatting rules manager dialog box

rules

the range of values or _____, of an axis is based on the values in the data source

scale

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 change was made

shared

to select adjacent worksheets, you use the _____ key

shift

to move the active cell up one row, press ______

shift + enter

you can switch from one scenario to another by clicking the _____ button in the scenario manager dialog

show

to make it possible for other users to access and edit the same data ______, you need to share a workbook

simultaneously

______ is a program that searches for the optimal solution of a problem involving several variables

solver

a data ______ is any file that contains the data you want to retrieve

source

if the destination file is closed when you make a change in the _____ file, you can choose whether to update the link to display the current values when you open the destination file

source

a table name cannot include _____

spaces

______ 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 ____ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each columns

tab

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

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 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

using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table

the first column

in the following formula: =IF(A1="YES,"DONE","RESTART"), what happens if A1="NO"?

the formula returns the text "RESTART"

fonts, colors, and cell styles are organized in ______ categories

theme and non-theme

the ____criteria filter requires the records displayed to have the current date

today

in ______, the ribbon increase in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need

touch mode

a(n) ______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the adjacent cell

tracer

when using the format painter, double-click the format painter button to paste the same format multiple times and click the format painter again to _______

turn it off

usually, you will want to protect a worksheet but leave some cells ______

unlocked

the three items that you must specify when using solver are ___

variable cell, objective cell, and constraints

generally, ______ are given a "wash-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet

watermarks

in the allow list box in the data validation dialog box, the _____ option means that the cell will accept only integers

whole number

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

you already created a line chart, but now decide that you want to change this chart to a pie chart. to do this, you click ____ from the type group in the chart tools design tab

change chart type

placing a chart in a ______ displays only the chart and no worksheet cells

chart sheet

after you filter a column, the _____ filter command becomes available so you can remove the filter and redisplay all the records

clear

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

if the VLOOKUP function cannot find the lookup value, the ________ error value is displayed in the cell

#N/A

all template files have a(n) ______ extension

.xltx

the possible values the type argument in the PMT function are

0 or 1

passwords can be up to ___ characters and can include numbers, symbols, uppercase letters, and lowercase letters

16

range names can be up to ____ characters

255

which of the following is not a comparison operator?

<<

the _____ criteria filter requires the records displayed to have the specified text string anywhere

Contains

the ____ CHART TOOLS contextual tabs appear on the ribbon when you select a chart

DESIGN and FORMAT

the general format of a 3-D cell reference is

WorksheetRange!CellRange

mm/dd/yyyy is known as ________

a date format

in conditional formatting, to highlight only cells that contain a specific date, select the rule ______

a date occuring

aside from solver, other excel _____ provide the ability to perform statistical analyses, generate business reports, and retrieve financial data from the internet

add-ins

when excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a(n) ______ column

calculated

in "SUM(number1[,number2, number 3,...])", number1, number2, number3 may be numbers or _____

cell references

real-time ______ values from measuring devices and scientific equipment are a possible data source in excel

data

a data ______ table describes the fields you plan to maintain in a table

definition