Computer Literacy Assignment Task, Basic Computer Science

Assignment Help:
Assignment Task:
You are required to develop working solutions in Excel that will manage the annual budget, current month’s inventory, and a list of the current month’s transactions for a company of your choosing. Your solutions should use formulas as well as functions specifically demonstrating use of “sum”, “if”, and “vlookup”. You must also demonstrate appropriate use of filtering, sorting, referencing, and formatting where appropriate.

The solution should demonstrate the following:
Appropriate use of both formulas and functions such as “sum”, “if”, and “vlookup” should be displayed. Absolute, relative, and mixed referencing as well as filtering, sorting, and formatting should also be used where appropriate. Charts and graphs should be used to provide visual representation of the data, where appropriate.
Budget:
Create an annual budget in an Excel spreadsheet for the company that details projected expenses and income for the year. The expenses should include: salaries/staff, rent/lease, telephone/internet, business rates, loans, gas, electricity, water, insurance, and stock items. The projected income, taxes, and profit as well as average, minimum, and maximum expenses for the year should also be displayed using functions and formulas.
(35 marks)
Inventory:
The inventory spreadsheet should display a detailed list of items offered by the company and should monitor the number of items left in stock for the current month. It should also include the “sum” function as well as two other appropriate functions.
(25 marks)
Transactions:
The transactions spreadsheet should provide a detailed display of the current month’s transactions or sales carried out for the company. It should also include the “sum” function as well as two other appropriate functions.

Related Discussions:- Computer Literacy Assignment Task

Enterprise resource planning, ENTERPRISE RESOURCE PLANNING What ...

ENTERPRISE RESOURCE PLANNING What has football got to do with it? asks management guru Michael Hammer in his latest best seller Beyond Reengineering. The answer is almos

Optical mark recognition, Optical Mark Recognition (OMR): OMR is the s...

Optical Mark Recognition (OMR): OMR is the scanning of paper to detect the presence or absence of a mark in a predetermined position. Now days, it is used as an input device f

Q: HOW DO YOU CODE -- WITHOUT USING ARRAYS OR SPLIT FUNCTION, Q: HOW DO YOU...

Q: HOW DO YOU CODE -- WITHOUT USING ARRAYS OR SPLIT FUNCTIONS -- TO SEPARATE COMMA SEPARATE NUMBER VALUES AND THEN SUM TO TOTAL? I.E., USING SUBSTRING AND INDEXOF. I''ve been try

Microprocessor, how does microprocessor interpret with the burglar alarmn

how does microprocessor interpret with the burglar alarmn

E - R diagram, draw the e r diagram for irctc rail ticket reservation onlin...

draw the e r diagram for irctc rail ticket reservation online

Communications programs , Communications Programs : By communications prog...

Communications Programs : By communications programs, we mean those programs which allow a computer to communicate via a transmission cable to another electronic device. Here we d

A brief introduction of python, Python is an interpreted, high-level, inter...

Python is an interpreted, high-level, interactive and object oriented-scripting language. Python was designed to be extremely readable which uses English keywords commonly where as

Components of a computer, COMPONENTS OF A COMPUTER: We use a computing...

COMPONENTS OF A COMPUTER: We use a computing system basically to feed in some data that is processed by the computer and some information is generated as a result.. For this w

Deadlocks, What is methods For handling Deadlocks?

What is methods For handling Deadlocks?

Mainframe architecture, Mainframe Architecture: Till a few decades bac...

Mainframe Architecture: Till a few decades back, all computing was controlled through the central mainframes server. Multiple users could connect to the central host through u

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd