Using functions in Excel

Using functions in Excel

7th Grade

10 Qs

quiz-placeholder

Similar activities

Roblox Studio Lesson 6

Roblox Studio Lesson 6

6th Grade - University

12 Qs

Python Data Structures

Python Data Structures

6th - 8th Grade

15 Qs

Digital Footprint / Online Safety Quiz Ideas

Digital Footprint / Online Safety Quiz Ideas

6th - 8th Grade

10 Qs

Credible Sources

Credible Sources

7th Grade

11 Qs

Scratch Pre-knowledge

Scratch Pre-knowledge

3rd Grade - University

15 Qs

Understanding Loops in C Programming

Understanding Loops in C Programming

1st Grade - University

15 Qs

Safe Gaming: Know the Risks

Safe Gaming: Know the Risks

7th Grade - University

12 Qs

Copyright, Fair Use, and Ethical Use of AI In Schools

Copyright, Fair Use, and Ethical Use of AI In Schools

7th - 12th Grade

10 Qs

Using functions in Excel

Using functions in Excel

Assessment

Quiz

Information Technology (IT)

7th Grade

Medium

Created by

Stephen Langford

Used 6+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Any function in Excel begins with...

=

@

DO

#

2.

MATCH QUESTION

45 sec • 1 pt

Match each function with what it does

Finds the total of the values

MAX

Rounds the value (to decimal places)

AVERAGE

Finds the lowest value

SUM

Finds the highest value

ROUND

Finds the mean of the values

MIN

3.

MATH RESPONSE QUESTION

45 sec • 1 pt

Media Image

What is the result of

= SUM(A1 : A3)

Mathematical Equivalence

ON

4.

MATH RESPONSE QUESTION

45 sec • 1 pt

Media Image

What is the result of

= AVERAGE(A1 : A3)

Mathematical Equivalence

ON

5.

MATH RESPONSE QUESTION

30 sec • 1 pt

Media Image

What is the result of

= MAX(B1 : B4)

Mathematical Equivalence

ON

6.

MATH RESPONSE QUESTION

30 sec • 1 pt

Media Image

What is the result of

= MIN(B1 : C4)

Mathematical Equivalence

ON

7.

MATH RESPONSE QUESTION

30 sec • 1 pt

Media Image

What is the result of

= ROUND(C3,1)

Mathematical Equivalence

ON

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?