What function adds cell values together and divides the result by the number of values?

Nội dung chính Show

Which of the following functions adds cell values together?
Which of the following functions adds all the values and divides the result by the number of values average count max min?
What function is used to add the numbers in a range of cell?

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

Which of the following functions adds cell values together?

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

Which of the following functions adds all the values and divides the result by the number of values average count max min?

The Average function totals all the underlying values in the Values area, and it divides by the number of values. The result is the same as using the AVERAGE function on the worksheet to calculate the average (mean) of the values.

What function is used to add the numbers in a range of cell?

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you're working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

What function adds cell values together and divides the result by the number of values?

Which of the following functions adds cell values together?

Which of the following functions adds all the values and divides the result by the number of values average count max min?

What function is used to add the numbers in a range of cell?

Bài Viết Liên Quan

Quảng Cáo

Có thể bạn quan tâm

Toplist được quan tâm

Quảng cáo

Xem Nhiều

Quảng cáo

Chúng tôi

Điều khoản

Trợ giúp

Mạng xã hội