WorksheetsExcel Fun for Grade 4
Total questions: 9
Worksheet time: 5mins
What does the 'All Border' function do in Excel?
It highlights the selected cells in yellow.
It applies a border to all sides of the selected cells.
It removes all borders from the selected cells.
It adds a shadow effect to the selected cells.
How do you merge two or more cells in Excel?
Select the cells, then press 'Ctrl + M'.
Right-click the cells and choose 'Format Cells'.
Select the cells, then click 'Merge & Center' in the Home tab.
Highlight the cells and click 'Insert Row' in the menu.
What is the process to rename a worksheet in Excel?
Double-click the worksheet tab and enter the new name.
Right-click the worksheet tab, select 'Rename', type the new name, and press Enter.
Select the worksheet, go to the Home tab, and click 'Change Name'.
Press Ctrl + N to open a new worksheet and rename it.
What steps do you take to save your Excel file?
Click 'File' > 'Save' or use Ctrl + S.
Click 'Edit' > 'Save As' or use Alt + S.
Go to 'View' > 'Export' or use Shift + E.
Select 'Home' > 'Download' or press Ctrl + D.
How can you drag cells to copy their content?
Right-click and select 'Copy' from the menu.
Press Ctrl+C to copy the cell content.
Click and drag the fill handle at the bottom right corner of the cell.
Use the 'Edit' menu to duplicate the cell.
What is the method to change the color of a cell in Excel?
Click the cell, go to 'View' tab, select 'Freeze Panes', and apply changes.
Right-click the cell, select 'Format Cells', and choose a border.
Select the cell, go to 'Data' tab, click 'Sort', and choose an option.
Select the cell, go to 'Home' tab, click 'Fill Color', and choose a color.
Can you explain what happens when you use the 'Merge' function?
The 'Merge' function only highlight cell
collect sum
add border
A. It combines data from two or more datasets based on a common column
Why is it important to save your work in Excel?
It is important to save your work in Excel to prevent data loss.
You should save your work in Excel to share it with others easily.
Saving your work help to open new file
Saving your work in Excel helps in improving software performance.
How do you know if a cell has a border applied?
background color.
Borders are appliedon text only
line around the cell
it is filled with color or shading.
