Misc. Flashcards
Normal View
Default view, collection of cells arranged in the work area
Page Layout View
Fine-tune a worksheet with many charts or a huge amount of data to achieve pro looking results
Page Break Preview View
Similar to P.L except you can set the area that is to be set as a page after inserting P.B
Custom View
Selected areas, like certain row and column
Full Screen View
Workbook covers entire screen. to get back tabs FILE > RESTORE
Chart Guidelines
- One message per chart
- Label X and Y axis, lines, bars, pie wedges
- Make the most. imp. text largest and most imp. sections darkest
- Bars and Columns wider than spaces between
- Be accurate, compare only like variables
- Eliminate unnecessary deets like grid lines, data points, etc.
- Use max. 4 colours per visual
Bar Charts
Emphasizes the comparison between items at a fixed period of time, also includes cylinder, cone and pyramid sub-types
Column Charts
Emphasizes variations over a period of time, also includes cylinder, cone and pyramid subtypes
Line Charts
Relationship of the changes in the data over a period of time
Pie Charts
One chart data series, shows the relationship of the parts to the whole
Area Charts
Shows the relative importance of values over time
XY (Scatter) Charts
Useful for showing a correlation among the data points that may not be easy to see from the data alone
Elements Of A Chart
Chart Area Plot Area Horizontal and Vertical Axis Chart and Axis title Data Points Data Label Legend
Page Layout options
Margins Orientations Page Size Define Print Area Page Headers and footers Specify Background Hide or display grid lines
Different Datatypes
Numeric Alphanumeric Binary Date Time Other variable types
Numeric types
BOOLEAN, TINYINT, SMALLINT, BIGINT, NUMERIC, DECIMAL, REAL, FLOAT, DOUBLE
Alphanumeric types
LONGVARCHAR, VARCHAR, CHAR, VARCHAR_IGNORECASE
Binary types
LONGVARBINARY, BINARY, VARBINARY
Date time
Date, Time, Timestamp
Other Data Types
Other/Object (Serialised Java objects)
