Search Header Logo

Excel Mastery Challenge

Authored by Chadie Natividad

Computers

7th Grade

Used 3+ times

Excel Mastery Challenge
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You have a list of scores in cells A1 to A10. You need to find the total score. Which formula would you use?

=SUM(A1:A10)

=AVERAGE(A1:A10)

=MAX(A1:A10)

=COUNT(A1:A10)

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You are managing a budget spreadsheet and need to find the highest expense from a range of values in cells B1 to B20. Which function would you use?


=MIN(B1:B20)

=AVERAGE(B1:B20)

  • =MAX(B1:B20)

=COUNT(B1:B20)

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You are preparing a contact list and need to combine the first name (cell A1) and last name (cell B1) into a single cell. Which formula would you use?

=COMBINE(A1, B1)

=MERGE(A1, B1)

=JOIN(A1, B1)

=CONCATENATE(A1, B1)

4.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You're putting up a business and need to calculate the total cost by multiplying the quantity in cell A1 with the price in cell B1. Which formula would you use?

  • =SUM(A1*B1)

=PRODUCT(A1,B1)

  • =AVERAGE(A1*B1)

=MAX(A1,B1)

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You're working with a large dataset and want to sort the data based on multiple criteria (e.g., first by general average, then by gender). What command enables you to do this?

  • Sort by Color

Custom Sort

Filter

Freeze Panes

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You're analyzing survey responses and need to categorize responses as "Satisfied" or "Dissatisfied" based on a certain score threshold. Which Excel function would you use?

=AVERAGE( )

=IF( )

=TRIM( )

=PROPER( )

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What symbol is used in Excel to indicate the beginning of a formula?

+

--

*

=

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?