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 ‘’Prices’’ worksheet, apply the Title style to cell A1. View Answer Answer: Home Tab/ Styles group/ cell styles...
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:...
Topic 2, Sales Summary
Topic 2, Sales Summary Case Study Exhibit. CORRECT TEXT On the ‘Comparison’ chart sheet, swap the data the axis. View Answer Answer: Right click and open axis options. Check the box that says values in reverse order....
CORRECT TEXT
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. View Answer Answer:...
CORRECT TEXT
CORRECT TEXT On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column. View Answer Answer:...
CORRECT TEXT
CORRECT TEXT On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’ View Answer Answer: On the data tab, click filter. Display only alpine....
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,...