NHS data excel

Question 1

Difference between Count and CountA?

Answer 1

CountA counts everything

Count is only numerical values

Question 2

How to use Sort formula for a table?

Answer 2

=SORT(select the data, number of the column you want to sort by, -1 or 1 for ascending or decesending)

=SORTBY does the same thing just instead of numbering the column you highlight it

Question 3

How to use COUNTIF?

Answer 3

wanted all test scores above 80

Do =COUNTIF(select range, “>=80”)

Question 4

What do you use to fix a value?

Answer 4

J$5

Question 5

How to make all text correct format with capitals and spacing?

Answer 5

Trim(proper(which cells))

Question 6

How to use Vlookup?

Answer 6

used to find values in a catalogue

Useful

Question 7

How to build a PIVOT table?

Answer 7

Insert Pivot table

Put values want to see in values section, can click on drop down if want to order by sum, average or count

Put other values in columns or rows to order data

Question 8

How to use slicers with pivot table?

Answer 8

Go to pivot table analysis

Go filters

Put slicers in, are basically filters for your charts to look at specific outcomes

Insert timeline is a slicer just for dates

Question 9

How do you update pivot table if put more data in it?

Answer 9

Use refresh

Question 10

How do an array calculation?

Answer 10

Use ctrl shift enter when you have done a formula

Question 11

How to find list of unique values?

Answer 11

=UNIQUE(

Question 12

How to use XLOOKUP?

Answer 12

=XLOOKUP(cell that tells you what your searching for, the cells you are selecting from, the cells you want your value from)