MS Excel Quiz Questions and Answers

Question 11

What is the purpose of the function UPPER() in Excel?

• Converts text to uppercase

• Counts the number of uppercase letters in a cell

• Rounds a number to the nearest integer

• Multiplies a range of cells

Question 12

In Excel, what does the term "data validation" refer to?

• Checking for errors in formulas

• Ensuring data accuracy through validation rules

• Protecting data from unauthorized access

• Sorting data in ascending order

Question 13

How can you create a drop-down list in Excel?

• Using the AutoFill feature

• Applying conditional formatting

• Using the Data Validation feature

• Applying a filter to a column

Question 14

What is the purpose of the TRANSPOSE function in Excel?

• Changes the case of text in a range

• Swaps the rows and columns of a range

• Converts a number to text

• Rounds a number to the nearest integer

Question 15

How can you find and replace data in Excel?

• Ctrl + F

• Ctrl + H

• Ctrl + R

• All of the above

Question 16

How can you create a hyperlink in Excel?

• Right-click and choose "Insert Hyperlink"

• Use the "Hyperlink" option in the Insert tab

• Type the URL directly in a cell

• All of the above

Question 17

How can you group worksheets in Excel?

• Select multiple sheets, right-click, and choose "Group Sheets"

• Use the "Group" option in the Home tab

• Drag and drop sheet tabs into a new group

• All of the above

Question 18

In Excel, what does the term "Data Series" refer to in a chart?

• The title of the chart

• The labels on the x-axis

• The numeric values plotted on the chart

• The legend of the chart
  

Question 19

What is the purpose of the N function in Excel?

• Rounds a number to the nearest integer

• Converts a value to a number

• Finds the nth largest value in a range

• Counts the number of cells that contain numbers

Question 20

How can you protect a worksheet in Excel from being edited?

• Apply a password to the sheet

• Use the "Protect Worksheet" option in the Review tab

• Lock individual cells

• All of the above