Bis155 Final Exam Study Guide
BIS155 Final Exam Study Guide
The Final Exam has a total of five essay questions. The focus of the exam is to evaluate your ability to select and apply appropriate tools/concepts based on descriptions of common business situations.
Topic Question Type Number of Questions Points Possible
TCO 1 through 9: Excel Essay 4 160
TCO 10: Database Concepts Essay 1 40
TOTAL 5 200 POINTS
TCO 1 – 2: Spreadsheet Development
1. Basic steps/tasks involved in spreadsheet development.
2. Appropriate cell references required in various situations (relative, mixed, or absolute).
3. Appropriate formatting for titles, column headings.
4. When to use ranges and how to meaningfully name cell ranges.
5. Simple formula creation using constants and/or cell references
6. When and how to use the functions covered in this class, including but not limited to PMT, VLOOKUP, HLOOKUP, MIN, MAX, SUM, IF, COUNT, COUNTIF, AVERAGE, and MEAN.
7. How to add comments to a worksheet.
8. Various options for print documentation of spreadsheet values and formulas, including page headers and footers.
TCO 3, 4, and 9: Data Manipulation and Analysis
1. Types of files that can be imported to Excel, and the import operation.
2. Tools available to “clean” data and prepare it for analysis; how and when to use each.
3. How to effectively plan and set up a spreadsheet “list” to store company records, and to facilitate efficient data entry and retrieval.
4. Select and apply appropriate sorts and filters based on a business information need.
5. Application of conditional formatting to highlight based on criteria.
6. Analysis of data via use of group subtotals, various “What-If” tools, and pivot tables/charts.
7. Use of appropriate charts (refer to Chapter 3) for communication of findings, and how to format for readability.
TCO 5 -6: Data Consolidation and Decision Making
1. Under what conditions and how to accomplish consolidation of similar data for summary information.
2. Creation
The Final Exam has a total of five essay questions. The focus of the exam is to evaluate your ability to select and apply appropriate tools/concepts based on descriptions of common business situations.
Topic Question Type Number of Questions Points Possible
TCO 1 through 9: Excel Essay 4 160
TCO 10: Database Concepts Essay 1 40
TOTAL 5 200 POINTS
TCO 1 – 2: Spreadsheet Development
1. Basic steps/tasks involved in spreadsheet development.
2. Appropriate cell references required in various situations (relative, mixed, or absolute).
3. Appropriate formatting for titles, column headings.
4. When to use ranges and how to meaningfully name cell ranges.
5. Simple formula creation using constants and/or cell references
6. When and how to use the functions covered in this class, including but not limited to PMT, VLOOKUP, HLOOKUP, MIN, MAX, SUM, IF, COUNT, COUNTIF, AVERAGE, and MEAN.
7. How to add comments to a worksheet.
8. Various options for print documentation of spreadsheet values and formulas, including page headers and footers.
TCO 3, 4, and 9: Data Manipulation and Analysis
1. Types of files that can be imported to Excel, and the import operation.
2. Tools available to “clean” data and prepare it for analysis; how and when to use each.
3. How to effectively plan and set up a spreadsheet “list” to store company records, and to facilitate efficient data entry and retrieval.
4. Select and apply appropriate sorts and filters based on a business information need.
5. Application of conditional formatting to highlight based on criteria.
6. Analysis of data via use of group subtotals, various “What-If” tools, and pivot tables/charts.
7. Use of appropriate charts (refer to Chapter 3) for communication of findings, and how to format for readability.
TCO 5 -6: Data Consolidation and Decision Making
1. Under what conditions and how to accomplish consolidation of similar data for summary information.
2. Creation