Component 2: Level 2 DIT: LA (B) Processing Methods 1

When completing a formulae for a VLOOKUP it will pick up data from where?

Another sheet / workbook /

Complete this formulae. This is a VLOOKUP and will be picking up data from the "datasheet"

=VLOOKUP(C3,....................A2:R110,2)

You have entered a formula that you copied down as shown but it did not give you the correct data. This is because it is missing what?

• no = sign

• a dollar sign to represent absolute cell references

• spaces

• correct pick up of cells

The freeze pane function allows us to do what?

• hide certain rows and columns

• scroll through sections needed

• View certain sections

• Set areas that are always in view

Hiding or unhiding cells allows us to ............ what anyone using the spreadsheet can see

Adding Cell comments allows..... (choose 2 answers)

• Users to be able to understand certain formulas and functions

• Know who has worked on the spreadsheet

• Set reminders so that other users can use the spreadsheet with ease

• Navigate around the spreadsheet

What is absolute cell referencing?

• Refers to a cell based on the position of the cell we’re writing the reference in. e.g. one cell to the left.

• where you use a symbol

• It is where the formula will refer to an exact specific cell

• Where you drop down the formula so that it copies everything