No explanation is given for this question. Let's Discuss on Board

No explanation is given for this question. Let's Discuss on Board

No explanation is given for this question. Let's Discuss on Board

No explanation is given for this question. Let's Discuss on Board

No explanation is given for this question. Let's Discuss on Board

Excel offers powerful tools for data entry, analysis, and visualization in spreadsheet format.

Bar charts visualize data comparisons across categories with rectangular bars.

Spreadsheet formulas simplify math operations and update results dynamically.

Starting with Excel 2007, Microsoft introduced the Office Open XML file format. The default file extension for Excel workbooks became `.xlsx`. The older `.xls` format was used for versions prior to 2007. A cell is formed at the intersection of a row and column in a spreadsheet. * The actual working area in Microsoft Excel is: (A) Workbook (B) Worksheet (C) Spreadsheet (D) Note sheet In Excel, the actual working area is called a worksheet, where data is input and manipulated. * A cell at the third column and 15th row has a cell address: (A) A15 (B) B15 (C) C15 (D) D15 The third column corresponds to 'C', and the 15th row corresponds to 15, making the address C15. * A collection of related worksheets is called: (A) Spreadsheet (B) Cells (C) File (D) Workbook A workbook contains multiple related worksheets, which are individual pages within the file. * The currently selected cell where data can be entered or edited is called: (A) Idle cell (B) Active cell (C) Passive cell (D) Present cell The active cell is the one currently selected for data entry or editing. * In a worksheet, a bold rectangle border indicates: (A) Present cell (B) Active cell (C) Passive cell (D) Idle cell The active cell is indicated by a bold rectangle border, showing where data will be entered or edited. * A cell in a worksheet, which is not active, is called: (A) Active cell (B) Idle cell (C) Passive cell (D) Present cell A passive cell is not currently selected and is inactive, unlike the active cell where data entry occurs. * Which cell address is correct? (A) Z2 (B) AZ3 (C) 2Z (D) Both a and b Z2 and AZ3 are both valid cell addresses, while 2Z is not a correct cell reference. * In a spreadsheet, rows are labeled by: (A) Letters (B) Numbers (C) Cell references (D) None Rows are labeled numerically in Excel (e.g., Row 1, Row 2, etc.). * In a spreadsheet, columns are labeled by: (A) Letters (B) Numbers (C) Cell references (D) None Columns are labeled alphabetically (e.g., Column A, Column B, etc.). * A workbook is a group of: (A) Many rows (B) Many columns (C) Worksheets (D) None A workbook contains multiple worksheets, which are individual sheets within the file. Absolute references use dollar signs before both the column and row (e.g., $A$1) to prevent them from changing during copying or moving. * Formulas can only be applied on: (A) Values (B) Labels (C) Unmerged cells (D) None Formulas operate on values (numbers or cell references) and not on labels (text) or merged cells. * To add the value of cell 'C9' of worksheet "Sheet3" with the cell 'B2' of the current worksheet, the formula is written as: (A) =C9 + B2 (B) =Sheet3!C9+B2 (C) =Sheet3!B2+C9 (D) =Sheet3!B2+sheet3!C9 To reference cells from another worksheet, use the syntax SheetName!CellAddress. * A mathematical expression used to perform calculations on a worksheet is called: (A) Cell (B) Format (C) Formula (D) Address Bar A formula is a mathematical expression used in Excel to perform calculations. * The absolute reference of cell address A15 is written as: (A) $A15 (B)$ A15 $ (C) A $15 (D)$ A $ 15 An absolute reference uses dollar signs before both the column letter and row number (e.g., $A$15). * Which symbol is used before a formula? (A) & (B) = (C) # (D) $ A formula in Excel begins with the equal sign (=). * The range of cells from C2 to C100 is referenced as: (A) C2-100 (B) C2:C100 (C) C2 to C100 (D) C2 : 100 A cell range is referenced with a colon (:) between the starting and ending cell addresses (e.g., C2:C100). * Which represents a valid range in Excel? (A) C1:C3 (B) C1, C2, C3 (C) =C1+C2+C3 (D) C1 to C3 A valid cell range in Excel is represented by the start and end cell addresses separated by a colon (e.g., C1:C3). * Calling a cell with the reference of its address is called: (A) Absolute referencing (B) Reference address (C) Relative referencing (D) None Relative referencing adjusts the cell reference based on the position of the formula when copied. * Which symbol is used in absolute referencing? (A) & (B) = (C) # (D) $ Correct Answer: (D)$ The dollar sign ($) is used in absolute referencing to lock a row or column in place. * Which function is used to return the current system date? (A) Max (B) Min (C) Today (D) None The TODAY() function returns the current date. * Which function is used to get the current date? (A) Exact() (B) Today() (C) Month() (D) Year() The TODAY() function retrieves the current date.

The 'Remove Duplicates' feature in Microsoft Excel is located on the 'Data' tab of the ribbon, within the 'Data Tools' group. This tool is used to scan a selected range of cells and delete rows that contain duplicate values.