NEW
Font size
WorksheetsGoogle Sheet Chapter 3
Total questions: 12
Worksheet time: 9mins
What is the formula to calculate the sum total from cell B2 to F2?
=SUM(B2:F2)
=AVERAGE(B2:F2)
=MAX(B2:F2)
=MIN(B2:F2)
What is the term for multiplying a factor to each score in a weighted sum total?
Absolute cell referencing
Relative cell referencing
Weighted average
Plain format
What is the term for referencing a fixed cell in a formula?
Absolute cell referencing
Relative cell referencing
In a spreadsheet formula, what does the cell reference $B$2 indicate?
Absolute reference to column B and row 2
Circular reference to column B and row 2
Mixed reference to column B and row 2
Press Ctrl+AltRelative reference to column B and row 2
In a spreadsheet, if cell A1 contains the formula "=B2+C3", what are the relative cell references in the formula when copied to cell D4?
=B2 + C3
=E5+F6
=C3+D4
=D3+E4
What is one of the purpose of using 'paste special' in spreadsheet?
To copy only the values of a cell without copying the formula
To copy and paste a cell with its referencing only
What is the purpose of data validation in spreadsheet?
To check if the entered data is within a specified range
To check if the entered data is a formula
To check if the entered data is a text
To check if the entered data is a date
What is the difference between relative cell referencing and absolute cell referencing?
Relative cell referencing is used for formulas, while absolute cell referencing is used for values
Relative cell referencing remains the same when copied, while absolute cell referencing changes the cell reference
Relative cell referencing changes the cell reference when copied, while absolute cell referencing remains the same
Relative cell referencing is used for values, while absolute cell referencing is used for formulas
How can you add data from another sheet in Excel?
By using cell referencing to refer to the cells in the other sheet
By using the 'paste special' feature to copy and paste the data
By using the 'data validation' feature to validate the data
By using the 'format' feature to format the data
In a spreadsheet, if cell A1 contains the formula "=B2+C$3", what are the relative and absolute cell references in the formula when copied to cell E5?
Relative reference: C3, Absolute reference: D4
Relative reference: C2, Absolute reference: D$3
Relative reference: B3, Absolute reference: C4
Relative reference: B2, Absolute reference: C$3
What is the result of the formula "=A2 * $B$3" when copied from cell C3 to cell C5?
=A2 * $B$3
=A5 * $B$3
=A4 * $B$3
=A4 * $B$5
What is the result of the formula "=SUM($A$1:$C$5)" when copied cell D8 to cell F10?
The formula changes to "=SUM($D$4:$F$8)"
The formula changes to "=SUM($C$3:$E$7)"
The formula changes to "=SUM($B$2:$D$6)"
The formula remains the same: "=SUM($A$1:$C$5)"
