Microsoft Excel Quiz

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

• Ctrl + S

• Ctrl + P

• Ctrl + A

• Ctrl + C

How do you freeze panes in Excel?

• Select the cell below and to the right of the rows and columns you want to freeze, then go to the View tab and click on Freeze Panes.

• Press Ctrl + F to open the Find and Replace dialog box, then go to the View tab and click on Freeze Panes.

• Right-click on the cell you want to freeze, then go to the Format tab and click on Freeze Panes.

• Select the cell above and to the left of the rows and columns you want to freeze, then go to the View tab and click on Freeze Panes.

What is the function of the VLOOKUP formula in Excel?

• To create a chart or graph based on data in a worksheet.

• To search for a value in a table and return a corresponding value from another column.

• To format the appearance of a cell or range of cells.

• To calculate the sum of a range of cells.

How do you create a chart in Excel?

• Copy and paste the data into a new chart template.

• Right-click on the data and select 'Create Chart'.

• Go to the 'Format' tab and choose 'Chart' from the dropdown menu.

• Select the data and click on the 'Chart' button in the 'Insert' tab.

What is the purpose of conditional formatting in Excel?

• The purpose of conditional formatting in Excel is to calculate formulas and functions.

• The purpose of conditional formatting in Excel is to create charts and graphs.

• The purpose of conditional formatting in Excel is to apply formatting to cells based on specific conditions or criteria.

• The purpose of conditional formatting in Excel is to sort data in ascending order.

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

• A relative reference changes based on the formula's position, while an absolute reference remains fixed.

• A relative reference changes based on the formula's position, while an absolute reference changes based on the value of the cell.

• A relative reference remains fixed, while an absolute reference changes based on the formula's position.

• A relative reference changes based on the value of the cell, while an absolute reference changes based on the formula's position.

How do you merge cells in Excel?

• Select the cells, go to the 'Format' tab and choose 'Merge Cells'.

• Select the cells, press Ctrl+M.

• Select the cells, go to the 'Insert' tab and choose 'Merge Cells'.

• Select the cells, right-click and choose 'Merge Cells' or click on 'Merge & Center' button in the 'Alignment' group.

What is the purpose of the SUM function in Excel?

• To add up a range of numbers or cells.

• To multiply a range of numbers or cells.

• To divide a range of numbers or cells.

• To subtract a range of numbers or cells.

How do you insert a new worksheet in Excel?

• Click on the 'File' tab and select 'New Worksheet'.

• Press Ctrl+Shift+N.

• Right-click on any existing worksheet tab and select 'Insert' from the context menu. Then, choose 'Worksheet' and click 'OK'.

• Go to the 'Insert' tab and click on 'Worksheet'.

What is the purpose of the IF function in Excel?

• Perform mathematical calculations

• Format cells and text

• Create charts and graphs

• Perform logical tests and return different values based on the result