Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default Help

Help, Looking for an answer to this Question



14.. Use database functions to calculate total and average orders for beverages sold after 4/1/06 by sales rep Davis.


Place the labels "# of Orders" and "Average Orders" in cells o1 and o2, respectively.



Using the database functions, calculate the summary results for the orders that meet the criteria and place the results in cells P1 and P2.



Format the results and print only the summary in the range O1:P2.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"