Excel Exam with Certified Answers

Document Content and Description Below

Excel Exam with Certified Answers spreadsheet ✔✔an electronic file that contains a grid of columns and rows containing related data worksheet ✔✔s spreadsheet that contains formulas, functio... ns, 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 of its arguements vlookup function ✔✔looks up a value in a vertical lookup table and returns a related result from the lookup table table array ✔✔a range containing a lookup value pmt function ✔✔calculates the periodic payment for a loan with a fixed interest rate and fixed term rate ✔✔the periodic interest rate, such as a monthly interest rate nper ✔✔the number of total payment periods pv ✔✔the present value of the loan range name ✔✔a word or string of characters that represents one or more cells column chart ✔✔displays data comparisons vertically in columns chart area ✔✔contains the entire chart and all of its elements plot area ✔✔contains a graphical representation of values in a data series value axis ✔✔displays incremental values to identify the values of the data series legend ✔✔a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart stacked column chart ✔✔places stacks of data in segments on top of each other in on column, with each category in the data series represented by a different color bar chart ✔✔compares values across categories using horizontal bars line chart ✔✔uses a line to connect data points in order to show trends over a period of time sparkline ✔✔a miniature chart contained in a single cell chart title ✔✔a label that describes the chart axis title ✔✔a label that describes either the category axis or the value axis data label ✔✔the value or name of a data point trendline ✔✔a line used to depict trends and forecast future data gridline ✔✔a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area freezing ✔✔keeps rows and or columns visible as you scroll through a worksheet page break ✔✔indicates where data starts on a new printed page print area ✔✔defines the range of data to print field ✔✔indvidual piece of data such a last name record ✔✔a complete set of data for an entity table ✔✔an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis sorting ✔✔arranges records in a table by the value in a field(s) within a table filtering ✔✔the process of displaying only records that meet specific conditions structured reference ✔✔a tag or use of a table element as a reference in a formula total row ✔✔appears as the last row of a table to display summary statistics, such as a sum conditonal formatting ✔✔highlights or emphasizes cells that meet certain conditons data bar ✔✔a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells [Show More]

Last updated: 1 year ago

Preview 1 out of 8 pages