Excel Module 2 Vocabulary Review

Question 1

sums the #s in a range & then divides the sum by the # of cells with numeric value in the range

Accepted Answer

AVERAGE function

Question 2

displays the highest value in a range

Accepted Answer

MAX function

Question 3

displays the smallest value in a range

Accepted Answer

MIN function

Question 4

the width of a column will be increased or decreased so that the widest entry will fit

Accepted Answer

best fit

Question 5

text or graphics that print at the bottom of each page

Accepted Answer

footer

Question 6

cell references, numbers, and arithmetic operators that instruct Excel to perform a calculation

Accepted Answer

formula

Question 7

collection of rules that define which mathematical operations take precedence over the others

Accepted Answer

order of operations

Question 8

portions of a printed page outside the main body and always are blank when printed

Accepted Answer

margins

Question 9

text or graphics that print at the top of each page

Accepted Answer

header

Question 10

formats a WS by applying fonts, styles, colors, and effects to give it a consistent appearance

Accepted Answer

theme

Questions 10