Data Science-Spreadsheet Functions

Data Science-Spreadsheet Functions

12th Grade

50 Qs

quiz-placeholder

Similar activities

Latihan USP Informatika IX paket 1

Latihan USP Informatika IX paket 1

9th Grade - University

50 Qs

PSAJ 2025 SIMDIG

PSAJ 2025 SIMDIG

12th Grade

45 Qs

Final CC101 Exam

Final CC101 Exam

12th Grade

50 Qs

Information Technology Practice for WebXam- AI beta

Information Technology Practice for WebXam- AI beta

12th Grade

51 Qs

KELAS 2-REVIEW MATERI INFORMATIKA SM2

KELAS 2-REVIEW MATERI INFORMATIKA SM2

2nd Grade - University

50 Qs

ASAS/PAS TIK Kelas XII Semester Ganjil Tahun Ajaran 2024/2025

ASAS/PAS TIK Kelas XII Semester Ganjil Tahun Ajaran 2024/2025

12th Grade

46 Qs

Penilaian Harian Kelas 7D

Penilaian Harian Kelas 7D

7th Grade - University

50 Qs

Quiz Pra-Asesmen

Quiz Pra-Asesmen

7th Grade - University

52 Qs

Data Science-Spreadsheet Functions

Data Science-Spreadsheet Functions

Assessment

Quiz

Information Technology (IT)

12th Grade

Medium

Created by

Roger Thompson

Used 5+ times

FREE Resource

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula is used to find the average of a set of numbers in Excel?

=SUM(A1:A10)

=MIN(A1:A10)

AVERAGE(A1:A10)

=AVERAGE(A1:A10)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The formula =IF(A1>50, "Pass", "Fail") will return "Pass" if:

A1 contains the text 'Pass'.
A1 contains a number greater than 50.
A1 is empty or contains no value.
A1 contains a number less than 50.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to round a number to two decimal places?

=TRUNC(A1,2)

=ROUND(A1,2)

ROUND(A1,2)

=RND(A1,2)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the $ symbol do in a cell reference, such as $A$1?

The $ symbol makes the cell reference relative, allowing it to change when copied.
The $ symbol is used to format the cell as currency.
The $ symbol indicates a formula error in the cell reference.
The $ symbol makes the cell reference absolute, preventing it from changing when copied.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What formula is used to calculate the sum of a range of cells in Excel?

=SUMIF(A1:A10)

=TOTAL(A1:A10)

=SUM(A1:A10)

=ADD(A1:A10)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, which formula returns the highest value in a range?

=MIN(A1:A10)

MAX(A1:A10)

=MAX(A1:A10)

=SUM(A1:A10)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function can be used to find the rank of a number in a list?

=RANK(A1,A1:A10)

RANK(A1,A1:A10)

=MATCH(A1,A1:A10,0)

=INDEX(A1:A10,3)

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?

Discover more resources for Information Technology (IT)