25 Questions
What is the primary function of the fill button in the editing menu?
To auto-fill a series of cells with a pattern
Where can the fill button be found in the software?
Home → editing → Fill
What values do you need to enter in the dialog box to use the fill button?
Increment value and stop value
What is the importance of selecting the row or column in the fill button dialog box?
To identify the cell range to fill
What is the first step to hide a worksheet or a group of worksheets?
Select the required sheets
What happens when you click the fill button without selecting a row or column?
The fill button will not work
What mouse button is used to access the Hide command?
Right mouse button
What happens when we select the required sheets and click on them with the right mouse button?
We can choose the Hide command
What is the purpose of the Hide command?
To make a worksheet invisible
Can we hide a single worksheet or a group of worksheets?
Either a single worksheet or a group of worksheets
What do you need to right-click on to show hidden worksheets?
The name of any worksheet
What appears after choosing the Unhide command?
The dialog box for showing worksheets
What is the purpose of the Unhide command?
To show hidden worksheets
Where do you find the Unhide command?
In the context menu of a worksheet
What happens when you right-click on the name of a worksheet?
A context menu appears with various options
What happens to the contents of cells when merging cells in Excel?
The contents are deleted except for the top left cell
What is a pre-requisite for merging cells in Excel?
The cells must be empty
When merging cells, which cell's contents are preserved in Excel?
The top left cell
What happens if you merge cells that contain data in Excel?
The data is deleted except for the top left cell
Why is it important to empty cells before merging them in Excel?
To preserve the contents of all cells
What is the correct sequence to merge a group of cells?
Select the required cells, then go to the main page, then Alignment, then Merge and Center
Where can you find the Merge and Center option?
In the Alignment section
What happens when you click again after merging cells?
The merge will be cancelled
What is the first step to merge a group of cells?
Select the required cells
What can you do to reverse the merge of cells?
Click again on the Merge and Center button
Study Notes
Filling a Series
- Use the "Fill" button to fill a series, located in Home → Editing → Fill → Series
- Enter the increment value and stop value in the dialog box
- Ensure the row or column is selected
Hiding and Showing Worksheets
- Hide a worksheet or group of worksheets by right-clicking on the selected sheets and choosing "Hide"
- Show hidden worksheets by right-clicking on any worksheet, choosing "Unhide", and selecting the desired worksheet from the dialog box
Merging Cells
- Cells must be empty before merging, otherwise Excel will delete contents except for the top-left cell
- Merge cells by selecting the required cells, going to the main page, then Alignment, and finally "Merge and Center"
- Cancel the merge by clicking again
This quiz covers basic Microsoft Excel features, including filling series and hiding/showing worksheets. Test your skills in Excel editing and formatting.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free