Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Administration > Spreadsheets > Flashcards

Spreadsheets Flashcards

1
Q

What are features of a spreadsheet?

A

Perform calculations using formulae | Producing charts | Data can be formatted | Data can be sorted and filtered

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

What are advantages of a spreadsheet?

A

Makes it easier to analyse data using IF and Pivot Tables | Calculations are more accurate allowing for better decision making | Data is automatically updated if inputs are changed | Using formatting can improve readability | Charts can help to illustrate trends and patterns visually

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

What is the purpose of sum?

A

Addition

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

What is the purpose of average?

A

Finds the mean

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

What is the purpose of min?

A

Lowest value in range of cells

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

What is the purpose of max?

A

Largest value in a range of cells

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

What is the purpose of count?

A

Counts the number of numerical cells

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

What is the purpose of counta?

A

Count the number of text cells

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

What is the purpose of countblank?

A

Counts the number of blank cells

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

What is the purpose of sumif?

A

Sums a range of cells based on a criteria

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

What is the purpose of countif?

A

Counts cells based on a criteria

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

What is the purpose of nested if?

A

Combines multiple IF statements

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

What is the purpose of rounding?

A

Rounds a decimal place

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

What is the purpose of vlookup?

A

Finds data/values vertically

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

What is the purpose of hlookup?

A

Finds data/values horizontally

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

What is the purpose of naming?

A

Gives clear and relevant labels

17
Q

What is the purpose of sorting?

A

Organise data in a logical order to help decision making or improve readability

18
Q

What is the purpose of filtering?

A

Displays data that meets criteria | Improves organisation, simplifies and allows for easier comparison

19
Q

What is the purpose of comments?

A

Enables additional information to give clarification

20
Q

What is the purpose of pivot tables?

A

Data analysis, clear ways to summarise data | Filters and calculates without complex formulas

20
Q

What is the purpose of charts?

A

Allows visual comparison of data | allows for easier analysis/tracking of trends

21
Q

What is the purpose of conditional formatting?

A

Enhances visually | Draws attention to key information

22
Q

What is the purpose of 3D formula?

A

Allows calculations to be performed across multiple sheets in the same structure

Administration (13 decks)

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