All categories

3 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]3 years ago

4 0

Answer:

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

I have tried many times to find a gaming setup for $4k. I have tried many websites but they are not working for my liking. Any o

Vikentia [17]

I would try going to pcpartpicker.com and build your pc from there, and after you’ve done that take your remaining budget to find whatever else you need for your setup

8 0

2 years ago

What is the difference, if any, between a project manager and a producer on a digital media production team? A project manager o

Flauer [41]

Answer:

A project manager just oversees the creative element, while a producer oversees the entire project.

It is B

7 0

3 years ago

Zola is very skilled with Microsoft and Apple, and she knows different methods of programming. This knowledge will help make Zol

hammer [34]

I believe programmer would be your answer! If there is a multiple choice, please tell me in the comments of this answer!

3 0

3 years ago

Read 2 more answers

in this third journal assignment, you will think about your work as the product tester for the travel booking software and how y

Temka [501]

My early test cases were greatly aided by the user stories. They gave a thorough summary of what a user can expect from the product as well as data on their past expectations and experiences.

Explanation:

The intricacies of the user's surroundings and the exact technological needs for the product, however, were absent from the user stories.

Greetings, Software Developers!

I'm trying to create more in-depth test cases for my job as a quality test for the online travel software. To do this, I'd like to learn more about the environment of the user and the software's technical requirements. Please give me more details about the technical specs and the user environment.

I'm grateful.

[Name]

To know more about testing
brainly.com/question/22710306
#SPJ4

3 0

1 year ago

c Write a program that simulates a magic square using 3 one dimensional parallel arrays of integer type. Each one the arrays cor

Komok [63]

Answer:

hope this helps and do consider giving a brainliest to the ans if it helped.

Explanation:

//program to check if the entered grid is magic square or not

/**c++ standard libraries

#include<bits/stdc++.h>

using namespace std;

/**function to check whether the entered grid is magic square or not

int isMagicSquare(int arr[3][3]){

int i,j,sum=0,sum1=0,rsum,csum;

for(i=0;i<3;i++){

sum+=arr[i][i];

sum1+=arr[i][2-i];

}

if(sum!=sum1){

return 0;

}

for(i=0;i<3;i++){

rsum=0;

csum=0;

for(j=0;j<3;j++){

rsum+=arr[i][j];

csum+=arr[j][i];

}

if(sum!=rsum){

return 0;

}

if(sum!=csum){

return 0;

}

return 1;

}

/** main function to get user entries and

* call function

* and print output

int main(){

int i,j,arr[3][3]={0};

for(i=0;i<3;i++){

for(j=0;j<3;j++){

cout<<"Enter the number for row "<<i<<" and column "<<j<<" : ";

cin>>arr[i][j];

}

int ret = isMagicSquare(arr);

if(ret==1){

cout<<"This is a Lo Shu magic square"<<endl;

}

else{

cout<<"This is not a Lo Shu magic square"<<endl;

}

return 0;

}

7 0

3 years ago