You are compiling data about courses at Bellows College.
On the ‘’Last Semester’
Correct Answer: A
Click wrap text.
On the ‘’Revenue’
Select a cell within your data. Press home and then format as table. Click the table style and select your range.
On the ‘’New Policies’
Select a blank cell and press insert. Pick win/loss sparklines. Select the data range. Click and drag the bottom right corner for more.
On the ‘’Sales’
=UPPER(text)
From the ‘’Graduation’
Right click on the chart. Click move chart. Click new sheet and rename it.
On the ‘’Instructional Hours’
Click on the green plus sign and press axis titles.
On the ‘Comparison
Right click and open axis options. Check the box that says values in reverse order.
You are revising a sales summary report for Northwind Traders.
On the ‘’Summary’
Conditional formatting, highlight cell rules, greater than and then pick the color.
On the ‘’Prices’
=_*_
On the ‘’Inventory
Click chart, press layout, click chart title and add it. Press add chart element, data labels,more detailed options, uncheck value and check percentage.
Comment will be moderated and published within 1-4 hours