# Bell Quiz 9/6 - Spreadsheet Math

9 Questions | Total Attempts: 69  Settings  Using the tutorial at : http://www. Tutorialsforopenoffice. Org/tutorial/Spreadsheet_Math. Html Answer the following questions:

Related Topics
• 1.
To add the numbers in two cells A1 and B1 you would type:
• A.

A1+ B1

• B.

A1 + B1 =

• C.

= A1+B1

• 2.
To add a collection of numbers you might use a special Function called :
• A.

Sum

• B.

• C.

Total

• 3.
The special function has it's own icon, a Greek Letter which looks like:
• A.

Σ

• B.

Ε

• C.

Π

• D.

Ω

• 4.
A "cell range" of A!, A2, A3, A4, and A5 used with a Function would look like
• A.

=A1:A5

• B.

A1,A5

• C.

(A1:A5)

• D.

(A1, A5)

• 5.
A multiplication of cell C3 and Cell C4 ,used in a spreadsheet, would look like:
• A.

C3 X C4

• B.

=C3XC4

• C.

=C3*C4

• D.

C3*C4

• 6.
To find the average value of a cell range from A1 to A5, you could use the following formula:
• A.

=A1+A2+A3+A4+A5/5

• B.

=Avg(A1:A5)

• C.

=Average(A1:A5)

• D.

=Ave(A1:A5)

• 7.
PEMDAS stands for the order of operations-- Parends (brackets), Exponents, Multiply-Divide, Add-Subtract. If you type =A1+10/B1 + 20 into a spreadsheet, where A1 is 20 and B1 is 10, the answer it will show is:
• A.

1

• B.

41

• C.

31

• D.

21

• 8.
To copy a formula to another cell or cells you:
• A.

Right click, copy, select new cell(s), paste

• B.

Right click, copy, select new cell(s), paste special, uncheck formulas and paste all

• C.

Right click copy, paste, select cells

• 9.
To compute 10 to an exponent of 4 in a cell on a spreadsheet, you would type ____________ then hit enter:
• A.

10 X 10 X 10 X 10

• B.

10^4

• C.

=10^4

• D.

=10*4