Q1. In a new worksheet, what's the correct formula to reference Cell A1 from the ALPHA worksheet?
- =ALPHA?A1
- =A1
- ="ALPHA"A1
- =ALPHA!A1
- ='ALPHA'A1
Q2. What does clicking and dragging the fill handle indicated by the cursor below do?
The Answers
Answer 1: The formula to reference Cell A1 from ALPHA worksheet is =ALPHA!A1
So, the correct answer is the fourth option =ALPHA!A1
Answer 2: Copy the formula to other cells
By clicking and dragging the fill handle, the formula in the first cell will get copied to the cells below to which the fill handle dragged. So, this makes our work easier. The formula need to be entered in the first cell only. We will get all answers by copying this formula to other cells using this method.
Which resource management task deploys or activates personnel and resources?