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

Briefly explain the shutter speed, Question 1 Write a note on transition, ...

Question 1 Write a note on transition, transition types & Features Question 2 Describe the different types of lens used in film shooting Question 3 Briefly explain

Synchronizing Threads in python, The threading module offered with Python i...

The threading module offered with Python includes a simple-to-implement locking mechanism that will permit you to synchronize threads. A new lock is formed by calling the Lock() me

Computer, what is the computer science

what is the computer science

HACKER, Briefly explain who a hacker is and what the activities of a hacker...

Briefly explain who a hacker is and what the activities of a hacker are?k question #Minimum 100 words accepted#

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

Pseudocode, Design a program that will read a file of sales records and pro...

Design a program that will read a file of sales records and produce a sales report. Each record in the file contains a customer’s ID, name, a sales amount, and a validated GST code

Analyze the complexity of dijkstra''s algorithm, QUESTION (a) Given the...

QUESTION (a) Given the graph as shown in figure, apply Lagrangian technique to complete the table assuming μ=1 and T=14                        Path P

Which port does FTP uses, Why is it called out of band protocol? A1) FTP us...

Why is it called out of band protocol? A1) FTP uses port 20 and port 21; port 20 is used for data connection, whereas port 21 is used for control connection. FTP is known as out-of

What is Assembler Programming?, To build assembler programs with TASM prog...

To build assembler programs with TASM programs is a different program structure than from using debug program. It''s important to comprise the subsequent assembler commands: ..CODE

What is packet switching? explain, Question 1 What are the five subscriber...

Question 1 What are the five subscriber-related signaling functions performed by the operator? Question 2 Compare Microprogrammed control and Hard-wired control Que

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