Year 10 Plenary SUM,MAX, MIN, AVERAGE

Year 10 Plenary SUM,MAX, MIN, AVERAGE

6th Grade

10 Qs

quiz-placeholder

Similar activities

Spreadsheet - Microsoft Excel

Spreadsheet - Microsoft Excel

7th Grade

15 Qs

Spreadsheet Formula

Spreadsheet Formula

7th Grade

15 Qs

Spreadsheets for year 7

Spreadsheets for year 7

7th Grade

12 Qs

Excel

Excel

7th Grade

15 Qs

Excel

Excel

University

11 Qs

Microsoft Excel - Basics, Formatting and Calculating

Microsoft Excel - Basics, Formatting and Calculating

6th - 8th Grade

10 Qs

Excel HW 2

Excel HW 2

3rd - 9th Grade

15 Qs

Exel Formulas

Exel Formulas

6th - 8th Grade

12 Qs

Year 10 Plenary SUM,MAX, MIN, AVERAGE

Year 10 Plenary SUM,MAX, MIN, AVERAGE

Assessment

Quiz

Computers

6th Grade

Medium

Created by

Anne Marie Murphy

Used 9+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

I can find the lowest number in a range with the ... function
MIN
MAX
AVERAGE
COUNT

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you key a formula in a spreadsheet what do you key in first?
Subtraction sign
Equal Sign
Addition sign
Division sign

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function is used to add more than 2 cells?

+

=

SUM

( )

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image
Columns are identified using _______?
Numbers
Letters
Numbers & Letters
Cells

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image
Rows are identified using ________?
Numbers
Letters
Numbers & Letters
Cells

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SUM, AVERAGE, MAX and VLOOKUP are examples of what?
Functions
Tables
Formulae
Statistical tools

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What formula would you use to find out the highest number within a range of cells?

=Max

=Min

=High

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?