Assignment 7 Mathematics and Logical Function

 

Table by using cell reference

Function use

Concatenate function :- this function helps to combine text of 2 different cell into one cell.

Row function :- Row function is use to return the row number of a reference.

Function use :-

=Concatenate ($B$16," X ",Row(A1)," = ",$B$16*Row(E1))

Concatenate :- this function is use to merge text to two or more cells into one cell.

$B$16 :- Dependent cell reference

" X " :- Symbol of X for showing Multiplication sign.

Row function:- this function is use to print row number.

" = " :- Symbol of = for showing Equal sign.

Row (A1) :- reference of row.

Function use in Table 1

=$B$16* Row (A1)

$B$16 :- Dependent cell

Firstly select the cell in which you want to perform the function.

Ex:- A1 (Active cell)

After that type "Equal symbol" and select "Dependent cell " then type " Row " function after then type " Multiplication" symbol.

Ex :- $B$16* Row (A1)

Note :- freeze dependent cell with Dollar.

Applying the function then press enter key.

After applying the function drag it as long as you have.

Function use in Table 2

First of all select the he cell which you want to perform the function.

Ex:- (Active cell)

After that type "equal" symbol and type the function. That is " Concatenate".

Ex:- =Concatenate()

Then select the " Dependent cell" and freeze that cell.

Ex :- = Concatenate ($B$16,...

After that type symbol of " X " with space then insert coma (,) and type Row function and give the reference.

Ex :- Row (A1)

Then type symbol of " Equal ",(=) with space then insert coma (,) and select the Dependent cell and freeze that with Dollar.

Ex :- $B$16

After that type symbol of Multiplication (*) and type The row function again and give the reference (E1).

Ex :- Row (E1)

Note :-

Note :- This is the question which is related to The cell referencing. I'll type any number and it's table should be display on the screen in both way.

Which are mention in table -1 and table -2

Use some steps to solve this.