Reference no: EM131445817
Excel Basic Assignment Eassy
Create a workbook that includes the components learned throughout your Excel 2016 Essential Training, and this semester.; the data should be your own data. Create as many worksheets, IN THE SAME WORKBOOK, that you need to in order to complete the tasks below. You will submit ONE file with several worksheets.
Your workbook should include the following components:
1. Use Autofill
2. Enter a Comment
3. Use the following formulas (Sum, Average, Min, and Max)
4. Calculate Year To Date Totals
5. Calculate Percentage Increase
6. Use Absolute Value
7. Use the IF Function
8. Use the COUNTIF Function
9. Use the SUMIF Function
10. Use the AVGIF Function
11. Make sure to FORMAT your worksheets (bold, italic, etc.)
12. Merge and Center
13. Include a border
14. Format numbers as needed (currency, date, etc.)
15. Insert a table
16. Insert a shape
17. Rename worksheets
18. Sort data with three levels
19. Set a print area
20. Create a chart
21. Protect cells in a worksheet
22. Use Goal Seek
Your worksheet should be a high-level advanced spreadsheet. The data does not have to be "real" data, but it must make sense.
Attachment:- raw_excel_data.xlsx
|
Statement of stockholders equity
: Electronics World Inc. paid out $29.8 million in total common dividends and reported $194.7 million of retained earnings at year-end. The prior year's retained earnings were $151.9 million. What was the net income? Assume that all dividends declared ..
|
|
Description of the leadership style you observed
: A description of the leadership style you observed. Explain how the leader creates safety establishes the norms of the group including confidentiality, and engages members
|
|
Upper management after visiting outlets
: What type of report do the regional managers most frequently write to upper management after visiting outlets and what report format do they most likely adopt?
|
|
Create an outline of your assignment
: Create an outline of your assignment. Each section of the rubric should be a section of your final paper and could become the headings. Your assignment will be graded based on each element of the rubric.
|
|
Create a workbook that includes the components learned
: Create a workbook that includes the components learned throughout your Excel 2016 Essential Training, and this semester.; the data should be your own data.
|
|
Human resources management and the organization president
: You've just taken a new job in human resources management and the organization's president gave you this high priority task: Give us a plan that can make performance reviews motivating to the recipients and their bosses alike.
|
|
What innate tendency should be released in patrick
: In order for Patrick to experience personal growth, which three characteristics or elements will be essential in the therapeutic environment? What innate tendency should be released in Patrick or anyone else in this environment
|
|
Explore how video games are being used by medical community
: For this writing assignment, you will explore how video games are being used by the medical community. Video games (both online and apps) are a source of entertainment for individuals and groups of people.
|
|
Create a business impact analysis on sangrafix a video game
: Create a business impact analysis on SanGrafix a video game design company. The BIA should include a descriptive list of the organization's key business areas. The BIA helps to identify and prioritize critical IT systems and components. A template..
|