Database&Spreadshet_GR8_4/2024

Database&Spreadshet_GR8_4/2024

9th Grade

49 Qs

quiz-placeholder

Similar activities

ICT 9 SUMMATIVE TEST

ICT 9 SUMMATIVE TEST

9th Grade

50 Qs

DW session 3 POST

DW session 3 POST

9th - 12th Grade

46 Qs

Citation styles: APA and Chicago

Citation styles: APA and Chicago

7th - 12th Grade

50 Qs

Web Design - Final Exam Review

Web Design - Final Exam Review

9th - 12th Grade

50 Qs

MS Excel

MS Excel

7th - 12th Grade

45 Qs

Aplikasi Pengolah Angka (Spreadsheet)

Aplikasi Pengolah Angka (Spreadsheet)

9th - 12th Grade

50 Qs

Unit Review: Chapters 1-7

Unit Review: Chapters 1-7

9th - 12th Grade

50 Qs

Soal HTML & CSS

Soal HTML & CSS

9th - 12th Grade

48 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?