COSC Excel Exam Questions and Answers Latest Update Graded A+

COSC Excel Exam Questions and Answers Latest Update Graded A+ workbook - Answers On startup, Excel displays a new blank: formula bar - Answers An Excel window element that displays the value or formula contained in the active cell is the: name box - Answers An Excel window element that displays the name of the selected cell, table, chart, or object is the: select all box - Answers A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the: active cell - Answers A cell surrounded by a black border and ready to receive data is the: auto fill - Answers The feature that generates and extends values into adjacent cells based on the values of selected cells is: general format - Answers The default format that Excel applies to numbers is the: underlying value - Answers The data that displays in the Formula Bar is referred to as the: absolute - Answers The type of cell reference that refers to cells by their fixed position in a worksheet is: sparklines - Answers Tiny charts embedded in a cell that give a visual trend summary alongside your data are: workbook - Answers An Excel file that contains one or more worksheets spreadsheet - Answers Another name for a worksheet cell - Answers The intersection of a column and a row sheet tabs - Answers The labels along the lower border of the Excel window that identify each worksheet. column - Answers A vertical group of cells in a worksheet. row - Answers A horizontal group of cells in a worksheet. cell content - Answers Anything typed into a cell. constant value - Answers Information such as numbers, text, dates, or times of day that you type into a cell. data - Answers Text or numbers in a cell that are not a formula. formula - Answers An equation that performs mathematical calculations on values in a worksheet. number value - Answers A constant value consisting of only numbers cell address - Answers Another name for a cell reference. value - Answers Another name for a constant value. fill handle - Answers The small black square in the lower right corner of a selected cell. chart - Answers The graphic representation of data in a worksheet. function - Answers A predefined formula that performs calculations by using specific values in a particular order or structure. statistical functions - Answers Excel functions such as AVERAGE that are useful to analyze a group of measurements. sum function - Answers A predefined formula that adds all the numbers in a selected range. average function - Answers A function that adds a group of values, and then divides the result by the number of values in the group. median function - Answers A function that finds the middle value that has as many values above it in the group as are below it. min function - Answers A function that determines the smallest value in a range max function - Answers A function that determines the largest value in a range drag and drop - Answers The action of moving a selection by dragging it to a new location. logical functions - Answers A group of functions that tests for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false. criteria - Answers Conditions that you specify in a logical function countif function - Answers A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria. logical test - Answers Any value or expression that can be evaluated as being true or false. if function - Answers A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false comparison operators - Answers Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria. conditional format - Answers A format that changes the appearance of a cell based on a condition data bar - Answers A shaded bar that provides a visual cue about the value of a cell relative to other cells is a: now function - Answers The function that retrieves and then displays the date and time from your computer is the: freeze panes - Answers The command that enables you to select one or more rows or columns and lock them into place is table - Answers A series of rows and columns with related data that is managed independently from other data is a sorting - Answers The process of arranging data in a specific order based on the value in each field is called: filtering - Answers The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called: printlines - Answers The Excel command that enables you to specify rows and columns to repeat on each printed page is: sheet tabs - Answers The labels along the lower border of the workbook window that identify each worksheet are the: summary sheet - Answers A worksheet where totals from other worksheets are displayed and summarized is a: detail sheets - Answers The worksheets that contain the details of the information summarized on a summary sheet are called: pie chart - Answers A chart that shows the relationship of each part to a whole. general fund - Answers The term used to describe money set aside for the normal operating activities of a government entity such as a city relative cell reference - Answers In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. data marker - Answers A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point chart sheet - Answers A workbook sheet that contains only a chart bevel - Answers A shape effect that uses shading and shadows to make the edges of a shape