Bell Quiz 9/6 - Spreadsheet Math

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Dwanderson
D
Dwanderson
Community Contributor
Quizzes Created: 2 | Total Attempts: 224
Questions: 9 | Attempts: 107

SettingsSettingsSettings
Bell Quiz 9/6 - Spreadsheet Math - Quiz


Using the tutorial at : https://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

    Correct Answer
    C. = A1+B1
    Explanation
    The correct answer is "= A1+B1". This is the correct syntax for adding the numbers in cells A1 and B1 in most spreadsheet programs. The equal sign at the beginning indicates that it is a formula, and the plus sign between the cell references indicates that the numbers should be added together.

    Rate this question:

  • 2. 

    To add a collection of numbers you might use a special Function called :

    • A.

      Sum

    • B.

      Add

    • C.

      Total

    Correct Answer
    A. Sum
    Explanation
    The special function used to add a collection of numbers is called "Sum".

    Rate this question:

  • 3. 

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

    • A.

      Σ

    • B.

      Ε

    • C.

      Π

    • D.

      Ω

    Correct Answer
    A. Σ
    Explanation
    The correct answer is Σ because it is the Greek letter sigma, which is commonly used to represent the sum of a series in mathematics. It is a special function and has its own unique icon.

    Rate this question:

  • 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)

    Correct Answer
    C. (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

    Correct Answer
    C. =C3*C4
    Explanation
    The correct answer is =C3*C4. This is the correct formula to multiply the values in cell C3 and C4 in a spreadsheet. The asterisk (*) is the multiplication operator in most spreadsheet software, so using it between the cell references C3 and C4 will calculate the product of the two cells. The equal sign (=) at the beginning indicates that this is a formula and not just a text entry.

    Rate this question:

  • 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)

    Correct Answer
    C. =Average(A1:A5)
    Explanation
    The correct answer is =Average(A1:A5). This formula calculates the average value of the cell range from A1 to A5 by summing up the values in the range and dividing it by the number of cells in the range. It is the most efficient and accurate way to find the average value in Excel.

    Rate this question:

  • 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

    Correct Answer
    B. 41
    Explanation
    The correct answer is 41. According to the order of operations (PEMDAS), we start by evaluating any parentheses or brackets, but there are none in this equation. Next, we evaluate any exponents, but there are none here either. Then, we perform any multiplication or division from left to right. In this case, we have 10 divided by B1, which is 10 divided by 10, resulting in 1. Finally, we perform any addition or subtraction from left to right. We have A1 (20) plus 1, which equals 21, and then we add 20, resulting in a final answer of 41.

    Rate this question:

  • 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

    Correct Answer
    A. Right click, copy, select new cell(s), paste
    Explanation
    To copy a formula to another cell or cells, you can right click on the cell containing the formula and select "copy". Then, select the new cell or cells where you want to paste the formula, right click again and choose "paste". This will copy the formula to the selected cell(s).

    Rate this question:

  • 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

    Correct Answer
    C. =10^4
    Explanation
    To compute 10 to an exponent of 4 in a cell on a spreadsheet, you would type "=10^4" then hit enter. This is because the caret symbol (^) is used in spreadsheets to represent exponentiation, so "=10^4" means 10 raised to the power of 4.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 07, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 03, 2011
    Quiz Created by
    Dwanderson
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.