IT 153 Unit 1-6 Review!

What is a function?

• Specific Number

• Autosum Option

• +, -, *, or /

• Predefined formula

What is a reference that refers to the same cell or reference on multiple sheets?

• Cell Address

• Pivot Table

• 3D Reference

• Table

What is a mini chart that is displayed within a worksheet cell?

• Column Graph

• Sparkline

• 3D Bar Chart

• 3D Reference

What function returns the smallest numeric value?

• MIN

• MAX

• AVG

• COUNTA

True or False: The average function will return the average number of cells used.

• True

• False

True or False: The order in which a calculation is performed may affect the result.

• True

• False

True or False: AutoSUM will work for noncontinuous ranges.

• True

• False

True or False: The three types of cell references are absolute, mixed, and relative.

• True

• False

What is an interactive way to quickly summarize large amount of data?

• Graphic organizer

• Table

• Pivot Table

• Sparkline

What function returns one value if a statement is true and another if it is false?

• IF

• VLOOKUP

• HLOOKUP

• COUNTIF