1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
RoseWind [281]
3 years ago
14

Create a new conditional format that applies yellow fill (fourth color in the bottom row) and bold font to values that are highe

r than 98% for the percent of list price column.4
Computers and Technology
2 answers:
Yuki888 [10]3 years ago
5 0

Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and identify variances of cells' values with a quick glance.

At the same time, Conditional Formatting is often deemed as one of the most intricate and obscure Excel functions, especially by beginners. If you feel intimidated by this feature too, please don't! In fact, conditional formatting in Excel is very straightforward and easy to use, and you will make sure of this in just 5 minutes when you have finished reading this short tutorial.

Elena L [17]3 years ago
3 0

Answer:

These steps will help you create a new conditional format. My explanation will be done using Microsoft Excel 2013. Same steps apply for a higher version of Microsoft Excel

Explanation:

Step # 1 -- Name the data range. To start off the process, select the first cell of the data in your spreadsheet and press the " Shift " key and click the last cell in the column containing your data you wish to apply the conditional formatting on. The values will be selected. Now go to the "name" bar and type in the name of the range.

Step # 2 -- Select a Color Scale. Once you have selected the data, click on the "conditional formatting" button under the "styles" group in the "home" tab. Go to the “Color Scales”, in the pull menu select the fourth color in the bottom row to apply the Yellow fill.

Step # 3 -- Make a new rule. You can also make new rules by selecting the "new rule" option from the conditional formatting drop-down menu. Once done, a new box will appear where you can select the rule type, format the style and perform other such actions. In the “Select a Rule Type” click “Format only values that are above or below average” and select “above” in the “Format Values that are” field and click the “format button.

Step # 4 -- Apply the Highlight Cells Rule. Here, you can apply the "highlight cells rules" option. Once you click on this, a number of options will appear. Select the "greater than" rule and input a conditional value of 98%. All values above this conditional value will be highlighted since the condition is of "greater than". Select “bold” under “font style” and click the OK button twice.

You might be interested in
What type of database contains multiple collections of data that are related to one another cells
statuscvo [17]
The different types<span> of </span>databases<span> include operational </span>databases<span>, end-user </span>databases<span>, distributed </span>databases<span>, analytical </span>databases<span>, relational </span>databases<span>, hierarchical </span>databases<span> and </span>database<span> models. 

Source Bing</span>
7 0
3 years ago
Explain the quality-improvement process.
Tasya [4]

Answer:

 The quality improvement is the process that involve the complete organization in pursuit of the quality. It basically helps to improve the team knowledge and in decision making by using the validate data.  

The quality improvement is the proactive undertaking of recognizing, breaking down and enhancing existing business forms inside an association for enhancement and to satisfy new portions or guidelines of value.

 The main factors of the quality improvement are:

  • Leadership quality
  • Monitoring various types of systems
  • High availability of resources
  • Adequate infrastructure

3 0
3 years ago
Read 2 more answers
The same student is curious about how a Web site appears on his computer screen. On a separate piece of paper, draw and explain
Ksivusya [100]

Answer:

HTTP is the application layer protocol required.

Explanation:

For a web page to be displayed on a browser, the seven layers of the OSI model work together. On the application layer, HTTP protocol is used to communicate between the server and the client. The HTTP client is the browser (Chrome, Internet Explorer, Firefox etc.) which sends a request to the HTTP server for accessing a web page.  

When a URL is accessed, the HTTP client sends a request to the HTTP server. The server locates the file which is being requested and sends a response message containing the web page which is to be displayed. The exchange of data between the HTTP client and server takes place over a TCP connection.

TCP is a transport layer protocol which provides a reliable connection over which the exchange of data takes place. Data at the transport layer is sent in the form of segments. If the data being sent from the server is too long, it is divided into multiple segments and sent one after the other. The client is then responsible for joining the segments and displaying the information as a web page. The transport layer is also responsible for error correction and detection during the communication process.

If the student is sending or retrieving information from a secure website, the messages being exchanged between the client and server will be encrypted. This means that if a third-party tries to tap the communication process, they would not be able to decipher the messages. This increases the security and helps keep the information present on the web page confidential.

8 0
3 years ago
Cisco's acquisition of Pure Digital, makers of the Flip video camera line, was largely considered a flop because comparable tech
juin [17]

Answer:

True

Explanation:

8 0
3 years ago
Read 2 more answers
What might happen if Python code is not in the correct order? The computer will fix the steps automatically. The computer will f
Vesna [10]

Answer:

The computer will follow the steps, but the program might not work.

Explanation:

4 0
3 years ago
Read 2 more answers
Other questions:
  • Which Computer career field enables you to create and design interactive multimedia products and service
    5·2 answers
  • Why are listening and speaking part of the Common Core and ELD Standards? Why is this particularly important for our ELD student
    14·1 answer
  • What weight pencil is recommended for darkening lines and for lettering? *
    7·2 answers
  • The Speed of Sound (Java Project. Please make it easy to understand. I'm a beginner at this. I believe we are supposed to use a
    5·1 answer
  • Write a program segment with a do-while loop that displays whether a user-entered integer is even or odd. The code should then a
    5·1 answer
  • Explain why, with fast moving mobiles, speed is more dominant in characterizing the use mobility pattern than direction?
    8·1 answer
  • What two devices in a computer should be considered "black boxes," and should never be opened due to risks involving charged cap
    13·1 answer
  • Can you withdraw from courses in top hat?
    14·1 answer
  • Given three floating-point numbers x, y, and z, output x to the power of z, x to the power of (y to the power of z), the absolut
    12·1 answer
  • Why is quantum computing potentially a better fit for weather forecasting than classical computers?.
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!