Microsoft Excel 2016 Certification Review exam |79 questions with complete solutions

workbook a file which contains one or more spreadsheets spreadsheet an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form cells individual locations on a spreadsheet cell address refers to one specific location; Cell A4 cell range refers to a group of adjacent cells; A4:A16 label classification is used for cells that contain text or for numbers that will not be used in calculations value classification indicates that the data has the potential to be used in calculations (numbers) formula instructs the software to perform a calculation = ALL formulas begin with an equal sign addition + division / multiplication * subtraction - order of operations PEMDAS function shortcut for a formula cell reference indicates a cell's location and provides instructions for how cell data is copied or used in calculations; also known as the cell address relative reference cell value changes as the formula is copied absolute reference cell value remains static when copied to other locations mixed reference combination of an absolute and a relative cell conditions or criteria tell the function how to calculate the results and what data to use. SUM function for example, =Sum(C4:C18) adds the range of cells from C4 through C18 AVERAGE function for example, =Average(C4:C18) determines the average of the range of cells from C4 through C18 MAXIMUM function for example, =Max(C4:C18) finds the highest number in the range of cells from C4 through C18 MINIMUM function for example, =Min(C4:C18) finds the lowest number in the range of cells from C4 through C18 left aligned default formatting for labels right aligned default formatting for values workbook a file which contains one or more spreadsheets spreadsheet (or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form. Cells individual locations on a spreadsheet Cell address refers to one specific location Cell range refers to a group of adjacent cells label classification is used for cells that contain text or for numbers that will not be used in calculations value classification indicates that the data has the potential to be used in calculations formula instructs the software to perform a calculation a. Formulas begin with an equal sign (=). When the equal sign (or in some cases a plus sign (+)) is keyed in a cell, the software "knows" that the data will be used in a calculation Order of Operations Parentheses Exponents Multiplication and division (from left to right) Addition and subtraction (from left to right) Basic Operators Addition Division Multiplication Subtraction basic function shortcut for a formula Cell reference indicates a cell's location and provides instructions for how cell data is copied or used in calculations Relative Reference cell value changes as the formula is copied Absolute Reference cell value remains static when copied to other locations Mixed Reference combination of an absolute and a relative cell Parentheses control the Order of Operations Sum for example, =Sum(C4:C18) adds the range of cells from C4 through C18 Average for example, =Average(C4:C18) determines the average of the range of cells from C4 through C18 Maximum for example, =Max(C4:C18) finds the highest number in the range of cells from C4 through C18 Minimum for example, =Min(C4:C18) finds the lowest number in the range of cells from C4 through C18 cell intersection of a column and row in a spreadsheet active cell the cell in which you are currently working function a mathematical operation that is built into a spreadsheet program to perform shortcut caluculations spreadsheet application software that allows users to use calculations label alphanumeric text not intended or calculations entered into a spreadsheet cell highlight the desired cell to format a cell this must be done first cell address individual cell location on a spreadsheet workbook a file that contains one or more spreadsheets spreadsheet an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information in numerical form label classification used for cells that contain text or numbers that will not be used in calculations value indicates the data has the potential to be used in calculations formula instructs the software to perform a calculation equal sign formulas begin with this cell reference indicates a cell's position and how the cell data will be used or copied in calculations relative cell value changes as the formula is copied absolute cell value remains the same when copied to other locations mixed combination of absolute and mixed parentheses control the order of operations sum adds a range of cells