functions in Spreadsheet

More formulas with the "Spreadsheet" application - Tutorials Ordissimo (Ordissimo v4)

In this guide, we'll go into more detail about using the "Spreadsheet" app and look at how to create a daily expense table. Keep reading to learn more...

Compatibility : Ordissimo
Level: Introduction
Estimated time: 30'

Together we'll see how to complete various operations using the "Spreadsheet" application. We'll look at specific formulas for subtracting, dividing, or multiplying lists of numbers. To practice, we will simulate a record of monthly expenses. 

1Open the "Spreadsheet" application.

On the home screen, click on "Spreadsheet". 

Open Spreadsheet

2Enter a title.

a. Place your cursor. 
Once your spreadsheet is open, use your mouse to click on the upper left hand "A1" cell. 

click on cell A1

b. Write the title.
Use your keyboard to type the title.

Write the text

3Create a table.

a. Create three columns. 
Now, you'd like to enter your monthly expenses. To do so, create three columns: "Date", "Expenses", "Amount". 

Create three columns

b. Enter data.
Enter your data into the table.

Fill out datas

4Format the title.

a. Select the cell.
You would like to emphasize the title by putting it in bold. Do this by clicking first on the cell in question (A1). 

select the cell

b. Click on "Style" then "Bold".
Then, click on "Style" at the top of your screen before choose the "Bold" option. 

click on style

c. Here is your title in bold.

put the text in bold

5Insert borders.

a. Select the zone you'd like to frame. 
By holding down your mouse, select the cells around which you'd like to create a border. 

insert border

b. Click on "Border".
Once the zone is selected, click on the "Border" icon then choose "All borders". 

click on border

6Access functions.

a. Click on the arrow in the upper right hand corner. 
Click on the arrow to the top right of the toolbar in order to access the "Functions" button.

access to functions

b. Position your cursor.
You'd like to calculate the total of your monthly expenses for February. Place your mouse in the cell where you'd like to execute this function. 

Place the cursor

c. Click on the "Functions" icon.
Click on the "Functions" icon to choose the correct formula.   

Click on Functions

d. Choose the "Sum" formula.
After selecting the "Sum" formula, it will appear in the chosen cell. Place your cursor between the parentheses and select cells to include in the calculation by holding and dragging your mouse. 

choose function sum

e. Click on the "Enter" key.
Next, click on the "Enter" key on your keyboard. The calculation takes place and the sum of the cells should appear.

click on key board enter

7Sum up your grocery expenses for the month. 

a. Use the sum formula.
Now you intend to calculate how much you've spent on groceries this month. Click on the cell in which you'd like to calculate this total and press "=", located to the top right of your keyboard. Next, click on the cell with your total expenses (C12) then on the "-" key and the "(" key, in that order. Using your mouse, click on each cell containing expenses for something other than groceries, making sure to add a "+" between each one (the "+" key is located to the bottom right of your keyboard). Once you've added up these cells, press on the ")" key and finally the "Enter" key. 

sum of grocery's costs

b. Total amount.
The total amount appears: "90".

total sum

8Other monthly expenses.

Now you'd like to calculate your remaining monthly expenses. Subtract the following cells: C12- C13 (total amount minus the amount spent on groceries). 

other expenses

9Estimate your annual budget. 

a. Multiply your monthly expenses by 12.
Finally, you'd like to estimate your annual budget. Click on the cell in which you'd like to calculate this product and press "=" on your keyboard. Complete the calculation by multiplying your total expenses for the month of February (C12) by 12 using the following formula: "=C12*12"

estimate budget

b. Total amount.
Here is the total amount: 2,760 euros for 12 months. 

total cost

10Save the document. 

a. Click on the "Save" document.
You'd like to save your spreadsheet. Click on the arrow to the top left of the screen, then on the "Save" icon, also in the top left hand corner. 

save your doc click on save

b. Enter a title for your document.
A window will appear: enter a title for your spreadsheet and click on "Save". 

write the title

c. My documents.
You'll find your document by returning to the "Docs" folder of the "Documents" directory. 

doc in Documents file

Here you'll find your saved spreadsheet and can open it at any time to update your calculations. 


Find other practical guides on "Spreadsheet" here: Introducing the Spreadsheet application !