LO5 - Spreadsheets (1)

LO5 - Spreadsheets (1)

10th - 11th Grade

15 Qs

quiz-placeholder

Similar activities

Google Sheets Basics

Google Sheets Basics

9th - 12th Grade

15 Qs

Google Spreadsheet - 01

Google Spreadsheet - 01

10th Grade

16 Qs

Matching for Excel Intermediate Topic

Matching for Excel Intermediate Topic

9th Grade - University

20 Qs

Excel Spreadsheet Fun (2nd)

Excel Spreadsheet Fun (2nd)

10th - 12th Grade

20 Qs

Getting to Know Excel!

Getting to Know Excel!

11th Grade

10 Qs

Spreadsheet Starter

Spreadsheet Starter

7th Grade - University

12 Qs

Excel: basic understanding

Excel: basic understanding

3rd Grade - Professional Development

13 Qs

INTRODUCTION TO MICROSOFT EXCEL

INTRODUCTION TO MICROSOFT EXCEL

7th Grade - University

20 Qs

LO5 - Spreadsheets (1)

LO5 - Spreadsheets (1)

Assessment

Quiz

Computers

10th - 11th Grade

Medium

Created by

Samantha Cook

Used 22+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A sales manager has requested the highest sale for the first quarter. Which function will be used?

SUM

MAX

MIN

AVERAGE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A sales manager has requested the lowest sale for the first quarter. Which function will be used?

SUM

MIN

MAX

AVERAGE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Bob needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?

Label

Value

Formula

Function

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A sales manager has requested the total sale for the first quarter. Which function will be used?

SUM

MIN

MAX

AVERAGE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In spreadsheets, columns are marked with _________

Letters

Numbers

= sign

Both a letter and a number

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In spreadsheets, rows are marked with _____

Letters

Numbers

= sign

Both a letter and a number

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

All spreadsheet formulas begin with which symbol?

=

^

$

#

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?