Database&Spreadshet_GR8_4/2024

Database&Spreadshet_GR8_4/2024

9th Grade

49 Qs

quiz-placeholder

Similar activities

HTML_Assessment

HTML_Assessment

7th - 9th Grade

52 Qs

Sosial Media, Internet dan UU ITE

Sosial Media, Internet dan UU ITE

7th - 9th Grade

47 Qs

General Trivia Quiz 2025

General Trivia Quiz 2025

6th Grade - University

49 Qs

Computer Servicing Ch 1-3 Review

Computer Servicing Ch 1-3 Review

9th - 12th Grade

53 Qs

TEST M.5

TEST M.5

9th - 12th Grade

51 Qs

TEST EXCEL

TEST EXCEL

9th - 12th Grade

50 Qs

LATIHAN PAT INFORMATIKA KELAS X

LATIHAN PAT INFORMATIKA KELAS X

9th - 12th Grade

50 Qs

Uji Pengetahuan UKK TKJ 2023

Uji Pengetahuan UKK TKJ 2023

9th - 12th Grade

50 Qs

Database&Spreadshet_GR8_4/2024

Database&Spreadshet_GR8_4/2024

Assessment

Quiz

Computers

9th Grade

Practice Problem

Easy

Created by

Lê Thủy

Used 6+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

49 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function SUMIFS do in Excel?

Sums values in a range that meet multiple criteria

Sums values in a range that meet a single criterion

Checks if a condition is met and returns one value if true and another value if false

None of the above

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the feature used to link tables together in the database?

Foreign key

Primary key

Attribute

Relationship

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to find the highest value in a range in Excel?

MAX

MIN

SUM

AVERAGE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which attribute is used to control the format of data added to a database table?

Validation rule

Format

Field size

Input mask

5.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

What does the function TRANSPOSE do in Excel?

Converts text to uppercase

Returns the transpose of a matrix

Converts a column into a row or vice versa

None of the above

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function COUNT do in Excel?

Counts the number of empty cells in a range

Counts the number of cells containing numbers in a range

Counts the number of non-empty cells in a range

None of the above

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to sum values in Excel?

COUNT

AVERAGE

SUM

MAX

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?