If we type  $H$12 in Excel we are using  :Group of answer choicesRelative referencingRelative row and absolute column referencingAbsolute row and relative column referencingAbsolute referencing

The Excel function HLOOKUP looks up a value in the top row of a table and returns a value in the same column from a row you specify. Group of answer choicesTrueFalse

To paste a formula to calculate the minimum of a column, we will use :Group of answer choicesAbsolute row and relative column referencingAbsolute referencingRelative referencingRelative row and absolute column referencing

Absolute referencingAbsolute referencing is marked by a dollar sign ($). For example, =$A$10 has absolute referencing for both the column and the row valueRelative references (which is what you normally do e.g. “=A10”) will change anytime the formula is copied and pasted. They are in relation to where the referenced cell is located. For example if you copied “=A10” to the cell to the right it would become “=B10”. With absolute referencing “=$A$10” copied to the cell to the right would remain “=$A$10”. But if you copied $A10 to the cell below, it would change to $A11 because the row value isn't an absolute reference.Absolute references will not change when you copy and paste the formula in a different cell. The cell being referenced is always the same.To easily switch between absolute and relative referencing in the formula bar, highlight the reference you want to change and press the F4 key; for example, if you want to change the absolute reference, $A$10, in your formula to a relative reference, A10, highli

The intersection of a column and a row in a worksheet is called____Group of answer choicesCellValueAddressColumn

Which dialog box can be used to find a specific cell reference?Group of answer choicesFormat CellsGo ToExcel OptionsFind & Replace