BTEC IT - Component 2 - L4

Which cell referencing allows you to refer to cells relative to the position of the formula?

• A) Absolute cell referencing
• B) Relative cell referencing
• C) Named cell referencing

What is the purpose of named cells?

• A) They make it easier to refer to cell locations in a formula
• B) They make the cell stand out on the worksheet
• C) They allow you to freeze the cell location

What is a macro?

• A) A series of commands designed to automate repetitive tasks
• B) A type of data validation
• C) A type of worksheet view

What is data validation used for?

• A) To ensure that data in a cell meets certain criteria
• B) To format data in a cell
• C) To sort data in a cell

What is the purpose of using multiple worksheets in a workbook?

• A) To keep track of data across different sheets
• B) To create a dashboard of data
• C) To freeze particular parts of the worksheet

What is the purpose of cell comments?

• A) To annotate cells with additional information
• B) To format cells for better visibility
• C) To group cells together

What is the purpose of alternative views in Excel?

• A) To change the background colour of the worksheet
• B) To hide or unhide particular cells
• C) To change the font size of the worksheet

What is conditional formatting used for?

• A) To format cells based on certain criteria
• B) To group cells together
• C) To freeze particular parts of the worksheet

Which of the following is an example of conditional formatting?

• A) Changing the font size of a cell
• B) Adding a border to a cell
• C) Applying a data bar to a cell

What is the purpose of freezing panes in Excel?

• A) To keep certain rows or columns visible while scrolling through the worksheet
• B) To group certain cells together
• C) To sort data in a particular order