MS Excel Quiz

What is relative referencing in MS Excel?

• Referring to a fixed cell

• Referring to a cell in a different workbook

• Referring to a cell relative to the current cell

• Referring to a cell in a different sheet

Which data type in Excel is used for alphanumeric characters?

• Number

• Date and Time

• Text (String)

• Boolean

How can you change the font size in Excel?

• Use the alignment buttons

• Use the Borders dropdown menu

• Use the Font Color icon

• Use the Font Size dropdown menu

What does the SUM() function do in Excel?

• Finds the maximum value in a range of cells

• Calculates the sum of a range of cells

• Counts the number of cells with data

• Finds the average of a range of cells

What does the Format Painter tool in Excel do?

• Apply borders around cells

• Change the font color

• Copy formatting from one cell to another

• Merge cells

Which data type in Excel represents logical values?

• Number

• Error

• Text (String)

• Boolean

How can you align text to the right in Excel?

• Use the Borders dropdown menu

• Use the Font Size dropdown menu

• Click on the 'Alignment' options

• Use the alignment buttons

What does the CONCATENATE function do in Excel?

• Counts the number of cells with data

• Joins text from multiple cells into one cell

• Sums a range of cells

• Finds the average of a range of cells

Which data type in Excel allows users to select a value from a predefined list of options?

• Rich Text

• Image

• Dropdown List

• Currency

What does the Data Validation feature in Excel allow you to do?

• Copy formatting from one cell to another

• Set criteria for what data is allowed in cells

• Apply borders around cells

• Change the font color