WorksheetsMicrosoft Excel Quiz
Total questions: 18
Worksheet time: 9mins
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
What is the purpose of using conditional formatting in Microsoft Excel?
The purpose of using conditional formatting in Microsoft Excel is to change the font style
The purpose of using conditional formatting in Microsoft Excel is to apply formatting to cells based on certain conditions or criteria
The purpose of using conditional formatting in Microsoft Excel is to create new worksheets
The purpose of using conditional formatting in Microsoft Excel is to delete rows and columns
How do you merge cells in Microsoft Excel?
To merge cells in Microsoft Excel, right-click on the cells and select 'Merge'
To merge cells in Microsoft Excel, go to the 'Home' tab and click on the 'Merge & Center' button
To merge cells in Microsoft Excel, use the 'Insert' tab and select 'Merge Cells' from the dropdown menu
To merge cells in Microsoft Excel, press the 'Delete' key on the keyboard
What is the purpose of using VLOOKUP function in Microsoft Excel?
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.
The purpose of using VLOOKUP function in Microsoft Excel is to change the font style
The purpose of using VLOOKUP function in Microsoft Excel is to create new worksheets
The purpose of using VLOOKUP function in Microsoft Excel is to delete rows and columns
How can you protect a worksheet in Microsoft Excel?
You can protect a worksheet in Microsoft Excel by clapping your hands
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.
You can protect a worksheet in Microsoft Excel by shaking your computer
You can protect a worksheet in Microsoft Excel by singing a song
What is the function of the 'PivotTable' feature in Microsoft Excel?
The 'PivotTable' feature in Microsoft Excel allows users to create a new worksheet
The 'PivotTable' feature in Microsoft Excel allows users to delete rows and columns
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.
The 'PivotTable' feature in Microsoft Excel allows users to change the color scheme of the worksheet
What is the purpose of using absolute cell reference in Microsoft Excel?
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.
The purpose of using absolute cell reference in Microsoft Excel is to change the font style
The purpose of using absolute cell reference in Microsoft Excel is to create new worksheets
The purpose of using absolute cell reference in Microsoft Excel is to delete rows and columns
How can you use the 'IF' function in Microsoft Excel?
You can use the 'IF' function in Microsoft Excel to perform conditional logic and return different values based on specified conditions.
You can use the 'IF' function in Microsoft Excel to change the font style
You can use the 'IF' function in Microsoft Excel to create new worksheets
You can use the 'IF' function in Microsoft Excel to delete rows and columns
What is the purpose of using the 'SUM' function in Microsoft Excel?
The purpose of using the 'SUM' function in Microsoft Excel is to add up values in a range of cells.
The purpose of using the 'SUM' function in Microsoft Excel is to change the font style
The purpose of using the 'SUM' function in Microsoft Excel is to create new worksheets
The purpose of using the 'SUM' function in Microsoft Excel is to delete rows and columns
