Search Header Logo

Excel Functions and Data Analysis Quiz

Authored by Bryan Cajurao

Other

University

Used 3+ times

Excel Functions and Data Analysis Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

What is a cell reference in Excel?

A tool for sorting data

A combination of a column letter and a row number

A chart displaying numeric data

A formula to calculate averages

2.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

Which symbol is used to create an absolute reference in Excel?

*

^

$

#

3.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

What formula adds up the values in cells A1 and A2?

=SUM(A1:A2)

=ADD(A1:A2)

=A1+A2

=A1&A2

4.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

What does the function =AVERAGE(A1:A10) do?

Sums up the numbers in A1 through A10

Finds the largest value in the range A1:A10

Returns the average of numbers in A1 through A10

Counts the number of cells in A1 through A10

5.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

How does the COUNT function work in Excel?

Counts all blank cells in a range

Counts only numbers in a list of arguments

Adds all numeric values in a range

Returns the average of numeric values in a range

6.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

What does =SUMIF(A1:A10,">5") do?

Sums all values in A1:A10

Sums all values in A1:A10 greater than 5

Counts all values in A1:A10 greater than 5

Finds the maximum value in A1:A10 greater than 5

7.

MULTIPLE CHOICE QUESTION

3 mins • 2 pts

What is the role of parentheses in Excel formulas?

Change cell references

Denote priority in calculations

Specify cell colors

Indicate text values

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?