make sure that Formulae and other information is properly produced in Series by using the Fill Handle

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Excel Document

·   includes at least two Tables (1 mark)

o   on separate sheets presenting different information (1 mark)

o   properly formatted, labeled and titled (2 marks)

o   a non-default Table Style is applied to each (2 marks)

·         includes at least two different types of Charts (2 marks)

o   on separate sheets presenting different information (1 mark)

o   properly formatted, labeled and titled (2 mark)

o   a non-default Chart Style is applied to each (1 mark)

·  use of proper Cell Styles and Borders (3 marks)

·  use of Structured (Named) References where appropriate (2 marks)

·  include at least three different AutoFunctions in your tables (Sum, Average, Min, etc. Using the same function multiple times will consider as one) (3 marks)

·         includes at least three, different, hand-written Formulae of at least intermediate complexity in your tables (5 marks)

o   formulas should display

§  complex calculations using multiple operations and parentheses and/or

§  non-AutoFunction Formulae (If, PMT, FV, Match, CountIf, etc.)

·    make sure that Formulae and other information is properly produced in Series by using the Fill Handle (2 marks)

·         use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables (3 marks)

· use Conditional Formatting at least twice in your Tables (2 marks)

PowerPoint Document

·   include at least 8 well-organized and Spell Checked Slides (not including the Title Slide) (2 mark)

·  include an Agenda slide (1 mark)

 

·         include a slide introducing your organization, yourselves and your positions (by Title ( ex. Vice President of Human Resources) (1 mark)

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme