spreadsheets

spreadsheets

1. what is VLOOKUP used for?

   • vlookup is used tpo organise data that is in columns.
   • what does it stand for?
     • it stands for vertical lookup

2. what is hlokup used for?

   • hlookup is used for woking with data that is horiontal.
   • what does hlookup stand for?
     • it stands for horizontal lookup.

3. what is nested if

   • a nested if statement is an if statement within an if statement.
   • whats the difference between nested if and if statements?
   • what is the difference between nested if statements and if statements?

4. if statement

   • what is an if satement