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

Advantages of computerized record-keeping, Advantages of Computerized Reco...

Advantages of Computerized Record-keeping Less manpower is required for upkeep.  Recording, storing, and retrieving are all much faster: easier and with little practice

As, access,excel and ms word/

access,excel and ms word/

What is an array? explain, Question 1 . What is an array? Explain Qu...

Question 1 . What is an array? Explain Question 2 . What do you mean by optional arguments? Describe Question 3 . Describe in brief about interfaces Question 4

Cipher program in java, Cryptography, the study of secret writing, has been...

Cryptography, the study of secret writing, has been around for a very long time, from simplistic techniques to sophisticated mathematical techniques. No matter what the form howeve

Determine whether the system is stable or causal, QUESTION (a) For each...

QUESTION (a) For each of the following systems, determine whether the system is (1) stable, (2) causal, (3) linear, (4) time invariant, (5) passive (i) Y[n] = x[-n] (ii)

Write a schema for the operation of ending a game, QUESTION 1 We need ...

QUESTION 1 We need to write Z specifications to record the information about passengers on board an aircraft. Here you are required to produce the specifications using appropr

Hardware, Hardware Hardware includes the cable and a Hub/Switch that...

Hardware Hardware includes the cable and a Hub/Switch that will connect the participating computers together. Printers or any other peripherals connected to one computer can

Operating systems, Consider the state transition diagram of Figure 3.9b. Su...

Consider the state transition diagram of Figure 3.9b. Suppose that it is time for the OS to dispatch a process and that there are processes in both the Ready state and the Ready/Su

IPC in linux, to do a assignment regarding IPC in linux

to do a assignment regarding IPC in linux

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