When you need to move to the last used cell area quickly, which shortcut commonly jumps to the edge of data
A Ctrl + P
B Ctrl + Arrow
C Alt + Enter
D Shift + F2
Ctrl + Arrow key jumps to the last filled cell in a direction within the current data region. It helps navigate big sheets quickly without scrolling row by row.
Which shortcut edits the active cell content directly without using the mouse
A F2
B F1
C F5
D F12
F2 puts the cursor inside the active cell for editing. It is useful for correcting text, adjusting numbers, or modifying formulas quickly without going to the formula bar.
Which option pastes only values and removes formulas from copied cells
A Paste Format
B Paste Link
C Paste Comment
D Paste Values
Paste Values keeps only the calculated results and removes formulas. This is useful before sharing, preventing formula changes, and converting dynamic results into fixed numbers.
Which option pastes only formatting like borders and colors
A Paste Values
B Paste Formulas
C Paste Formats
D Paste Special All
Paste Formats copies cell styling such as font, colors, borders, and number format without copying the data. It helps create uniform tables while keeping original values unchanged.
Which Paste Special option transposes rows into columns
A Multiply
B Divide
C Subtract
D Transpose
Transpose switches rows and columns. It is useful when data is arranged in the wrong direction, like months in a row instead of a column, without retyping everything.
Which tool quickly removes cell borders from a selected area
A No Border
B Wrap Text
C Merge Cells
D Text Split
No Border removes all border lines from selected cells. It helps clean formatting mistakes and reset table appearance without changing the data inside the cells.
What does the Format Cells dialog control mainly
A Sheet deletion
B Chart creation
C File export
D Cell appearance
Format Cells controls number format, alignment, font, border, fill, and protection. It is a key tool for creating clean worksheets and correct display of dates, currency, and decimals.
Which number format shows leading zeros like 0007
A General format
B Custom format
C Percentage format
D Date format
Custom format like 0000 forces Excel to display leading zeros for numbers. This is useful for roll numbers, codes, and IDs where fixed digit length must be shown.
Which function returns the text length in a cell including spaces
A LEN
B TRIM
C MID
D RIGHT
LEN counts all characters, including spaces. It helps validate code lengths and detect unusual entries, such as extra characters that can cause mismatches in lookups.
Which function replaces old text with new text inside a cell
A CONCAT
B PROPER
C VALUE
D SUBSTITUTE
SUBSTITUTE replaces specific text within a string. For example, replacing “-” with “/” in dates. It is useful for cleaning imported data without manual edits.
Which function finds the position of a character within text
A SUM
B MAX
C FIND
D ROUND
FIND returns the position number of one text inside another, case-sensitive. It helps split strings when you first locate separators like “@” in emails or “-” in codes.
Which function searches text ignoring case and returns position
A SEARCH
B FIND
C LEFT
D RIGHT
SEARCH is similar to FIND but not case-sensitive. It returns the position of a substring inside text, helping locate patterns like “abc” and “ABC” equally.
Which function extracts last n characters from text
A LEFT
B RIGHT
C MID
D LEN
RIGHT returns a specified number of characters from the end of a text string. It is useful for extracting last digits of IDs or suffix codes from combined text.
Which function extracts first n characters from text
A RIGHT
B MID
C TRIM
D LEFT
LEFT extracts characters from the beginning of text. It is used for prefixes, short codes, or taking first letters of names for creating abbreviations.
Which function returns a part of text from a middle position
A MID
B LEFT
C RIGHT
D VALUE
MID extracts a substring using a start position and length. It is useful when text follows a fixed structure, like extracting area code from a phone string.
Which function joins text and can insert a separator like comma
A COUNTIF
B SUMIF
C ROUNDUP
D TEXTJOIN
TEXTJOIN combines many cells with a chosen delimiter like “, ” and can ignore blanks. It is useful to build clean lists, addresses, or combined labels quickly.
Which symbol joins text in older Excel formulas
A *
B &
C ^
D %
The ampersand (&) joins text values, like =A1&” “&B1. It is a simple way to combine strings without special functions, widely supported in Excel versions.
Which function converts a number to text with a format like 0012
A TEXT
B VALUE
C LEN
D TRIM
TEXT converts a number to formatted text. Example: TEXT(12,”0000″) returns “0012”. It is useful for display formats, codes, and creating formatted labels for reports.
Which function checks if a condition is true and returns one value otherwise another
A SUM
B MIN
C IF
D MAX
IF performs logical testing. It returns one result if the condition is TRUE and another if FALSE. This is used for pass/fail, discount rules, and eligibility checks.
Which function checks multiple conditions and returns TRUE only if all are TRUE
A OR
B IFERROR
C CONCAT
D AND
AND returns TRUE only when all given conditions are TRUE. It is used when multiple requirements must be met, such as passing in all subjects or meeting all criteria.
Which function returns TRUE if at least one condition is TRUE
A OR
B AND
C NOT
D ROUND
OR returns TRUE if any one condition is true. It is useful in rules like “eligible if marks ≥ 50 OR category is special,” depending on your selection logic.
Which function reverses TRUE to FALSE and FALSE to TRUE
A AND
B OR
C IF
D NOT
NOT changes a logical value to its opposite. It helps in advanced conditions, such as excluding a case, and is often combined with IF, AND, and OR.
Which function hides formula errors by returning a chosen value like blank
A COUNT
B SUM
C IFERROR
D MAX
IFERROR returns a specified result when a formula produces an error. Example: IFERROR(A2/B2,””). It helps keep reports clean by avoiding error codes in output.
Which tool allows sorting by cell color or icon
A Sort options
B Data validation
C Freeze panes
D Print setup
Excel sorting can be done by values, cell color, font color, or icon. This helps group highlighted rows together, such as pending tasks marked in red.
Which filter option shows only rows between two numbers
A Text Filters
B Color Filters
C Clear Filter
D Number Filters
Number Filters allow conditions like “Greater than,” “Between,” or “Top 10.” This helps quickly view records in a range, such as marks between 50 and 80.
Which filter option is used for “Begins With” in a text column
A Number Filters
B Date Filters
C Text Filters
D Icon Filters
Text Filters include options like “Begins With,” “Contains,” and “Ends With.” They help filter names or codes quickly, such as showing all entries starting with “HP”.
Which filter option helps show only a specific month from dates
A Color Filters
B Date Filters
C Text Filters
D Custom Sort
Date Filters allow filtering by month, year, week, and ranges like “This Month.” This makes it easy to analyze date-based records without creating extra helper columns.
Which feature highlights top 10 values using conditional formatting
A Data bars
B Icon sets
C Color scales
D Top/Bottom Rules
Top/Bottom Rules can highlight top 10 values, bottom 10 values, above average, etc. It helps identify best or worst performance quickly in a large dataset.
Which chart element names categories on the horizontal line
A Axis labels
B Legend
C Data labels
D Title
Axis labels display category names on the horizontal axis, like months or product names. They help interpret chart bars or points and match them with the correct categories.
Which tool changes chart colors, styles, and layout quickly
A Print Area
B Chart Styles
C Goal Seek
D Subtotal
Chart Styles provide ready-made design combinations for charts, including colors and formatting. They help create professional-looking charts quickly without manually formatting each element.
Which feature can change chart type from column to line quickly
A Page Setup
B Freeze Panes
C Text Split
D Change Chart Type
Change Chart Type allows switching between chart types while keeping the same data range. It helps test which visualization best explains the data without recreating a chart.
Which Excel feature summarizes many charts and KPIs on one sheet
A Dashboard
B Gridlines
C Sheet tab
D Name box
A dashboard sheet shows key metrics using charts, tables, and indicators in one view. It helps users understand performance quickly without scanning full worksheets and raw data.
Which PivotTable field area filters the entire report
A Values area
B Rows area
C Filters area
D Columns area
PivotTable Filters allow filtering the entire pivot report by a field like Year or Region. It changes the full summary view without manually filtering the source data.
Which PivotTable action updates results after source data changes
A Merge cells
B Refresh
C Wrap text
D Print titles
PivotTables do not always update automatically. Using Refresh recalculates the pivot based on latest source data, ensuring totals and counts reflect current records.
Which PivotTable layout shows each row label in separate columns
A Compact Form
B Outline Form
C Normal Form
D Tabular Form
Tabular Form displays each row field in its own column, like a table. It improves readability and is useful for exporting pivot results or applying further formulas.
Which feature adds a calculated row for totals per group after sorting
A Subtotal
B Flash Fill
C Print Titles
D Paste Values
Subtotal inserts summary rows for each group, such as totals per department. It works best after sorting by the grouping column and helps create quick group reports.
Which worksheet protection option allows editing only unlocked cells
A Protect Workbook
B Print Titles
C Protect Sheet
D Page Break
If you unlock input cells and lock formula cells, then apply Protect Sheet, users can edit only the unlocked cells. This protects formulas while allowing safe data entry.
In VLOOKUP concept, which match setting is used for exact match
A TRUE match
B Auto match
C Sort match
D FALSE match
Using FALSE (or 0) in VLOOKUP forces exact matching. It is important when matching IDs or codes because approximate matches may return wrong records.
Which lookup requires first column sorted for approximate matching
A FALSE match
B TRUE match
C Text match
D Icon match
Approximate VLOOKUP (TRUE) assumes the first column is sorted ascending. It is commonly used for slabs like grading or tax brackets where nearest lower match is needed.
Which error commonly appears when a lookup value is not found
A #N/A
B #REF!
C #DIV/0!
D #VALUE!
#N/A means a value is not available, often when a lookup can’t find the requested key. It can be handled using IFERROR to show blank or a message instead.
Which feature links a chart to PivotTable so it changes with filters
A Sparkline
B Area chart
C Pivot Chart
D Pie chart
Pivot Charts are connected to PivotTables. When you change pivot filters or fields, the chart updates automatically, making interactive reporting and dashboards easy.
Which function returns a date using year, month, day parts
A TODAY
B NOW
C TEXT
D DATE
DATE creates a valid date from separate parts, like DATE(2026,2,23). It is useful when dates are stored as separate columns or when converting text safely.
Which function returns the current day number from a date
A DAY
B MONTH
C YEAR
D VALUE
DAY extracts the day of the month from a date value. It helps group or analyze data by day, such as attendance by date or daily transaction reporting.
Which function rounds to the nearest multiple like 5 or 10
A ROUNDUP
B MROUND
C INT
D MAX
MROUND rounds a number to the nearest given multiple. It is helpful for packaging sizes, billing units, and standard rounding rules where values must align to fixed steps.
Which function removes decimals without rounding for positive numbers
A ROUND
B INT
C MIN
D LARGE
INT rounds down to the nearest integer. For positive values it removes the decimal part, like INT(7.9)=7, useful when only whole units are allowed.
Which feature sums across multiple sheets like Sheet1 to Sheet3 using one formula
A 3D reference
B Flash Fill
C Print Titles
D Wrap Text
A 3D reference refers to the same range across multiple sheets, like SUM(Sheet1:Sheet3!B2). It is useful for consolidating monthly sheets into one total.
Which workbook item contains multiple worksheets together
A Cell
B Column
C Range
D Workbook
A workbook is the entire Excel file that can include multiple worksheets, charts, and other objects. It is the main container that you save as an Excel document.
Which worksheet management action makes a copy of an existing sheet
A Print Area
B Wrap Text
C Goal Seek
D Move or Copy
Move or Copy lets you duplicate a worksheet within the same workbook or into another workbook. This is helpful when you want the same format or template for new data.
Which function checks the highest value in a range quickly
A MAX
B MIN
C SUM
D COUNT
MAX returns the largest number in a range. It is used in reports to identify top scores, highest sales, or maximum readings without sorting the data.
Which worksheet feature shows the sheet name at bottom and allows renaming
A Formula bar
B Ribbon
C Gridlines
D Sheet tabs
Sheet tabs display worksheet names at the bottom. You can switch sheets, rename them, reorder them, and manage sheets easily, improving workbook organization and navigation.