Google Sheet Chapter 3

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

3. 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?

• 3. =B2 + C3

• 3. =E5+F6

• 3. =C3+D4

• 3. =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