Perform following Excel functions and formulas
Mathematical Round, ceil floor, fact, subtotal, sum , sum if; Logical AND, OR, NOT, if; Statistical Min, max, avg, count if; Text Concatenate, Exact, find, left, right, len, lower, upper, trim; Lookup Hlookup, Vlookup; Date and Time Date, day, days360, hours, minute, now, second, time, today, year, datediff;
Financial Functions; FV, IPMT, NPER, NPV, PMT, PV, Rate Pivot table
Do as directed (Word Questions)
Q.1 Manager of the ABC Company wants to call a meeting with the dealers to take stock of pending collections. Write down a fax using FAX wizard of MS WORD to urgently call the all the dealers.
Q.2 Prepare the format with appropriate layout of Visitors gate Pass which can be allowed to meet the employees of the company during working hours.
No comments:
Post a Comment