Excel Key Terms Review

What kind of software is Excel?

• Spreadsheet software
• Word Processing
• Drawing

What do you call the rectangles on a spreadsheet?

• Cell
• Button
• Sentence

In Excel, columns are labeled by?

• Numbers

• Letters

In Excel rows are labeled by

• Letters

• Numbers

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

• MAX
• MIN
• LARGE
• SUM

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

• MAX
• MIN
• SMALL
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

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

• concatenate

• proper

• left

• e=mc2

Which formula would you use to calculate how many sales are over $20 from a series.

• sum

• sumif

• count

• countif

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

• function
• problem
• equation
• equal sign