Functions
Sports..nope, it's Functions
More Functions
Questions about Functions
Music--JK..more functions
100
All formulas must start with this character
What is =
100
a predefined formula that performs a calculation
What is function
100
This separates a function containing multiple arguments?
What is a comma
100
This function determines the smallest value of a given list of numbers or arguments
What is MIN
100
The arguments of a function are enclosed in these.
What is Parentheses
200
This function returns the current date but not the time?
What is TODAY
200
function that calculates the arithmetic mean for the values in a range of cells
What is AVERAGE
200
This function quickly adds a contiguous range of cells
What is AUTOSUM
200
This function takes all of the values in each of the specified cells and totals their values
What is SUM
200
The tab in Excel provides access to a library of formulas and functions
What is FORMULAS
300
This function counts the number of cells in a selected range that contains numbers, dates, formulas, or text labels?
What is COUNTA
300
What formula will find the average value between the range of B7 and P7?
What is =AVERAGE(B7:P7)
300
This function adds up the values in a selected range and then divides that total by the number of nonblank cells in the range
What is AVERAGE
300
To specify a date that will not update automatically, the user would need to do this.
What is type the date manually (do not use function)
300
One of the functions that does not use arguments, just parentheses.
What is TODAY, NOW, OR DATE
400
The NOW function returns this
What is Date and Time
400
Because Excel calculates PMT as a negative number, this has to be inserted at the start of the function.
What is the negative sign
400
The function library on the Formulas tab is arranged by what?
What is categories
400
to determine how many cells in a range contain a number, use this function
What is COUNT
400
If Mrs. Porter wants to know who scored the highest on the Certification exam, she would use this function.
What is MAX
500
You want to include non-contiguous cells for a total. Use this function.
What is SUM
500
The three arguments required for the PMT function
What is rate, Nper, PV
500
In order to print all formulas in a worksheet, use this command on the Formulas tab.
What is show formulas
500
Out of the options, "cells with text" "cells with blanks" and "cells with currency" the COUNT function would include these cells.
What is CELLS WITH CURRENCY.
500
The Insert Function button is located in which two places?
What is Formulas Tab and Formula Bar
M
e
n
u