In a worksheet, what is the name of the vertical set of cells used to store values under a header
A Row
B Column
C Range
D Sheet tab
A column runs vertically and is labeled with letters like A, B, C. Data under a specific heading (like “Marks”) is usually kept in one column for easy analysis and sorting.
In Excel, what do row numbers represent in a worksheet grid
A Vertical labels
B Chart labels
C Horizontal labels
D File names
Rows run horizontally and are identified by numbers like 1, 2, 3. Each row commonly represents one record, such as one student’s complete information across columns.
Which notation correctly represents a contiguous range in Excel
A A1:A3
B A1,A2,A3
C A1;A3
D A1-A3
A range uses a colon to show the first and last cell. A1:A3 means cells A1, A2, and A3. For a block, it may look like A1:C5.
Which feature quickly applies number format like currency or percent
A Format Painter
B Find and Replace
C Number Format
D Data Validation
Number Format changes how values appear, such as currency (₹), percentage (%), or dates. It does not change actual stored value, only its display style.
Which formatting changes text to appear bold
A Italic
B Underline
C Wrap Text
D Bold
Bold formatting makes characters thicker and darker. It is commonly used for headings and important totals to improve readability and help users notice key information.
Which tool copies only formatting to another cell
A Format Painter
B Paste Special
C Sort
D Flash Fill
Format Painter copies cell formatting like font, color, borders, and number style. It helps maintain a consistent layout across tables without copying the data itself.
What does Wrap Text do in a cell
A Split columns
B Remove spaces
C Show text in lines
D Hide overflow
Wrap Text displays long text on multiple lines within the same cell. This increases row height and improves readability without increasing column width.
Which option aligns text to the center of a cell
A Left Align
B Center Align
C Top Align
D Bottom Align
Center alignment places content in the middle horizontally within the cell. It is useful for titles, headings, and short values to give a clean table look.
Which action merges selected cells into one cell
A Merge & Center
B AutoSum
C Group
D Subtotal
Merge & Center combines multiple cells into one large cell and centers the text. It is often used for table headings, but should be used carefully in data tables.
Which view is best to check how sheet will print
A Normal view
B Formula view
C Macro view
D Page Break Preview
Page Break Preview shows how Excel splits the sheet into pages for printing. You can adjust page breaks and ensure tables fit properly on paper.
Which shortcut opens the Print screen quickly
A Ctrl + C
B Ctrl + V
C Ctrl + P
D Ctrl + Z
Ctrl + P opens the print settings and preview. You can select printer, number of copies, page range, and scaling options before printing the worksheet.
Which feature repeats a specific row on every printed page
A Print Titles
B Print Area
C Freeze Panes
D Text to Columns
Print Titles allows printing header rows or columns on each page. This is useful for long tables so the column headings remain visible on every printed page.
Which option selects the entire worksheet at once
A Ctrl + A once
B Alt + A
C Shift + A
D Ctrl + A twice
Pressing Ctrl + A selects the current data region first; pressing it again selects the entire worksheet. It is helpful for applying formatting to the full sheet.
Which sign is used for percentage formatting
A ₹
B #
C %
D &
Percentage format displays values as parts of 100. For example, 0.25 becomes 25%. It is commonly used for growth rates, marks percentage, and share calculations.
Which formula correctly adds two cells A1 and B1
A A1+B1
B =A1+B1
C =A1*B1
D =SUM(A1,B1, )
Excel formulas must start with “=”. The plus operator adds numbers. =A1+B1 adds values from A1 and B1 and shows the result in the formula cell.
Which function counts cells that are not empty
A COUNT
B COUNTIF
C COUNTA
D COUNTBLANK
COUNTA counts all non-empty cells including numbers, text, and dates. It is useful when you want total filled entries, not just numeric values.
Which function counts blank cells in a range
A COUNTBLANK
B COUNT
C COUNTA
D COUNTIF
COUNTBLANK counts empty cells within a range. It helps identify missing data, such as blank marks or incomplete forms, so you can correct them.
) Which function returns TRUE only when all conditions are TRUE
A IF
B OR
C CONCAT
D AND
AND tests multiple conditions and returns TRUE only if all are TRUE. Example: =AND(A1>=33,B1>=33) can check if two subjects are passed together.
OR function returns TRUE when
A All conditions true
B No condition true
C Any condition true
D Only numbers used
OR returns TRUE if at least one condition is TRUE. It is useful for rules like “eligible if marks ≥ 50 OR category is reserved,” depending on logic needs.
Which function removes extra spaces from text
A TRIM
B LEFT
C MID
D LEN
TRIM removes extra spaces from text, leaving single spaces between words. It helps clean imported data where names or codes may contain unwanted spaces.
LEN function returns
A Text in uppercase
B Number of characters
C First word only
D Decimal rounding
LEN counts characters in a cell, including spaces. It is useful for checking ID length, validating phone numbers, or identifying unusually long or short entries.
LEFT function is used to
A Sort left side
B Align left
C Hide columns
D Take left characters
LEFT extracts a specified number of characters from the start of text. Example: =LEFT(A1,3) takes first 3 letters, useful for codes and prefixes.
RIGHT function is used to
A Fix errors
B Create charts
C Take right characters
D Protect sheet
RIGHT extracts characters from the end of a text string. Example: =RIGHT(A1,4) can pick last 4 digits of an ID or year part from text.
MID function is used to
A Extract middle text
B Merge two sheets
C Round numbers
D Count blanks
MID extracts characters from the middle of text using a start position and length. It is useful when data has fixed patterns, like extracting area code from a number.
Which date function returns today’s date
A NOW
B TODAY
C DATE
D DAY
TODAY returns the current date without time. It updates automatically when the file recalculates. It is used for reports, deadlines, and age or duration calculations.
NOW function returns
A Date only
B Time only
C Date and time
D Month name
NOW returns both current date and current time. It updates automatically. It is useful for time-stamped entries, logging, and tracking when a worksheet was updated.
Which function converts text to uppercase
A LOWER
B PROPER
C VALUE
D UPPER
UPPER converts all letters to capital form. It helps standardize codes or names, especially when data is entered inconsistently in mixed case.
PROPER function changes text to
A All capitals
B All small letters
C Title case words
D Remove duplicates
PROPER capitalizes the first letter of each word and makes other letters lowercase. It helps correct name formatting, like turning “rohit kumar” into “Rohit Kumar.”
Which feature arranges data using multiple keys
A Custom Sort
B Filter
C Flash Fill
D Sparklines
Custom Sort lets you sort by more than one column, such as sorting by “Class” first and then by “Marks.” This creates better organized lists for analysis.
What does a filter dropdown appear on
A Chart axis
B Column header
C Sheet tab
D Status bar
When you apply Filter, dropdown arrows appear in column headers. You can select values, text rules, or number ranges to show only needed rows quickly.
Which option clears applied filters
A Remove Duplicates
B Protect Sheet
C Clear Filter
D Freeze Panes
Clear Filter removes the filtering condition and shows all rows again. It does not change the data, only the display, making it safe for analysis and review.
Highlight Cells Rules belong to
A Conditional Formatting
B Data Validation
C Page Setup
D Sort tool
Highlight Cells Rules is a conditional formatting option used to color cells based on conditions like “greater than,” “between,” or “text contains,” for quick visual checks.
Which feature formats values greater than a threshold
A Data bars
B Greater Than rule
C Pivot table
D Named range
The “Greater Than” conditional formatting rule highlights cells exceeding a specified value. It is useful to mark top scores, high expenses, or sales above target.
What does Icon Sets show in cells
A Formula text
B Page numbers
C Small indicator icons
D Data labels
Icon Sets display symbols like arrows, flags, or traffic lights based on values. They help quickly classify performance levels such as high, medium, and low.
Which chart element shows measurement scale
A Legend
B Title
C Data table
D Axis
An axis provides the scale for values on a chart. The horizontal axis usually shows categories, and the vertical axis shows numeric values, helping interpret chart data correctly.
Which element explains colors of series
A Axis
B Gridlines
C Legend
D Trendline
The legend identifies different data series by color or pattern. In a column chart, it tells which color represents “Sales,” “Profit,” or another series.
A chart title mainly shows
A Chart topic
B Worksheet name
C Cell address
D Filter rule
Chart title describes what the chart represents, like “Monthly Sales.” It helps viewers understand the chart’s purpose quickly, especially when used in reports or dashboards.
Which chart is best for category comparison in one view
A Pie chart
B Line chart
C Bubble chart
D Column chart
Column charts compare categories using vertical bars. Differences are easy to see, making them suitable for comparing marks of students, sales by product, or totals by month.
What does Pivot Chart mainly work with
A Word document
B Pivot Table data
C Paint tools
D CSV only
A Pivot Chart is linked to a Pivot Table and updates when pivot fields change. It is useful for interactive reporting and quick visual summaries of grouped data.
Dashboard in Excel usually means
A Single formula cell
B Only print settings
C Summary visual sheet
D Hidden workbook
A dashboard is a sheet that summarizes key information using charts, tables, and KPIs. It helps viewers understand performance quickly without scanning full raw data.
Which tool allows only values from a list
A Data Validation
B Sort
C Subtotal
D Find
Data validation can restrict entry to a list, such as “Yes/No” or department names. This reduces typing errors and keeps data consistent for accurate filtering and reporting.
Error Alert in validation appears when
A Cell is selected
B Chart is created
C Sheet is renamed
D Invalid entry typed
Error Alert shows a warning when a user enters data that breaks validation rules. It helps prevent wrong entries, like text in a number-only field or invalid dates.
What-if analysis mainly helps to
A Delete data
B Test different inputs
C Format charts
D Rename sheets
What-if analysis checks how changing inputs affects results. It helps in planning, budgeting, and targets by trying different values without permanently changing the original dataset.
Subtotal vs SUM: Subtotal is useful because it
A Works only in charts
B Deletes duplicates
C Ignores hidden rows
D Locks workbook
SUBTOTAL can ignore filtered-out or hidden rows depending on the function number used. This makes totals accurate when filters are applied, unlike a simple SUM.
Protect Workbook mainly prevents
A Structure changes
B Cell value edits
C Formula calculation
D Chart creation
Protect Workbook mainly protects workbook structure, such as adding, deleting, moving, or renaming sheets. It helps keep the workbook organization safe when shared.
Import data basics often include reading
A PPT slides
B Video files
C CSV files
D EXE files
Excel can import data from CSV and other sources. CSV is common because it stores tabular data simply, making it easy to bring data from other systems into Excel.
MATCH function concept is used to
A Add two cells
B Merge worksheets
C Format currency
D Find position number
MATCH returns the position of a value in a list, like 5th item. It is often combined with INDEX to return a related value from another column.
INDEX function concept is used to
A Sort by color
B Return value by position
C Count blank cells
D Print selected range
INDEX returns the value at a given row and column position in a range. When used with MATCH, it helps look up values flexibly without fixed column numbers.
COUNTIF concept is used to
A Add all numbers
B Convert to uppercase
C Count with condition
D Make chart labels
COUNTIF counts cells that meet a criterion, like “>=60” or “Delhi.” It is useful for counting passed students, counting specific categories, or matching a particular text.
SUMIF concept is used to
A Sum with condition
B Split text columns
C Remove duplicates
D Create pivot chart
SUMIF adds values only when a condition is true. Example: sum sales only for “North” region. It is helpful for category-wise totals and quick conditional summaries.