Chapter 4: Spreadsheets

?
Spreadsheets
Contains one or more worksheets. It is used to create/manipulate data. It can also preform calaculations.
1 of 7
Conditional Formatting
This is where a cell’s value dictates what happens to the styling (border, shading, background, etc) of a cell
2 of 7
Data Validation
Ensure data being entered is suitable, a certain data type is entered, if invalid data is inputted, an error message is displayed.
3 of 7
Vlookup
Looks at a value in a table and returns a specific value from a specified column in the same row.
4 of 7
Examples of Data Types
Number, Currency, Percentage, Date
5 of 7
Absolute Cell Referencing
cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed
6 of 7
Cell
The intersetion of a row & a column.
7 of 7

Other cards in this set

Card 2

Front

This is where a cell’s value dictates what happens to the styling (border, shading, background, etc) of a cell

Back

Conditional Formatting

Card 3

Front

Ensure data being entered is suitable, a certain data type is entered, if invalid data is inputted, an error message is displayed.

Back

Preview of the back of card 3

Card 4

Front

Looks at a value in a table and returns a specific value from a specified column in the same row.

Back

Preview of the back of card 4

Card 5

Front

Number, Currency, Percentage, Date

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »