TGT1

TGT1

4th Grade

10 Qs

quiz-placeholder

Similar activities

Kiểm tra Excel

Kiểm tra Excel

4th - 5th Grade

15 Qs

Google Sheets

Google Sheets

3rd - 12th Grade

8 Qs

Spreadsheet Mini Quiz

Spreadsheet Mini Quiz

KG - University

10 Qs

EXCEL TIK P6

EXCEL TIK P6

4th Grade - University

10 Qs

More Spreadsheet Basics

More Spreadsheet Basics

KG - University

10 Qs

Penilaian Harian 1 Ms. Excel (Kondisi IF)

Penilaian Harian 1 Ms. Excel (Kondisi IF)

1st - 12th Grade

10 Qs

Pendalaman Materi Kondisi (IF)

Pendalaman Materi Kondisi (IF)

1st - 12th Grade

10 Qs

OFIMÁTICO VERANO 16

OFIMÁTICO VERANO 16

1st - 10th Grade

10 Qs

TGT1

TGT1

Assessment

Quiz

Computers

4th Grade

Hard

Created by

Inez Salim

Used 3+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Find the youngest age from participant number 8 to 15.

=YOUNGEST(C8:C15)

=MIN(C9:C16)

=YOUNGEST(C9-C16)

=MIN(C8-C15)

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Find the total age of Daisy, Gwen, and Stephanie.

=C5+C6+C7

=SUM(C5:C7)

=14+10+4

All answers are correct

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Find the average age from participant 1 to 10.

=AVERAGE(C2,C11)

=AVERAGE(C2:C3:C4:C5:C6:C7:C8:C9:C10:C11)

=AVERAGE(C2:C11)

=AVERAGE(C2-C11)

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Find the oldest age from participant number 3 to 8.

=OLDEST(C3:C8)

=MAX(C4:C9)

=OLDEST(C4-C9)

=MAX(C3-C8)

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Find the age gap between the first participant and the last participant.

=B15-B1

=B16-B2

=C15-C1

=C16-C2

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

To count cells with numbers.

SUM

MIN

MAX

COUNT

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Math operator to do division in a spreadsheet.

*

:

÷

/

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?