CORRECT TEXT

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. View Answer Answer: Select and press delete on the home tab....

Topic 1, Clothing Orders

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. View Answer Answer: =IF(inventory level<15%), "low", ""). Select and drag to apply to other rows...

CORRECT TEXT

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.’’ View Answer Answer: Conditional formatting, highlight cell rules, greater than and then pick the...

CORRECT TEXT

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. View Answer Answer:...

CORRECT TEXT

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. View Answer Answer: Click chart, press layout, click chart title and add it. Press add chart element, data labels,...