2dn test I

What should we put into excel cells in order to create "SUMA" function?

• "=SUMA'

  
  

• +SUMA

  
  

• =SUMA

  
  

How to make the program know that you are creating a table, not just fill up "random" cells?

• Select the specific part and click "Shift"+"F"

  
  

• Select the specific part and select the "table"button and select "utwórz tabelę".

  
  

• Select the specific part and click "Ctrl" +"Shift"+"F"

What is the purpose of the functions in excel. (two answers are correct)

• To make data more clear.

  
  

• To fill up cells with specific data easier.

  
  

• To automate some changes.

  
  

What does IF function do?

• Outputs a specific data depending on whether previous function works or not.

  
  

• Output a specific data basing on how many of them is true.

  
  

How to create a chart.

• First create a table with data, then, after you highlight the specific data, create a (fitting) chart.

• it's not possible to create a chart in Excel

  
  

• Create a chart and fill it up by hand with the specific data.,

  
  

You can find charts in Insert section

• True

  
  
  

• False

  
  

  
  

How to sum cells

• Press all the cells and click + symbol

  
  

• Select two cells that you want to sum and use =SUM(cell #1 ; cell#2)

  
  

• Drag the cursor down the row and press enter

  
  

In order to change the fonts you should:

• Select words you want to change, click on colour of words and change the font

  
  

• Select words you want to change, press insert icons and change the font

  
  

• Select words you want to change, go to fonts and click the font you like

  
  

In what purpose you use function =ŚREDNIA

• To show how many people did something

  
  

• To calculate the biggest number

  
  

• To calculate the average number

  
  

How to merge

• use $ sign

  
  

• use # sign

  
  

• use function merge