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

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

Multi-valued attribute dbms, Multi-valued Attribute DBMS Each multi valued ...

Multi-valued Attribute DBMS Each multi valued attribute maps into a separate table. Include also an attribute for the primary key of the entity and relationship type which the attr

statistics, write a 2 page essay operational gaming and monte carlo simula...

write a 2 page essay operational gaming and monte carlo simulation

Base, 123 is not valid in which base value

123 is not valid in which base value

Find shortest path in network, Find shortest path from node 1 to node 10 in...

Find shortest path from node 1 to node 10 in the network shown in figure, also find shortest path from node 3 to node 10. Please write all steps to finding shortest path mechanism

Vdu visual display unit output, VDU (Visual Display Unit) output...

VDU (Visual Display Unit) output Make sure that VDUs are of an appropriate type. They can cause severe eyestrain and tension if you do not check: (a) Colour (

Hill climbing - artificial intelligence , Hill Climbing - artificial intell...

Hill Climbing - artificial intelligence: As we've seen, in some particular problems, searching the search path from primly to goal state is the point of the exercise. In anothe

Write the function pop in c, QUESTION (a) Convert each of the following...

QUESTION (a) Convert each of the following expressions to prefix and postfix. (i) (A+B)*(C+D) (ii) A-B/(C*D^E) (^ denotes exponentiation) (b) The following algorithm c

Define Function of OSI Layers, OSI Layers: Open Systems Interconnection mod...

OSI Layers: Open Systems Interconnection model is a reference model developed by International Organization for Standardization in 1984, as a conceptual structure of principles fo

SQL 2008 Server Management Studio, 4. Provide a list of productid’s, the n...

4. Provide a list of productid’s, the name of the vendor and their credit rating. The results should be ordered by last name and then by credit rating. Write out the SQL that wo

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