Spreadsheet skills

This document looks at spreadsheet skills; it looks at the more complex skills such as v-lookup, if function, drop down list, validation rule, importing data etc;

HideShow resource information
Preview of Spreadsheet skills

First 74 words of the document:

V-lookup (vertical lookup)
Looks up values of a cell vertically in a table.
Displays the data corresponding to the cell of selected and the chosen
The formula is "=vlookup(look up value ,table, column number)"
Condition Formatting
Allows you to change the appearance of cell depending on certain conditions
Highlights your information and makes it easier for someone to read the significant
information

Other pages in this set

Page 2

Preview of page 2

Here's a taster:

Data Validation Rule
-
Validation rule lets you provide a
message to help users who input data
that is not valid.
- This restricts what users can enter as it requires specific value
Link Sheet
1) Click the cell where you would like to link the information and type
=
2) Then select the sheet and cell which you would like to link your information and press enter.…read more

Page 3

Preview of page 3

Here's a taster:

Then select list on the allow option.
3) Select your source. This is what options you would like your user to choose from. In this case the options are
food so I highlight the table of different food available and press ok.
4)
This is what your work should
look like with the included drop
down list.…read more

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »