All categories

3 years ago

Which feature enables you to format data using specific conditions?

Computers and Technology

2 answers:

Nina [5.8K]3 years ago

3 0

Cell protection
open Review tab>> Changes Group>>Protect Sheet

Ket [755]3 years ago

3 0

Answer:

Cell protection

Explanation:

Under cell protection you can consult if the cell that you are trying to format is actually unlocked to do the changes, so in cell protection you can go and check what can you do about it and what changes can you actually make to the cell, to format the data to the specific conditions that you desire.

You might be interested in

Write a program with the total change amount as an integer input, and output the change using the fewest coins, one coin type pe

riadik2000 [5.3K]

Answer:

In Python:

cents = int(input("Cents: "))

dollars = int(cents/100)

quarters = int((cents - 100*dollars)/25)

dimes = int((cents - 100*dollars- 25*quarters)/10)

nickels = int((cents - 100*dollars- 25*quarters-10*dimes)/5)

pennies = cents - 100*dollars- 25*quarters-10*dimes-5*nickels

if not(dollars == 0):

if dollars > 1:

print(str(dollars)+" dollars")

else:

print(str(dollars)+" dollar")

if not(quarters == 0):

if quarters > 1:

print(str(quarters)+" quarters")

else:

print(str(quarters)+" quarter")

if not(dimes == 0):

if dimes > 1:

print(str(dimes)+" dimes")

else:

print(str(dimes)+" dime")

if not(nickels == 0):

if nickels > 1:

print(str(nickels)+" nickels")

else:

print(str(nickels)+" nickel")

if not(pennies == 0):

if pennies > 1:

print(str(pennies)+" pennies")

else:

print(str(pennies)+" penny")

Explanation:

A prompt to input amount in cents

cents = int(input("Cents: "))

Convert cents to dollars

dollars = int(cents/100)

Convert the remaining cents to quarters

quarters = int((cents - 100*dollars)/25)

Convert the remaining cents to dimes

dimes = int((cents - 100*dollars- 25*quarters)/10)

Convert the remaining cents to nickels

nickels = int((cents - 100*dollars- 25*quarters-10*dimes)/5)

Convert the remaining cents to pennies

pennies = cents - 100*dollars- 25*quarters-10*dimes-5*nickels

This checks if dollars is not 0

if not(dollars == 0):

If greater than 1, it prints dollars (plural)

if dollars > 1:

print(str(dollars)+" dollars")

Otherwise, prints dollar (singular)

else:

print(str(dollars)+" dollar")

This checks if quarters is not 0

if not(quarters == 0):

If greater than 1, it prints quarters (plural)

if quarters > 1:

print(str(quarters)+" quarters")

Otherwise, prints quarter (singular)

else:

print(str(quarters)+" quarter")

This checks if dimes is not 0

if not(dimes == 0):

If greater than 1, it prints dimes (plural)

if dimes > 1:

print(str(dimes)+" dimes")

Otherwise, prints dime (singular)

else:

print(str(dimes)+" dime")

This checks if nickels is not 0

if not(nickels == 0):

If greater than 1, it prints nickels (plural)

if nickels > 1:

print(str(nickels)+" nickels")

Otherwise, prints nickel (singular)

else:

print(str(nickels)+" nickel")

This checks if pennies is not 0

if not(pennies == 0):

If greater than 1, it prints pennies (plural)

if pennies > 1:

print(str(pennies)+" pennies")

Otherwise, prints penny (singular)

else:

print(str(pennies)+" penny")

4 0

3 years ago

How to generate random numbers in excel without duplicates

Lilit [14]

Answer:

<h3>Generate Random Number List With No Duplicates in Excel:</h3>

1. Select cell B3 and click on it.

2. Insert the formula: =RANDBETWEEN(10,30)

3. Press enter.

4. Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.

Explanation:

Hope it helps you..

Your welcome in advance..

(ㆁωㆁ)

5 0

3 years ago

How many report charts can be added to the account page layout to meet this requirement? A sales manager would like to look at a

Virty [35]

Answer:

D - 2

Explanation:

You can have two report charts per page. You can only add report charts from the enhanced page layout editor.

The mini console and the original page layout editor are not supported. On detail pages, users can refresh up to 100 report charts every 60 minutes. Your organization can refresh up to 3,000 report charts every 60 minutes

8 0

3 years ago

What font is the declaration of independence?

Keith_Richards [23]

I believe it is old English text

4 0

4 years ago

General Hardware Products Your boss, the IT director, wants you to explain FDDs, BPM, DFDs, and UML to a group of company manage

Bas_tet [7]

Answer:

1. FDD is a process and Analysts can use a FDD to create and use business functions and processes. It Requirements models are used when gathering requirements for a new system.

2. BPM is used on an ongoing basis for business process improvement. It is meant to improve order, insight and efficiency of the collective workflows that make up any given business process. BPM is meant to reduce any chaos within those collective workflows that make up a process and eliminate ad hoc workflow management. BPM means Business Process Management.

3. DFDs stands for Data Flow Diagram which will help software developers and designers to understand how they can take their next step to fit into the overall business process. DFDs paly key role for a successful requirements modeling.

4. UML can be used for modeling a system independent of a platform language. UML is a graphical language for visualizing, specifying, constructing, and documenting information about software-intensive systems. UML gives a standard way to write a system model, covering conceptual ideas.

Explanation:

Functional decomposition diagram (FDD) is used to identify functions and define their structure. It is a technique to decompose the complex problem into manageable pieces or individual elements to develop the application or product.

DFDs: It contains a process (shape) that represents the system to model, in this case, the "Food Ordering System". It also shows the participants who will interact with the system, called the external entities. In this example, Supplier, Kitchen, Manager and Customer are the entities who will interact with the system.

Unified Modeling Language (UML): Edraw UML Diagram is the application of choice for many software engineers and designers. The software is fully compatible with 64 and 32-bit Windows platforms from Windows XP to Windows 10.

3 0

4 years ago