Search Header Logo

Spreadsheet Features, Cell Referencing, and Formulas

Authored by Tomasz Lawrynowicz

Other

1st Grade

Used 3+ times

Spreadsheet Features, Cell Referencing, and Formulas
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

11 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the formula =SUM(A1:A5) do in a spreadsheet?

Multiplies the values in cells A1 to A5.

Adds the values in cells A1 to A5.

Subtracts the values in cells A1 to A5.

Finds the average of the values in cells A1 to A5.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of relative cell referencing?

Option B: $A$1
Option C: B2
Option D: A$1
Option A: A1

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the AVERAGE function in a spreadsheet?

To find the highest number in a range.
To calculate the average of a range of numbers.
To format the appearance of the numbers in a range.
To calculate the sum of a range of numbers.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a spreadsheet, what does the IF function allow you to do?

Count the number of cells in a range.

Perform conditional logic based on specified criteria.

Multiply the values in a range of cells.

Sort data in ascending order.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an absolute cell reference?

B2
$A$1

A$1

$C3

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary function of the SUM function in a spreadsheet?

Finds the average of a range of cells.

Calculates the total of a range of cells.

Multiplies the values in a range of cells.

Checks for errors in a range of cells.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of data validation in a spreadsheet?

Calculates the average of a range of cells.

Checks for errors in a range of cells.

Ensures data entered meets specified criteria.

Multiplies the values in a range of cells.

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?