Question

A. Fill in the blanks.
1. A formula in Excel must begin with___sign.
2. The functions are found under__tab.
3 A cell address is a combination of___and___
4 The cell address AB143 indicates ___column and row___
5. The absolute cell address for a cell located in column Z and row 10 is___

B. Write the output for each of the following categories.
1. = SUM (8,-6, 3, 20) ________
2. = AVERAGE (45, 30, 50, 47, 33) _______
3. = MAX (-30, 45, 30, -45.4, 0) _______
4. = POWER (2, 5) _______
5. = QUOTIENT (97 + 43, 27 + 43) _______​

Answer 1

Answer:

A. 1. equal

2. formula

3. rows and columns

4. AB column and row 143

5. Z10

B. 1. 25

2. 41

3. 45

4. 32

5. 2