Chapter 15: MS Excel for Data Handling (Set-5)

While copying a formula across columns, which reference keeps column fixed but allows row to change, like $B3

In Excel, what is a 3D reference mainly used for in formulas

Which tool prevents printing extra blank pages by controlling scaling options

Which feature lets you print only selected cells while ignoring the rest

In sorting, which option keeps entire records aligned while sorting one column

Which option allows sorting by a custom list like Jan, Feb, Mar

Which feature can extract unique records to another location without deleting originals

Which conditional formatting rule uses formulas for flexible highlighting

In conditional formatting, what does Applies to define

Which chart element helps identify values when axis labels are hidden

Which chart type best shows cumulative totals over time with areas

Which Excel feature creates a chart inside a cell, based on a row of values

In PivotTable, which setting changes “Sum” to “Count” for a field

Which PivotTable tool quickly groups dates into months or years

Which function safely handles division to avoid #DIV/0! by testing denominator

Which function displays a custom output if any formula error occurs

Which lookup method works even if the return column is to the left of lookup column

In VLOOKUP concept, which argument decides the returned column number

Which VLOOKUP mode is used for an exact match requirement

When using TRUE in VLOOKUP, the first column should be

Which function returns the position of a value, useful before INDEX

Which function can return a value from a matrix using row and column numbers

Which text function joins values with delimiter and can ignore blanks

Which function converts “15-02-2026” text to a real date depends on locale, so safer approach is

Which function extracts a number from text when stored as “123”

Which approach best preserves leading zeros in IDs during import

Which feature records repeated steps to run again automatically

Which file type is macro-enabled in Excel

In workbook protection, which password mainly locks adding/deleting sheets

Which feature lets you print only a selected range while ignoring other sheet data

Which formula becomes wrong if you copy it without locking a constant cell like tax rate

Which Excel feature prevents accidental change of formula cells but allows input in certain cells

In Data Validation, which option shows a warning but still allows entry if user insists

Which tool makes a series like 1, 3, 5 using fill handle efficiently

Which chart feature lets you show values as percentages on a pie chart

Which kind of chart is most suitable to show distribution with many categories is usually avoided because

Which PivotTable option shows values as percentage of total

Which PivotTable step is required after adding new rows to source data range, if range not a table

Which feature helps create dynamic charts by using PivotTable filters

In conditional formatting, how do you remove rules from selected cells only

Which function rounds number to nearest multiple, like nearest 5

Which function truncates decimals without rounding, for positive values

Which error appears when Excel doesn’t recognize a function name, like typing =SUMM()

Which error appears when a lookup value is not found in VLOOKUP exact match

Which data cleaning step helps when VLOOKUP fails due to hidden spaces in codes

Which option in Text to Columns is used when data is separated by comma

Which option in Text to Columns is used when data has fixed positions, like ID(5)Name(10)

In chart formatting, why is “Select Data” used

Which worksheet feature helps keep important values constant across many formulas without using $A$1 repeatedly

Which best practice reduces errors when using many formulas across sheets