Sarah, who has been an apparel retailer for ten years, wants to analyze and compare the monthly profits for the ten years. She fills details such as the year, month, and profit in three columns on an Excel sheet. She wants to highlight the months with a profit of more than $100. In this scenario, Sarah should use the _____ function to highlight the relevant cells at once.?

A. ?conditional formatting
B. ?tatistical
C. ?Flash Fill
D. ?Text to Columns


Answer: A

Computer Science & Information Technology

You might also like to view...

Windows 7 comes with a group of mini programs that can be installed called ________

A) utensils B) widgets C) gizmos D) gadgets

Computer Science & Information Technology

A ____ is a data parameter associated with a software or hardware characteristic under a key (or subkey).

A. Registry module B. Registry value C. Registry branch D. Registry entry

Computer Science & Information Technology

Declaring main as static allows the JVM to invoke main ________.

a. without knowing the name of the class in which main is declared. b. by creating an object of the class in which main is declared. c. without creating an instance of the class in which main is declared. d. None of the above.

Computer Science & Information Technology

Which method is used to create a new item in a collection?

a. Store b. Insert c. Add d. Create

Computer Science & Information Technology