Microsoft Excel Quiz - AI

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

• Ctrl + S

• Ctrl + C

• Ctrl + P

• Ctrl + A

What is the function of the SUM formula in Excel?

• To subtract a range of numbers or cells.

• To multiply a range of numbers or cells.

• To find the average of a range of numbers or cells.

• To add up a range of numbers or cells.

How can you freeze panes in Excel?

• Press Ctrl + F to open the Find and Replace dialog box, then select the Freeze Panes option.

• Select the row below and the column to the right of the cells you want to freeze. Then, go to the View tab, click on the Freeze Panes option, and select Freeze Panes.

• Go to the Format tab and click on the Freeze Panes option.

• Select the row above and the column to the left of the cells you want to freeze.

What is the purpose of conditional formatting in Excel?

• To calculate formulas in Excel

• To create charts and graphs in Excel

• The purpose of conditional formatting in Excel is to visually highlight or emphasize data based on specific conditions or criteria.

• To sort and filter data in Excel

What is the difference between a relative reference and an absolute reference in Excel?

• A relative reference remains constant, while an absolute reference changes when copied or filled.

• A relative reference is used for formulas, while an absolute reference is used for formatting.

• A relative reference is used for text, while an absolute reference is used for numbers.

• A relative reference changes when copied or filled, while an absolute reference remains constant.

How can you create a chart in Excel?

• Right-click on a cell and select 'Chart' from the context menu.

• Follow the steps mentioned in the explanation.

• Click on the 'Insert' tab and select 'Chart' from the toolbar.

• Press the 'Ctrl + C' shortcut to copy a chart from another Excel file and then paste it into your current file.

What is the purpose of the VLOOKUP function in Excel?

• The purpose of the VLOOKUP function in Excel is to calculate mathematical operations.

• The purpose of the VLOOKUP function in Excel is to format cells and apply styles.

• The purpose of the VLOOKUP function in Excel is to search for a value in a table and return a corresponding value from a different column.

• The purpose of the VLOOKUP function in Excel is to create charts and graphs.

How can you sort data in Excel?

• You can sort data in Excel by using the 'Find and Replace' feature and selecting the 'Sort' option.

• You can sort data in Excel by selecting the range of cells or table, going to the 'Data' tab, clicking on the 'Sort' button, choosing the column to sort by, selecting the sorting order, and clicking 'OK'.

• You can sort data in Excel by using the 'Filter' option under the 'Data' tab and selecting the 'Sort' option.

• You can sort data in Excel by right-clicking on a cell, selecting 'Sort', choosing the column to sort by, selecting the sorting order, and clicking 'OK'.

What is the purpose of the IF function in Excel?

• Format cells based on a logical condition.

• Perform calculations based on a logical condition.

• Create charts based on a logical condition.

• Perform a logical test and return different values based on the result

How can you protect a worksheet in Excel?

• Go to the 'Page Layout' tab, click on 'Print Titles', and select 'Sheet'.

• Go to the 'Home' tab, click on 'Format Cells', and select 'Protection'.

• Go to the 'Review' tab, click on 'Protect Sheet', and set a password

• Go to the 'File' tab, click on 'Protect Workbook', and set a password.