All categories

3 years ago

Which Excel function or tool will you use to display the cells that are referred to by a formula in the selected cell

Computers and Technology

1 answer:

Alenkasestr [34]3 years ago

7 0

Answer:

Trace Precedent

Explanation:

Trace Precedent is a Microsoft Excel tool that is mostly used in auditing work to evaluate the connection or linkage between the cells in a spreadsheet. It is used to display the cells that are referred to by a formula in the selected cell. This is to locate the basis of an error in knowing how the formulas are adapted.

This can be done by clicking on the Formulas tab, then click on Formulas Auditing, then click on Trace Precedents.

Hence, in this case, the correct answer is TRACE PRECEDENTS.

You might be interested in

A plan to budget time for studying and activities is referred to as a study routine. study habits. study skills. a study schedul

vesna_86 [32]

Answer:

A study routine

Explanation:

6 0

3 years ago

Read 2 more answers

Henry is troubleshooting a network connection and wants to see if he can connect to the server on his network. Which Microsoft c

Lemur [1.5K]

Answer:

The command to use to check if he can connect to the server is the ping command.

Explanation:

The ping command is a network testing command to verify that one computer can reach or communicate with another computer on the network.

In Microsoft, the ping command is used in the command prompt window.

The ping command sends an Internet Control Message Protocol or ICMP Echo request or packets to another computer on the network and waits for a reply. The reply either informs you of the time it took to communicate with the other computer or inform you that there was no response.

4 0

3 years ago

A computer has a cache and main memory. 20 ns are required to reference a word that is in the cache. If the word is in main memo

Alecsey [184]

Answer:

$T_{average} =12026ns$

Explanation:

Given Information:

$T_{cache}=20 ns$

$T_{main}=60ns$

$T_{disk} =12ms=12,000,000ns$

$hit_{cache} =0.9$

$miss_{cache} =1-0.9=0.10$

$hit_{main} =0.99$

$miss_{main} =1-0.99=0.01$

There are 3 possible cases

1. Location of reference word is in cache

$T_{cache}*hit_{cache} =20*0.9=18ns$

2. Location of reference word is not in cache but in main memory

$(T_{cache}+T_{main})*(miss_{cache}*hit_{main}) =(20+60)*(0.10*0.99)=7.92ns$

3. Location of reference word is neither in cache nor in main memory

$(T_{cache}+T_{main}+T_{disk})*(miss_{cache}*miss_{main})$

$(20+60+12,000,000)*(0.10*0.01)=12000.08 ns$

The average time required to access a referenced word on this system is simply the sum of above 3 cases

$T_{average} =18+7.92+12000.08=12026ns$

5 0

3 years ago

Zahid needs to ensure that the text flows around an image instead of the image being placed on a separate line as the text. Whic

erica [24]

Answer:

I believe the answer is He can't do this on the layout dialog box

Explanation:

You use the format tab for text wrapping.

( Sorry if I'm wrong )

7 0

2 years ago

Read 2 more answers

What allows your computer to communicate over a network and access the Internet?

geniusboy [140]

Answer:

To connect to the Internet and other computers on a network, a computer must have a NIC (network interface card) installed.

Explanation:

A network cable plugged into the NIC on one end and plugged into a cable modem, DSL modem, router, or switch can allow a computer to access the Internet and connect to other computers. ISPs (Internet service providers)

5 0

2 years ago