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

Potential risks to information systems, Question 1 Write about Pot...

Question 1 Write about Potential Risks to Information Systems Factors to be addressed for making information systems more secure Question 2 Write about the foll

Microsoft office, Finding someone who doesn''t use some aspect of Microsoft...

Finding someone who doesn''t use some aspect of Microsoft Office on a daily basis is difficult. Whether it is Outlook for email,Word for creating and editing documents,or Excel f

Define stocktaking, QUESTION (i) Define each of the following terms: ...

QUESTION (i) Define each of the following terms: a) Book trade catalogue b) Stocktaking c) Ephemera d) Contracting out e) Special library (ii) Discuss the adv

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

File organization, File Organization There are three types of fi...

File Organization There are three types of file organization used in practice. Let us consider the example of a dictionary. The dictionary contains listing of English wo

Computerised systems, Computerised Systems : You would have realized by no...

Computerised Systems : You would have realized by now that computing systems are most useful for manipulating information. Any organisation and management of information basically

Configuration of a pc, Configuration of a PC: Generally, when you thin...

Configuration of a PC: Generally, when you think of purchasing a Computer, you first try to exactly know what will be the hardware components such as processor, memory etc. of

Wat do u do, can u write my assignment for me

can u write my assignment for me

Need of operating system, Need of operating system: What kind of facil...

Need of operating system: What kind of facilities operating system provides to the users and programs: The operating system provides interfaces for the user (keyboard, m

Components of a digital computer , COMPONENTS OF A DIGITAL COMPUTER: A...

COMPONENTS OF A DIGITAL COMPUTER: A digital computer is an electronic device that receives data, performs arithmetic and logical operations and produces results according to a

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