A workbook is the main Excel file. It can contain multiple worksheets, charts, and other objects. When you save an Excel file, you are saving the workbook.
What does a worksheet mainly contain in Excel
A Only pictures
B Only formulas
C Only macros
D Rows and columns
A worksheet is a grid made of rows and columns. Their intersections form cells where you enter text, numbers, dates, or formulas for data handling.
Which part shows sheet names like Sheet1, Sheet2
A Sheet tabs
B Formula bar
C Name box
D Status bar
Sheet tabs appear at the bottom of the workbook window. They display worksheet names and allow you to switch, rename, insert, delete, or move worksheets easily.
What happens when you rename a sheet
A Data gets deleted
B Workbook format changes
C Sheet label changes
D Row numbers change
Renaming only changes the worksheet’s tab name for better identification. The data, formulas, formatting, and references inside the sheet remain unchanged.
Which action adds a new worksheet quickly
A Ctrl + P
B Click + icon
C Shift + F1
D Alt + Enter
Clicking the plus (+) button near sheet tabs inserts a new worksheet. It is a quick way to expand the workbook without changing existing sheet data.
Why do we use Freeze Panes
A Lock rows/columns view
B Hide gridlines
C Remove formulas
D Increase file size
Freeze Panes keeps selected rows or columns visible while scrolling. This is useful for headings like column names so you can read data clearly in long sheets.
What does Print Area define
A Cells to calculate
B Cells to format
C Cells to print
D Cells to hide
Print Area sets a specific range that Excel will print. Only that chosen section appears on paper or PDF, even if there is other data in the worksheet.
Which feature controls margins and page orientation
A Conditional format
B Data validation
C Flash fill
D Page Setup
Page Setup lets you set margins, orientation (portrait/landscape), paper size, scaling, and headers/footers. It helps make worksheets print neatly and professionally.
What is a cell in Excel
A Row-column intersection
B A file name
C A chart area
D A toolbar button
A cell is where a row and column meet, like A1 or B5. It is the basic unit where you enter values, labels, or formulas for calculations.
A group of selected cells is called
A Workbook
B Ribbon
C Range
D Clipboard
A range is a block of one or more cells selected together, such as A1:A10. Ranges are used in formulas, formatting, sorting, and many data tools.
Which tool copies a pattern down quickly
A Goal Seek
B Solver
C Text Wrap
D Autofill
Autofill uses the fill handle to extend series like numbers, dates, or formulas. It saves time by repeating patterns and adjusting references automatically.
Where do you type or edit formulas
A Formula bar
B Sheet tab
C Status bar
D Scroll bar
The formula bar shows the content of the active cell and is commonly used to enter or edit formulas. It is helpful when formulas are long.
Which symbol must start a formula
A #
B @
C =
D &
Excel formulas begin with the equals sign. It tells Excel to calculate an expression instead of treating the entry as normal text or a simple value.
Which operator is used for multiplication
A +
B *
C /
D ^
The asterisk () is used for multiplication in Excel formulas. For example, =A1B1 multiplies the values in cells A1 and B1.
Relative reference changes when copied, like
A $A$1
B A$1
C A1
D $A1
A relative reference like A1 adjusts automatically when you copy the formula to another cell. This helps apply the same calculation pattern to multiple rows or columns.
Which reference stays fixed when copied
A A1
B A1:B1
C Sheet1!A1
D $A$1
An absolute reference uses dollar signs to lock row and column. When copied, $A$1 always points to the same cell, useful for constants like tax rates.
Mixed reference example is
A A$1
B A1
C $A$1
D A1:A10
A mixed reference locks either the row or column. In A$1, the row 1 stays fixed but the column changes when copied across.
Which function adds numbers in a range
A COUNT
B MAX
C SUM
D MIN
SUM totals values in selected cells. Example: =SUM(A1:A5) adds all numbers from A1 to A5, commonly used for totals and summaries.
Function to find average value is
A CONCAT
B AVERAGE
C ROUND
D IF
AVERAGE calculates the mean of numeric values. Example: =AVERAGE(B1:B10) adds values and divides by the count of numbers, ignoring blank cells.
Which function returns smallest number
A MAX
B COUNT
C MIN
D SUM
MIN finds the lowest numeric value in a range. It helps identify minimum marks, lowest sales, or smallest measurement quickly without manual checking.
Which function returns largest number
A MAX
B MIN
C ROUND
D IF
MAX gives the highest numeric value in a range. It is useful for finding top score, highest sales, or maximum value in a dataset.
Which function counts numeric cells
A COUNTA
B CONCAT
C COUNT
D MIN
COUNT counts only cells containing numbers. It ignores text and blanks. This is helpful when you want to know how many numeric entries are present.
IF function is mainly used for
A Sorting data
B Printing pages
C Drawing charts
D Logical decision
IF tests a condition and returns one value if TRUE and another if FALSE. Example: =IF(A1>=33,”Pass”,”Fail”) for basic result logic.
Which joins text from cells
A COUNT
B MAX
C CONCAT
D SUM
CONCAT combines text strings. For example, =CONCAT(A1,” “,B1) can join first name and last name. It helps create full labels or combined fields.
ROUND is used to
A Limit decimal places
B Remove duplicates
C Add sheet
D Hide columns
ROUND changes a number to a specified decimal places. Example: =ROUND(12.345,2) gives 12.35. It is useful for clean reporting and calculations.
Which tool sorts A to Z
A Filter
B Data validation
C Ascending sort
D Text to columns
Ascending sort arranges text from A to Z and numbers from smallest to largest. It helps organize lists like names, roll numbers, or amounts properly.
Sorting Z to A is called
A Flash fill
B Descending sort
C Remove duplicates
D Sparklines
Descending sort arranges text from Z to A and numbers from largest to smallest. It is useful to show highest values on top, like top sales.
What does Filter do in a table
A Shows matching rows
B Changes data type
C Deletes unwanted rows
D Locks cells
Filter displays only the rows that meet selected criteria and hides the rest temporarily. It does not delete data, so you can clear the filter anytime.
Purpose of Conditional Formatting is
A Protect workbook
B Insert new sheet
C Highlight based rules
D Create pivot table
Conditional Formatting changes cell appearance based on conditions, like values greater than 80. It helps quickly spot trends, high/low values, or duplicates visually.
Which is a conditional formatting style
A Page margins
B AutoCorrect
C Name manager
D Data bars
Data bars show a bar inside cells based on their values. Higher numbers display longer bars, making comparisons easy without reading every number.
Color scales in Excel are used to
A Merge files
B Print only titles
C Show value intensity
D Create dropdowns
Color scales apply colors based on cell values, like green for high and red for low. They help visualize patterns and ranges in data at a glance.
What does Remove Duplicates do
A Deletes duplicate entries
B Adds repeated rows
C Hides sheet tabs
D Splits columns
Remove Duplicates checks selected columns and deletes repeated records, keeping only unique rows. It helps clean lists like emails, IDs, or names quickly.
Text to Columns is used to
A Add new chart
B Round numbers
C Split cell content
D Protect sheet
Text to Columns divides one cell’s data into multiple columns based on delimiter like comma or space. It is useful when data comes as “Name,City”.
Flash Fill mainly works by
A Changing fonts
B Printing grid
C Locking workbook
D Detecting patterns
Flash Fill automatically fills values by recognizing patterns you start typing, like splitting names or formatting numbers. It saves time without needing formulas.
Which chart best shows trend over time
A Pie chart
B Line chart
C Doughnut chart
D Radar chart
Line charts show changes over time using connected points. They are ideal for months, years, or daily values to observe rising or falling trends clearly.
Which chart compares categories with bars
A Scatter plot
B Stock chart
C Bar chart
D Surface chart
Bar charts compare values across categories using horizontal bars. They are useful when category names are long and you want an easy visual comparison.
Column chart is mainly used to
A Show parts of whole
B Check spelling
C Import CSV
D Compare values
Column charts display vertical columns to compare values among categories. They are common for marks, sales, and counts because differences are easy to see.
Pie chart is best for showing
A Time trend
B Data distribution
C Parts of whole
D Text length
Pie charts show how each category contributes to a total. They work best with a few categories and when the sum represents 100% of the whole.
What is the chart legend
A Label for series
B Data table
C Axis line
D Print header
The legend identifies chart series by color or marker. It helps readers understand which line, bar, or slice belongs to which data series.
Data labels on a chart show
A File location
B Cell formatting
C Value on points
D Sheet protection
Data labels display values directly on chart elements like bars or points. They make charts easier to read without checking the data table separately.
Sparklines are
A Full-size charts
B Mini cell charts
C Pivot tables
D Macro buttons
Sparklines are small charts inside a single cell showing trends. They provide quick visual insight next to data, useful for dashboards and summaries.
Data validation is mainly used to
A Speed printing
B Create workbook
C Sort columns
D Restrict data entry
Data validation controls what users can enter in a cell, such as only numbers between 1 and 10. It reduces errors and keeps data consistent.
A dropdown list is created using
A Data validation
B Freeze panes
C Conditional format
D Page break
Data validation can create a dropdown list from a typed list or a cell range. Users can then choose valid values instead of typing, improving accuracy.
What is an Input Message in validation
A Chart title
B Print preview
C Entry guidance popup
D Error value
An input message appears when the cell is selected, guiding the user on what to enter. It improves correct data entry by showing short instructions.
Goal Seek is used to
A Get target result
B Find duplicates
C Create pivot chart
D Split text
Goal Seek changes one input cell to achieve a desired formula result. For example, it can find required marks or required sales to reach a target total.
Pivot table is mainly for
A Drawing shapes
B Writing macros
C Data summarization
D Printing headers
Pivot tables summarize large data by grouping and calculating totals, counts, or averages. They help analyze data quickly without writing complex formulas.
Subtotal feature is used to
A Hide columns
B Summarize by groups
C Rename workbook
D Insert chart axis
Subtotal adds summary rows like sum or count for grouped data, usually after sorting. It helps get totals per category, such as totals per department.
Protect Sheet is used to
A Add new function
B Increase chart size
C Prevent unwanted edits
D Change file type
Protect Sheet restricts changes like editing cells, formatting, or inserting rows. It is useful when sharing files so others can view or enter limited data safely.
CSV file is mainly used for
A Image editing
B Video playback
C Font installation
D Comma-separated data
CSV stores data with values separated by commas. It is widely used for exporting and importing spreadsheet data between different software because it is simple and compatible.
VLOOKUP concept is used to
A Draw a chart
B Freeze top row
C Find in first column
D Rename sheet tab
VLOOKUP searches a value in the first column of a table and returns related data from another column in the same row. It is used for matching IDs with details.