Search Header Logo

Excel Functions Quiz 280324

Authored by Talent Ltd

Computers

Professional Development

20 Questions

Used 2+ times

Excel Functions Quiz 280324
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to count the number of cells with numeric data in a range A1:A10, which function would you use?

COUNT(A1:A10)

COUNTA(A1:A10)

COUNTBLANK(A1:A10)

SUM(A1:A10)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would return the smallest number in the range C1:C10?

MIN(C1:C10)

MAX(C1:C10)

AVERAGE(C1:C10)

COUNT(C1:C10)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function COUNTBLANK(range) do?

Counts the number of numeric values in the range.

Counts the number of non-numeric values in the range.

Counts the number of blank or empty cells in the range.

Sums the numeric values in the range.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you have a list of values in A1:A5 and you want to sum only the values greater than 50, which formula is correct?

SUMIF(A1:A5, ">50")

SUM(A1:A5, ">50")

COUNTIF(A1:A5, ">50")

AVERAGEIF(A1:A5, ">50")

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If cells A1, A2, and A3 contain the numbers 3, 7, and 8 respectively, what will the formula =MIN(A1:A3) return?

3

7

8

18

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How would you calculate the average value of cells in the range B1:B5?

SUM(B1:B5)/5

COUNT(B1:B5)

AVERAGE(B1:B5)

MIN(B1:B5)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You need to remove leading and trailing spaces from a text string in cell A1. Which function would you use?

LEN(A1)

TRIM(A1)

MIN(A1)

COUNTA(A1)

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?