Please wait...
The bee is on your task.
Welcome to the MS Excel MCQ Challenge. This section is specifically curated to align with the JOA (IT) 2026 syllabus. By practicing these 10 targeted questions, you will strengthen your understanding of concepts related to MS Excel. Each question includes a detailed explanation to help you bridge the gap between theory and practical application.
Question 701 : What is the output of the formula =BASE(15, 2, 10)?
Question 702 : What is the output of the formula =BASE(212, 2, 8)?
Question 703 : What will the formula =FLOOR(40, 7) evaluate to in MS Excel?
Question 704 : What is the result of the formula =FLOOR(320, 25)?
Question 705 : What does the formula =FLOOR(-5.4, 1) return in Excel?
Question 706 : What is the output of the formula =FLOOR(610, 100)?
Question 707 : What is the median of the following dataset: 1, 4.5, 7, 8, 12, 14, 15, 15?
Question 708 : What is the output of the formula =MEDIAN(1, 2, 3, 4, 5)?
Question 709 : Which of the following represents a mixed cell reference in Excel?
Question 710 : In an Excel sheet, A1=6, A2=11, B1=3, B2=2. If cell A3 contains "=$A$1+A2" and is copied to B3, what is the value displayed in B3?
Discover more technical MCQs by navigating to the next page.
To excel in the JOA (IT) 2026 exam, we recommend reviewing the Study Material tab first to build a conceptual foundation before attempting these MCQs. Understanding the MS Excel lifecycle and its implementation is crucial for scoring high in the computer awareness section. Our content is updated regularly to match the latest HPSSC/HPPSC exam patterns.