Speadsheet Formulas/Functions Review

Speadsheet Formulas/Functions Review

6th - 8th Grade

5 Qs

quiz-placeholder

Similar activities

Pēcpārbaudījums 6. klase

Pēcpārbaudījums 6. klase

6th Grade - University

10 Qs

G5_Unit1+2 Review_2

G5_Unit1+2 Review_2

5th - 6th Grade

10 Qs

Quiz Komponen Komputer

Quiz Komponen Komputer

1st Grade - University

10 Qs

Evaluating Sources

Evaluating Sources

6th Grade

10 Qs

Data

Data

4th - 6th Grade

10 Qs

Pretest Pengolahan Data Dasar

Pretest Pengolahan Data Dasar

7th Grade

10 Qs

Excel Basic

Excel Basic

KG - University

10 Qs

4. Excel Comprehension MCQ

4. Excel Comprehension MCQ

7th Grade

10 Qs

Speadsheet Formulas/Functions Review

Speadsheet Formulas/Functions Review

Assessment

Quiz

Computers

6th - 8th Grade

Practice Problem

Medium

Created by

Bo Riddick

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...

5 questions

Show all answers

1.

DROPDOWN QUESTION

1 min • 2 pts

What is the formula for multiplying two cells?

=A1*B1

A1*B1

=A1+B1

=A1/B1

=A1-B1

2.

MATCH QUESTION

1 min • 1 pt

Match the following formulas with the correct definition

=A1-B1

Multiply

=A1+B1

Add

=A1/B1

Divide

=A1*B1

Subtract

3.

MATCH QUESTION

1 min • 5 pts

Match the following functions with the correct definition

The middle number in a set of numbers

Sum

The average of a set of numbers

Range

The number that appears most frequently in a set

Mode

The difference between the largest and smallest number in a set

Median

The sum of all the numbers in a set

Mean

4.

MATCH QUESTION

1 min • 5 pts

Match the following functions with the correct formulas

=A2-A5

Mode

=sum(A1:A5)

Mean

=med(A1:A5)

sum

=mode(A1:A5)

Range

=avg(A1:A5)

Median

5.

DROPDOWN QUESTION

1 min • 2 pts

What are two spreadsheet programs? (a)   (b)  

Microsoft Excel

Google Sheets

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?

Discover more resources for Computers