Excel Quiz 3
Write out the complete answer next to the appropriate number.
Use Excel Gradebook to answer the following.
- Which of the following formulas would you use to calculate the average quiz score in column G?
- =AVERAGE(B2:F2)
- =AVG(B2:F2)
- =SUM (B2:F2)
- =AVERAGE(G2)
- If you wanted to format the cells in this gradebook for percentage, you would:
- Go to the Percentage menu at the top
- Right click and go to "Format Cells"
- Right click and go to "Percentage Options"
- Percentage is not an option
- You could calculate the percentage increase or decrease from the 1st quiz to the 5th quiz in Column "H" for all students by using the formula:
- =(F2-B2)/B2
- =SUM(B2:F2)
- =AVERAGE(B2,F2)
- =SUM(B2,F2)
- This teacher calculated the average scores for each quiz in row 13 using rows 2 through 11. To show that a range of cells is used, this teacher used which operator in her formula:
- comma
- colon
- period
- question mark
- The vertical (up and down) location where the student names are stored is identified as:
The image is not necessary for the following questions.
- The comma is best used for:
- showing a range of cells
- listing cells in a formula that are not next to each other in the spreadsheet
- deleting cells from the spreadsheet
- formatting cells
- The function for addition in Excel is:
- The function for averaging numbers in Excel is:
- AVG
- ADD, DIVIDE
- AVERAGE
- AVGNUM
- The operator used for division in Excel is:
- / (forward slash)
- \ (back slash)
- * (asterick)
- ~ (tilde)
- Parenthesis:
- Are not used in Excel
- Mulitply two cells
- Control formatting
- Tell Excel what to do first in a formula