Spreadsheets X Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

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

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In a spreadsheet, what does “B4” refer to?
Back: The cell in the second column and fourth row.

A

The cell in the second column and fourth row.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

C5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Addition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

A2-B2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

SUM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

MAX

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

AVERAGE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Pie Chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What type of chart is commonly used to compare qualities across categories

A

Bar chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

If you want to represent trends over time which type of chart would you do

A

Line chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly