Ask Your Question
0

how to compose a spreadsheet

asked 2019-07-21 21:48:18 +0200

ginabella67 gravatar image

Never have composed a spreadsheet i.e. # of columns etc. Please help STEP BY STEP!! Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-07-22 00:47:45 +0200

lazarus477 gravatar image

updated 2019-07-22 00:49:44 +0200

  1. Decide one what data you want to store and or analyze.
    1. Define the field names for the data and enter these horizontally, vertically, or both ways.
    2. Enter data in the cells that make up the rows and columns of the spreadsheet.
    3. Add formulas in the formular bar to compute values based on entered values.
    4. Apply formatting to data such as currency and date formats, to name a couple.
    5. Next to get some visually appealing structure and design make use of visual elements such as grid lines and text areas.
    6. Add graphs to graph out data.

The list goes on but that is one way of looking at how one creates a spreadsheet. Next I suggest you to google up some examples of spread sheets and also watch some videos on the subject. The handbook for LibreOffice Calc is here: https://documentation.libreoffice.org/en/english-documentation/calc/

For good instructive videos watch these: https://thefrugalcomputerguy.com/seriespg.php?ser=10

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-21 21:48:18 +0200

Seen: 35 times

Last updated: Jul 22