EXCEL

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

What text formula joins the text from two or more cells?

• concatenate

• proper

• merge

• join

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

• format cell

• conditional formatting

• fill color

• magic cell

Which tab contains the tool "Freeze Panes"?

• Home

• Page Layout

• View

• Review

A ___________ conveys a visual representation of data.

• chart
• picture
• text box
• style

A(n) _________ is a prewritten formula that is built into EXCEL. 

• function
• problem
• equation
• equal sign

A combination of numbers and symbols used to express a calculation. Always begins with an = sign.

• Cell address
• Worksheet
• Formula

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

By default, all cell references are _________ references. 

• Absolute
• Relative