Formula Sheet for Test 1

Question 1

Sorting Data step by step

Answer 1

Step 1: Select cells A1:F21.
* Step 2: Click the Data tab in the Ribbon.
* Step 3: Click Sort in the Sort & Filter group.
* Step 4: Select the check box for My data has headers.
* Step 5: In the first Sort by dropdown menu, select Sales
(February 2018).
* Step 6: In the Order dropdown menu, select Largest to
Smallest.
* Step 7: Click OK

Question 2

Filtering Data step by step

Answer 2

Using Excel’s Filter function to see the sales of models made
by Nissan:
* Step 1: Select cells A1:F21.
* Step 2: Click the Data tab in the Ribbon.
* Step 3: Click Filter in the Sort & Filter group.
* Step 4: Click on the Filter Arrow in column B, next to
Manufacturer.
* Step 5: If all choices are checked, you can easily deselect all
choices by unchecking (Select All). Then select only the
check box for Nissan.
* Step 6. Click OK

Question 3

Conditional Formatting of Data step by step

Answer 3

To identify the automobile models in Table 2.2 for which sales had
decreased from February 2018 to February 2019:
* Step 1: Starting with the original data shown in Figure 2.3, select
cells F1:F21.
* Step 2: Click on the Home tab in the Ribbon.
* Step 3: Click Conditional Formatting in the Styles group.
* Step 4: Select Highlight Cells Rules, and click Less Than… from the
dropdown menu.
* Step 5: Enter 0% in the Format cells that are LESS THAN: box.
* Step 6: Click OK.