Y6 Excel Functions and Features Quiz

What is the purpose of using Auto Fill in Excel?

• To quickly copy formulas or patterns across cells.

• To calculate data automatically.

• To delete unnecessary rows.

• To format the cells automatically.

How do you insert a new row in Excel?

• Go to the 'Insert' tab and select 'New Sheet'.

• Right-click on the row number, select 'Insert'.

• Click on the cell and press Enter.

• Use Auto Fill to add a new row.

How do you apply a border to cells in Excel?

• Click the cell, go to the 'Insert' tab, and select 'Border'.

• Right-click the cell and select 'Format Cells'.

• Select the cells, go to the 'Home' tab, click on 'Borders', and choose a border style.

• Go to the 'View' tab and select 'Borders'.

How can you format headers with bold text and a fill color?

• Select the header, apply bold from the 'Home' tab, and choose a fill color.

• Right-click on the header, select 'Format Cells', and change the alignment.

• Use the 'Insert' tab to apply bold formatting.

• Use Auto Fill to format the header row.

How do you calculate Profit in Excel when given Sales and Expenses?

• Use the formula Sales - Expenses.

• Use the formula =Sales - Expenses.

• Use the formula =Expenses * Sales.

• Use the formula Sales * Expenses.

Why would you rename Sheet1 in Excel?

• To make it easier to identify and organize your data.

• To delete the data in Sheet1.

• To merge multiple sheets.

• To insert a new chart.

What happens when you use the Auto Fill handle to drag down a formula?

• It copies the exact value to all cells.

• It copies the formula and adjusts references based on the new row or column.

• It only copies the text, not the formula.

• It deletes the formula from the first cell.

How do you move a chart to a new sheet in Excel?

• Select the chart, go to the Chart Design tab, and click Move Chart, then select New Sheet.

• Select the chart, go to the Format tab, and click Move Chart, then select Sheet1.

• Go to the File tab and choose 'Move Chart', then select New Sheet.

• Insert a new worksheet and move the chart manually.

Where can you find the Auto Fill handle in Excel?

• In the 'Insert' tab.

• In the bottom-right corner of a selected cell.

• In the 'Home' tab under 'Data'.

• In the right corner border line of a selected cell.

How do you access the Chart Design tab in Excel?

• It appears automatically at the tab bar when you select a chart.

• By going to the 'Insert' tab.

• By right-clicking on a cell.

• By clicking on the 'Home' tab.