Angela C10 Assignment 8 Business Consulting

  

Excel Formulae

Microsoft Excel is a spreadsheet program developed by Microsoft. Microsoft Excel is a part of Microsoft Office Suit. Microsoft Excel features calculations, formulae, graphic tools, pivot table, analytics, and macro programming. An entrepreneur can use Microsoft Excel to store data and perform calculations. 

. 

To show the total expenses for each day in Column F, following formula can be used: 

Enter =SUM(B5:E5) in cell F5 and press enter. Then, drag the formula down till F11.

To know total expenses for the week in each category, following forma can be used:

Enter =SUM(B5:B11) in cell B13. Press enter. Then drag the formula rightward till F13.

To make an entry in Column G to remind you of expenses that require receipts for the accountant, following formula to be entered in cell G5:

=IF(F5>=100, “Yes”,””)