Btec Business Level 3 Unit 3 P1

MOD

P1
Introduction
I will be listing and I will also be sorting tables , subtotals and totals aswell. The boxes will be listed and I will create a customized cell format. The cell formats will be customized by using styles. The boxes will be listed and drop-down boxes to select data for entry. I will be naming the cells and ranges for use in the formulae. I will be auto-filling for lists of dates or days pf the week. The validation will restrict data input to the acceptable data values. I will be using template to create a standard spreadsheet layout for repeated use. The cells will be protected by hiding and locking the cells. I will sort single and multiple columns of data. I will be using macros which are activated by buttons. I will use the automatic transfer of data between different parts of the spreadsheet and I will also use multiple sheets with links between them. …show more content…
The job requires me to work in the admin department. I am required to work with worksheets. I will also be designing spreadsheets to help the sales employees gather customer orders. My spreadsheet that I am making will contain multiple worksheets to hold items, prices and customer quotations. I will also include surveys sheets and quotations. I will make sure that the spreadsheet is formatted appropriately and that I use the functions and formulas within Excel to solve the complex problems within the MOD business.
I will assist the sales people when quoting the sales customers. The other job that I have to do is that I have to design spreadsheets and also I have to use worksheets. I have to use the functions and formulas in Excel to solve complex problems. The spreadsheet has to be formatted correctly and I have to contain a lot of worksheets to hold the items. The functions and formulas will be useful to MOD because then MOD can work out the complex problems. I will also use Macros to move one sheet to

Show More