Page 117 - Ms Excel Note and Workbook
P. 117

MICROSOFT EXCEL NOTE AND WORKBOOK









                                                                                    TIP
                                                                             It may take some trial and
                                                                             error depending on the
                                                                             type of function you're
                                                                             looking for











               5.  Review  the results to  find  the  desired  function,  then  click OK.  In  our  example,  we'll
                   choose NETWORKDAYS, which will count the number of business days between the
                   ordered date and received date.











                                                                                    TIP
                                                                            the Insert Function
                                                                            command can be a
                                                                            powerful way to find a
                                                                            function quickly.








               6.  The Function Arguments dialog box will appear. From here, you'll be able to enter or
                   select the cells that will make up the arguments in the function. In our example, we'll
                   enter E3 in the Start_date field and F3 in the End_date field.

               7.  When you're satisfied, click OK.


















                                                                                              108 | P a g e
   112   113   114   115   116   117   118   119   120   121   122