Essay
Unit 9 Spreadsheets (+Formula course)
- Module
- Unit 9 Spreadsheet
- Institution
- PEARSON (PEARSON)
Spreadsheet assignment in ICT level 2 Extended Certificate description how is used all the formula and calculation and explanation!
[Show more]
Seller
FollowContent preview
Unit 9 Assignment 1Date issued:
Teacher: Rawa Baker
Final deadline:
Students: Yavor Todorov Panov Duration (appro
ID: 19021672 hours
, Introduction
I’m from administrator department where producing spreadsheets for footballing team, to be able handle infor
the club “season-ticket holder”.
I’ll produce the desire spreadsheet document that manager require from me.
The spreadsheet I’d been asked to produce:
Worksheet 1: Ticket-holder details
Worksheet 2 Ticket-holder details
Worksheet 3 Ticket-holder details
Each of this, I should create worksheet contain name, addresses and contain contact details of each ticket applica
Calculation and tools/techniques
We are going to use different tool and technique to improve the productivity and accuracy, to produce the desire spr
fulfil the manager requirement, such as (formatting , function, formulas, IF statement and macros);
Data input
We are going to use data entry to put the data into the ticket friendly! I should also put validation text on ticket whe
registered for any unexpected mistake.
, Before I create the spreadsheet, the manager has asked me to find out how that type of s
is used for real. The purpose of both spreadsheets is so that I can manage the data about
season ticket holders. This is going to help me as I don't need to rely on papers and we ha
electronic version which will be most useful to the manager.
How spreadsheets improve productivity
Spreadsheets improve productivity by allowing the users to use those function that can be
subtracting or searching for specific pieces of data and putting that data where it is neede
How spreadsheets improve accuracy
Spreadsheets improve accuracy by keeping track of the data inputted and allowing the use
complete and easy access to either read it or change/write data
Also the purpose is by creating those two spreadsheet by using costume modelling and sto
which will customize and make work more efficient, by calculating fast and make sure the
enough supplement in this football club. I should considering create spreadsheet table co
names, addresses and contact details of each ticket applicant
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller qvorpanov. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £4.19. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
52510 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now