Search Header Logo

Random Quiz

Authored by Janice Peneyra

Professional Development

12th Grade

Used 1+ times

Random Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function is used to find the largest value in a range of numbers?

=MIN()

=MAX()

=LARGE()

=BIGGEST()

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function =SUM(A1:A5) do in Excel?

Multiplies the values in cells A1 to A5

Finds the average of cells A1 to A5

Adds the values in cells A1 to A5

Divides the values in cells A1 to A5

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you apply a filter to a table in Excel?

Use the "Filter" function in the Home tab

Right-click on the table and choose "Apply Filter"

Go to the Data tab and click on "Filter"

Type "=FILTER(table)" in a cell

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the "IF" function in Excel?

To create a table of contents

To count the number of cells in a range

To calculate the sum of a range of numbers

To perform conditional calculations based on a logical test

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the "VLOOKUP" function in Excel?

To perform vertical lookup and retrieve data based on a matching value

To find and replace text in a worksheet

To add a range of numbers

To calculate the square root of a number

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula of the monthly collection efficiency report?

Total Collected Amount / Total Collectibles

Total Collectibles /Total Collected Amount

Total Collectibles / Total Unpaid Amount

7.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Atlantic Hardware VISION : To be the customer's ___ building materials and home improvement needs in Cebu by 2027.

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?

Discover more resources for Professional Development