R060 TA2 Naming, referencing and datatypes in a spreadsheet.Quiz

By default, what are the names of worksheets in a workbook?

• cover, hours, drivers

• sheet1, sheet2, etc.

• Q23, Subtotal

• R1, S5

Why is it useful to rename worksheets with more meaningful names?

• It makes the workbook look colorful.

• It makes referring to worksheets easier.

• It increases the size of the workbook.

• It makes the workbook more secure.

Which of the following is an example of renaming a cell reference?

• sheet1 to sheet2

• cover to hours

• Q23 to Subtotal

• R1 to S5

What is the benefit of renaming a group of cells?

• It makes the workbook load faster.

• It makes it easier to refer to them in a formula.

• It changes the color of the cells.

• It protects the cells from being edited.

Which of the following could be a renamed group of cells?

• sheet1

• cover

• DriverNames

• Subtotal

What is a cell reference in a spreadsheet?

• A. A unique identifier for a cell, such as A3, B78, AS8

• B. A formula used in calculations

• C. A type of data entered into a cell

• D. A function that changes cell values

What is a relative cell reference?

• A. A reference that does not change when copied

• B. A reference that changes when the formula is copied to the next cell down

• C. A reference that points to a specific cell in another worksheet

• D. A reference that only works within the same worksheet

What is an absolute cell reference?

• A. A reference that changes when the formula is copied to the next cell down

• B. A reference that does not change when the formula is copied to the next cell down

• C. A reference that points to a cell in another worksheet

• D. A reference that only works within the same worksheet

Can cells and worksheets be referenced across different worksheets?

• A. No, they can only be referenced within the same worksheet

• B. Yes, they can be referenced across different worksheets

• C. Only cells can be referenced across different worksheets

• D. Only worksheets can be referenced across different worksheets

What is multi-sheet referencing in spreadsheets?

• Displaying data from one worksheet in another worksheet in the same workbook

• Displaying data from one workbook in another workbook

• Displaying data from one cell in another cell in the same worksheet

• Displaying data from one worksheet in another worksheet in a different workbook