Sort this data by the Visits column so the smallest numbers are listed first. Font Size

Enable sharing so more than one person at a time can work on this workbook. Font Size

Sort this data by the Date of Last Visit column so the oldest dates are listed first. Font Size

In cell H1, enter a formula using COUNTIF to count the number of cells in the range named Delivery Time that have a value greater than 14. Remember to enclose the expression in quotation marks. Font Size

Preview how the worksheet will look when printed without a defined print area. Font Size

Use the Document Inspector to remove all comments and annotations and personal information and hidden information from this workbook. Close the Document Inspector when you are through. Font Size

Use Formula AutoComplete to enter a SUM function in cell E4 to calculate the total of cells B4:D4. Font Size

Enter a formula using DAVERAGE to calculate the average value in the Total Spent column for rows that meet the criteria in the criteria range A1:G2. The database is defined by the named range CustomersDB. Font Size

Save this workbook in the Excel 97-2003 format. Allow the file to save with compatibility issues. Font Size

Preview how the worksheet will look when printed. Font Size

Remove duplicate rows where data in all the columns are identical. Font Size

Using the Replace command, find and replace all cells formatted with the Accounting Number Format with the Currency format. Close the Find and Replace dialog when you are finished. Font Size