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
svet-max [94.6K]
3 years ago
14

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

Computers and Technology
2 answers:
yan [13]3 years ago
4 0

Answer:

B

C

E

Edgenuity

gtnhenbr [62]3 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.

<em>Method 1: Using Absolute Cell Reference</em>

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

<em>Method 2: Move The Formula</em>

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
what would be the result of running these two lines of code
MatroZZZ [7]

Answer:

Jog

Explanation:

The variable options is a list containing 5 string values

options = ["ski", "surf", "jog", "bike", "hike"]

Indexing in python starts from 0 ; hence the index values of the list values are :

0 - ski

1 - surf

2 - jog

3 - bike

4 - hike

The statement ;

print(options[2]) means print the string at index 2 in the list named options

The string at index 2 is jog ;

Hence, the string jog is printed.

8 0
3 years ago
What is a good rule of thumb for how much white space you should have in a flyer or poster
almond37 [142]
Poster because if you have that much space....well what I do is calculate it by the centimeters in square divide:)
6 0
3 years ago
Read 2 more answers
Sarah has prepared a project document about the small and medium-sized companies in the United States. While proofreading, she r
erik [133]
The answer is F7. When you click F7 it highlights key words.<span />
3 0
3 years ago
Read 2 more answers
Ping pc-b from a command prompt window on pc-a. were the pings successful? why?
love history [14]
If the pings are successful you are either on the same subnet and everything is configured correctly or ICMP echo is enabled on the router which it should be by default internally. Externally, ICMP can/should be disabled to avoid DOS attacks.
7 0
3 years ago
Write any four causes of cyber crime
jenyasd209 [6]
A Lack of Empathy
The Victim Deserves It
Self-loathing
It Becomes an Addiction
7 0
3 years ago
Other questions:
  • Why is timbre an important musical element?
    7·2 answers
  • A manufacturer of machine tools creates a spreadsheet of tools and the cost for those. The spreadsheet has four fields: name of
    13·1 answer
  • What is the best anime that you like the most (give me 3 plz)
    7·2 answers
  • Create a class, using separate files, named DynamicGrades. (2 points) This class has three data members: an int that represents
    13·1 answer
  • A digital certificate system: Group of answer choices uses digital signatures to validate a user's identity. is used primarily b
    13·1 answer
  • Which function will add a name to a list of baseball players in Python?
    13·2 answers
  • Supp guees how your dayyyyyyyyyyyy
    10·2 answers
  • The printer prints 16 pages every minute. How many pages are printed in 6 minutes?
    14·2 answers
  • Group of programs are software ​
    6·2 answers
  • Java question
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!