Topic 1, Clothing Orders
Case Study
Exhibit.
CORRECT TEXT
On the ‘’Prices’’ worksheet, in the ‘’inventory Notice’’ column, use a function to display ‘’Low’’ if the ‘’ inventory Level % is below 15%. Otherwise, leave the ‘’Inventory Notice’’ blank.
CORRECT TEXT
On the ‘’Prices’’ worksheet, apply the Title style to cell A1.
CORRECT TEXT
On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’
CORRECT TEXT
On the ‘’Prices’’ worksheet, in the ‘’Tax column, enter a formula that multiples the value in the ‘’Unit Price’’ column by cell L2.
CORRECT TEXT
On the ‘’Inventory’ chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.
CORRECT TEXT
You are updating the sales spreadsheet for an online clothing store.
On the "Quote’’ worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.
Topic 2, Sales Summary
Case Study
Exhibit.
CORRECT TEXT
On the ‘Comparison’ chart sheet, swap the data the axis.
CORRECT TEXT
You are revising a sales summary report for Northwind Traders.
On the ‘’Summary’’ worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ‘’$5,000,000.’’
CORRECT TEXT
On the ‘’Projections’ worksheet, in the ‘’Quarter2’’ column, enter a formula that multiples the value in the Quarter 1’’ column by the ‘Q2_increase’ named range. Use the range name in the formula instead of a cell reference or value.
CORRECT TEXT
On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column.