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:
Questions and Answers
- 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.
Add
- 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
Back to top