Excel flashcards: Mix A
10 cards, free and without an account. Practise a mix of the ribbon, functions, error messages, shortcuts and terms.
Mix AWhere do you find this in the ribbon?
Make sure no one can change the formulas on this sheet any more.
The cards in this mix
Try them yourself first. Click a card when you want to see the answer.
Where do you find this in the ribbon?Make sure no one can change the formulas on this sheet any more.
Review > Protect Sheet Once the sheet is protected, nobody can change the locked cells. Cells you unlock first can still be filled in.
What does this formula give?=ROUND(2.567,1)
2.6 ROUND looks at the next digit: 6 rounds the 5 up.
Which function do you use?You want to add up a column of numbers.
SUM =SUM(B2:B10) adds up everything from B2 to B10.
What's going wrong here?=COUNTIF(B2:B9,>500)
The comparison isn't in quotation marks. Write =COUNTIF(B2:B9,">500").
What does this error mean?#N/A
A lookup function can't find the value. Check for hidden spaces and for numbers stored as text.
Which shortcut do you use?Jump to the end of your list
Ctrl + arrow on Windows Cmd + arrow on a Mac.
What does this mean?Cell
The box where a row and a column cross. Every cell has an address, such as B3.
Where do you find this in the ribbon?Let others fill in the range B2:B10 on a protected sheet anyway.
Review > Allow Edit Ranges That frees up part of the sheet, with its own password if you like. It works as soon as the sheet is protected.
What does this formula give?=ROUNDDOWN(2.567,1)
2.5 ROUNDDOWN always goes down, whatever the next digit is.
Which function do you use?You want to know how much a customer paid on average.
AVERAGE =AVERAGE(B2:B10). An empty cell doesn't count, a 0 does.