The assignment will be done in two different paper
1 Excel paper and 1 word document paper
Attached will be three different excel datasets and they are named Product, Employee and Sales data.
Create 1 single excel paper with 5 different sheets. The sheets will be named “Cell Referencing & Formulas”, “Lookup Formula (LOOKUP)”, “Data Integration”, “Excel Charts”, “Pivot Tables & Charts”.
For tasks use an Excel file with Sheets 1 through 5 , You can Import the data sets if required.
Excel tasks:
1. Cell Referencing & Formulas:
Calculate the total salaries of employees who belong to Finance or Operations departments and have salaries above 60,000.
Use the AND function to identify employees from the HR department earning more than 70,000.
2. Lookup Formula (LOOKUP):
Use LOOKUP to find the region with the highest sales for product B in quarter 3 from the sales data.
3. Data Integration:
Merge the product data and sales data. Calculate the total revenue for each product by multiplying sales by prices.
4. Excel Charts:
Create a line chart that shows the sales trend for products C and D across all quarters.
5. Pivot Tables & Charts:
Develop a pivot table to show total sales by product for each region. Then create a corresponding pivot chart.
Write the theories in a separate sheet with sheet name Theory.
Theory Questions:
1. Clarify the distinction between data analysis and data analytics, focusing on their respective processes and outcomes. How does each contribute to decision-making in a retail business?
2. Describe how MS Excel, as a computer application, helps in data visualization, pivot table creation, and reporting. Include examples from project management or accounting.
3. Explain how the Operations department can use MS Excel for inventory management and production scheduling. Additionally, describe how IT professionals may use Excel for tracking system performance metrics.
Thats it. Thank you.
