StudyXT

A dvanced MS Excel   formula logic, lookup functions, conditional calculations, references, errors, arrays, and practical formula-based questions . Advanced MS Excel Formula MCQs 1. What will =IF(A1>=60,"Pass","Fail") return if A1 contains 75? A. 60 B. TRUE C. Pass D. Fail Answer: C. Pass Explanation: Since 75 ≥ 60 is TRUE, the IF() function returns "Pass" . 2. What is the result of =SUM(A1:A5) ? A. Adds only A1 and A5 B. Adds values from A1 through A5 C. Counts cells A1 through A5 D. Finds the average Answer: B. Adds values from A1 through A5 Explanation: The colon : specifies a continuous range from A1 to A5. 3. Which formula correctly calculates the average only for values greater than 50 in A1:A20? A. =AVERAGEIF(A1:A20,">50") B. =AVERAGE(A1:A20,">50") C. =IFAVERAGE(A1:A20,50) D. =AVGIF(A1:A20,50) Answer: A. =AVERAGEIF(A1:A20,">50") Explanation: AVERAGEIF() calculates the average of cells satisfying a spe...

MS Excel MCQs with explanations,  suitable for competitive exams, computer exams, UGC/college exams, SSC, banking, teaching recruitment, and general computer knowledge . MS Excel MCQs 1. Microsoft Excel is primarily used for: A. Word processing B. Spreadsheet and data analysis C. Presentation design D. Web browsing Answer: B. Spreadsheet and data analysis Explanation: Excel is spreadsheet software used for storing, organizing, calculating, analyzing, and visualizing data. 2. The intersection of a row and a column is called: A. Sheet B. Cell C. Workbook D. Range Answer: B. Cell Explanation: A cell is the basic unit of an Excel worksheet, such as A1 or B5 . 3. A collection of worksheets is called: A. Workbook B. Range C. Column D. Cell Answer: A. Workbook Explanation: An Excel file containing one or more worksheets is called a workbook. 4. Which symbol is used to begin a formula in Excel? A. # B. @ C. = D. % Answer: C. = Explanation: Every Excel formula generally starts with the...