WorksheetsMS Excel Review
Total questions: 10
Worksheet time: 9mins
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".
=C5*D5
The total price if quantity (how many) is in C5 and unit price is in D5.
=sum(b2:b14)
Total of prices in cells B2 through B14.
=D4-D5
Net pay if gross pay is in D4 and taxes is in D5.
=F4/F3
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.
What tab in the ribbon do I click on to create a chart for my data?
Formulas
Home
Insert
Page Layout
