Excel Quiz 4

Excel Quiz 4

KG

45 Qs

quiz-placeholder

Similar activities

Ujian Akhir Semester Ganjil Kls XII (23-24)

Ujian Akhir Semester Ganjil Kls XII (23-24)

12th Grade

50 Qs

Literasi & Numerasi Kelas 5

Literasi & Numerasi Kelas 5

5th Grade

40 Qs

env sci unit 5 review

env sci unit 5 review

9th Grade

44 Qs

PAT kelas 7 bahasa inggris

PAT kelas 7 bahasa inggris

7th Grade

45 Qs

US Sastra Inggris

US Sastra Inggris

12th Grade

40 Qs

IPS tengah semester 1 kelas 8

IPS tengah semester 1 kelas 8

8th Grade - University

40 Qs

SOAL UJIAN PKN KLS X TAHUN PELAJARAN 2023/2024

SOAL UJIAN PKN KLS X TAHUN PELAJARAN 2023/2024

KG

40 Qs

playaway weekend with Quizizz

playaway weekend with Quizizz

1st Grade

41 Qs

Excel Quiz 4

Excel Quiz 4

Assessment

Quiz

Others

KG

Practice Problem

Easy

Created by

Марк Калдыбеков

Used 14+ times

FREE Resource

AI

Enhance your content in a minute

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

45 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the OR() function return?

TRUE if any condition is TRUE

FALSE always

The opposite of NOT

FALSE if one is false

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which error indicates a divide-by-zero problem?

#NAME?

#VALUE!

#DIV/0!

#REF!

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function returns the current time only (without date)?

=TEXT(NOW(),"hh:mm:ss")

=NOW()

=TIME()

=TODAY()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main purpose of a PivotTable in Excel?

To create complex formulas and calculations

To organize and summarize large amounts of data

To create data visualizations using charts and graphs

To apply cell formatting to selected ranges

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a PivotChart in Excel?

A way to filter data in a worksheet

A tool for merging cells

A type of data validation rule

A visual representation of PivotTable data

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are functions and their codes in the context of subtotals in Excel?

Descriptions of different subtotal functions available in Excel

Formulas used to calculate subtotals and the corresponding color codes

Shortcut keys to apply subtotals to selected data

Codes used to hide subtotals in a worksheet

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, what is the working principle of 'Interim Results' in subtotals?

It adds cell formatting to the subtotal results

It calculates intermediate totals at various levels of grouping.

It calculates an average of data points

It performs a multiplication operation

Create a free account and access millions of resources

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?