K201 Ch 11-17 Exam

What does the SUM function do?

Adds a range of numbers

What does the AVERAGE function do?

Calculates the mean of a range

What is a cell reference?

The location of a cell (ex: A1)

Difference between relative and absolute references?

Relative changes when copied (A1), Absolute stays fixed ($A$1)

What does the $ symbol do in a formula?

Locks a cell reference so it doesn’t change when copied

What is the difference between COUNT and COUNTA?

COUNT = counts numbers only, COUNTA = counts all non-empty cells

What is mixed cell referencing?

Locks only one part of a reference ($A1 locks column, A$1 locks row)

When should you use absolute references?

When a value (like a rate or constant) should stay the same in all formulas

What does =TODAY( ) do?

Returns the current date and updates automatically

What does CTRL + ; do?

Inserts the current date that does NOT change

What is the syntax of the DATEDIF function?

=DATEDIF(start_date, end_date, “unit”)

What units can DATED IF use?

“Y” = years, “M” = months, “D” = days

How do you calculate whole weeks between two dates?

Use: =INT(DATEDIF(A1, B1, “D”)/7)

What does the INT function do?

Rounds a number DOWN to the nearest whole number

What does the ROUND function do?

Rounds a number to a specified number of decimal places

Example of 3D referencing

=SUM(‘Sheet1:Shee4” !E6)