| A | B |
|---|
| Which tab in Excel provides access to a library of formulas and functions | 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 __________. | 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 recognize | values, 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. | 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 function | 9 |
| 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 function | Fv |
| You want to calculate the number of non-blank cells in your worksheet. Which function do you use | COUNTA |
| 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 AutoSum | By 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 functions | statistical |
| All functions require arguments within parentheses | FALSE |
| Using functions helps to ensure the accuracy of a formula’s results | TRUE |
| The TODAY function returns the current date in a worksheet | TRUE |
| The AVERAGE function returns the number of cells in the selected range that contain text or values, but not blank cells | FALSE |
| When functions take more than one argument, you should enter them in multiple sets of nested parentheses, separated by commas | FALSE |
| In the PMT function, the Nper argument is the total number of payments for the loan | TRUE |
| You can use a range in the SUBTOTAL function, but you cannot modify the range once it’s in use | FALSE |
| A cell cannot be a trace dependent and a trace precedent for the same formula | TRUE |
| You can refer to the TODAY and NOW functions in other formulas to perform calculations | TRUE |
| 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 |
