Quiz
Find and Replace and Sorting Quiz
This quiz has question types that open in the usual player.
Questions in this quiz (10)
1When sorting data in Excel you can only ever sort one column at a time.
- ATrue
- BFalse
2What key do you press with 'F' to quickly bring up the Find dialog box?
- ACTRL
- BCTRL + ALT
- CALT
- DSHIFT
3Ascending means . . .
- ALargest to smallest
- BSmallest to largest
4When sorting text, A-Z is the same as 'smallest to largest' when sorting numbers.
- ATrue
- BFalse
5You were trying to replace the number 1 with the word Yes in one column in your Excel spreadsheet. However, it replaced every occurrence of the number 1 in the spreadsheet. Where do you click to make sure just the number on its own is replaced?
- AMatch case
- BMatch entire cell contents
6You should quickly click on the [blank_start]Undo[blank_end] button if you have sorted your data or used Find/Replace and the result is not what you wanted.
- AUndo
7Find & Replace is available in which of the following applications.
- AWord
- BExcel
- CPowerPoint
- DOutlook
8When you want to replace text using Find/Replace you have to do it all at once.
- AYes. Click on the Replace All button.
- BNo. You can click on Find Next then Replace or Find Next again until you have replaced all the items you want.
9Descending means -
'largest to smallest' when sorting numbers and 'Z to A' when sorting text.- ATrue
- BFalse
10Which application is this Find & Replace dialog box from?
Word, Excel or PowerPoint?
Click on the orange dot and choose from the drop down list.
- AExcel
- BWord
- CPowerPoint
Information
- Description
- Quiz on Find and Replace and Sorting Quiz, created by Liz Riggs on 18/06/2019.
- Author
- Liz Riggs
- Language
- English
- Views
- 28
- Tags
- Rating
- No ratings yet Rate this quiz