A
B
C
D
E
1
3257
6291
2
2
1416
825
3
3 =A1+A2
5
4
5
6 =$E$1*A3
Use the worksheet above to answer questions 7 -12.
(ENTER THE ABOVE INFORMATION IN AN EXCEL WORKSHEET TO HELP YOU ANSWER THE QUESTIONS)
7 Type with the correct syntax what the formula in cell A3 would look like if you copied it to cell B3.
8 Type what the result would be in cell B3 for the formula created in question 7.
9 Type with the correct syntax what the formula in cell A3 would look like if you copied it to cell A4.
10 Type what the result would be in cell A4 for the formula created in question 9.
11 Type with the correct syntax what the formula in cell A6 would look like if you copied it to cell B6.
12 Type what the result would be in cell B6 for the formula created in question 11.
13 If the active cell includes a formula, where on the worksheet is the formula displayed?
14 When more than one mathematical operation appears in a formula, Excel performs each operation by
applying the mathematical rules called what?
15 Type the name of one of the five mathematical operations that you used in a formula.
16 Type the name of another one of the five mathematical operations that you use in a formula.