All categories

4 years ago

Samuel wanted to paste the value and the formula attached from cell B6 to cell F16

Computers and Technology

2 answers:

yan [13]4 years ago

4 0

Answer:

Edgenuity

gtnhenbr [62]4 years ago

3 0

Answer:

See Explanation

Explanation:

Given

Source: B6

Location: F16

I'll list two methods which Samuel can use to achieve his goal

Take for instance, the formula in cell B6 is =SUM(B1:B5)

This style of referencing is called relative cell referencing

If Samuel copies and the pastes the formula like this =SUM(B1:B5), the cell name will be changed in the destination cell; meaning that he wont be able to retain the formula and value.

Method 1: Using Absolute Cell Reference

Sam will have to alter the formula in cell B6 to =SUM($B$1:$B$5)

With this, he has switched from relative reference to absolute reference;

Irrespective of the location Sam wants to paste the formula (as long as the formula is in the same work book), the formula and the value won't change.

So, the formula will still maintain its original text and value, when pasted in cell F16

Method 2: Move The Formula

Alternatively, Sam can move the formula from cell B6 to cell F16.

This can be achieved by

1. Select cell B6

2. Click on Cut on the home tab (or press Ctrl + X)

3. Select cell F16

4. Click on Paste on the home tab (or press Ctrl + V)

You might be interested in

A type of address translation in which a gateway has a pool of public ip addresses that it is free to assign to a local host whe

krok68 [10]

Dynamic Network Address Translation (DNAT)

7 0

3 years ago

Remi always works on several projects at a time. He has thousands of files saved on his computer. Yet he always seems to be able

astraxan [27]

Answer

the micmethod <-----made by myself

Explanation:

1. alphabetical order

2.put in empty folder

3.name folder after file put file in hard drive

4.a hard drive is also a usb

5.make hard drive into necklace and wear all the time

6. now u never lose it

4 0

3 years ago

Will give brainliest and good amount of points, no false answers.

nlexa [21]

The problem with the swap function is that it loses the value at the first index, as soon as it gets overwritten by the value at the second index. This happens in the first statement. To fix it, you need a helper variable.

First you're going to "park" the index at the first index in that helper variable, then you can safely overwrite it with the value at the second index. Then finally you can write the parked value to the second index:

var swap = function(array, firstIndex, secondIndex) {

let helper = array[firstIndex];

array[firstIndex] = array[secondIndex];

array[secondIndex] = helper;

};

I hope this makes sense to you.

7 0

4 years ago

true or false : The incorrect attitude towards driving is the cause of most collisions among teenage drivers.

natulia [17]

That is true your state of mind is what matters most

4 0

3 years ago

Read 2 more answers

PLS HELP ASAP) Omar is using the web to do research on diabetes. he needs to ensure that all of the information he finds regardi

LUCKY_DIMON [66]

Not sure on the first question, but the second would be answer choice a: Travel.state.gov since a website with .gov at the end tend to be trustworthy sources

4 0

3 years ago