Which function key opens a dialog box that allows you to make a special selection of, for example, all cells containing comments, or all cells containing formulas, or all objects (text boxes, shapes, etc.) on a worksheet

Answers

Answer 1

Answer:

F5 key.

Explanation:

In Computer science, F5 is a function key which opens a dialog box that allows you to make a special selection of, for example, all cells containing comments, or all cells containing formulas, or all objects (text boxes, shapes, etc.) on an excel worksheet.

In Microsoft Excel, the F5 key is known as a "Go to special function" which avails users the ability to select all cells that meets certain defined criteria, such as the cells containing comments, formulas, objects, constants etc.


Related Questions

Saving a file as a new filename can be accomplished through the Save As dialog box.

True False

Answers

Answer:

True.

Explanation:

A dialog box is a small window that serves as a controlling element in computers. The name dialog box is suggestive that it is a window that helps the user to communicate and response with an answer.

There are several types of common dialog box such as open dialog box, save as dialog box, print dialog box, etc.

Save as dialog box is a window that enables the user to save a file with a new name and new location. Save as dialog box can be opened by going to the File menu and click Save as. After the Save as dialog box appears, the user is able to change file name, location, etc.

Thus the statement is true.

A(n) __________ item is a hardware or software item that is to be modified and revised throughout its life cycle.

Answers

Answer: configuration

Explanation: hardware also known as a software.

Answer: configuration

Explanation: hardware also known as a software.  

helping is caring :)

Word processing is the use of computer software to enter and edit text.

Answers

Answer:

True

Explanation:

Word processing software or word processing program handles functions related to entering and editing text in a text document. In essence a word processor processes text documents which includes processing entire papers, paragraphs, pages. With a word processing software text is entered  in the document mainly through typing in the letters with a keyboard and a word processor allows copying, deleting and formatting text through the use of built in commands

Examples of word processing programs are Microsoft Word, AppleWorks and OpenOffice.

You open a web page and log into your email. The traffic travels over many routers. What protocol will the routers use to determine the most optimal path to forward the traffic?

Answers

Answer:

Border Gateway Protocol is a protocol the routers use to determine the most optimal path to forward the traffic.

Explanation:

BGP is a path vector protocol which chooses the most optimal path. The protocol decides core routing decisions based on path, configuration and network.

This protocol gives all the notification about the status of the connection and router.

It is used to routing in an autonomous system and provides ways to measure the effectiveness of configuration.

Memory operations currently take 30% of execution time of program A. A new widget called a "cache" speeds up 80% of memory operations by a factor of 4. A second new widget called a "L2 cache" speeds up half of the remaining 20% by a factor of 2. What is the total speed up?

Answers

Answer:

The answer is "1.24"

Explanation:

Formula:

[tex]\bold {Speedup= \frac{1}{(1 - non-speedup-portion) +(Speed up portion 1)}+\frac{(speed up-portion \ 2)}{ speedup\ 2}+ ....}\\\\[/tex]Given value:

Operations in the memory = 30%

                                              = 0.3  

80% Memory [tex]= 0.3 \times 80\%[/tex]

                       [tex]=[/tex] [tex]\frac{(0.3 \times 80) }{100}[/tex]

                       [tex]= 0.24[/tex]  

Now it takes 0.06 seconds, saved 0.18 seconds.

20% of the memory operations:

[tex]= 0.3 \times 20\% \\\\= \frac{(0.3 \times 20)}{100} \\\\= 0.06[/tex]

Half of the other 20% = 0.03  

It takes 0.015 seconds now, saved 0.015 seconds, saved 0.195 seconds.  

It takes 0.805 seconds in the 1 second.

[tex]Speedup = \frac{1} {0.7 + 0.3\times \frac{0.8}{4}} + 0.3\times0.2\times\frac{0.5}{2} + 0.3\times0.2\times0.5[/tex]

[tex]Speedup = 1.2422[/tex]

Which statement best describes an academic goal?

Answers

Answer:

Explanation:

Hila gets good grades and works hard to finish first in class.

Hope this helped you!

Answer:

Hila gets good grades and works hard to finish first in class.

Hope this helped you!

Explanation:

what does a cargo and freight agent do

Answers

Hey there!

Well cargo and freight agents expedite and route movement of incoming and exporting cargo and of course freight.

Hope this helps :)

MS Excel is a powerful spreadsheet program that helps people with complex mathematical calculations. In what ways could you use Excel for personal, work and school purposes? Give an example for all three.

Answers

Answer:

Explanation:

En Google te sale la respuesta fácilmente.

Solo pones la pregunta primero con personales, luego con laborales y así...

Y de luego los ejemplos

A switch operates in the OSI reference model __________ layer and uses the __________ address to forward packets.

Answers

Answer:

A switch operates in the OSI reference model data link layer and uses the MAC address to forward packets

Explanation:

A network switch used in wired physical network connection, has several ports and acts as the bridge in the network of computing devices with a port naming system based on MAC addresses to forward data receives at the OSI model data link layer. By incorporating the capability of routing, switches can forward data at the network layer, known as layer 3.

Read the code below.
What will the computer print if the input for year_variable is 1700?
if year_variable == 1776:
print("Your answer is correct. The Declaration of Independence was signed in “year_variable”.")
elif year_variable 1776: compute_variable = year_variable - 1776
print("Subtract “compute_variable” years from your answer for the correct answer.")

Your answer is incorrect. The Declaration of Independence was signed in 1776.
Subtract 76 years from your answer for the correct answer.
Add compute_variable years to your answer for the correct answer.
Add 76 years to your answer for the correct answer.


PLEASE EXPLAIN HOW YOU GOT IT

Answers

Answer:

D. Add 76 years to your answer for the correct answer.

Explanation:

Write the code in python and make year_variable= 1700

Since the input value is 1700, it is less than 1776. This means the elif year_variable < 1776:

would run. This line of code makes whatever the input value is to be subtracted from 1776, then produce an answer labeled as "compute_variable"

This "compute_variable" is then shown to be in a print function, where it says to add whatever the compute variable is to the input, to get the correct answer.

Answer:

The answer is D.

Explanation:

Hope it helps! =D got it on edge

Quickly viewing a segment of your database right from the contacts, companies, deals, or tickets dashboard is an example of which type of segment?A. Active list.B. Saved filter.C. Static list.D. Saved list.

Answers

Answer:

D) Saved list

Explanation:

Segments are saved searches or dynamic lists that enables you to access information from multiple databases as well as search for specific field values or behavioural information.

Saved lists are used with standard objects like tickets, contacts, deals, companies etc. It allows you to quickly view or access a segment of your database right from the contacts, deals, tickets dashboard or generally objects dashboard, based on their property values.

If you were doing a regular expression inside a Linux command line, which special character on the keyboard would give you two possible matches using the example below: car ____ truck

Answers

Answer: car | truck

Explanation: The pipe (|) symbol used can be used in regular expression to simply imply OR. This means when used in between expression, can be used to search for all matches of the strings in which it stands in between. In the scenario above, If the pipe symbol is located in between the two strings, such as [ cars | trucks], the expression returns possible occurrence of the strings cars and trucks. It may also be used to locate and return the occurrences of more than 2 strings, such as; string1 | string2 | string3

The next thing Maia wants to do is to indent the first line of her paragraphs.
How does she do this?

Answers

Answer:

She moves the first-line indent marker to the right.

Explanation:

Answer: d the first-line indent to the right

Explanation:

List some good names for devices on your home network or on the network in your school's lab. Demonstrate the use of best practices when creating a naming scheme for devices on a computer network.

Answers

Answer:

Following are the answer to this question:

Explanation:

The following is the list of name devices, which is used home network or the school lab.

hrtr01(home router 1). schadmrtr02(school building router 2). clpc01, and clpc02 (computer laboratory pc 1 and 2) .

Uses:

Its use as descriptive names as necessary without gives potential hacks much more relevant data.  It provides only areas that are essential for both device identification.  It allows the name for irrelevant or redundant information doesn't over-complicated.

Jack needs to email two documents to a friend, but the files are so large his email server bounced them back as undeliverable. What is your advice?

Answers

first try to do one at a time and if they are both too large he can send them through softwares like google drive that let you have large amounts of storage with your files

You are a cleared employee. You discovered fraud and waste of money related to a classified program within your agency. If you report this fraud and waste through appropriate channels, you may receive protection under the Presidential Policy Directive 19 (PPD-19), Protecting Whistleblowers with Access to Classified Information.A. TrueB. False

Answers

Answer:

A. True.

Explanation:

In this scenario, you are a cleared employee. You discovered fraud and waste of money related to a classified program within your agency. If you report this fraud and waste through appropriate channels, you may receive protection under the Presidential Policy Directive 19 (PPD-19): Protecting Whistleblowers with Access to Classified Information.

In USA, the Presidential Policy Directive 19 (PPD-19) which was signed by President Barack Obama in October 2012, is an executive order designed to provide significant protection for an employee who have access to classified informations such as fraud, waste of money and abuse or prohibiting any form of retaliation against this cleared employee.

janice has set her camera for f/4 but is trying to decide if she should switch to f/8
a. a larger aperture and smaller depth field
b. a smaller aperture and greater depth field
c. a smaller aperture and smaller depth of field
d. a larger aperture and greater depth of field

Answers

Answer:

b

Explanation:

cuz the smaller apeture and greater depth field would be better

Answer:

B a larger aperture and smaller depth of field

Explanation:

EDGE 2022

Think about some of the most memorable and forgettable games ever created. They can be games that were
discussed in this unit or otherwise. What are some of the consistent factors that made certain games
memorable to you? What were some of the consistent factors that made certain games forgettable to you?
Why? Explain.

Answers

Answer:

There can be many reasons.

Explanation:

1) Unforgettable story

2) The scenery is soooo good (for example, Legends of Zelda : Breath of the Wild)

3) The meaning behind the game.

4) Why the game was created caught your attention

Hope I helped!

A computer retail store has 15 personal computers in stock. A buyer wants to purchase 3 of them. Unknown to either the retail store or the buyer, 3 of the computers in stock have defective hard drives. Assume that the computers are selected at random.
(a) In how many different ways can the 4 computers be chosen?
(b) What is the probability that exactly one of the computers will be defective?
(c) What is the probability that at least one of the computers selected is defective?

Answers

Answer:

a. 1365 ways

b. Probability = 0.4096

c. Probability = 0.5904

Explanation:

Given

PCs = 15

Purchase = 3

Solving (a): Ways to select 4 computers out of 15, we make use of Combination formula as follows;

[tex]^nC_r = \frac{n!}{(n-r)!r!}[/tex]

Where [tex]n = 15\ and\ r = 4[/tex]

[tex]^{15}C_4 = \frac{15!}{(15-4)!4!}[/tex]

[tex]^{15}C_4 = \frac{15!}{11!4!}[/tex]

[tex]^{15}C_4 = \frac{15 * 14 * 13 * 12 * 11!}{11! * 4 * 3 * 2 * 1}[/tex]

[tex]^{15}C_4 = \frac{15 * 14 * 13 * 12}{4 * 3 * 2 * 1}[/tex]

[tex]^{15}C_4 = \frac{32760}{24}[/tex]

[tex]^{15}C_4 = 1365[/tex]

Hence, there are 1365 ways

Solving (b): The probability that exactly 1 will be defective (from the selected 4)

First, we calculate the probability of a PC being defective (p) and probability of a PC not being defective (q)

From the given parameters; 3 out of 15 is detective;

So;

[tex]p = 3/15[/tex]

[tex]p = 0.2[/tex]

[tex]q = 1 - p[/tex]

[tex]q = 1 - 0.2[/tex]

[tex]q = 0.8[/tex]

Solving further using binomial;

[tex](p + q)^n = p^n + ^nC_1p^{n-1}q + ^nC_2p^{n-2}q^2 + .....+q^n[/tex]

Where n = 4

For the probability that exactly 1 out of 4 will be defective, we make use of

[tex]Probability = ^nC_3pq^3[/tex]

Substitute 4 for n, 0.2 for p and 0.8 for q

[tex]Probability = ^4C_3 * 0.2 * 0.8^3[/tex]

[tex]Probability = \frac{4!}{3!1!} * 0.2 * 0.8^3[/tex]

[tex]Probability = 4 * 0.2 * 0.8^3[/tex]

[tex]Probability = 0.4096[/tex]

Solving (c): Probability that at least one is defective;

In probability, opposite probability sums to 1;

Hence;

Probability that at least one is defective + Probability that at none is defective = 1

Probability that none is defective is calculated as thus;

[tex]Probability = q^n[/tex]

Substitute 4 for n and 0.8 for q

[tex]Probability = 0.8^4[/tex]

[tex]Probability = 0.4096[/tex]

Substitute 0.4096 for Probability that at none is defective

Probability that at least one is defective + 0.4096= 1

Collect Like Terms

Probability = 1 - 0.4096

Probability = 0.5904

what is meant by concentration of a solution​

Answers

Answer:

The concentration of a solution means the amount of solute present in a given or specific amount of solution. (presented in percentage)

For example, the Normal Saline solution normally used for different scientific experiment or so. The saline water has 0.9% of salt (sodium chloride). This is the concentration of solution of salt.

Answer:

Concentration is the ratio of solute in a solution to either solvent or total solution.

Explanation:

Concentration basically means how much of something is in a given area. A gas, for example, can be highly concentrated in a given area, but a liquid cannot be concentrated and always takes up the same amount of space.


Convert 30 to hexadecimal ​

Answers

Answer:

1E

Explanation:

Here is a table to help you. Similar to a multipication table, just follow either the number 3 down to A (aka 10) or 6 x 5 and you will find your answer of

1E = 30

01000001 01101110 01110011 01110111 01100101 01110010 00100000 01101001 01110011 00100000 00110100 00110010 00101110 There's a way to make this meaningful; find it!

Answers

Answer:

Binary Code

Explanation:

I believe this is Binary code, so if you enter this in Google, click a translator from binary code to text, and it should tell you.

when I did it, it said "Answer is 42"

Hopefully this helped any.

qbasic write a program to input number of keyboard to purchase and display the total amount to be paid for with dry run and output step by step​

Answers

Answer:

DIM cost, amount

cost=8

INPUT "How many do you want to purchase";amount

PRINT "Total cost: ";amount*cost

Explanation:

What do you mean by dry run?

An essential skill today is knowing how to cite sources properly. Creative Commons has a system of licenses and tools for creators to retain copyright while allowing others to:

Answers

Answer:

Copy, distribute, and remix

Explanation:

Creative Commons is not for profit international network and organisation with head quarters in America that enables the discovery of material that are openly licensed so as to be available for use by others fostering the possibility to gain educational insight to creative works to serve as foundation for their own works legally. Creative Commons provide CC licences that are accessed by content creators with a desire to share their creativity on the web.

Which of these jobs would be most appropriate for someone who majors in information technology? managing a database for a large department store developing new computing technology that will someday improve network speeds managing the computer network for a large department store designing the hardware for a military helicopter's on-board computer

Answers

Answer:

A

Explanation:

managing the computer network for a large department store

The job that would be most appropriate for someone who majors in information technology is to manage the computer network for a large department store. Thus, the correct option for this question is C.

What is Information technology?

Information technology may be defined as a broad study of a system and network that uses the computer's hardware, software, services, and supporting infrastructure in order to manage and deliver information using voice, data, and video.

So, the job associated with information technology may require the significant utilization of computers and networks over a huge range of numbers. Managing a database is the work of software engineers, designing the hardware for a military helicopter's onboard computer is the work of hardware engineers, etc.

Therefore, the job that would be most appropriate for someone who majors in information technology is to manage the computer network for a large department store. Thus, the correct option for this question is C.

To learn more about Information technology, refer to the link:

https://brainly.com/question/4903788

#SPJ5

Define a public static method named s2f that takes two String arguments, the name of a file and some text. The method creates the file and writes the text to it. If all goes well the method returns true. If, however, either of its arguments are null or if there is any problem in creating or writin

Answers

Answer:

Java solution (because only major programming language that has public static methods)

(import java.io.* before hand)

public static boolean s2f(String fileName, String text){

   try{

       PrintWriter out = new PrintWriter(new File(fileName));

       out.println(text);

       out.close();

       return true;

   }

   catch(Exception e){

       return false;

   }

}

You need to install several USB devices on a server. You have been asked to attach USB hubs to the computer. Only one USB port is available. How many hubs can you daisy chain using the single port?

Answers

Answer:

5 Hubs

Explanation:

Only up to 5 hubs you can have connected without problems.

Once you have a listing of every unique combination of salesperson, product and location, what Excel function would you use to compute the total sales for each combination of salesperson, product and location

Answers

Answer:

SUMIFS

Explanation:

As we know that the excel is used to present the data in a very attractive way by applying the formulas, pie charts, functions as a pivot table, goal seeking, macros, etc

In order to determine the total sales for each and every sales person, production and location combination we use the SUMIFS function so that the total of each column could come in an easiest and better way


The house had a wonderful pool of ... (his/its/our) own.​

Answers

Answer:

its

Explanation:

"It" used in a number of different forms of sentences and has several rules. 'It' can be used in a sentence either for a Subject or an Object. It can be used as an introductory word in a sentence when there is no mention of the subject. It used for the singular, third-person pronoun. While it has many uses and according to the question, it is used to refer to a lifeless object (home).

A={a,b,c,d} B={p,q,r,s} find the value of A-B and B-A​

Answers

Answer:

a-b=(a,b,c,d)

b-a=(p,q,r,s)

Other Questions
If you have a strand of DNA that reads 3'TACGCGATAGGCAAATT5'. 1. Give the corresponding strand of mRNA 2. Assuming the last condon is a stop codon, will this mRNA strand code correctly for a five amino acid protein (1) In "The Gettysburg Address," Abraham Lincoln says, "the brave men, living and dead, who struggled here, have consecrated it, far above our poor power to add or detract." He believes that the world has taken notice of the battle but that the war is far from over. (2) He urges that it is "for us to be here dedicated to the great task remaining . . . that this nation . . ." He hopes that others will continue to fight for the freedom of all men. (3) Finally, he is determined to make sure that, "these dead shall not have died in vain." Identify whether each quotation is formatted correctly, and, if not, how it needs to be improved. Hem and Nem are partners in a firm sharing profits in the ratio of 3:2. Their capitals were 80,000 and 60,000 respectively. They admitted Sam on Jan 1, 2019 as a new partner for 1/5th share in the future profits. Sam brought 60,000 as his capital.Calculate the value of goodwill of the firm and record necessary journal entries when Sam brings his share of goodwill in cash. Write standard form, expanded form and word form at the top of the page write five numbers that are at least 8 digits long Complete las siguientes oraciones con la forma correcta de la palabra o frase que falta. 1. Este puesto como agente de viajes me interesa mucho, voy a llenar __________ ahora mismo. 5. Queremos crear una organizacin ________, o sea, una compaa que no piense en ganar dinero para s misma. 9. Cuando se necesita dinero para ayudar a los pobres, a veces los voluntarios tienen que ________ fondos. 10. En el futuro, si me quedo sin trabajo, _________ (hacer) otra cosa. Jamal bought donuts and cupcakes. He bought three times as many donuts as cupcakes. Donuts cost $0.50 each. Cupcakes cost $1.00 each. Jamal spent $10.00 total. How many donuts did Jamal buy? How many cupcakes did Jamal buy? 10 (6x - 5) Simplify by distributing (and combining like terms if necessary).6 (2x - 3) - 5x Simplify by distributing (and combining like terms if necessary).2x (5 + 4) Simplify by distributing (and combining like terms if necessary).-9 (8x - 5) Simplify by distributing (and combining like terms if necessary).5 - 8 (3x + 5) -3 Which statement about nuclear fission is correct? produces very little energy produces a lot of air pollution requires large amounts of matter produces tremendous amounts of energy A rectangular room is 3 meters longer than it is wide, and its perimeter is 22 meters. Find the dimension of the room. The length is : meters and the width is: meters. What was the effect of surplus food on the creation of governments Describe the characteristics of our government system What can happen when imagination overcomes reason? The three angles in a triangle are in the ratio 3:5:7. Find the largest angle in the triangle? Each DNA molecule resulting from replication has one original strand and one new strand. This also known as _________________________replication of DNA. Simplify the expression (7x - 3x) + (11x - x - 7) A. 18x + 2x + 7 B. 4x - 4x - 7 C. 18x - 2x - 7 D. 18x - 4x - 7 The ozone layer is important because it Janissa bought 50 cupcake cases for baking. She used 2/5 of the cases to bake vanilla cupcakes. She then used 5/6 of the remaining cases to bake chocolate cupcakes. How many cupcake cases does Janissa have left? During the academic decline in Europe, most geographic advances took place in China and ______? please help!!! 100 points if correct!!! please actually answerInstructionsIn this experiment, you will be using two coins as a simulation for a real-world compound event.Suppose that a family has an equally likely chance of having a cat or a dog. If they have two pets, they could have 1 dog and 1 cat, they could have 2 dogs, or they could have 2 cats. What is the theoretical probability that the family has two dogs or two cats?Describe how to use two coins to simulate which two pets the family has.Flip both coins 50 times and record your data in a table like the one below.(picture below)Based on your data, what is the experimental probability that the family has two dogs or two cats? If the family has three pets, what is the theoretical probability that they have three dogs or three cats? How could you change the simulation to generate data for three pets? Most concurrent powers_________.a. can be traced to Article IV.b. prevent Congress from regulating businesses within specific states.c. encourage state governments to restrict the number of non-citizens who are employed by the state.d. are are not specifically stated in the Constitution, but are only implied.