Answer:
a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.
b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.
c. In the formula bar type =365 days; +2 : E6
d. In the formula bar type =365 days ; +2 : C6
Explanation:
Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.
Answer:
Cash Sales Transaction
Journal Entry
Dr. Cash 100,000
Cr. Sales 100,000
Cash received and sales has been recorded due to the nature of Cash and Income, Cash and Sales is entered as Debit and credit respectively.
* For Journal posting MS excel file is attached which has T account with above transaction posted in it.
Explanation:
Answer:
![\left[\begin{array}{cccc}-&Budget&Variance&Actual\\IL&10,000&700&9,300\\IM&11000&-3,800&14,800\\Utilities&7,400&-2,400&9,800\\Maintenance&6,000&1,200&4,800\\Total \: Variable&34,400&-4,300&38,700\\Supervisor&35,400&0&35,400\\Depreciation&7,100&0&7100\\PT and insurance&7,700&-600&8,300\\Maintenance&6,000&0&6,000\\Total \: Fixed&56,200&-600&56,800\\Total \: MO&90,600&-4,900&95,500\\\end{array}\right]](https://tex.z-dn.net/?f=%5Cleft%5B%5Cbegin%7Barray%7D%7Bcccc%7D-%26Budget%26Variance%26Actual%5C%5CIL%2610%2C000%26700%269%2C300%5C%5CIM%2611000%26-3%2C800%2614%2C800%5C%5CUtilities%267%2C400%26-2%2C400%269%2C800%5C%5CMaintenance%266%2C000%261%2C200%264%2C800%5C%5CTotal%20%20%5C%3A%20Variable%2634%2C400%26-4%2C300%2638%2C700%5C%5CSupervisor%2635%2C400%260%2635%2C400%5C%5CDepreciation%267%2C100%260%267100%5C%5CPT%20and%20insurance%267%2C700%26-600%268%2C300%5C%5CMaintenance%266%2C000%260%266%2C000%5C%5CTotal%20%5C%3A%20Fixed%2656%2C200%26-600%2656%2C800%5C%5CTotal%20%5C%3A%20MO%2690%2C600%26-4%2C900%2695%2C500%5C%5C%5Cend%7Barray%7D%5Cright%5D)
Explanation:
We list them and subtract budget - actual
When actual is greater than budget the variance is negatine.
While budget being lower than actual is considered a positive variance.
Answer:
B. Grouting
Explanation:
These are the options for the question;
A. Epoxy resin
B. Grouting
C. Tensioning
D. Ranging
In the case of dormant cracks wider than about 1m, it is more economical to use grouting method.
Grouting techniques is a techniques that is achieved by removal of dirt or unwanted substance from the crack of the the faulty part and then grouting of the crack after which the surface is sealed by sealants. It should be noted that grouting is economical than other methods such as surface treatment.
