In Excel, which area shows the active cell name like A1 and can jump to a typed address
A Status bar
B Sheet tab
C Name Box
D Title bar
The Name Box displays the address of the selected cell, such as A1. You can also type an address like D20 to jump directly there, which saves time in large sheets.
Which button quickly calculates the sum of nearby numbers in a column
A AutoFill
B AutoSum
C Text Split
D Sort Now
AutoSum inserts the SUM function automatically for a nearby range and suggests the most likely cells to add. It is a fast way to total values without typing a full formula.
Which symbol is used to start any Excel formula
A +
B #
C &
D =
Excel treats an entry as a formula only when it begins with “=”. Without it, Excel usually treats the entry as text or a plain value, not as a calculation.
In cell references, what does the dollar sign ($) mainly do
A Adds currency
B Counts cells
C Locks reference
D Splits text
The dollar sign locks the row or column in a cell reference. For example, $A$1 stays fixed when copied, which is useful for constants like rates or fixed cells.
Which reference adjusts automatically when copied to another cell
A A1
B $A$1
C $A1
D A$1
A relative reference like A1 changes based on where you copy the formula. This helps apply the same calculation pattern across many rows or columns.
Which function gives the total of values in A1 to A10
A COUNT(A1:A10)
B MAX(A1:A10)
C MIN(A1:A10)
D SUM(A1:A10)
SUM adds all numeric values in the specified range. It is the most common function for totals in marksheets, sales sheets, and expense tracking tables.
Which function finds the average of a selected range
A CONCAT
B ROUND
C AVERAGE
D COUNTBLANK
AVERAGE calculates the mean of numbers in a range by adding them and dividing by the count of numeric cells. It ignores blank cells, which helps in clean reporting.
Which function returns the largest number from a range
A MIN
B MAX
C SUM
D COUNT
MAX returns the highest numeric value in a range. It is used to find highest marks, maximum sales, or peak readings quickly without manual searching.
Which function returns the smallest number from a range
A MAX
B COUNT
C MIN
D IF
MIN returns the lowest numeric value in a range. It is useful to find minimum marks, lowest cost, or smallest measurement in data analysis.
Which function counts how many numeric entries are in a range
A COUNTA
B COUNTIF
C COUNTBLANK
D COUNT
COUNT counts only cells containing numbers. It ignores text and blanks. This is helpful when you want the number of numeric values used in calculations.
Which function combines text from two cells into one result
A CONCAT
B MAX
C MIN
D SUM
CONCAT joins text strings from cells. For example, CONCAT(A2,” “,B2) can join first name and last name. It helps create full names and combined labels.
Which function rounds 12.345 to two decimal places
A SUM(12.345,2)
B MIN(12.345,2)
C COUNT(12.345,2)
D ROUND(12.345,2)
ROUND changes a number to the specified decimals. ROUND(12.345,2) becomes 12.35. It is important for clean output in money, percentage, and measurement values.
Which option arranges data from A to Z or smallest to largest
A Filter
B Data bars
C Ascending sort
D Goal seek
Ascending sort orders text A to Z and numbers from smallest to largest. It helps organize lists like names, IDs, dates, and marks in a clean sequence.
Which option arranges numbers from largest to smallest
A Ascending sort
B Descending sort
C Wrap text
D Print area
Descending sort orders numbers high to low and text Z to A. It is used to show top values first, like highest marks or highest sales.
Which feature shows only rows that match a selected condition
A Filter
B Merge cells
C Freeze panes
D Print titles
Filter hides rows that do not match chosen criteria and shows only relevant records. It does not delete any data, so you can clear the filter and restore all rows.
Which Excel feature highlights cells based on rules like “greater than 80”
A Page Setup
B Text to Columns
C Conditional Formatting
D Name Manager
Conditional Formatting changes the look of cells when conditions are met. It helps quickly identify high values, low values, duplicates, or trends using colors and icons.
Which conditional formatting style shows colored bars inside cells
A Legends
B Print Area
C Sheet tabs
D Data Bars
Data Bars display a bar within each cell based on its value. Higher values show longer bars, making comparisons easy across many rows without reading each number.
Which feature removes repeated entries while keeping unique rows
A Text Join
B Wrap Text
C Remove Duplicates
D Goal Seek
Remove Duplicates checks selected columns and deletes duplicate records. It keeps only the first occurrence, helping clean lists like IDs, phone numbers, or emails.
Which tool splits a single cell’s data into multiple columns
A Text to Columns
B Protect Sheet
C Freeze Panes
D Pivot Chart
Text to Columns separates data using a delimiter like comma or space, or by fixed width positions. It is useful when names, codes, or addresses are in one cell.
Which feature fills remaining cells by learning a pattern you type
A Subtotal
B Print Titles
C Flash Fill
D Cell Merge
Flash Fill recognizes patterns from your example and fills the rest automatically, like splitting names or formatting codes. It works without formulas and speeds up data cleaning.
Which chart type is best to show changes over time
A Pie chart
B Doughnut chart
C Radar chart
D Line chart
Line charts connect points across time, making trends easy to see. They are ideal for monthly sales, yearly growth, or temperature changes where direction matters.
Which chart type compares categories using vertical bars
A Scatter chart
B Stock chart
C Column chart
D Surface chart
Column charts compare values across categories with vertical bars. They are commonly used for marks, sales by product, and counts by category because differences are clear.
Which chart element explains series colors or markers
A Axis
B Legend
C Gridline
D Title
The legend identifies each data series in a chart, like Sales vs Profit. It helps understand which color or marker belongs to which series, improving chart readability.
Which chart option prints values directly on bars or points
A Sheet tabs
B Print area
C Freeze panes
D Data labels
Data labels show actual values on chart elements. This helps viewers read exact numbers quickly without checking the worksheet data, especially in reports and presentations.
Which tiny chart fits inside a single cell for quick trend view
A Pivot chart
B Line chart
C Sparkline
D Bar chart
Sparklines are mini charts placed inside cells to show trends across a row of data. They are useful in dashboards for quick visual comparison in limited space.
Which feature restricts what users can enter in a cell
A Data Validation
B Sort
C Merge
D Wrap
Data Validation controls allowed inputs, such as only numbers, dates, or a list. It reduces wrong entries and keeps data consistent for reliable filtering and calculations.
Which Data Validation type creates a dropdown list
A Date
B Decimal
C Custom
D List
The List validation type creates a dropdown from typed items or a range. Users select a valid value, which prevents spelling mistakes and makes reports more accurate.
What is the purpose of an Error Alert in Data Validation
A Prints warnings
B Adds new sheet
C Shows invalid entry message
D Formats chart
Error Alert appears when a user enters data outside the allowed rule. It warns or blocks the entry depending on settings, helping maintain clean and correct data.
Which tool changes one input value to reach a target result in a formula
A Goal Seek
B Filter
C AutoFill
D Subtotal
Goal Seek finds the required input to achieve a desired formula result. For example, it can find needed sales to reach a target profit, useful for planning scenarios.
Which feature helps test different input values to see different outcomes
A Merge cells
B Print titles
C Freeze panes
D What-if analysis
What-if analysis is a set of tools that show how changing inputs affects results. It supports planning, budgeting, and decision-making by testing multiple possibilities safely.
Which tool summarizes large data by grouping and totals
A Page Setup
B Wrap Text
C Pivot Table
D Flash Fill
Pivot tables summarize large datasets by grouping fields and calculating totals, counts, or averages. They are widely used for reports because they avoid complex manual calculations.
Which feature adds group totals after sorting a list
A AutoSum
B Subtotal
C Print Area
D Protect Sheet
Subtotal inserts summary rows like sum, count, or average for each group in a sorted list. It helps generate grouped reports such as department-wise totals quickly.
Which feature prevents unwanted editing of worksheet content
A Remove duplicates
B Filter
C Protect Sheet
D Sort
Protect Sheet restricts actions like editing locked cells, deleting rows, or changing formatting. It helps keep formulas and structure safe when a file is shared.
Which feature prevents adding or deleting worksheets in a workbook
A Wrap Text
B Print titles
C Freeze panes
D Protect Workbook
Protect Workbook mainly protects the workbook structure, stopping users from adding, deleting, moving, or renaming sheets. It helps maintain organization in shared workbooks.
Which file format saves data as comma-separated text
A CSV
B XLSX
C PDF
D PPTX
CSV stores data in plain text with values separated by commas. It is commonly used for importing and exporting data between systems, though formatting and formulas are usually not kept.
Which lookup searches in the first column and returns related value to the right
A HLOOKUP
B MATCH
C VLOOKUP
D INDEX
VLOOKUP searches a value in the first column of a table range and returns the corresponding value from a specified column to the right, useful for matching IDs with details.
Which lookup searches across the first row conceptually
A VLOOKUP
B SUMIF
C COUNTIF
D HLOOKUP
HLOOKUP searches for a value in the first row of a table and returns a value from a chosen row below. It is used when headers are arranged horizontally.
Which function finds the position of a value in a list
A INDEX
B TRIM
C MATCH
D PROPER
MATCH returns the position number of a value within a range. It is useful for locating items and is often combined with INDEX for flexible lookup solutions.
Which function returns a value from a range using row/column position
A LEN
B INDEX
C RIGHT
D TODAY
INDEX returns the value at a specified row and column in a range. When combined with MATCH, it becomes a powerful lookup method that works even if columns move.
Which function counts cells matching a condition like “>=60”
A COUNT
B COUNTA
C COUNTBLANK
D COUNTIF
COUNTIF counts cells that meet a given criterion. For example, COUNTIF(A1:A20,”>=60″) counts how many scores are 60 or above, useful for pass analysis.
Which function sums values only when a condition matches
A SUMIF
B SUM
C MAX
D MIN
SUMIF adds values that meet a condition, such as summing sales for one region or totaling marks for one category. It helps create quick conditional totals without filters.
Which function returns today’s date without time
A NOW
B DATE
C TODAY
D DAY
TODAY returns the current system date and updates automatically. It is used for deadlines, age calculations, and reports where time is not required.
Which function returns current date and time together
A TODAY
B YEAR
C MONTH
D NOW
NOW returns both the current date and current time. It updates automatically and is useful for time-stamping logs or tracking when a workbook was last recalculated.
Which function extracts the year from a date
A YEAR
B MONTH
C DAY
D TEXT
YEAR extracts the year part from a date value, like 2026. It helps in year-wise grouping, filtering, and preparing yearly summaries in reports.
Which function removes extra spaces from text
A LEN
B MID
C TRIM
D LEFT
TRIM removes extra spaces, leaving single spaces between words. It helps clean imported data where hidden spaces can break comparisons and lookups, improving accuracy in matching.
Which function converts text to uppercase letters
A LOWER
B UPPER
C PROPER
D VALUE
UPPER converts all letters in a text string to capital form. It is useful for standardizing codes, IDs, and names when data is entered in mixed letter cases.
Which function converts “rohit kumar” into “Rohit Kumar”
A UPPER
B LOWER
C TRIM
D PROPER
PROPER capitalizes the first letter of each word and makes remaining letters lowercase. It helps clean name fields and improves formatting consistency in reports.
Which tool records steps to automate repeated tasks
A Pivot Table
B Conditional Format
C Macro Recorder
D Print Area
Macro Recorder records your actions like formatting, copying, and filtering and saves them as a macro. You can run the macro again to repeat tasks quickly and consistently.
Which file type supports saving macros
A XLSM
B XLSX
C CSV
D PDF
XLSM is the macro-enabled workbook format. It can store VBA macros, unlike XLSX. Use XLSM when automation is needed, and share carefully due to macro security.
Which workbook element lets you switch between worksheets quickly
A Formula bar
B Status bar
C Ribbon
D Sheet tabs
Sheet tabs at the bottom show worksheet names. Clicking a tab switches sheets quickly. You can also rename, reorder, color, insert, or delete sheets using these tabs.