Excel Final Exam with Complete Solutions

Absolute cell refernce - ANSWER-a cell reference that does not change when copied or moved to a new cell active cell - ANSWER-the cell in the worksheet in which you can type data active worksheet - ANSWER-the worksheet that displayed in the work area alignment - ANSWER-the position of data within a cell autofit - ANSWER-an automatic determination of the best width for a column or the best height for a row based on its its contents automatic page break - ANSWER-a page break excel inserts when ever it runs out of room on a page border - ANSWER-a line around the edge of the cell cell - ANSWER-the intersection of a column and a row in a table or worksheet cell reference - ANSWER-a unique identifier for a cell, which is formed by combing the cell's columns letter and row number cell style - ANSWER-a collection of formatting characteristics you apply to a cell or range of cells clear - ANSWER-to remove all of the formatting applied to a cell or range of cells column - ANSWER-A vertical stack of cell in a table or worksheet column heading - ANSWER-Identified by a letter copy - ANSWER-To place a copy of selected text on the clipboard or the office clipboard cut - ANSWER-To remove selected text and place it on the clipboard or the the office clipboard Fill - ANSWER-The background color of a cell Fill handle - ANSWER-The black square in the lower right corner of the active cell