Answer:
Ergonomics requirement and work strategies: - we know that ergonomics work strategies include regular movement, software, work organization and good posture. But it also include conformable environment. Such as light, humidity, temperature, noise, space etc. it improve comfort, health, safety, satisfaction, performance.
yes, before entering the data into excel worksheet; it is good practice to do planning. Firstly study the case study in proper manner, and then find the requirements of project. After that create a plan how to arrange, manage and design the data in excel sheet.
Organizational and task requirements: -
- Data entry: - there two to methods for data entry. First one is check and understands the data and type or enters each data by using keyboard. Second one is import the document into excel worksheet.
- Storage: - you store your data in different places. For example in disk drive, any folder in your computer, pen drive, disk, hard disk etc. but maximum time organization want save data as hardcopy or printout. So can also take the printout of the data easily.
- Output: - we can take different type output of data. Send as email, include within test report, add the attachments, include the presentations etc.
- Reporting and presentation requirement: - every company set the formant for each and every spread sheet. It may include header, footer, size, style, detail of company logo, paper size, margin etc.
I take these formats and organizational polices to make well sheet: - insert the company detail, company logo, standard font, main heading, header, footer, paper size, margins, page numbers and also include the organizational charts.
- After entered data always use column auto fit option. So that you easily understand the whole data.
- If you want to add duplicate recode then no reenter the same data, place the mouse on + sign and press and hold the left button of the mouse and also drag the mouse.
- Don’t calculate the data on pen paper or calculator. Just use the functions and you solve any type of calculation in easy way.
- There are lots of optional for designing and formatting. So you make your document in effective and attractive manner.
- You can insert the charts in your documents.
- You can also use the macros. I use this code for making my data attractive.
Sub Macro() //macro name
With Sheets(1)// all opration apply on sheet 1
Cells.Font.Name = "Cambria" // here font name is cambria
Cells.Font.Size = 12// here font size is 12
Cells.Font.Bold = True//here font style is bold
End With
Range("B1:B3").Interior.Color = vbYellow // here I set the yellow colors in some cells
Range("C3:E3").Interior.Color = vbYellow
Range("A4:A8").Interior.Color = vbBlue// here I set the blue color in some cells
Range("B10") = Application.WorksheetFunction.Sum(Range("B4:B8"))//calculate the //sum
Range("C10") = Application.WorksheetFunction.Sum(Range("C4:C8"))
Range("D10") = Application.WorksheetFunction.Sum(Range("D4:D8"))
Range("E4") = Application.WorksheetFunction.Sum(Range("B4:D4"))
Range("E5") = Application.WorksheetFunction.Sum(Range("B5:D5"))
Range("E6") = Application.WorksheetFunction.Sum(Range("B6:D6"))
Range("E7") = Application.WorksheetFunction.Sum(Range("B7:D7"))
Range("E8") = Application.WorksheetFunction.Sum(Range("B8:D8"))
Range("B4:E10").NumberFormat = "$#,##0.00"// add currency formant
- Sum(range)
- Average(range)
- If(condition, value one, value two)
- Count()
- Min(range)
- Max(range)
- Subtotal(103, rang)
- Vlookup()
References: -
- Jelen, B. (2010). Rev Up to Excel 2010. Uniontown, Ohio: Holy Macro! Books.
- Excel 2010. (2011). [Fairport, NY]: Axzo Press.
- Walkenbach, J. (2013). Excel 2010 formulas. Hoboken, N.J.: Wiley.
- Marmel, E. (2010). Master visually Excel 2010. Indianapolis, IN: Wiley.
- Reding, E. and Wermers, L. (2011). Microsoft Excel 2010. Boston: Course Technology/Cengage Learning.
