p7 Y10 Homework - BTEC DIT quiz on Component 2 Lesson 15-17

What section of the Excel menu contains the Outline tools?

• Home
• Formulas
• Data
• View

What section of the Excel menu contains the Filter tools?

• Home
• Insert
• Formulas
• View

What is the purpose of the text to columns feature?

• To convert rows into columns.
• To split data up automatically.
• All of the above.
• None of the above.

What two options are there for splitting up data using text to columns?

• Delimited
• Delineated
• Full Width
• Fixed Width

What type of cell reference updates when you copy a formula to a new cell?

• Absolute
• Relative
• All of the above.
• None of the above.

What is the correct cell reference for cell B2 on the worksheet “Dashboard”?

• =Dashboard$B2
• =$Dashboard$B2
• =Dashboard!B2
• =!Dashboard!B2

True or False: when linking between worksheets to a named cell, you don’t need to name the worksheet.

• True
• False

Where would you find the option to add a comment to a cell?

• In the View tab of the menu.
• In the Data tab of the menu.
• By right-clicking on the cell.
• By right-clicking on the formula bar.

Which of the following statements about cell comments are true? Choose two options.

• Cell comments are a name we give a cell.
• Cell comments are a short message we add to cells.
• They only show when you hover over a cell containing a comment.
• They shouldn't appear in your final spreadsheet.

In what tab of the menu would you find the conditional formatting options?

• Home
• Insert
• Data
• Review