Question
Create a file in LibreOffice Calc showing the daily circulation of library documents (atleast for the one week) with separate columns for fine and books reserved. Add a bar chart representing the data.
Answer :
Word Count : 642
To begin, create a new spreadsheet in LibreOffice Calc and add the following headers in the first row:
- Date
- Number of Books Borrowed
- Fine Collected
- Number of Books Reserved
In the rows below, add the data for each day of the week, with the corresponding number of books borrowed, fine collected, and number of books reserved for each day. Here is an example of what the spreadsheet might look like:
| Date | Number of Books Borrowed | Fine Collected | Number of Books Reserved |
|---|---|---|---|
| 2023-07-15 | 45 | 350 | 12 |
| 2023-07-16 | 38 | 225 | 10 |
| 2023-07-17 | 52 | 450 | 15 |