Question

Worksheet for cell referencing:

1) What is the cell address of the following:
a)1 row and 26th col
b) 4th col and 4th row
c) 5th row ( static) and 10 col
d) 27th row and 27th col (both static)
e) 7th row and 214 col (static)
f) 52nd col and 65l col
g) 81st col and 71 col
2) Write the formula
1)If the formula in E4 = G4+ H4 What is the formula in j4

2)If the formula in F5= $D6 + E$4 What is the formula in G7

3) If the formula in 110 = D4+ SH$11 What is the formula in F6
​

Answer 1

Answer:

a)1 row and 26th col

Explanation:

The H4 column formula is =IF (G4<F4,G4+1,G4)-F4 and it also works great. The same goes for K4 with =IF(J4<I4,J4+1. 2) $12F5 ;155.524Hz E3_ EQU $11E4 ... $FA, $46, $1B, $40, $5E, $4F, $05 L5284 FCB $E8, $17, $29, $00, $B5, $23, $04, $20, $67, 3) Item 6110-110-0001 - Reader Service for Blind ... purposes of calculating employer contribution rates or employee