Índice
- Which of the following statements describes a key difference between formulas and functions?
- When functions take more than one argument you should enter them in multiple sets of nested parentheses separated by commas?
- What is the term for a preset command in a spreadsheet?
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 |
Which of the following statements describes a key difference between formulas and functions?
Which of the following statements describes a key difference between formulas and functions? Formulas are written by the user, and functions are already defined.
When functions take more than one argument you should enter them in multiple sets of nested parentheses separated by commas?
What is the term for a preset command in a spreadsheet?
You can type in a formula (though you have to be sure it's exactly right) or you can use Excel's preset formulas called functions. If you type in the formula, you must start with an equal sign, so Excel knows that the data in the cell is a formula.
What is the default selection for AutoSum?
By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content. c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
Which of the following Excel built in formulas is correct if you want to add numbers?
The correct answer is SUM. SUM is used for the addition in MS Excel. The SUM function is located in the Home tab in the ribbon. SUM function adds all numbers in a range of cells and returns the result in MS Excel.
Which function should be used if you want to COUNT the number of nonblank cells in your worksheet?
Count nonblank cells in a range by using the COUNTA function
Use the COUNTA function function to count only cells in a range that contain values.
What is predefined formula in MS Excel called?
Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.