Bell Quiz 9/6 - Spreadsheet Math
9 Questions
| Total Attempts: 73
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
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 62207 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 59827 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 44527 | Last updated: Feb 12, 2021
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top