Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cells A 1 :A 1 0 contain a set of numbers. You want to select those cells that contain numbers less than 1 0 0

Cells A1:A10 contain a set of numbers. You want to select those cells that contain numbers less than 100 and highlight those cells in red, and you want to do it in such a way that even if some numbers change, those cells still get highlighted in red if their value falls below 100; otherwise, the cells should not be colored. Which of the following Excel features allows you to accomplish this task?
\table[[,A,,A],[1,83,1,83],[2,81,2,81],[3,141,3,141],[4,91,4,91],[5,120,5,120],[6,114,6,114],[7,121,7,121],[8,89,8,89],[9,105,9,105],[10,104,10,104]]
Select the single best answer:
A. Filter
B. Sorting
C. Conditional Formatting
D. Pivot Table
E. Cell Style
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 4.5 Databases

Authors: Sandeep Chanda, Damien Foggon

3rd Edition

1430243805, 978-1430243809

More Books

Students also viewed these Databases questions

Question

Do you think the banquet is a ritual? Why or why not?

Answered: 1 week ago

Question

How can speakers enhance their credibility?

Answered: 1 week ago