Gabriel needs to create a formula that does not change when it is copied to cell b2. which formula should he create?

1 answer:

azamat3 years ago

4 0

=sum(1+1) it's a simple formula and won't change from any cells. Another you can do is to put a value in a specific cell, let's say, C3. Then have a formula that says, =sum(C3+2). But if you REALLY wanna impress someone - put a value in A1 - anything at all. Then put this formula in any other cell you want. If you change cells, you get a different answer. If you change the # in A1, you get different answers, all thanks to the RANDom function. =SUM((RAND()*100)+A1)

You might be interested in

Name and describe the two (2) broad categories of files

fenix001 [56]

If it’s computer files, that would be System Software and Application software.

“The System Software is the programs that allow the computer to function and access the functionality of the hardware. Systems software sole function is the control of the operation of the computer.

Applications software is the term used for programs that enable the user to achieve specific tasks such as create a document, use a database or produce a spreadsheet.”

8 0

3 years ago

If you are trying move a hard drive from a non-working computer to a working computer for the purposes of accessing the data on

Llana [10]

You must have an administrator password before you can access the drive <span />

5 0

3 years ago

3. By default, Blender® remembers your last 32 actions and allows you to undo them one at a time by pressing CTRL+Z. (1 point)

Setler [38]

Answers:

(3) True
(4) Num Lock

Explanations:
(3) To undo any task in most of the softwares including Blender, CTRL + Z is used. If you want to double check, go to preference -> Input -> Search for undo. You would see CTRL + Z shortcut there for one time undo (as shown in the picture 1 attached.) Hence (TRUE).

(4) As in blender, during the scene creation, the designers usually use top, left, right or bottom view. Blender has the built-in keys set for those views. As you can see in the second image that the Top view is set to NumPad 7 (likewise others set to other numbers). In order to use the those numpad numbers, you must turn on the NumLock! Hence NumLock is the answer.