Excel Mastery

Excel Mastery

9th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

OCR GCSE CS - 2.1 ERL sorts and searches

OCR GCSE CS - 2.1 ERL sorts and searches

10th - 11th Grade

9 Qs

Excel 2016 perusteet

Excel 2016 perusteet

10th Grade

12 Qs

MEDIA AND INFORMATION LITERACY

MEDIA AND INFORMATION LITERACY

12th Grade

10 Qs

Review for Midterm Test ICT 3

Review for Midterm Test ICT 3

1st - 11th Grade

15 Qs

To Change or Not to Change?

To Change or Not to Change?

12th Grade

10 Qs

General Ict Quiz

General Ict Quiz

4th Grade - University

15 Qs

Threats to Data

Threats to Data

9th - 12th Grade

11 Qs

HEALTH AND SAFETY 9

HEALTH AND SAFETY 9

7th - 9th Grade

11 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.

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?