Microsoft Excel Quiz

You have a list of sales data in column A and their corresponding product names in column B. How can you quickly sort the data based on product names?

• Use the Filter option.

• Use the SUM function.

• Use the Sort function by highlighting both columns A and B.

• Use the VLOOKUP function.

You want to format a cell to display a currency value. What is the appropriate formatting option?

• Text

• Number

• Percentage

• Date

Which formula would you use to calculate the average of a range of cells (e.g., A1:A10)?

• SUM(A1:A10)

• AVERAGE(A1:A10)

• COUNT(A1:A10)

• MIN(A1:A10)

How can you quickly copy a formula down to multiple cells?

• Manually type the formula in each cell.

• Use the Fill Handle (small black square in the bottom right corner of the cell).

• Use the Paste Special option.

• Use the Data Validation tool.

You have a large spreadsheet and want to quickly jump to a specific cell (e.g., cell D25). What is the most efficient way?

• Use the arrow keys to navigate.

• Use the Find function.

• Click on the cell reference box (e.g., A1) and type D25.

What function can be used to count the number of times a specific value appears in a range of cells?

• AVERAGE

• COUNTIF

• VLOOKUP

• SUM

How can you create a chart to visually represent your data?

• Use the Conditional Formatting option.

• Use the Insert Chart option and select the desired chart type.

• Use the Sort function.

• Use the Data Validation tool.

What is the symbol used to indicate an absolute cell reference in a formula?

• * (asterisk)

• $ (dollar sign)

• % (percent sign)

• # (number sign)

You want to add a border around a specific range of cells. How can you achieve this?

• Use the Fill Handle.

• Use the Conditional Formatting option.

• Use the Format Cells option and select the Borders tab.

• Use the Sort function.

What does the function CTRL+Z do in Excel?

• Bold the selected text.

• Undo the last action.

• Redo the last action.

• Copy the selected cell.