TestOut Office Pro – Excel Videos 5.7.1 & 5.7.2 (15)

What is the problem with using a Relative Reference for the tamale price?

• It makes the price too high

• It doesn't allow for easy updates

• It treats the price per tamale as a relative reference

• It locks the price in place

What is the purpose of using a spreadsheet in the tamale business scenario?

• To confuse customers

• To remember the total when a customer orders a large amount

• To increase the price of tamales

• To reduce the number of tamales sold

What does each formula reference in a Relative Reference?

• The cell directly to the right

• The cell directly to the left

• The cell above

• The cell below

What is the purpose of using absolute references in Excel?

• To change the reference number automatically

• To keep the reference number constant

• To update the whole table automatically

• To perform calculations on row headings

What is the main advantage of using both absolute and relative references?

• It saves time and reduces errors

• It makes the table look better

• It allows for more colors in the table

• It increases the number of worksheets

What is the effect of pressing F4 three times on a cell reference?

• It becomes a relative reference

• It becomes an absolute reference

• It becomes a mixed reference

• It moves to a different worksheet

What is the first step in solving the problem of using only absolute references?

• Use mixed references

• Use only relative references

• Delete the formula

• Change the worksheet

What is the result of copying a formula with mixed references up or down?

• The reference changes in both row and column

• The reference stays constant in both row and column

• The reference changes in either row or column

• The reference moves to a different worksheet

What is the main topic of the section titled "5.7.2 Advanced Cell References"?

• Basic cell formatting

• Advanced techniques for referencing cells

• Creating new worksheets

• Deleting cells

How can you find the average value of a cell across multiple sheets in Excel?

• Use the SUM function

• Use the AVERAGE function with a range of sheets

• Use the MAX function

• Use the MIN function