Specific features of a spreadsheet

HideShow resource information

Specific features of a spreadsheet

Labels: used for titles, headings, names and for identifying columns or rows of data

Data: values (text or number) that you enter into a spreadsheet, the data that would be used for calculations or for producing graphs and charts

Formatting cells

Printing formulae

Layout of worksheets

Cell gridlines: feint lines used to mark the cells. They can be removed by:

  • Tools menu, Options, View tab, Gridlines to remove the tick, OK

Linked sheets: called a 3D reference

Automatic recalculation

Sorting rows/columns: ascending order or descending order

1 of 2

Continued

Graphs and charts:

  • easier to interpret results
  • line, bar, pie, scatter graphs
  • remember to include a title for the graph that explains its purpose clearly, label each axis, add a legend, use appropriate colours and shading when producing a graph
2 of 2

Comments

No comments have yet been made

Similar Design & Technology: Systems & Control Technology resources:

See all Design & Technology: Systems & Control Technology resources »See all resources »