All categories

3 years ago

Pick the correct statements regarding cell references.

Computers and Technology

2 answers:

shusha [124]3 years ago

7 0

Statement two and three is correct.

Statement 1 is incorrect. A relative reference changes when a formula is copied to another cell while Absolute references remain constant. However, it is safe to say that an absolute address can be preceded by a $ sign before both the row and the column values. It is designated by the addition of a dollar sign either before the column reference, the row reference, or both. Statement C is also correct. A mixed reference is a combination of relative and absolute reference and the formula (= A1 + $B$2) is an example of a mixed cell reference.

Lady_Fox [76]3 years ago

3 0

Answer:

1) A relative reference will retain its references when copied to another cell.

2) An absolute address has a $ sign before both the row and the column values.

3) = A1 + $B$2 is an example of a mixed cell reference.

4) The address 7B is invalid.

Explanation:

We know that a call by reference method can be defined as a method of providing different arguments to a function and then that function copies the address of an argument into the formal pattern.

You might be interested in

What are the layers in the internet protocol stack? what are the principle responsibilities of each of these layers?

Andrew [12]

1: Application
2: Presentation
3:Session
4: Transport
5:Network
6: Data link
7: Physical

Application is a Interface Layer and responsible Layer

3 0

3 years ago

Because of the internet, travel agents now focus more on computers than they do on customer relationships.

jasenka [17]

Answer:

true

Explanation:

there are a lot of easier ways to access clients through computers with the internet.

6 0

2 years ago

Read 2 more answers

Which is a safe Internet behavior?

Westkost [7]

Don’t give out personal information

7 0

3 years ago

Which keyboard shortcut opens the find and replace dialog box to the replace tab?

Vsevolod [243]

Answer:

CTRL + F

Explanation:

usually CTRL + F but it would depend on the program

3 0

2 years ago

Write a MATLAB script m-file to compute the ISS given an array of 6 AIS scores, which represent the most severe injuries to each

Dmitrij [34]

Answer:

The Matlab code is as given in the explanation, paste the code in the new script file, save it and run.

Explanation:

The code is as follows

Code:

%% Initialization of the code

% The code takes an array of six AIS scores of the form [AIS1 AIS2 AIS3

% AIS4 AIS5 AIS6] of order 1x6.

AIS=input('Please enter the AIS array of the form [AIS1 AIS2 AIS3 AIS4 AIS5 AIS6]');%taking input of the array

AISs=sort(AIS,'descend');%sorting the array in the descending order

iss=(AISs(1,1)^2)+(AISs(1,2)^2)+(AISs(1,3)^2);%Calculating the ISS

disp(['The injury severity score (ISS) for the entered array is ', num2str(iss)])%Displaying the output

Output:

Please enter the AIS array of the form [AIS1 AIS2 AIS3 AIS4 AIS5 AIS6][3 0 4 5 3 0];

The injury severity score (ISS) for the entered array is 50

4 0

3 years ago