Explanation
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.