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