Q. What is MS Excel Advanced?
Ans. MS Excel Advanced involves using advanced formulas, functions, charts, data analysis tools, PivotTables, and other spreadsheet features.
Q. What is a formula in MS Excel?
Ans. A formula is an expression that performs calculations using values, cell references, operators, and functions. It usually begins with an equals sign (=).
Q. What is a function in Excel?
Ans. A function is a predefined formula that performs a specific calculation, such as SUM, AVERAGE, IF, or COUNTIF.
Q. What is the SUM function?
Ans. The SUM function adds numbers or values in a specified range of cells.
Q. What is the AVERAGE function?
Ans. The AVERAGE function calculates the arithmetic mean of numeric values in a selected range.
Q. What is the IF function?
Ans. The IF function checks a logical condition and returns one value when the condition is TRUE and another when it is FALSE.
Q. What is the difference between relative and absolute cell references?
Ans. Relative references change when a formula is copied, while absolute references, such as $A$1, keep the referenced row and column fixed.
Q. What is conditional formatting?
Ans. Conditional formatting automatically changes cell formatting when specified rules or conditions are met.
Q. What is data validation?
Ans. Data validation restricts or controls the type of data users can enter into a cell.
Q. What is a PivotTable?
Ans. A PivotTable summarizes and analyzes large datasets by grouping, filtering, and calculating values.
Q. What is a chart in Excel?
Ans. A chart presents worksheet data visually to help users compare values, identify patterns, and understand trends.
Q. What is the VLOOKUP function?
Ans. VLOOKUP searches for a value in the first column of a table and returns a related value from a specified column in the same row.
Q. What is the XLOOKUP function?
Ans. XLOOKUP searches a range or array and returns a corresponding value from another range or array.
Q. What is the COUNTIF function?
Ans. COUNTIF counts cells in a range that satisfy a specified condition.
Q. What is the SUMIF function?
Ans. SUMIF adds values that meet a specified condition.
Q. What is the purpose of sorting data?
Ans. Sorting arranges data in a chosen order, such as ascending, descending, alphabetical, or chronological order.
Q. What is the purpose of filtering data?
Ans. Filtering displays only the records that meet specified criteria while temporarily hiding other records.
Q. What is Freeze Panes?
Ans. Freeze Panes keeps selected rows or columns visible while the user scrolls through a worksheet.
Q. What is a macro in Excel?
Ans. A macro is a recorded or programmed sequence of actions that automates repetitive spreadsheet tasks.
Q. What is the purpose of protecting a worksheet?
Ans. Worksheet protection helps restrict changes to specified cells or worksheet elements, depending on the protection settings.