WorksheetsExcel M quiz
Total questions: 20
Worksheet time: 40mins
What is the primary purpose of Conditional Formatting in Excel?
To sort data alphabetically
To automatically change the formatting of cells based on set conditions
To create pivot tables for data analysis
Which of the following is NOT a common use of Conditional Formatting?
Highlighting cells with values above a certain threshold
Changing the background color of alternate rows
Encrypting sensitive data in a cell
How do you activate Conditional Formatting in Excel?
By right-clicking on a cell and selecting "Insert"
By going to the "Home" tab and selecting "Conditional Formatting" from the "Styles" group
By selecting "File" and then "Options" to configure advanced settings
Which of the following conditions for Conditional Formatting compares two columns for duplicate values?
"Format cells that contain"
"New Formatting Rule"
"Duplicate Values"
What is the primary function of the Freeze Panes feature in Excel?
To lock cells for editing
To keep specific rows or columns visible when scrolling
To merge multiple cells into one
Where can you find the Freeze Panes option in Excel?
Under the "Insert" tab
Under the "Data" tab
Under the "View" tab
If you want to freeze the first row and the first column, which Freeze Panes option should you select?
Freeze Top Row
Freeze First Column
Freeze Panes
What happens when you apply Freeze Panes to a worksheet?
The selected rows or columns are duplicated
The selected rows or columns are hidden
The selected rows or columns remain visible while scrolling through the worksheet
What can you add to the header and footer section when printing an Excel worksheet?
Macros and VBA code
Page numbers, date, and file name
Formulas and Functions
Which view must you be in to see and edit the header and footer in Excel?
Normal View
Page Layout View
Data View
Which option should you use if you want to fit all columns on a single page when printing an Excel worksheet?
Set Print Area
Scale to Fit Columns
Page Break Preview
How can you save an Excel worksheet as a PDF using built-in Excel features?
Print -> Choose "Microsoft Print to PDF" as the printer
Save As -> Choose "CSV" from the dropdown
Data -> Export as PDF
What is the first step in creating a chart in Excel?
Select the "Insert" tab and choose a chart type
Select the data you want to chart
Add chart labels and titles
Which of the following is NOT a common type of chart available in Excel?
Pie Chart
Line Chart
Mind Map
Where can you find the option to create charts in Excel?
Under the "Formulas" tab
Under the "Insert" tab
Under the "Data" tab
What does a pie chart typically represent?
Time-based trends
Proportions of a whole
Sequential steps in a process
What is the primary purpose of using Sparklines in Excel?
To provide detailed analytics
To show a trend in a single cell
To filter data based on criteria
Where can you find the option to insert Sparklines in Excel?
Under the "Data" tab
Under the "Insert" tab
Under the "Formulas" tab
Which of the following is NOT a type of Sparkline available in Excel?
Line
Column
Radar
What characters are NOT allowed in a table name in Excel?
Spaces and special characters like "! or @"
Numbers and underscores
Letters and hyphens
