Question

Using the libreoffice calc prepare a spreadsheet showing monthly expenses under the given heads .Also calculate the total expense on each item
•school fee
•stationery
•mobile bill
•electricity bill​

Answer 1

Answer:

ESSENTIAL LibreOffice: Tutorials for Teachers

Copyright © Bernard John Poole, 2014. All rights reserved

108

4

INTRODUCTION TO THE CALC SPREADSHEET

Preparing a Grade book

LEARNING OUTCOMES

This tutorial will help you understand what a spreadsheet is and where a spreadsheet might come

• in useful for classroom management. Specifically you will learn about the following topics.

• Helpful hints for understanding the basic concepts of a spreadsheet, including:

• cells, rows and columns

• cell coordinates

• entering data into a spreadsheet cell

• Setting up labels, including:

• setting column widths

• aligning data in cells

• entering column and row labels

• Creating and copying formulas

• Making changes in a spreadsheet

• inserting rows and columns

• deleting rows and columns

• Producing a printed copy of the contents of a spreadsheet document

• Saving a backup copy of your work

• Appreciating the power of spreadsheet templates