EXCEL Final Exam
Subtotal - answer-A row within the dataset containing at least one aggregated value when the category you specified in the "At a change in" option in the Subtotal dialog box changes. Outline - answer-A hierarchical structure of data. Grouping - answer-A process of joining rows or columns of related data together. Data Mining - answer-A process of analyzing large volumes of data, using advanced statistical techniques, and identifying trends and patterns in the data. Pivot Table - answer-A powerful, interactive data-mining feature that enables you to summarize and analyze data, especially helpful when working with large datasets. PivotTable Fields task pane - answer-A window that enables you to drag fields to particular areas to build and arrange data in a PivotTable Slicer - answer-A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly. Slicer Caption - answer-Text that displays in the header at the top of the slicer window. PivotChart - answer-An interactive graphical representation of the data in a PivotTable. What-If Analysis - answer-The process of changing variables to observe how changes affect calculated results. Variable - answer-A value that you can change to see how it affects the other values. One-variable data table - answer-A data analysis tool that provides various results based on changing one variable. Substitution Value - answer-Replaces the original value of a variable data table. Two-variable data table - answer-A data analysis tool that provides results based on changing two variables. Goal Seek - answer-A tool that identifies the necessary input value to obtain a desired goal. Scenario Manager - answer-Enables you to define and manage scenarios to compare how they affect results. Solver - answer-An add-in application that manipulates variables based on constraints to find the optimal solution to a problem. Constraints - answer-Limitations that impose restrictions on Solver. AND function - answer-Returns TRUE when all arguments are true and False when at least one argument is false. MATCH function - answer-Identifies a searched item's position in a list. INDEX function - answer-Returns a value or reference to a value within a range. Loan amortization table - answer-A schedule showing monthly payments, interest per payment, principal amount toward paying off the loan, and the remaining balance for each payment. IPMT function - answer-Calculates periodic interest for a fixed-term, fixed-rate loan or investment. PPMT function - answer-Calculates the principal payment for a specified payment period given a fixed interest rate, term, and periodic payments. CUMIPMT function - answer-Calculates cumulative interest for specified payment periods. CUMPRINC - answer-Calculates cumulative principal for specified payment periods. SUMIF function - answer-Calculates the total of a range of values when a specified condition is met. AVERAGEIF function - answer-Calculates the average of values in a range when a specified condition is met. COUNTIF function - answer-Counts the number of cells in a range when a specified condition is met. Grouping - answer-The process of selecting two or more worksheets to perform the same action at the same time. Splitting - answer-The process of diving a worksheet window into two or four re-sizable panes. Hyperlink - answer-An electronic marker to another location in a worksheet, workbook, file, Web page, or e-mail. 3-D reference - answer-A pointer to a cell in another worksheet. 3-D formula - answer-A formula or function that refers to the same cell or range in multiple worksheets. Importing - answer-The process of inserting data from one application into another. Web query - answer-A data connection that links an Excel worksheet to a particular data table on a Web page. CONCATENTATE function - answer-A function that joins two or more text strings into one text string. PROPER function - answer-A function that capitalizes the first letter of each word in a text string, including the first letter of prepositions and articles. LOWER function - answer-A function that converts all uppercase letters to lowercase. UPPER function - answer-A function that converts all text to uppercase letters. SUBSTITUTE function - answer-A function that substitutes new text for old text in a text string. Metadata - answer-Pieces of data, such as a keyword, that describes other data, such as the contents of a file. Collaboration - answer-Occurs when multiple people work together to achieve a common goal by u
Document information
- Uploaded on
- June 26, 2024
- Number of pages
- 4
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers