Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel Quiz

Total questions: 18

Worksheet time: 9mins

Name
Class
Date
1.

What is the function of Microsoft Excel?

a)

The function of Microsoft Excel is to play music and videos

b)

The function of Microsoft Excel is to cook food and prepare recipes

c)

The function of Microsoft Excel is to create and manipulate spreadsheets for data analysis, calculations, and visualization.

d)

The function of Microsoft Excel is to send and receive emails

2.

What is the shortcut key to save a spreadsheet in Microsoft Excel?

a)

Ctrl + S

b)

Alt + S

c)

Shift + S

d)

Ctrl + A

3.

How can you format cells in Microsoft Excel?

a)

You can format cells in Microsoft Excel by clapping your hands

b)

You can format cells in Microsoft Excel by selecting the cells you want to format, then right-click and choose 'Format Cells' from the menu. This will open a dialog box where you can apply various formatting options such as number, alignment, font, border, fill, and protection.

c)

You can format cells in Microsoft Excel by shaking your computer

d)

You can format cells in Microsoft Excel by singing a song

4.

What is the purpose of using formulas in Microsoft Excel?

a)

To play music

b)

The purpose of using formulas in Microsoft Excel is to perform calculations, manipulate data, and automate repetitive tasks.

c)

To write essays

d)

To create art designs

5.

What is the difference between a row and a column in a spreadsheet?

a)

A row runs horizontally across the spreadsheet, while a column runs vertically down the spreadsheet.

b)

A row is always wider than a column in a spreadsheet

c)

A row is used for text data, while a column is used for numerical data

d)

A row and a column are the same thing in a spreadsheet

6.

How do you insert a new row or column in Microsoft Excel?

a)

Double-click on the row number or column letter

b)

Go to the 'File' menu and select 'New'

c)

Right-click on the row number or column letter and select 'Insert' from the context menu.

d)

Press the 'Delete' key on the keyboard

7.

What are the different types of charts that can be created in Microsoft Excel?

a)

The different types of charts that can be created in Microsoft Excel include column charts, bar charts, line charts, pie charts, scatter plots, area charts, and many more.

b)

Only line charts and pie charts

c)

Bar charts and scatter plots

d)

Column charts and area charts

8.

How do you apply filters to data in Microsoft Excel?

a)

To apply filters in Microsoft Excel, right-click on the data range and select 'Filter'

b)

To apply filters in Microsoft Excel, go to the 'Insert' tab and click on 'Filter'

c)

To apply filters in Microsoft Excel, use the 'Format' tab and select 'Filter' from the dropdown menu

d)

To apply filters in Microsoft Excel, select the data range, go to the 'Data' tab, and click on the 'Filter' button.

9.

What is the function of the 'freeze panes' feature in Microsoft Excel?

a)

The 'freeze panes' feature in Microsoft Excel allows users to create a new worksheet

b)

The 'freeze panes' feature in Microsoft Excel allows users to delete rows and columns

c)

The 'freeze panes' feature in Microsoft Excel allows users to lock specific rows or columns in place so that they remain visible while scrolling through the rest of the worksheet.

d)

The 'freeze panes' feature in Microsoft Excel allows users to change the color scheme of the worksheet

10.

How can you create a chart in Microsoft Excel?

a)

You can create a chart in Microsoft Excel by drawing it with a pencil

b)

You can create a chart in Microsoft Excel by going to the 'Insert' tab and selecting the desired chart type from the 'Charts' group

c)

You can create a chart in Microsoft Excel by using the 'Format' tab and choosing 'Chart' from the dropdown menu

d)

You can create a chart in Microsoft Excel by using the 'Data' tab and clicking on the 'Chart' button

11.

What is the purpose of using conditional formatting in Microsoft Excel?

a)

The purpose of using conditional formatting in Microsoft Excel is to change the font style

b)

The purpose of using conditional formatting in Microsoft Excel is to apply formatting to cells based on certain conditions or criteria

c)

The purpose of using conditional formatting in Microsoft Excel is to create new worksheets

d)

The purpose of using conditional formatting in Microsoft Excel is to delete rows and columns

12.

How do you merge cells in Microsoft Excel?

a)

To merge cells in Microsoft Excel, right-click on the cells and select 'Merge'

b)

To merge cells in Microsoft Excel, go to the 'Home' tab and click on the 'Merge & Center' button

c)

To merge cells in Microsoft Excel, use the 'Insert' tab and select 'Merge Cells' from the dropdown menu

d)

To merge cells in Microsoft Excel, press the 'Delete' key on the keyboard

13.

What is the purpose of using VLOOKUP function in Microsoft Excel?

a)

The purpose of using VLOOKUP function in Microsoft Excel is to search for a specific value in the first column of a table and return a corresponding value in the same row from another column.

b)

The purpose of using VLOOKUP function in Microsoft Excel is to change the font style

c)

The purpose of using VLOOKUP function in Microsoft Excel is to create new worksheets

d)

The purpose of using VLOOKUP function in Microsoft Excel is to delete rows and columns

14.

How can you protect a worksheet in Microsoft Excel?

a)

You can protect a worksheet in Microsoft Excel by clapping your hands

b)

You can protect a worksheet in Microsoft Excel by selecting the worksheet, then right-click and choose 'Protect Sheet' from the menu. This will open a dialog box where you can set a password and choose the actions you want to allow users to perform.

c)

You can protect a worksheet in Microsoft Excel by shaking your computer

d)

You can protect a worksheet in Microsoft Excel by singing a song

15.

What is the function of the 'PivotTable' feature in Microsoft Excel?

a)

The 'PivotTable' feature in Microsoft Excel allows users to create a new worksheet

b)

The 'PivotTable' feature in Microsoft Excel allows users to delete rows and columns

c)

The 'PivotTable' feature in Microsoft Excel allows users to summarize and analyze data from a larger table into a concise, tabular format for easier reporting and analysis.

d)

The 'PivotTable' feature in Microsoft Excel allows users to change the color scheme of the worksheet

16.

What is the purpose of using absolute cell reference in Microsoft Excel?

a)

The purpose of using absolute cell reference in Microsoft Excel is to lock a cell or range of cells so that they do not change when copied or filled.

b)

The purpose of using absolute cell reference in Microsoft Excel is to change the font style

c)

The purpose of using absolute cell reference in Microsoft Excel is to create new worksheets

d)

The purpose of using absolute cell reference in Microsoft Excel is to delete rows and columns

17.

How can you use the 'IF' function in Microsoft Excel?

a)

You can use the 'IF' function in Microsoft Excel to perform conditional logic and return different values based on specified conditions.

b)

You can use the 'IF' function in Microsoft Excel to change the font style

c)

You can use the 'IF' function in Microsoft Excel to create new worksheets

d)

You can use the 'IF' function in Microsoft Excel to delete rows and columns

18.

What is the purpose of using the 'SUM' function in Microsoft Excel?

a)

The purpose of using the 'SUM' function in Microsoft Excel is to add up values in a range of cells.

b)

The purpose of using the 'SUM' function in Microsoft Excel is to change the font style

c)

The purpose of using the 'SUM' function in Microsoft Excel is to create new worksheets

d)

The purpose of using the 'SUM' function in Microsoft Excel is to delete rows and columns