Lackawanna CIS210 2022 February Module 5 Discussion (dq1+dq2) Latest

CIS210 Computerized Spreadsheet

Module 5 Discussion

DQ1 By now, you are finding that Excel has a lot to offer in terms of applications to help boost a business.  From general accounting to inventory to the overall tracking of balances, Excel can be fully integrated into what a business needs.

Taking what you learned so far, what and how do you see Excel working in the business environment you currently work in (or want to work in)?

DQ2 Spreadsheet programs are used in most businesses today. Microsoft Excel, Google Sheets, or Apple Numbers have a lot of similarities.  Using any of the spreadsheet software, you can enter data, link workbooks, apply mathematical formulas, functions, and charts. Spreadsheets have a range of tools and features to save, manage, and analyze data.

What is Excel's what-if analysis tools:

Goal Seek

Scenario Manager

Data Table

PMT function

What are Pivot Tables?

Pivot Tables and What-if analysis have endless possibilities, list 3 of the most important uses of Pivot Tables and what-if analysis for business owners.