Spreadsheet Flashcards

1
Q

What is merge and centre

A

Merges cells together and puts text in the centre

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

What is conditional formatting

A

Setting formatting in a cell to change based on the value in the cell

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

What is data type

A

Setting values in the cell to set data type

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

What is validation

A

Setting cells to only expect certain values

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

What is a temples

A

Creating a set layout for others to use and amend for example account documents in business

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

What is the sum function

A

Add all cells in a cell range

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

What is the max function

A

Finds the highest value in a given cell range

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

What is the min function

A

Finds the lowest value in a given cell range

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

What is the average function

A

Calculates the mean of values in a set range

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

What is the if function

A

If uses a logical operator to check if the cell in question meets a set criteria and the outputs a value if the condition is met or a different value if it is not met.

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

What is the Vlookup function

A

Vlookup look up a value in a table and outputs value
from another column in the same table. It is made up of

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

How to write a Vlookup function

A

=Vlookup(the lookup cell, the range for the table to search in, the column to display, True (exact match) or false (approximate match))

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

What is a macro

A

Small automated programs that perform repetitive tasks. In spreadsheets these are mainly used with buttons to move sheets or print

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

What is absolute cell referencing

A

When you use the fill handle to replicate the formula the cell references will automatically update to match the row/column this is called relative cell referencing.

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