Data Science

Question 1

What is the vertical arrangement of data in a spreadsheet called?

Answer 1

Column

Question 2

What is the intersection of a row and a column in a spreadsheet called?

Answer 2

Cell

Question 3

What is the horizontal arrangement of data in a spreadsheet called?

Answer 3

Row

Question 4

In a spreadsheet, what does “B4” refer to?

Answer 4

The cell in the second column and fourth row.

Question 5

If u want to refer to the cell in the third column and fifth row, what cell reference would you use?

Answer 5

C5

Question 6

What arithmetic operation is represented by the formula “=A1+B1” in a spreadsheet?

Answer 6

Addition

Question 7

If you want to subtract the value in cell B2 from the value in cell A2, what formula would you use?

Answer 7

=A2-B2

Question 8

Which function would you use to find the total of a range of cells in a spreadsheet?

Answer 8

SUM

Question 9

What function would you use to find the highest value in a range of cells?

Answer 9

MAX

Question 10

If you want to calculate the average of a range of cells, which function would you use?

Answer 10

AVERAGE

Question 11

Which type of chart is best suited for showing the distribution of categories as parts of a whole?

Answer 11

Pie chart

Question 12

What type of chart is commonly used to compare quantities across categories?

Answer 12

Bar chart

Question 13

If you want to represent trends over time, which type of chart would you use?

Answer 13

Line chart