Excel Exam | actual questions and answers | updated

Excel Exam | actual questions and answers | updated spreadsheet - an electronic file that contains a grid of columns and rows containing related data worksheet - s spreadsheet that contains formulas, functions, values, texts, and visual aids workbook - a file containing related worksheets input area - a range of cells containing values for vairables used in formulas output - a range of cells containing results based on manipulating the variables name box - identifies the address of the current cell formula bar - displays the content (text, value, date, or formula) in the active cell sheet tab - diplays the name of a worksheet within a work-book cell - the interesection of a column letter and a row number cell address - identifies a cell by a letter and a ro number active cell - the current cell, indicated by a dark border text - includes letters, numbers, symbols, and spaces value - a number that represents a quantity or an account formula - a combination of cell refrences, operators, values, and or functions used to perfom a calculation range - a rectangular group of cells nonadjacent range - contains multiple ranges of cells semi-selection - the process of using the mouse pointer to select cells while building a formula relative cell reference - indicates a cell's relative location from the cell containing the formula, the cell reference changes when the formula is copied absolute cell reference - indicates a cell's specific location; the cell reference does not change when you copy the formula mixed cell reference - contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula circular reference - occurs when a formula directly or indirectly refers to itself syntax - a set of rules that govern the structure and components for properly entering a function arguement - an input, such as a cell reference or value, needed to complete a function function screentip - a small pop-up description that displays the arguements for a function as you enter it counta function - tallies the number of cells in a range that are not empty now function - displays current date and time if function - evaluates a condition and returns one value if the condition is true and a different value if the conditon is false logical test - an expression that evaluates to true or false nested function - a function that contains another function embedded inside one or more