Assignment
Part 1
Please respond to the following:
· Based on your experiences with Excel 2007 and/or from reviewing this Part's reading, explain at least three practical uses for Excel 2007 in the workplace, at home and at school.
· Identify one unique or unusual use for Excel 2007 outside of what you have already provided.
Part 2
Please respond to the following:
· Based your experience with Excel 2007 and/or from reviewing this Part's reading, explain when it is appropriate to link Excel documents in other applications and when it is appropriate to embed them instead.
· Identify the challenges in using the link feature in Excel and suggest how to overcome each challenge.
· Identify the challenges in using the embed feature in Excel and suggest how to overcome each challenge.
Part 3
Please respond to the following:
· Based on your experiences with Excel 2007 and/or from reviewing this Part's reading, explain how a good or bad understanding of logic can make the difference in using advanced functions such as the "IF" function.
· Identify and discuss a challenge in using the "IF" function in Excel.
Please respond to the following:
· Based your experiences with Excel 2007 and/or from reviewing this Part's reading, discuss the reasons for using Excel for creating and maintaining data in tables as well as when to use to use other programs such as Word or Access for maintaining data in tables.
· Identify and discuss one unique problem related to maintaining data in tables in other programs besides Excel.
Part 4
Please respond to the following:
· Based the experiences you have gained over the last few Parts with Excel 2007, discuss how the activities will help you with your future career aspirations, including with future classes at Strayer.
· What additional topics would you like to see covered in this class?
Part 5
Please respond to the following:
· Describe your impressions of Peachtree Complete Accounting. Discuss whether it seems to be an easy or hard application to use.
· Conclude how much accounting knowledge you think is needed to use and understand Peachtree Complete Accounting.
Please respond to the following:
· Discuss possible difficulties users could encounter when using the Peachtree navigation bar.
· Suggest how the navigation bar could be improved.
Part 6
Please respond to the following:
Take a look of the Employee & Payroll Navigation Center.
· Peachtree Complete Accounting allows you to assign employees as sales reps or vendor reps. Determine what other assignments should be available for employees in Peachtree Complete Accounting. Explain your rationale.
· Identify and discuss a challenge in maintaining employee records in Peachtree Complete Accounting.
Please respond to the following:
Take a look of the Inventory & Services Navigation Center.
· Identify and discuss a challenge in maintaining items and services in Peachtree Complete Accounting.
· Discuss the various ways that user security addresses the purpose of internal control. Provide specific examples to support your response.
Part 7
Please respond to the following:
· Peachtree Complete Accounting has the ability to generate a variety of financial statements. Select a financial statement for Bellwether Garden Supply and explain the firm's performance per the financial statement you selected.
· For the financial statement that you selected, now review the previous two reporting periods and explain the firm's performance over the three reporting periods (the current period you initially selected and the two prior reporting periods).
Please respond to the following:
· Identify and discuss a challenge in setting up beginning balances in Peachtree Complete.
· Identify a challenge in designing a new chart of account in Peachtree Complete Accounting. How can the challenge be minimized?