19.2.2014 nifty tips | 19.2.2014 nifty tips details

-

19.02.2014 NIFTY TIPS




Popular posts from this blog

TASK - 8

-
TASK - 8                             8a . Put in am / is / do / don't / does / doesn't                                         1. Excuse me, do you speak English?           2. "Have a cigarette, 'No, thank you, I ….. smoke.       3.  Why ….. You laughing at me?             4. What …. she do? She is a doctor.           5. I …. want to go out. It …. raining.             6. Where ….. You come from? ' From Australia'       ...
Read more

DMIN Function Dictionary

-
Function Dictionary Function Examples Function Categories DMIN                 This is the Database range. Product Wattage Life Hours Brand Unit Cost Box Quantity Boxes In Stock Value Of Stock Bulb 200 3000 Horizon £4.50 4 3 £54.00 Neon 100 2000 Horizon £2.00 15 2 £60.00 Spot 60           £0.00 Other 10 8000 Sunbeam £0.80 25 6 £120.00 Bulb 80 1000 Horizon £0.20 40 3 £24.00 Spot 100 unknown Horizon £1.25 10 4 £50.00 Spot 200 3000 Horizon £2.50 15 1 £37.50 Other 25 unknown Sunbe...
Read more

FORECAST Function Dictionary

-
Function Dictionary Function Examples Function Categories FORECAST             Month Sales 1 £1,000 2 £2,000 3 £2,500 4 £3,500 5 £3,800 6 £4,000     Type the month number to predict :  12     The Forecast sales figure is :  £7,997  =FORECAST(E11,F4:F9,E4:E9) What Does It Do ?             This function uses two sets of values to predict a single value. The predicted value is based...
Read more