Search Header Logo

Spreadsheet Pre-test

Authored by Inez Salim

Computers

4th Grade

Used 12+ times

Spreadsheet Pre-test
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What do all formulas begin with?

%
[ ]
=
:

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What symbol do we use for multiplication in a Spreadsheet program? 

/
=
^
*

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What symbol do we use for division in a Spreadsheet program? 

/
*
+
=

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image

What is the cell reference of the yellow cell?

B7

7B

8B

B8

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What two operations does the AVERAGE function perform?

Addition and Multiplication

Multiplication and Division

Addition and Subtraction

Addition and Division

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the purpose of the MIN function

Add the numerical values in a range of cells

Find the lowest number in a range of cells

Find the highest number in the range of cells

Finds the average from a range of cells

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the purpose of the COUNT function?

Adds the values of a range of cells

Counts how many cells in a range contain anything

Counts how many cells in a range contain numbers

Counts how many cells have been selected

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

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?