Post your doubts here for any problem in ict practical

[razor blade]

Stuck anywhere in ICT practical.
Just type your doubt and inshaallah I will clear it.
(database, spreadsheet, document productin, presentation(ppt))

 

[Loodynagy]

Stuck anywhere in ICT practical.
Just type your doubt and inshaallah I will clear it.
(database, spreadsheet, document productin, presentation(ppt))

Yeah, I'd appreciate your help. I have a few doubts. Should I?

 

[razor blade]

Yeah, I'd appreciate your help. I have a few doubts. Should I?

sure

 

[Loodynagy]

"include both absolute and relative referencing and must not use a named range" suggest?

 

[razor blade]

do you know first how to use the vlookup function?

 

[Loodynagy]

do you know first how to use the vlookup function?

Yeah, I suppose.
=VLOOKUP(Here I'll select the cell with the lookup value, then the table array, then the column number, then either True, or False)
Is there anything more, you can tell me ofcourse.

 

[razor blade]

thats it, nothing more to include,
when including absolute referencing this means that the range specified will not change
relative referencing is the opposite
in the table array, if the lookup values are in order (ascending or descending), you can use "true" as a named range or just leave it blank thats the meaning of
"dont use a named range"
hope this helps

 

[razor blade]

+ if the lookup values are not in order use "false" as the named range and dont leave it blank
i guess if the question says dont use a named range the values will be in order
just check it

 

[Loodynagy]

Ahaaa! I get it now!
But I thought that "dont use a named range" would mean, selecting a range and giving it a range name and then using it in the formula. Or is that wrong?

 

[razor blade]

dont give any new named ranges

 

[Loodynagy]

Aha, alright! Thank you! I'd come back to you if I had any more doubts. I really appreciate your help.

 

[razor blade]

No problem

 

[Loodynagy]

Do you have any notes that you think I can rely on?

 

[razor blade]

I think there is no need for notes
if you have any doubts in this practical just post here

 

[Loodynagy]

You sure you'll be available whenever, cuz I don't wanna disturb you :3

 

[razor blade]

No its okay
No problem at all

 

[razor blade]

But just one question
Are you from egypt?

 

[Loodynagy]

Thank you

http://papers.xtremepapers.com/CIE/...unication Technology (0417)/0417_w10_qp_3.pdf
Q.14

 

[Loodynagy]

But just one question
Are you from egypt?

Yeah..?

 

[razor blade]

Use =AVG formula