Excel Interview Questions for Data Analyst(MCQ): Test Your Knowledge! What is an absolute cell reference?A reference that changes when copiedA reference that doesn't change when copiedA reference to another sheetA reference to another workbookHow does INDEX differ from LOOKUP?No differenceINDEX is more flexibleLOOKUP is more flexibleINDEX is fasterWhat does the CONCATENATE function do?Splits textJoins textFormats textCounts textHow do you combine text from multiple cells?Use SUMUse CONCATENATE or &Use VLOOKUPUse IFWhat's the main purpose of the INDIRECT function?Creates direct referencesCreates indirect referencesFormats cellsCreates hyperlinksWhere is the Find and Replace feature located?Home tabData tabReview tabFormulas tabHow do you edit a formula in Excel?Double-click the cellPress F2Right-click > Edit FormulaClick the formula barWhat does the SUMIF function do?Adds all numbersAdds numbers meeting a conditionCounts numbers meeting a conditionAverages numbers meeting a conditionWhat do MAX and MIN functions do?Find average valuesFind extreme valuesSort dataFormat numbersWhich function returns the mode of a data set?MODEMEDIANAVERAGEMOSTWhat does the DATEVALUE function do?Formats datesConverts text to dateCalculates date differenceReturns current dateWhat is VBA in Excel?Visual Basic ApplicationVery Big ApplicationVariable Basic AlgorithmVertical Bar AnalysisWhat does the RIGHT function do?Aligns text rightExtracts rightmost charactersMoves cell rightFormats right sideWhich function would you use to return the smallest value in a range?MINSMALLLOWESTLEASTWhat does TRIM do?Removes all spacesRemoves leading/trailing spacesJoins textSplits textWhat is a Slicer used for in Excel?Cutting dataFiltering pivot tables and chartsFormatting cellsSplitting textWhat is a cell address?A unique cell identifierA formulaA data typeA chart typeWhat's the primary use of the RANDBETWEEN function?Generates random decimalGenerates random integer in rangeSorts randomlySelects random cellsWhat are Freeze Panes used for?To lock specific rows or columnsTo protect the worksheetTo create a tableTo format cellsWhich function returns a reference to a single cell?CELLREFOFFSETINDEXWhich function calculates the number of days between two dates?DAYSDATEDIFDAYSBETWEENDATERANGEWhat does the TRANSPOSE function do in Excel?Converts text caseFlips data horizontallySwitches rows and columnsRotates textWhich function would you use to return the absolute value of a number?ABSOLUTEABSPOSITIVEUNSIGNEDWhat does SIGN do?Formats cellReturns 1, 0, or -1 based on number's signCreates signatureChecks if positiveWhich Excel feature allows you to create dynamic chart titles?Data ValidationName ManagerVLOOKUP functionCell References Score: 0/25 Retake Quiz Next Set of Questions