Microsoft Excel Quiz

What is the function of Microsoft Excel?

• The function of Microsoft Excel is to play music and videos

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

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

• The function of Microsoft Excel is to send and receive emails

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

• Ctrl + S

• Alt + S

• Shift + S

• Ctrl + A

How can you format cells in Microsoft Excel?

• You can format cells in Microsoft Excel by clapping your hands

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

• You can format cells in Microsoft Excel by shaking your computer

• You can format cells in Microsoft Excel by singing a song

What is the purpose of using formulas in Microsoft Excel?

• To play music

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

• To write essays

• To create art designs

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

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

• A row is always wider than a column in a spreadsheet

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

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

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

• Double-click on the row number or column letter

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

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

• Press the 'Delete' key on the keyboard

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

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

• Only line charts and pie charts

• Bar charts and scatter plots

• Column charts and area charts

How do you apply filters to data in Microsoft Excel?

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

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

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

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

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

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

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

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

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

How can you create a chart in Microsoft Excel?

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

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

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

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