This essay has been submitted by a student. This is not an example of the work written by professional essay writers.
Uncategorized

Computer and Internet Literacy 

Pssst… we can write an original essay just for you.

Any subject. Any type of essay. We’ll even meet a 3-hour deadline.

GET YOUR PRICE

writers online

 

 

 

 

Computer and Internet Literacy

Students Name

Institutional Affiliation

 

 

For the discussion board, the formulas used for sheet 2 are as follows.

  • Product “=Product(C3,B3)” and “=(D3*E3)” – these formulas are essential as they enabled me to calculate the product of two cells by simply inputting the relevant formula using cell addresses (Walkenbach, 2011). By entering the command “product” and the cell addresses as the values, excel software automatically generates the answer making work more manageable, primarily when one can utilize the AutoFill function.
  • Sum “=Sum(D3:D12)” – the formula enabled me to find the sum of all employees working hours in a day. The function enables the software sum up all values from the cell D3 to D12 due to the use of a full colon to define the range of cells to be included in the calculation (McFedries, 2013). It is worth noting that for specific cells, a comma replaces the full colon.
  • Average/Mean “=Average(C3:C12)” – the formula facilitated the calculation of the mean working hours per individual in a day. Similarly, to the Sum function, the formula for calculating average in my case utilized the range since I used a full colon to separate cell addresses.

 

References

McFedries, P., (2013). Excel 2013 formulas and functions: Microsoft Excel 2010, portable documents: Microsoft Excel 2010. London, England: Que Publishing.

Walkenbach, J., (2011). Excel 2007 formulas. Hoboken, NJ: John Wiley & Sons.

 

 

  Remember! This is just a sample.

Save time and get your custom paper from our expert writers

 Get started in just 3 minutes
 Sit back relax and leave the writing to us
 Sources and citations are provided
 100% Plagiarism free
error: Content is protected !!
×
Hi, my name is Jenn 👋

In case you can’t find a sample example, our professional writers are ready to help you with writing your own paper. All you need to do is fill out a short form and submit an order

Check Out the Form
Need Help?
Dont be shy to ask