Excel Skills Review

The horizontal placement of cells in a table or worksheet.

• range
• row
• column
• cell

An equation that calculates a new value from values currently in a worksheet.

• Formula Bar
• column
• cell
• formula

Putting cells in order based on their contents is called..

• Sorting
• Filtering
• Numbering
• Identifying

Correct or incorrect formula?
=sum(C4:C9)

• Correct
• Incorrect

What is the horizontal section of a spreadsheet?

• function
• formula
• column
• row

What is a vertical section of a spreadsheet

• row
• addition
• column
• format

What function adds all of the numbers in a range of cells?

• Difference
• Sum
• Average

All formulas in Microsoft Excel begin with the following symbol:

• +
• -
• =
• %

The correct formula to add cell B1 and B2 is

• AddB1+C1
• =sum(B1+C1)
•  =B1+B2

The part of a spreadsheet identified by letters of the alphabet (vertical across the top):

• cell
• column
• row