Grade 7 Revision Questions - 2nd Semester

In this diagram what does the selected area represent?

• a Row
• a Cell
• a Column
• a Chart

Which of the following is an absolute cell reference?

• A2
• $A$2
• #A#2
• A:2

Let's say you're trying to find your average grade in this spreadsheet. What's wrong with the formula in cell C11?

• It should use the COUNT function instead.
• There is nothing wrong with the formula.
• It should have an equals sign (=) at the beginning.
• It's referencing the wrong cell range.

What are we doing in the example below?

• Filtering the Type column by number
• Filtering the Type column to show only Laptops and Projectors
• Filtering the Type column to show everything except Laptops and Projectors
• Filtering the Type column by date

(Let the GIF Play)
How are we sorting the data in this clip?

• Custom Sort by T-Shirt Size
• Alphabetically by First Name
• Alphabetically by Last Name
• Numerically by Homeroom Number

What is the cell range in this diagram?

• A1:F1
• A1:A8
• A1:F8
• A1:1A

What is being adjusted in this diagram?

• Cell A1
• Font Size
• Alginment
• Spacing

How would we type the formula to Add the June and July Budgets?

• =June+July
• =1200+1500
• =D10+D11
• =C10+C11

What function will calculate the AVERAGE of all the numbers in a column?

• =IF(A1:A6)

• =SUM(E1:E5)

• =AVERAGE(E1:E5)

• =CONCAT(E1:E5)

Which of the following is an example of an addition formula?

• =B4+D7

• 2+3+6=11

• F3*G7

• =B9/B6