Excel recap Y10

What methods can you use to create a workbook in Excel?

• Click on the 'File' tab and select 'New'.

• Open Excel and select 'Blank Workbook'.

• Press 'Ctrl + N' on your keyboard.

• All of the above.

What does a cell in Excel represent?

• The intersection of a column and a row.

• A single column.

• A single row.

• A range of cells.

How can you describe every single cell in Excel?

• By its row number only.

• By its column letter and row number.

• By giving it a unique name.

• By its column letter only.

What is a range in Excel?

• A collection of cells grouped together.

• A collection of columns.

• The total number of cells in a workbook.

• A single cell.

How do you enter data into a cell in Excel? (select all that apply)

• Double-click the cell and enter the value

• Select the cell and enter the value

• Right-click the cell and choose 'Edit'

What is the purpose of the 'Auto Fill' feature in Excel?

• To automatically format cells.

• To extend a series of data or a pattern.

• To fill cells with a single color.

• To automatically correct spelling errors.

How do you start a formula in Excel?

• With an @ symbol.

• With an = sign.

• With the word 'Formula'.

• With a + sign.

What symbol is used for multiplication in Excel formulas?

• *

• /

• +

• -

What is the difference between 'Relative' and 'Absolute' cell references in Excel?

• Relative references are used for formulas; Absolute references are used for functions.

• Absolute references can only refer to cells in the same worksheet; Relative references can refer to cells in any worksheet.

• There is no difference.

• Relative references change when a formula is copied; Absolute references do not.

How can you adjust the print area in Excel? (select two)

• By selecting the range and pressing 'Ctrl + P'.

• By going to Page Layout > Print Area > Set Print Area.

• By dragging the page break lines in Page Break Preview.