Fill, copy, and when a cell reference should stay put

Question 1 of 7

1. The fill handle is:

   The small square at the corner of the selected cell that you can drag to copy into adjacent cells A type of chart The File tab The button that prints the worksheet
2. If the fill handle is hidden in Windows desktop Excel, Microsoft says to:

   Close Excel and reopen it without changing Options Open File > Options > Advanced and enable the fill handle and cell drag-and-drop Delete the workbook and start over Click Data > Filter
3. Home > Fill > Down is used after you:

   Hide column A Close the workbook Select the formula cell and the adjacent cells you want to fill Create a PDF
4. Copying `=A2+B2` from C2 down to C3 usually gives:

   `=A2+B2` unchanged `=SUM(A2:B2)` `=A1+B1` `=A3+B3`
5. An absolute reference to H1 is written:

   `H1:H1:H1` H1% `$H$1` `#H1`
6. You lock a rate cell so that:

   Dates become text Every copied formula keeps pointing at that same cell Excel deletes other sheets The file cannot be saved
7. A sample extra-rate column in this course is:

   Practice math only, not tax or bookkeeping help Official CRA tax advice Your real payroll A MOS exam requirement