Excel flashcards: Mix B
10 cards, free and without an account. Practise another mix of the ribbon, functions, error messages, shortcuts and terms.
Mix BWhere do you find this in the ribbon?
Stop anyone from adding, deleting or renaming worksheets.
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?Stop anyone from adding, deleting or renaming worksheets.
Review > Protect Workbook That protects the structure of the workbook: which sheets there are, not what's in them.
What does this formula give?=ROUNDUP(2.512,1)
2.6 ROUNDUP always goes up, even for a tiny remainder.
Which function do you use?You're looking for the price that goes with a product code. The codes are on the left of your table.
VLOOKUP =VLOOKUP(E2,$A$2:$C$50,3,FALSE) reads the third column for an exact match.
What's going wrong here?=SUMM(A1:A5)
There's no function called SUMM. This gives #NAME?. Write =SUM(A1:A5).
What does this error mean?#NAME?
Excel doesn't recognise a name in your formula. Check the spelling, and put text in quotation marks.
Which shortcut do you use?To the last cell you've used
Ctrl + End The same on Windows and on a Mac.
What does this mean?Formula
A calculation that starts with an = sign, such as =A2*B2.
Where do you find this in the ribbon?Get back an earlier, automatically saved version of this workbook.
File > Info > Manage Workbook That's where you'll find the versions Excel saved automatically along the way.
What does this formula give?=INT(7.9)
7 INT drops the decimal places and always rounds down.
Which function do you use?If the score is above 50, it should say Pass, and otherwise Fail.
IF =IF(B2>50,"Pass","Fail")