WorksheetsExercise Spreadsheet P6
Total questions: 15
Worksheet time: 56mins
What is done using the Sort & Filter tool in Spreadsheet?
Delete unwanted data
Calculate the amount of data
Arrange data in alphabetical order
Show only selected data
What are the functions of MAX and MIN in a Spreadsheet?
Calculate the total data
Save file
Find the highest and lowest value in the data
Delete filter
What is done by clicking 'Boy' after selecting 'Gender' in step 8?
Show only male data
Remove filter
Save file
Show only female data
What is done by clicking 'Select All' after selecting 'Gender' in step 7?
Delete filter
Show only female data
Show all data without filter
Save file
What is done by clicking 'Clear' after selecting 'Sort & Filter' in step 1?
Show all data without filter
Show only female data
Save file
Delete filter
What is done by clicking 'OK' after selecting 'Boy' in step 9?
Delete filter
Show all data without filter
Show only male data
Save file
What is done by clicking 'OK' after selecting 'Girl' in step 10?
Save the file
Show only female data
Show all data without filter
Remove filter
What does clicking 'OK' after selecting 'Remove Filters' do in step 2?
Show only female data
Remove filter
Show all data without filter
Save file
What is the purpose of clicking 'Confirm' after selecting 'Male' in step 9?
Delete the filter
Show all data without filter
Show only male data
Save the file
What action is performed by clicking 'Confirm' after selecting 'Female' in step 10?
Save the file
Show only female data
Show all data without filter
Remove the filter
What is the function of clicking 'Reset' after selecting 'Sort & Filter' in step 1?
Show all data without filter
Show only female data
Save the file
Delete the filter
What feature can be used to view selected data in a spreadsheet?
Sort
Filter
Format
Chart
What is the primary function of a spreadsheet software?
Data analysis
Data entry
Data visualization
Data printing
What are some common functions used in spreadsheet software?
SUM
AVERAGE
MAX
MIN
What feature of spreadsheet software involves modifying page setup?
Formatting cells
Creating charts
Modifying page setup
Using formulas
What advanced feature of spreadsheet software allows for data filtering and sorting?
Pivot Tables
Conditional Formatting
Data Validation
Sort & Filter tool
How can the Sort & Filter tool be used to filter data in spreadsheet software?
How can auto-filter be used to view selected data in spreadsheet software?
What are some advanced features for modifying page setup in spreadsheet software?
What are some advanced features of spreadsheet software that can be used to enhance the printing of worksheets?
How can the COUNT function be used to calculate the number of students in a spreadsheet?
How can functions for maximum, minimum, and count be used in spreadsheet software?
What is the next step after inputting the number of copies and clicking on print?
Select the printer
Review the print settings
Wait for the print job to finish
Collect the printed worksheets
What is the method for modifying page setup in the Marks workbook?
Click the file tab, then print, and select page orientation, percentage, and paper size for printing.
Go to the View tab and select Page Setup, then choose the desired settings.
Access the Page Layout tab and adjust the page setup options as needed.
Navigate to the Home tab, click on Page Setup, and customize the printing settings.
What action should be taken to print only a part of the worksheet?
Select cells A1 to E13 and set the print area
Click the Page Layout tab and set the print area
Select cells A1 to E13 and click the Page Layout tab
Set the print area and click the Page Layout tab
What is the action to remove the print area in Excel?
Click the Home tab, then print area, and clear the print area.
Click the Insert tab, then print area, and clear the print area.
Click the Data tab, then print area, and clear the print area.
Click the Page Layout tab, then print area, and clear the print area.
What is the method for modifying page setup in the Marks workbook?
Clicking the Page Layout tab
Selecting page orientation, percentage, and paper size for printing
Opening the Marks workbook
Clicking the Save button
What is the method to modify the page setup in Activity 5?
Click on the Page Setup arrow and open the Page Setup Dialog box.
Double-click on the Page Setup arrow.
Right-click on the Page Setup arrow and select Page Setup.
Go to the File menu and select Page Setup.
What is the main activity in Unit 5?
Opening the Marks workbook
Clicking the file tab
Printing a worksheet
Closing the Marks workbook
What are the steps for modifying page setup including page orientation, percentage, and paper size in Method 2 of Activity 6?
How can you select specific cells to print and remove print area in a worksheet?
How can the print area be removed and cleared in Activity 9?
What are the steps for printing a worksheet, including selecting cells, print preview, and number of copies?
How can teachers demonstrate printing using the computer's attached printer?
What are the steps for modifying page setup, including page orientation, percentage, and paper size?
