WorksheetsMS Excel Quiz
Total questions: 10
Worksheet time: 5mins
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
