Bis155 Final Exam Study Guide

Topics: Page footer, Renting, Spreadsheet Pages: 4 (1275 words) Published: December 4, 2011
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.

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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Is582 Final Exam Study Guide Research Paper
  • final exam study guide Essay
  • Essay on Final Exam Study Guide
  • final exam study guide Essay
  • Essay about Ibca Spring 2013 Final Exam Study Guide
  • final exam study guide Essay
  • Final Exam Study Guide Essay

Become a StudyMode Member

Sign Up - It's Free