excel module 2 formulas functions and formatting
book: Shelley Cashman 9781337251655 – Loose leaf 9781305871809 -Paperback
Discovering Computers and Microsoft Office 365 Office 2016
Please read Module 2 of Excel. (Pages EX57 to EX112) or (pages 795 to 850)
Follow the “Oliviaâ€™s Art Supplies” tutorial throughout the chapter. It is important to understand this before starting the exercise to be submitted.
Use the presentation “MS Excel – Module 02” that is in Lectures to reinforce the knowledge.
Complete and submit the following:
a) Complete the Chapter Exercise “Oliviaâ€™s Art Supplies Worksheet” similar to the figure 2-1
Follow the instructions throughout the chapter (Page Ex58 to Ex105) or (Page 796 to 848)
Submit the Assignment with the Name 5-ExM2-Ex1-YourName
b) In Lab #1: Insurance Premium Worksheet on page EX 109 (or 846)
Submit the Assignment with the Name 5-ExM2-Ex2-YourName
Data Files can be found in the Course Documents section.
Be sure to complete the document properties.
– Use of formulas (EX 65) or (Page 803)
– Functions MAX, MIN and AVERAGE (EX 72) or (Page 810)
– Use of conditional Formatting (EX 88) or (Page 826)