• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Exam (elaborations)

EXCEL Final Exam

Document preview thumbnail
Preview 1 out of 4 pages

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
$8.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
TOPDOCTOR
5.0
(1)
Sold
10
Followers
5
Items
3387
Last sold
1 year ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.