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.
TopicQuestion TypeNumber of QuestionsPoints Possible
TCO 1 through 9: ExcelEssay4160
TCO 10: Database ConceptsEssay140
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 and use...