Lackawanna CIS210 Module 7 Assignment Latest 2022 February

CIS210 Computerized Spreadsheet

Module 7 Final Exam   

CIS 210 Final Exam

For your final Exam please complete only ONE of the 2 options below:

Final Exam _ Option 1 ( predesigned spreadsheet templates are NOT accepted)

During the past weeks, you have learned how to design a good excel workbook, how to insert functions & formulas, and how to link worksheets and external workbooks.

Now it is your time to apply what you have learned.

Start with a blank Excel workbook, and create an Excel workbook about any topic ( Do not use a predesigned spreadsheet template). You may like to  review the exercises provided in this course, search the internet and look at the following link for ideas: https://instanteduhelp.com/microsoft-excel-projects-spreadsheet-ideas/ (Links to an external site.)

Your workbook should have at least the following:

At least 5 formulas/ functions, for instance: sum, average, minimum, max, multiply, divide, subtract, or PMT

What if function (any rules)

Conditional formatting (any rules)

One chart/ graph. Be sure to modify the chart title and the legend

Sparklines (any kind)

Tab name and color ( any colors)

Printout ( header with your name)

Use the strategies you have learned to format your workbook, you can use any theme, cell style, or colors. You may like to review this video for more information: