Chapter 4 – Rearranging Data in Excel
Class 6 Interactive Quiz
A. Multiple Choice Questions
1. Which Excel option allows you to change the display format of a date?
Format Cells
Data Validation
Text to Columns
2. Which key lets you edit cell content directly?
F5
F2
Ctrl + E
3. Which feature automatically fills data based on a pattern?
AutoFill
Flash Fill
Fill Series
B. True or False
4. Auto Fill allows you to fill cells with consecutive data.
True
False
5. You can copy data by selecting the cells and pressing Ctrl + X.
True
False
6. To enter numbers as text, begin the entry with an apostrophe (').
True
False
C. Drag and Drop
Drag each shortcut into the correct action.
Ctrl + Z
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + Y
Ctrl + E
7. Undo →
Drop here
8. Copy →
Drop here
9. Redo →
Drop here
10. Paste →
Drop here
11. Cut →
Drop here
12. Flash Fill →
Drop here
D. Match the Following
Choose the correct match.
13. Range
-- Select --
Automatically fills data based on a pattern
Copies data from one place to another
Changes the position of data without deleting
Fills a series of data (e.g., months or numbers)
Group of contiguous cells
14. Auto Fill
-- Select --
Automatically fills data based on a pattern
Copies data from one place to another
Changes the position of data without deleting
Fills a series of data (e.g., months or numbers)
Group of contiguous cells
15. Moving Data
-- Select --
Automatically fills data based on a pattern
Copies data from one place to another
Changes the position of data without deleting
Fills a series of data (e.g., months or numbers)
Group of contiguous cells
16. Flash Fill
-- Select --
Automatically fills data based on a pattern
Copies data from one place to another
Changes the position of data without deleting
Fills a series of data (e.g., months or numbers)
Group of contiguous cells
17. Copying Data
-- Select --
Automatically fills data based on a pattern
Copies data from one place to another
Changes the position of data without deleting
Fills a series of data (e.g., months or numbers)
Group of contiguous cells
Submit Quiz
Reset