Mastering Microsoft Excel

Mastering Microsoft Excel

Professional Development

20 Qs

quiz-placeholder

Similar activities

Dihybrid Cross

Dihybrid Cross

11th Grade

20 Qs

4P_SCIENCE_33_3

4P_SCIENCE_33_3

4th Grade

15 Qs

(2.4) Isotopes and Its Uses

(2.4) Isotopes and Its Uses

10th Grade

17 Qs

Volcanos

Volcanos

4th - 5th Grade

15 Qs

Weathering and Moving Rocks

Weathering and Moving Rocks

7th Grade

20 Qs

Natural resources, rocks/minerals, and weathering/erosion

Natural resources, rocks/minerals, and weathering/erosion

3rd - 5th Grade

20 Qs

KSSM Science Form 2 Chapter 7

KSSM Science Form 2 Chapter 7

2nd - 5th Grade

20 Qs

Synthetic fibers and plastics

Synthetic fibers and plastics

8th Grade

15 Qs

Mastering Microsoft Excel

Mastering Microsoft Excel

Assessment

Quiz

Science

Professional Development

Practice Problem

Medium

Created by

Reshma Joseph

Used 4+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is Microsoft Excel?

A web browser

A word processing program

A graphic design tool

A spreadsheet application

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the default file extension for an Excel workbook?

.xlsx

.xls

.txt

.csv

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function would you use to find the average of a range of cells?

COUNT

MAX

AVERAGE

SUM

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Microsoft Excel spreadsheets, rows are designated as _______.

1, 2, 3, ....

A, B, C, ....

A1, B1, C1, ....

I, II, III, ....

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

How do you create a pie chart in Excel?

Select your data, go to 'File' > 'New Chart', and choose a type.

Select your data, go to 'Insert' > 'Pie Chart', and choose a style.

Highlight your data, click on 'Data' > 'Chart Options', and pick a design.

Choose your data, navigate to 'View' > 'Chart Wizard', and select a format.

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the purpose of conditional formatting in Excel?

The purpose of conditional formatting in Excel is to visually enhance data by applying formatting based on specific conditions.

To create charts automatically based on data trends.

To protect data from being edited by users.

To sort data in ascending or descending order.

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

How do you sort data in Excel?

Select the data range, go to the 'Home' tab, click 'Format', then choose 'Align' options.

Select the data range, go to the 'Data' tab, click 'Sort', choose the column and order, then click 'OK'.

Highlight the data, then press 'Ctrl + Z' to undo any changes.

Right-click the data range and select 'Delete' to remove duplicates.

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?