You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale.
How can you change the color of the cells that contain values under one dollar in the lowest priced column?
What will be an ideal response?
This type of formatting is called conditional formatting. To apply conditional formatting, highlight the column containing the lowest cost item from each sale. Click the Conditional Formatting button in the Styles group, point to Highlight Cells Rules, then click Less Than. Enter 1.00 in the Less Than dialog box, then choose a color format in the dialog box. Click OK. All cells with a value less than $1.00 will have a color applied to them.
You might also like to view...
When an async method encounters an await expression: If the asynchronous task has already completed, ________.
a) the async method simply continues executing b) the async method splits off another thread c) the await method is called d) the async method terminates
If you want to use a SmartArt graphic to visually represent information that is not sequential, use the List SmartArt graphic type
Indicate whether the statement is true or false
Applets are an implementation and application of ____ technology.
A. Java B. JavaScript C. ActiveX D. DHTML
_______ is a way of protecting the rights of intellectual property owners.
A. Copyright B. Digital privacy C. Public domain D. Paraphrasing