Information systems
Shortcut keys Types of charts
Copy: ctrl + C Column: categorical/discrete (not continous, set-intervals)
Save: ctrl + S Line: continuous data (infinite possibilities like time)
Find: ctrl + F Pie: proportional data
Paste: ctrl + V Bar: sideways column chart used to compare things over
Cut: ctrl + X time when changes are large
Bold: ctrl + B Stock: stock prices
Italic: ctrl + I Surface: 3D surface that connects data points
Underline: ctrl + U Bubble: Scatter chart variation
Doughnut: pie chart variation
Radar: plots values around axis (each data category has its
own axis)
, Error messages:
Basic formulas:
If, and, or statements
All = AND(argument1, argument2,..)
At elast one = OR(argument1, argument2,…)
*Default for or statement is true/false
If = IF(condition, trueAction, falseAction)
Condition: eg X>7
TrueAction: When true this will display, use quotation marks when using a string
FalseAction: (optinoal statement) Executes when not true, eg “ “ → shows blank space
Vlookup
=VLOOKUP(lookupValue, database, columnNumber, true/false)
LookupValue: value searching for Eg Student number
Database: database, excluding headings
Shortcut keys Types of charts
Copy: ctrl + C Column: categorical/discrete (not continous, set-intervals)
Save: ctrl + S Line: continuous data (infinite possibilities like time)
Find: ctrl + F Pie: proportional data
Paste: ctrl + V Bar: sideways column chart used to compare things over
Cut: ctrl + X time when changes are large
Bold: ctrl + B Stock: stock prices
Italic: ctrl + I Surface: 3D surface that connects data points
Underline: ctrl + U Bubble: Scatter chart variation
Doughnut: pie chart variation
Radar: plots values around axis (each data category has its
own axis)
, Error messages:
Basic formulas:
If, and, or statements
All = AND(argument1, argument2,..)
At elast one = OR(argument1, argument2,…)
*Default for or statement is true/false
If = IF(condition, trueAction, falseAction)
Condition: eg X>7
TrueAction: When true this will display, use quotation marks when using a string
FalseAction: (optinoal statement) Executes when not true, eg “ “ → shows blank space
Vlookup
=VLOOKUP(lookupValue, database, columnNumber, true/false)
LookupValue: value searching for Eg Student number
Database: database, excluding headings
