Excel Mastery

Excel Mastery

9th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

After Effect Intoduction

After Effect Intoduction

10th Grade - University

15 Qs

OOP 1 Undiksha

OOP 1 Undiksha

12th Grade - University

13 Qs

Empowerment Technologies Quiz 2

Empowerment Technologies Quiz 2

11th Grade

10 Qs

Chapter 3 Exploring Linux Filesystems

Chapter 3 Exploring Linux Filesystems

11th Grade - University

10 Qs

IP ADDRESSING AND ITS VERSION

IP ADDRESSING AND ITS VERSION

11th Grade

15 Qs

Spreadsheet Starter

Spreadsheet Starter

7th Grade - University

12 Qs

8525 AQA GCSE  3.1.1 Pseudo-code

8525 AQA GCSE 3.1.1 Pseudo-code

10th - 11th Grade

14 Qs

Електронні таблиці Exel

Електронні таблиці Exel

1st - 12th Grade

12 Qs

Excel Mastery

Excel Mastery

Assessment

Quiz

Computers

9th - 12th Grade

Practice Problem

Easy

Created by

Shaheena Jussab

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the shortcut key to open the 'Insert Function' dialog box in Excel?

Shift + F4

Alt + F3

Ctrl + F3

Shift + F3

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you create a chart in Excel?

Select data, go to Insert tab, click on Chart button, choose chart type

Click on the data, press Ctrl+C, go to Insert tab, click on Chart button, choose chart type

Go to Format tab, click on Chart button, choose chart type

Right-click on the data, select Create Chart

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of sorting and filtering data in Excel?

To make the data look more visually appealing.

To organize and analyze data more effectively.

To randomly rearrange the data.

To waste time and confuse users.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula can be used to add up a column of numbers in Excel?

AVERAGE

SUM

TOTAL

ADD

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function of the VLOOKUP formula in Excel?

To calculate the sum of a range of cells.

To format the appearance of a cell or range of cells.

To create a chart or graph based on data in a worksheet.

To search for a value in a table and return a corresponding value from another column.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you apply conditional formatting to a range of cells in Excel?

You can apply conditional formatting to a range of cells in Excel by right-clicking on the range and selecting 'Conditional Formatting'.

You can apply conditional formatting to a range of cells in Excel by using the 'Format' option in the 'Home' tab.

You can apply conditional formatting to a range of cells in Excel by typing the desired formatting rule directly into the cell formula bar.

You can apply conditional formatting to a range of cells in Excel by selecting the range, going to the 'Conditional Formatting' option in the 'Home' tab, choosing the desired formatting rule, and customizing the rule settings.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of pivot tables in Excel?

The purpose of pivot tables in Excel is to import and export data.

The purpose of pivot tables in Excel is to summarize and analyze data.

The purpose of pivot tables in Excel is to format and style cells.

The purpose of pivot tables in Excel is to create charts and graphs.

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?