Question

Suppose you need to use value of cell b4 from sheet1 in sheet3.Choose the cell address that that you will write in sheet3.

Sheet1!b4

Sheet3!b4

b4!sheet1

b4!sheet3​

Answer 1

ANSWER

Select a cell, and then type an arithmetic operator (+, -, *, or /). Select another cell, and then press the F4 key to make that cell reference absolute. You can continue to press F4 to have Excel cycle through the different reference types.

• Mark as brainliest please..