Data Science Flashcards
what is a row?
the line of cells going across the screen and is labelled with numbers
what is a column?
line of cells going up and down and is labelled with letters.
What is a cell?
a cell is a box, they all have their own individual cell references (eg D6)
what is a spreadsheet?
are like big electric notebooks that help you to organise data and can perform calculations for you based in that data.
what does a cell reference like ‘C5’ indicate in a spreading?
it is in the third column and the fifth row
what arithmetic operation is represented by =A1+B1
addition
what function would you use to find the total sales for a range of cells in a spreadsheet?
sum
what type of chart is best suited for showing trends over time?
line chart
if you want to predict future sales based on past data in a spreadsheet what skill would you need to use?
interpreting data
what feature would you use on a spreadsheet to hide certain rows based on specific criteria?
filter
how would you arrange data in a spreadsheet from largest to smallest values in a particular column?
by using the sort function
in a spreadsheet what does B4 refer to?
the cell in the second column and fourth row
if u want to refer to the cell in the third column and fifth row, what cell reference would you use ?
C5
What arithimetic operation is represented by the formula “=A1+B1” in a spreadsheet?
addition
If you want to subtract the value in cell B2 from the value in cell A2, what formula would you use?
=A2-B2
