IGCSE Practice Practical Spreadsheet

IGCSE Practice Practical Spreadsheet

9th - 10th Grade

19 Qs

quiz-placeholder

Similar activities

Latihan Soal Grafik dan Data

Latihan Soal Grafik dan Data

9th Grade

15 Qs

Aplikasi Pengolah Angka

Aplikasi Pengolah Angka

10th Grade

15 Qs

Excel Functions and Formulas

Excel Functions and Formulas

9th - 11th Grade

14 Qs

Excel Quiz

Excel Quiz

8th - 12th Grade

20 Qs

Ulangan Kelas 8A

Ulangan Kelas 8A

9th Grade

17 Qs

Excel Functions and Formulas

Excel Functions and Formulas

9th - 11th Grade

20 Qs

Uji Pemahaman Excel untuk Siswa SMA

Uji Pemahaman Excel untuk Siswa SMA

10th Grade

20 Qs

Vlookup, IF, Absolute Refrence, Error di Ms. Excel

Vlookup, IF, Absolute Refrence, Error di Ms. Excel

10th Grade

15 Qs

IGCSE Practice Practical Spreadsheet

IGCSE Practice Practical Spreadsheet

Assessment

Quiz

Computers

9th - 10th Grade

Hard

Created by

Fritz Bansag

Used 19+ times

FREE Resource

19 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact absolute cell reference formula for cell F14

(Click on the photo to enlarge)

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact absolute cell reference formula for cell F19

(Click on the photo to enlarge)

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact formula to get the TOTAL Income in CELL H11

(Click on the photo to enlarge)

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact formula to get the TOTAL Income in CELL H18

(Click on the photo to enlarge)

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact VLOOKUP formula in Cell D7 according to the given data in Cell B7 with the criteria data range from Cells H7 to I17 (Click on the photo to enlarge)

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact VLOOKUP formula in Cell C10 according to the given data in Cell B10 with the criteria data range from Cells H7 to I17 (Click on the photo to enlarge)

7.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Write the exact VLOOKUP formula in Cell C15 according to the given data in Cell B15 with the criteria data range from Cells H7 to I17 (Click on the photo to enlarge)

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?