Excel Ch 3 Terms 1Online version Match the definition with its correct term. by Kerri Stegman 1 Cell reference with only one dollar sign before either the column or the row a mixed cell reference b absolute cell reference c relative cell reference d assumptions 2 Instructs Excel to adjust the cell reference as it copies it to the destination area a mixed cell reference b absolute cell reference c relative cell reference d fill series 3 Instructs Excel to keep a cell reference constant in the formula as it copies it to the destination area a mixed cell reference b absolute cell reference c relative cell reference d fill formatting only 4 Copies the contents and format of a selected range and places the copy on the clipboard a copy button b copy cells c fill handle d paste button 5 Copies the item from the clipboard to the destination area a fill series b paste button c fill handle d cut command 6 Copies the cells to the Office clipboard, but does not remove the cells from the source area until you paste the cells in the destination area a clipboard b fill formatting only c cut command d drag and drop 7 Fill destination area using format of source area. No content is copied unless fill is series. a fill series b copy cells c paste options button d fill formatting only 8 Fill destination area with contents using format of source area, do not create a series a copy cells b fill formatting only c fill series d assumptions 9 Fill destination area with series using format of source area a fill formatting only b fill series c copy cells d IF function 10 A simple way to create a date stamp and to enter the system date tracked by your computer in a cell in the worksheet a paste button b fill series c NOW function d date stamp 11 Reserved place in the computer’s memory that allows you to collect text and graphics from an Office document and then paste them into almost any other type of document a freeze the titles b assumptions c paste button d clipboard 12 Shows the date a workbook was created or the period it represents a date stamp b range finder c format symbol d IF function 13 Used to copy a cell, range of cells, and create a series a paste button b fill handle c drag and drop d copy cells 14 Used to ensure correctness in your formulas by checking them a date stamp b absolute cell reference c range finder d delete 15 Using the mouse to move or copy cells a drag and drop b freeze the titles c clipboard d cut command 16 Values in cells that can be changed to determine new values for formulas a IF function b assumptions c fill series d mixed cell reference 17 When a number is entered with this, Excel immediately displays it with the assigned format a assumptions b paste options button c format symbol d fill formatting only 18 When used, Excel displays the titles on the screen, no matter how far down or to the right you scroll a date stamp b clipboard c fill series d freeze the titles