Exploring New Excel Features

Exploring New Excel Features

5th Grade

10 Qs

quiz-placeholder

Similar activities

Brazilian Arts

Brazilian Arts

1st - 6th Grade

10 Qs

Is saptak me

Is saptak me

1st - 5th Grade

12 Qs

Pitch Shapes 1

Pitch Shapes 1

3rd - 10th Grade

10 Qs

MAD T SHIRT

MAD T SHIRT

5th Grade

16 Qs

¿Cuánto sabes de canto?

¿Cuánto sabes de canto?

1st - 5th Grade

10 Qs

Time Signature

Time Signature

KG - 6th Grade

16 Qs

Colombian music 5th Grade - Review

Colombian music 5th Grade - Review

5th Grade

15 Qs

Quiz Of The Week (A2, W3)

Quiz Of The Week (A2, W3)

KG - Professional Development

15 Qs

Exploring New Excel Features

Exploring New Excel Features

Assessment

Interactive Video

Arts

5th Grade

Hard

Created by

Marcus Legear

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens to the cell value when a new checkbox is checked?

It changes to 'TRUE'

It changes to 'FALSE'

It becomes empty

It remains unchanged

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you count the number of completed tasks using checkboxes?

Using the AVERAGE function

Using the MAX function

Using the SUMIF function

Using the COUNTIF function

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the COUNTIF function do with checkboxes?

Counts unchecked boxes

Deletes unchecked boxes

Counts all boxes

Counts checked boxes

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of the GROUPBY function in Excel?

To sort data

To merge data

To summarize data

To filter data

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What additional feature does the PIVOTBY function offer over the GROUPBY function?

It allows adding a field in the columns of your summary table

It allows for faster data processing

It automatically updates data

It supports more complex formulas

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function allows you to summarize data by adding a field in the columns?

AVERAGE

PIVOTBY

GROUPBY

SUM

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you import data from a picture into Excel?

Using the Import Data command

Using the Insert Data function

Using the Data from Picture tool

Using the Scan & Upload feature

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?