Excel Subtraction and Absolute Reference Quiz

What is the first step in setting up a subtraction formula in Excel?

• Type a minus sign in the cell

• Left-click on the cell where the result will be displayed

• Enter the value to be subtracted

• Highlight the entire column

How do you ensure that a specific cell is always referenced in a formula?

• By adding dollar signs before the column letter and row number

• By typing the cell address in lowercase

• By using a relative reference

• By highlighting the cell in a different color

What keyboard shortcut is used to type a dollar sign in Excel?

• Shift + 3

• Ctrl + 4

• Shift + 4

• Alt + 5

What happens when you drag the fill handle in Excel?

• It moves the cell content to another location

• It copies the formula to adjacent cells

• It deletes the content of the cell

• It changes the cell format

What is the purpose of using absolute references in Excel formulas?

• To change the cell color

• To automatically adjust the formula for each cell

• To ensure the formula references a fixed cell

• To make the formula more complex