MS Excel Review

Columns in Excel are labeled by (a)  

The rows in Excel are labeled by (a)   .

Cells in Excel are named by the __________ and ____________ that intersect.

(a)  

Which of the following is the symbol for division in Excel?

• +

• /

• *

• -

Which is the symbol for multiplication in Excel?

• +

• -

• /

• *

When you need to enter a formula into a cell in Excel what is the first thing you type?

(a)  

What is the order of operations in math?

(a)  

What would the formula be if I wanted to add cells B4 and C4?

(a)  

Match the following Excel formulas to the "problem".

• Total of prices in cells B2 through B14.

• =F4/F3

• The total price if quantity (how many) is in C5 and unit price is in D5.

• =sum(b2:b14)

• Unit price if total price is in F4 and quantity (how many) is in F3.

• =G3+G5+G7

• The total of cells that are not right next to each other.

• =D4-D5

• Net pay if gross pay is in D4 and taxes is in D5.

• =C5*D5

What tab in the ribbon do I click on to create a chart for my data?

• Formulas

• Home

• Insert

• Page Layout