Spreadsheets X Flashcards
What is the vertical arrangement of data in a spreadsheet called?
Column
What is the intersection of a row and a column in a spreadsheet called?
Cell
What is the horizontal arrangement of data in a spreadsheet called?
Row
In a spreadsheet, what does “B4” refer to?
Back: The cell in the second column and fourth row.
The cell in the second column and fourth row.
If you want to refer to the cell in the third column and fifth row, what cell reference would you use?
C5
What arithmetic 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
Which function would you use to find the total of a range of cells in a spreadsheet?
SUM
What function would you use to find the highest value in a range of cells?
MAX
If you want to calculate the average of a range of cells, which function would you use?
AVERAGE
Which type of chart is best suited for showing the distribution of categories as parts of a whole?
Pie Chart
What type of chart is commonly used to compare qualities across categories
Bar chart
If you want to represent trends over time which type of chart would you do
Line chart
