Excel Chapter 2: End-of-Chapter Quiz with Verified Answers

Document Content and Description Below

Excel Chapter 2: End-of-Chapter Quiz with Verified Answers Function ✔✔A predefined formula that adds all the numbers in a selected range. Statistical functions ✔✔Excel functions, such as AV... ERAGE, that are useful to analyze a group of measurements SUM function ✔✔A predefined formula that adds all the numbers in a selected range. AVERAGE function ✔✔An Excel function that adds a group of values and then divides the result by the number of values in the group MEDIAN function ✔✔An Excel function that finds the middle value that has as many values above it in the group as are below it MIN function ✔✔An Excel function that determines the smallest value in a range MAX function ✔✔An Excel function that determines the largest value in a range MEDIAN function (2)*Possible error ✔✔An Excel feature which, after typing an = (equal sign) and the beginning letter or letters of a function name, displays a list of function names that match the typed letters(s) Logical Functions ✔✔A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false Criteria ✔✔Conditions that you specify in a logical function COUNTIF function ✔✔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 ✔✔Any value or expression that can be evaluated as being true or false IF function ✔✔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 operator ✔✔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 ✔✔A format that changes the appearance of a cell based on a condition Data bar ✔✔A shaded bar that provides a visual cue about the value of a cell relative to other cells NOW function ✔✔The function that retrieves and then displays the date and time from your computer Freeze panes ✔✔The command that enables you to select one or more rows or columns and then lock them into place Excel Table ✔✔A series of rows and columns that contains related data and that is manages independently from other data Sorting ✔✔The process of arranging data in a specific order based on the value in each field Filtering ✔✔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 Print titles ✔✔The Excel command that enables you to specify rows and columns to repeat on each printed page Sheet tabs ✔✔The labels along the lower border of the workbook window that identify each worksheet Summary sheet ✔✔The worksheets that contain the details of the information summarized on a summary sheet Detail sheets ✔✔The worksheets that contain the details of the information summarized on a summary sheet Paste ✔✔The action of playing cell contents that have been copies or moved to the clipboard into another location Flash Fill ✔✔The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output Arguments ✔✔The values that an Excel function uses to perform calculations or operations Paste Area ✔✔The target destination for data that has been cut or copied using the Office Clipboard Volatile ✔✔The term used to describe an Excel function that is subject to change each time the workbook is opened [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages