Please enable JavaScript.
Coggle requires JavaScript to display documents.
L06 Revision - Coggle Diagram
L06 Revision
features of spreadsheet
rows and columns
through a spreadsheet's grid system of rows and columns, all of your information is neatly organized in one easy-to-read space
Most data management programs arrange data in such a way that each type of data is represented by a column with a label at the top and each row contains the specific data for one type of item. A collection of data arranged in rows and columns is a table.
chart
a type of chart in spreadsheets which is updated when the range of the sources data for the chart is updated
charts enable you to visually compare multiple sets of data. Charts can help people better understand and remember information. Many people understand a picture more quickly than blocks of text
macros
adding buttons to a spreadsheet in order to carry out repetitive tasks e.g create a button to print out a particular table of the spreadsheets
Businesses use macros to perform functions like high level calculations, forecasting or basic formatting activities. A task that may take hours to do manually, is cut to several minutes!
living worksheet
data can be used across sheets in order to process and analyse it in a new formats.often used on completed spreadsheets in order to try out new scenarios or to find details on how to achieve an certain goal
Put similar items in the same column Design the data so that all rows have similar items in the same column.
Keep a range of data separate Leave at least one blank column and one blank row between a related data range and other data on the worksheet
database
report
often a more human friendly method at presenting the results of a quary.its also creates a printable version of a quary result in case a hard copy is needed
Reports will provide important detail that can be used to help develop future forecasts, marketing plans, guide budget planning and improve decision-making. Managers also use business reports to track progress and growth, identify trends or any irregularities that may need further investigation
input frames
A main advantage of frames is that it allows the user to view multiple documents within a single Web page. It is possible to load pages from different servers in a single frameset. The concern that older browsers do not support frames can be addressed using the <noframe> tag
-
-