(4) Excel Questions from newbie

[stonewall68]

Don't Laugh, but I bought a DVD to try and learn Excel.
I can't find the answer to these questions.
Questions:

1. To provide users with a drop down list of valid values for data entry in a cell would most likely be achieved by using?
A. Data Validation
B. Conditional formatting
C. A pivot table
D. a Macro

2. Select the correct description for a VatRate?
A. It's a built in function
B. Cell Label
C. A format Style
D. Name Range

3. Enter the formula to create an absolute cell reference to the contents of the cell C12 on Sheet 5 into Cell E4 on Sheet 4.

Write the Cell __________________________


4. To Link the contents of cell A4 on sheet 2 into cell B9 on sheet 3 , we would write the following formula.
A. =Sheet2!B9
B. =Sheet3!B9
C. =Sheet2!B4

 

[NARAYANK991]

Hi ,

My answers would be :

1. Data Validation

2. Named Range

3. I assume that what the question is asking for is :

What formula would be entered in cell C12 in tab Sheet5 , to reference cell E4 in tab Sheet4 ?

My answer would be : =Sheet4!$E$4

The $ signs make the reference absolute. Without them , the reference would be a relative one.

4. I assume that what the question is asking for is :

What formula would be entered in cell A4 in tab Sheet2 , to reference cell B9 in tab Sheet3 ?

My answer would be : =Sheet3!B9

Narayan

 

[stonewall68]

Thank you Very Much! You have been a Huge Help!
These questions have been driving me crazy.
Thank you so much for the help.

Hi ,

My answers would be :

1. Data Validation

2. Named Range

3. I assume that what the question is asking for is :

What formula would be entered in cell C12 in tab Sheet5 , to reference cell E4 in tab Sheet4 ?

My answer would be : =Sheet4!$E$4

4. I assume that what the question is asking for is :

What formula would be entered in cell A4 in tab Sheet2 , to reference cell B9 in tab Sheet3 ?

My answer would be : =Sheet3!B9

Narayan