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
NemiM [27]
3 years ago
14

Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that conta

in 98% or higher for the Percent of List Price column. g
Computers and Technology
1 answer:
Svetllana [295]3 years ago
6 0

Answer:

It involves 7 steps, explained below

Explanation:

1st step: Using Excel, select the cells you want to format, for instance A2:A9

2nd step: Go to the Home tab > Styles group and click Conditional Formatting. You will see a number of different formatting rules, including data bars, color scales and icon sets.

3rd step: Since we need to apply new conditional formatting only, we choose the numbers we desire, we choose Highlight Cells Rules < Less than what we want.

4th step: Enter the value in box in the right-hand part of the window under "Format cells that are LESS THAN", in our case we type what we desire. As soon as you have entered the value, Microsoft Excel will highlight the cells in the selected range that meet your condition.

5th step: Select the format you want from the drop-down list. You can choose one of the pre-defined formats or click Custom Format... to set up your own formatting but since we want new format, we choose custom format.

6th step: In the Format Cells window, switch between the Font, Border and Fill tabs to choose the font style, border style and background color, respectively. On the Font and Fill tabs, you will immediately see a preview of your custom format.

7th step: after this has been done, click okay at the bottom of the window.

You might be interested in
After an informative session, you find yourself with several pages of notes. For maximum retention and understanding, you should
creativ13 [48]
Hey there!

I would say that you should go over them within the least amount of time as possible. The amount that someone remembers after a lecture or informative session goes down greatly after only a few hours since the lecture, so it's best to review them within 8 hours or so. If you do it within this time, you will still have the greatest possible remembrance of what you learned, since your memory of this continues to diminish over the next few days. 

Hope this helped you out! :-)
7 0
3 years ago
Why is it important to respect other political opinions
steposvetlana [31]

It is important to respect other political opinios because America is a free country. Hearing others opinios are also important in life, because it helps us see the world in different persective.

6 0
3 years ago
Read 2 more answers
A ________ topology uses more than one type of topology when building a network. crossover multiple-use fusion hybrid
frosja888 [35]

Answer:

hybrid topology

Explanation:

The type of topology that is being described is known as a hybrid topology. Like mentioned in the question this is an integration of two or more different topologies to form a resultant topology which would share the many advantages and disadvantages of all the underlying basic topologies that it is made up of. This can be seen illustrated by the picture attached below.

6 0
3 years ago
Computing devices translate digital to analog information in order to process the information
tester [92]

Complete Question:

Which of the following about computers is NOT true?

Group of answer choices.

A. Computing devices translate digital to analog information in order to process the information.

B. Computing devices are electronic.

C. The CPU processes commands.

D. The memory uses binary numbers

Answer:

A. Computing devices translate digital to analog information in order to process the information.

Explanation:

Computing is the process of using computer hardware and software to manage, process and transmit data in order to complete a goal-oriented task.

The true statements about computers are;

I. Computing devices are electronic: the components and parts which makes up a computer system are mainly powered by a power supply unit and motherboard that typically comprises of electronic components such as capacitors, resistors, diodes etc.

II. The CPU processes commands: the central processing unit (CPU) is responsible for converting or transforming the data from an input device into a usable format and sent to the output device.

III. The memory uses binary numbers: computer only understand ones and zeros.

5 0
3 years ago
write the algorithm, flowchart and BASIC program to calculate the area of the rectangle length 50m and width 30m.​
GalinKa [24]

Answer:

The Basic Program is as follows:

10 LENGTH = 50

15 WIDTH = 30

20 AREA = WIDTH * LENGTH

25 PRINT AREA

30 END

The Algorithm is as follows:

1. Start

2. Let Length = 50

3. Let Width = 30

4. Compute Area = Length * Width

5. Display Area

6. Stop

See Attachment for flowchart (flowchart is designed using draw io tools)

Explanation:

The flowchart, algorithm and basic program all follow the same sequence and explanation

Using the basic program as a case study;

Line number 10: The program starts by initializing LENGTH to 50

Line number 15: It then initializes WIDTH to 30

Line number 20: The AREA is calculated by LENGTH * WIDTH

Line number 25: The value of AREA is printed afterwards

Line number 30: Lastly, the program stops execution

8 0
3 years ago
Other questions:
  • Jason is creating a web page for his school's basketball team. He just finished creating his storyboard. Which tool should he us
    6·2 answers
  • Normal wear and road conditions can take their toll on a car’s steering and suspension system, altering __________. A. wheel ali
    15·2 answers
  • In terms of object-oriented programming, after a class is defined,
    11·1 answer
  • The breastbone or ________________ extends down the chest.
    5·1 answer
  • A letter of application should be written on:
    13·1 answer
  • Question 8 (True/False Worth 3 points)
    15·1 answer
  • Use the drop-down menus to explain how to locate the Consolidate dialog box.
    6·1 answer
  • How to beat level 50 in give up robot 2
    5·1 answer
  • Explain impact of modern technology on human life​
    5·1 answer
  • Resource _____ let you view, manage, and automate tasks on multiple aws resources at a time.
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!