Search Header Logo

Advance Microsoft Advance Excel - Assessment

Authored by Ragu Nath

Other

University

Used 2+ times

Advance Microsoft Advance Excel - Assessment
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

1 - Which tab in Excel contains options for formatting, inserting, and deleting cells?

Home

Insert

Data

Review

2.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

2 - Which shortcut key is used to open the "Format Cells" dialog box?

Ctrl + 1

Ctrl + 2

Ctrl + F

Ctrl + S

3.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

3 - What is the purpose of Data Validation in Excel?

To format cells with colors

To restrict the type of data entered into a cell

To create charts

To sort data alphabetically

4.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

4 - Which feature allows you to create a dropdown list in a cell?

Conditional Formatting

Data Validation

Pivot Table

Filter

5.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

5 - What does the shortcut "Ctrl + T" do in Excel?

Insert a table

Insert a chart

Insert a pivot table

Insert a formula

6.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

6 - Which Excel feature allows you to create pre-designed layouts for reports?

Pivot Tables

Templates

Macros

Charts

7.

MULTIPLE CHOICE QUESTION

30 sec • 4 pts

7 - What is the purpose of the "Subtotal" feature in Excel?

To create charts

To calculate totals for grouped data

To filter data

To validate data

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?