Spreadsheet Features, Cell Referencing, and Formulas

Spreadsheet Features, Cell Referencing, and Formulas

1st Grade

11 Qs

quiz-placeholder

Similar activities

General Knowledge

General Knowledge

1st Grade

15 Qs

Grade 2 - Pollution and Climate Change

Grade 2 - Pollution and Climate Change

1st - 2nd Grade

10 Qs

Risk management quiz no.1

Risk management quiz no.1

1st Grade

10 Qs

Football Quiz

Football Quiz

KG - Professional Development

15 Qs

Communities

Communities

1st - 3rd Grade

10 Qs

Ohio Valley College of Technology

Ohio Valley College of Technology

KG - University

10 Qs

Introduction to cloud Computing.

Introduction to cloud Computing.

1st - 3rd Grade

10 Qs

Types of Government

Types of Government

KG - University

10 Qs

Spreadsheet Features, Cell Referencing, and Formulas

Spreadsheet Features, Cell Referencing, and Formulas

Assessment

Quiz

Other

1st Grade

Practice Problem

Medium

Created by

Tomasz Lawrynowicz

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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?