Search Header Logo

Y7 Spreadsheets

Authored by Phil Branson

Computers

7th Grade

CCSS covered

Used 53+ times

Y7 Spreadsheets
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

22 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you insert a new row?

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What would be a correct formula for SUM in excel?

=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which button can you click to add up a series of numbers?

The autosum button
The Formula button
The quicktotal button
The total button

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

You can edit a cell by...

Clicking the formula button
Double clicking the cell
Selecting Edit>Edit Cell from the menu
None of above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula gets the biggest value of a range of cells?

MAX
MIN
LARGE
SUM

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which formula gets the smallest value of a range of cells?

MAX
MIN
SMALL
SUM

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which symbol must all formula begin with?

=
+
(
@

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?