Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

s2 computing > Spreadsheets > Flashcards

Spreadsheets Flashcards

1
Q

what are columns?

A

vertical groups of boxes

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

What is a row?

A

Rows are groups of boxes going horizontal.

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

what is a cell?

A

A cell is one box, with an individual cell reference.

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

What is a cell reference?

A

a cell reference marks the placing of each individual cell. eg. A1 is the first cell on the spreadsheet.

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

What is the correct formula for addition? eg. B5 and K8

A

=B5+K8

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

What is the correct formula for substitution?
eg. D2 O9

A

= D2-O9

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

What is the correct formula for division. eg A3 B7

A

=A3/B7

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

What is the correct formula for multiplying?
eg A6 C8

A

=A6*C8

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

What is the correct formula for finding the sum?A1 A4

A

=SUM(A1:A4)

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

What is the correct formula to find the average. B1 B4

A

=AVERAGE(B1:B4)

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

What is the correct formula for finding the min. A5 A7

A

= MIN(A5:A7)

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

What is the correct formula for finding the max

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

s2 computing (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions