Mastering Spreadsheet Functions Quiz

Mastering Spreadsheet Functions Quiz

9th Grade

17 Qs

quiz-placeholder

Similar activities

Functions and Features of Online Communities

Functions and Features of Online Communities

9th Grade

15 Qs

S3 Admin and IT Spreadsheets

S3 Admin and IT Spreadsheets

9th Grade

15 Qs

KELAS 7 BAB 6 ANALISIS DATA C. Pengolahan Data Dasar

KELAS 7 BAB 6 ANALISIS DATA C. Pengolahan Data Dasar

7th Grade - University

20 Qs

Spreadsheets Knowledge Check

Spreadsheets Knowledge Check

9th - 12th Grade

15 Qs

BAB 6 ANALISIS DATA B. Perkakas Pengolah Lembar Kerja

BAB 6 ANALISIS DATA B. Perkakas Pengolah Lembar Kerja

7th Grade - University

20 Qs

Data Structures Quiz

Data Structures Quiz

9th - 12th Grade

14 Qs

Latihan Soal Informatika

Latihan Soal Informatika

8th Grade - University

17 Qs

LATIHAN SOAL.! PART 1

LATIHAN SOAL.! PART 1

7th Grade - University

20 Qs

Mastering Spreadsheet Functions Quiz

Mastering Spreadsheet Functions Quiz

Assessment

Quiz

Information Technology (IT)

9th Grade

Medium

Created by

S Uwadiae

Used 1+ times

FREE Resource

17 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

11

16

13

10

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the average of a range of cells in a spreadsheet?

SUM

AVERAGE

MEDIAN

MODE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How would you apply conditional formatting to highlight cells greater than 100 in a spreadsheet?

Use the conditional formatting rule "Cell Value > 100"

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the SUM function in spreadsheets?

To find the average of numbers

To add up a range of numbers

To count the number of cells

To find the maximum value

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a basic formula to subtract 10 from 25 in a spreadsheet?

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Finds the minimum value in the range A1 to A10

Finds the maximum value in the range A1 to A10

Adds all the values in the range A1 to A10

Counts the number of cells in the range A1 to A10

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you format a cell to display numbers as currency in a spreadsheet?

Apply the currency format from the formatting menu

Type the currency symbol manually

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?