Search Header Logo

ASET11. Advanced Office Tools

Authored by Michael Atienza

Computers

11th Grade

Used 9+ times

ASET11. Advanced Office Tools
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of the SUMIF function?

To count the total number of cells in a range.

To add all numbers in a specified range of cells.

To conditionally add numbers based on a specific criterion.

To find the average of a range of numbers.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to calculate the arithmetic mean of a range of numbers?

COUNT

SUM

AVERAGE

IF

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The AND function returns a TRUE value only if:

At least one of its conditions is true.

All of its conditions are true.

None of its conditions are true.

The logical test is false.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the COUNT function do?

It counts the number of cells in a range that contain numerical data.

It counts cells that satisfy a given criterion.

It counts the number of empty cells in a range.

It counts the total number of cells in a range, including text and numbers.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is ideal for searching for a value in the first column of a data table and returning a corresponding value from a specified column?

HLOOKUP

VLOOKUP

SUMIF

AVERAGEIF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The COUNTIF function is used to:

Count all non-empty cells in a range.

Count cells in a specified range that satisfy a given criterion.

Count cells with formulas.

Count cells that contain text.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which advanced spreadsheet tool is used to condense thousands of rows into meaningful summaries with drag-and-drop simplicity?

Conditional Formatting

Data Validation

Pivot Table

Text to Columns

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?