Bitm 215 exam prep - Study guides, Class notes & Summaries

What is Grouping? - Selecting two or more worksheets so you can perform the same action at the same time. T/F: You must ungroup the worksheets if you want to perform a task only on one worksheet. - TRUE Data Entry - Entering labels, values, dates, and formulas Structural Changes - Inserting and deleting rows and widening columns. Formatting - Changing fonts, alignment, and number formats. Page Layouts - Inserting headers and changing page orientation.

consolidated worksheet - combines data from multiple worksheets using a mathematical or statistical function A static data consolidation - places a non-changing result in the consolidation sheet. If the source data is edited, the consolidated sheet is not updated. The Consolidate button is located - on the Data tab in the Data Tools group. A dynamic data consolidation places - formulas in the consolidation worksheet. If the source data is edited, the consolidated sheet is automatically upd...

In a calculation, the difference between actual values and predicted values is called: - Forecast Error Which type of function would you use to format a value as a label? - Text In a financial function, nper stands for - number of payments Like many financial functions, the PV function uses the concept of a(n) - Annuity

T/F: If you change the order of your worksheets after entering a 3-D formula, your formula will be automatically altered. - FALSE What would you use a web query for in Excel? - To import sports scores into a spreadsheet. What is Metadata? - Pieces of data that describe other data. What is a Document Property? - An attribute that describes a file: - author's name, title, subject, company, creation date, revision date, keywords