Which tab in Excel provides access to a library of formulas and functions
AB
Formulas
Which function quickly adds a contiguous range of cells?AutoSum
Which of the following is a predefined formula that performs a calculation?function
Excel’s built-in functions are designed to perform different types of __________.

You are watching: A formula that performs a calculation

calculations
Which of the following can you use rather than manually creating a formula?Function
Use the tools on the __________ tab to help you fill in formulas with the correct syntax.Formulas
The Function Library in Excel arranges functions by __________.category
If you want to calculate how much interest you will pay on your mortgage, which function icon would you click in the Formulas tab?Financial
Which part of a formula takes a number of specific arguments and returns a single value based on those arguments?function
The Insert Function button is located on which of the following?Formulas tab & Formula Bar
Which function calculates the arithmetic mean for the values in a range of cells?AVERAGE
Which function determines the smallest value of a given list of numbers or arguments?MIN
Which function does the opposite of the MIN function?MAX
What does the NOW function return?date and time
Depending on the function, an argument can be which of the following?single-cell reference, constant value, another function, range of cells
What separates a function containing multiple arguments?comma
In order to define where the function ends, functions without arguments must still be followed by which characters?parentheses
Which of the following are valid functions=NOW(), =PMT(rate,nper,pv)
Which function determines the payment for a loan based on the interest rate of a loan, the number of payments to be made, and the loan amount?PMT
Which function returns the current date but not the time?TODAY
Which of the following functions do not use arguments?TODAY and DATE
You have sorted your employee listing by the department field and wish to total the salaries within each department. Which function would you use?SUBTOTAL
The __________ function takes all of the values in each of the specified cells and totals their values.SUM
In Excel, dates and time are actually __________ values.numeric
Just as you can with any other number, which of the following can be done with a date?multiply, subtract, add, & divide
January 1, 1900 would be represented by what serial number in Excel?1
The value returned by the __________ function automatically updates every time you change the worksheet.TODAY
How do you specify a date in Excel that doesn’t change automatically?Manually type a date.
Which of the following is a valid TODAY formula to calculate the number of years you have lived if you were born in 1975?=YEAR(TODAY())-1975
Which of the following is the default format of the NOW function?mm/dd/yyyy hh:mm
Which function totals all the cells in the range?SUM
Which function calculates (by default) the total from the adjacent cell through the first nonnumeric cell, using the SUM function in its formula?AutoSum
All formulas must start with what character(s)?=
What action must you perform prior to using the AutoSum?Select the cell to contain the answer.
AutoSum will __________ selecting a range the first time it detects an empty cell.stop
In order to determine how many cells in a range contain a number, which function do you use?COUNT
COUNT is considered what type of function?Statistical
Which of the following entries will the COUNT function disregard?cells with text & cells without data
What must surround the arguments of a function?parentheses
Which function counts the number of cells in a selected range that contains numbers, dates, formulas, or text labels?COUNTA
Both the COUNT and COUNTA functions ignore which of the following?blanks
Which is a valid syntax for the COUNT function?=COUNT(A1:C38)
Which function would you use to identify those cells that contain numbers—not text—in a range?COUNT
Which function adds up the values in a selected range and then divides that total by the number of nonblank cells in the range?AVERAGE
Which of the following formulas will find the average value between the range of B7 and P7?=AVERAGE(B7:P7)
The __________ function allows you to find the smallest number in a range of cells.MIN
In order to create a formula using the MIN function, you must first do what?Select the cell where the answer will be displayed.
Which function would you use to return the largest value in a range of cells?MAX
The __________ function can be used to calculate loan payments.PMT
Which of the following are required arguments within the PMT function?Nper, Rate, &Pv
The rate used in the PMT function represents which of the following?annual interest rate for the loan
Which of the following is the proper syntax for the PMT function=PMT(rate,nper,pv,fv,type)
You are responsible for tracking overhead inventory costs in five cities and wish to total the costs within each city. Which function would you use to perform this task?SUBTOTAL
Which of the following will the SUBTOTAL function recognizevalues, cell references, ranges, & named ranges
You need to add the values in cells B7, B30, and B35. Which function should you use when adding noncontiguous cells?SUM
Press and hold the _________ key to select noncontiguous cells.Ctrl
A warning icon that appears to the left of a cell indicates there is a/an __________ in that cell.error
What can you use to show the relationship between formulas and the cells they reference?trace arrows
Which tab contains the trace precedence option?Formulas
The external workbook must be __________ before you can use the trace precedence and trace dependence commands.open
In order to print all formulas in a worksheet, use the ___________ command on the Formulas tab.

See more: How Many Ounces Are 15 Grams Is How Many Ounces In 15 Grams?

Formulas
Which keyboard combination displays or hides formulas in a worksheet?Ctrl + Grave mark
Your spreadsheet has a column designed to track completed projects, and you want to find out how many projects have a completion date. Which of the following will you use to count only those cells containing data?COUNTA
In cells C2–C120, you are tracking student test scores. Which function is used to find the student with the best score?MAX
You use Excel to create customer invoices basing payment due in thirty days. In order to prevent automatic updates, which of the following functions could you use?TODAY
Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?AutoSum
The arguments of a function are contained within which of the following?parentheses
When using the SUBTOTAL function, what is the function number for the SUM function9
You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function do you use?AVERAGE
Which of the following is not a required argument for the PMT functionFv
You want to calculate the number of non-blank cells in your worksheet. Which function do you useCOUNTA
You want to create a formula that calculates the number of years you have lived. You were born in 1991. Which of the following formulas is correct=YEAR(TODAY())-1991
Which of the following statements accurately describes the default selection for AutoSumBy default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell
You want to sum multiple non-contiguous cell ranges that are named. Which of the following is best to use?SUBTOTAL
The COUNT and SUM functions are examples of which functionsstatistical
All functions require arguments within parenthesesFALSE
Using functions helps to ensure the accuracy of a formula’s resultsTRUE
The TODAY function returns the current date in a worksheetTRUE
The AVERAGE function returns the number of cells in the selected range that contain text or values, but not blank cellsFALSE
When functions take more than one argument, you should enter them in multiple sets of nested parentheses, separated by commasFALSE
In the PMT function, the Nper argument is the total number of payments for the loanTRUE
You can use a range in the SUBTOTAL function, but you cannot modify the range once it’s in useFALSE
A cell cannot be a trace dependent and a trace precedent for the same formulaTRUE
You can refer to the TODAY and NOW functions in other formulas to perform calculationsTRUE
To evaluate the error in the formula, select the Edit in Formula Bar option from the pop-up menu that appears after you click the warning icon.FALSE
*