10G - Spreadsheets Revision 1

10G - Spreadsheets Revision 1

10th Grade

9 Qs

quiz-placeholder

Similar activities

Excel CH 1 & 2

Excel CH 1 & 2

1st - 11th Grade

10 Qs

Spreadsheets-grade-10

Spreadsheets-grade-10

10th Grade

12 Qs

Excel Module 1

Excel Module 1

9th Grade - University

10 Qs

Google Sheets Vocab

Google Sheets Vocab

9th - 12th Grade

10 Qs

Excel Functions and Formulas

Excel Functions and Formulas

9th - 11th Grade

14 Qs

Repaso Excel Básico Bayer CH

Repaso Excel Básico Bayer CH

6th Grade - University

11 Qs

Excel Basic

Excel Basic

KG - University

10 Qs

Analisis data Ulangan

Analisis data Ulangan

10th Grade

10 Qs

10G - Spreadsheets Revision 1

10G - Spreadsheets Revision 1

Assessment

Quiz

Computers

10th Grade

Medium

Created by

Charlotte Hook

Used 1+ times

FREE Resource

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

To format a heading to make it expand across more than one cell you need to highlight the cells and then:

Wrap Text

Merge Cells

Align to Middle

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula finds the LARGEST number in an range? 

SUM

MIN

MAX

IF

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What type of chart is this?

Line chart

Pie chart

Bar chart

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula adds up the TOTAL of a range of numbers?

VLOOKUP

IF

SUM

AVERAGE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Correct the following formula:

=IF(C3>=G2,'Enter',"No Entry")

=IF(C3>=G2,'Enter',"No Entry")

=IF(C3>=$G$2,"Enter","No Entry")

=IF(C3>=G2,"Enter","No Entry")

6.

OPEN ENDED QUESTION

3 mins • 1 pt

What do you use an absolute cell reference for?

Evaluate responses using AI:

OFF

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function in Excel helps you to organise data?

Sort & Filter

VLOOKUP

Borders & Shading

Font Size

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Is this formula correct?

No

Yes

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula finds the arithmetic MEAN?

SUM

MAX

MIN

AVERAGE