Print Layout and Filters

What is the purpose of the filter option in Excel?

• To arrange data in a specific order

• To temporarily hide rows that do not meet certain criteria

• To delete unwanted rows from the dataset

• To protect the data from being edited

Which tab is typically used to apply a filter in Excel?

• Insert

• Home

• Data

• Review

How can you preview how your document will look when printed in Excel?

• Go to View > Page Layout

• Go to File > Print to enter Print Preview mode

• Use the "Show Formulas" button

• Go to Home > Print Preview

In Excel, when you apply a filter to a column, the data outside the filter is permanently deleted.

• TRUE

• FALSE

Arrange the steps in the correct order to apply a filter in Excel:

a. Select the data range.

b. Click on the "Data" tab.

c. Use the dropdown arrow in the header to filter the data.

d. Choose the "Filter" option.

• a-b-c-d

• a-b-d-c

• c-a-b-d

• b-d-a-c

Which of the following Page Setup options would allow you to print the sheet in landscape orientation?

• Page Layout > Orientation > Portrait

• Page Layout > Orientation > Landscape

• File > Print > Orientation

• View > Page Break Preview

If you want to print the Excel file without page breaks showing, which of the following should you do in Page Setup?

• Use the "Print Preview" option

• Set the scaling option to "Fit to 1 page"

• Choose "Page Breaks" in the sheet view

• Select "No Scaling"

Which filter type is specifically designed for filtering text values in Excel?

• Advanced filter

• Text filter

• Numeric filter

• Conditional filter

What is the best way to filter a column for values that meet multiple conditions?

• Use the "Custom AutoFilter" option

• Use a pivot table

• Use the "Remove Duplicates" option

• Create a new worksheet

What happens when you clear a filter in Excel?

• The filter dropdown disappears

• All filtered rows are permanently deleted

• The hidden rows become visible again

• The table format is removed