Scribd
Upload
10 views1 page

Computer Applications in Business Analysis

The document outlines tasks related to computer applications in business, including creating a Word document on the benefits of computer networks, designing a company report cover and CV, and preparing a presentation on e-business impact in India. It also includes sales data analysis for four products, requiring calculations of total sales, sales categorization, and Excel functions for data manipulation. Additionally, it involves preparing a payroll sheet for employees, calculating net salaries, and creating a visual dashboard of salary distributions.

Uploaded by

luckyyy000143
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views1 page

Computer Applications in Business Analysis

The document outlines tasks related to computer applications in business, including creating a Word document on the benefits of computer networks, designing a company report cover and CV, and preparing a presentation on e-business impact in India. It also includes sales data analysis for four products, requiring calculations of total sales, sales categorization, and Excel functions for data manipulation. Additionally, it involves preparing a payroll sheet for employees, calculating net salaries, and creating a visual dashboard of salary distributions.

Uploaded by

luckyyy000143
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Computer Application in Business

1. Prepare a two-page Word document that explains “Benefits of Computer Networks in


Business,” inserting at least one table and an image downloaded from the internet.
2. Design a company report cover page and CV using Word art, headers, and footers. Also,
create a formal business letter in Word using mail merge for five customers.
3. Prepare a 5-7-slide presentation on “Impact of E-Business in India” with suitable
animations and transitions. Insert a chart/graph in a presentation.
4. A company sells four products (Laptop, Tablet, Mobile, and Printer). The sales data for
January is given below:
Product Units Sold Unit Price Discount % Category
Laptop 15 50,000 5% Electronics
Tablet 25 25,000 10% Electronics
Mobile 40 15,000 8% Electronics
Printer 10 8,000 5% Accessories
a) Calculate the Total Sales for each product after applying the discount.
(Hint: Units Sold × Unit Price × (1 – Discount %))
b) Use the IF function to display “High Sale” if Total Sales > 5,00,000, otherwise
“Low Sale.”
c) Create a separate table showing Unit Price of products and use VLOOKUP to
fetch the unit price for each product from this table.
d) Find the Maximum, Minimum, and Average sales values using Excel functions.
e) Use Conditional Formatting to highlight products with sales above 4,00,000.
5. Using MS Excel, prepare a payroll sheet for at least 10 employees showing Basic
Salary, HRA, DA, and other Allowances, along with deductions such as PF and Tax.
Calculate the Net Salary for each employee using appropriate formulas. Further, create
a dashboard that visually represents the salary distribution and component-wise
analysis by using at least three different charts (Bar, Line, and Pie).

You might also like