Priya Dogra – Certification | Jobs | Internships
Related Articles
The MOS (Microsoft Office Specialist) certification validates your skills in using Microsoft Office applications effectively.
Certifies proficiency in core Office apps:
- Excel Associate
- Word Associate
- PowerPoint Associate
- Outlook Associate
🧑💼 Ideal for: Students, Office professionals, Admins
Q1. Which function returns the number of cells that meet a condition?
A. SUM
B. COUNTIF
C. AVERAGEIF
D. VLOOKUP
✅ Answer: B. COUNTIF
🔸 Q2. What does the AutoSum button do?
A. Finds the average
B. Adds selected cells
C. Subtracts values
D. Sorts data
✅ Answer: B. Adds selected cells
🔸 Q3. Which shortcut key inserts the current date in a cell?
A. Ctrl + D
B. Ctrl + ;
C. Ctrl + :
D. Ctrl + Shift + T
✅ Answer: B. Ctrl + ;
🔸 Q4. What does
=IF(A1>10, "Yes", "No")return if A1 is 5?A. 10
B. Yes
C. No
D. A1
✅ Answer: C. No
🔸 Q5. What is the use of Freeze Panes in Excel?
A. Locks entire workbook
B. Makes cell borders bold
C. Keeps header rows/columns visible while scrolling
D. Creates a chart
✅ Answer: C. Keeps header rows/columns visible while scrolling
🔸 Q6. Which chart is best for showing percentages?
A. Line chart
B. Bar chart
C. Pie chart
D. Scatter chart
✅ Answer: C. Pie chart
🔸 Q7. What does the function
=VLOOKUP(101, A2:B10, 2, FALSE)do?A. Looks for 101 in column A and returns value from column B
B. Adds all numbers in range A2:B10
C. Filters column 2
D. Checks for duplicates
✅ Answer: A. Looks for 101 in column A and returns value from column B
🔸 Q8. Which function calculates the average of selected values?
A. SUM
B. MEDIAN
C. AVERAGE
D. COUNT
✅ Answer: C. AVERAGE
🔸 Q9. The function
=CONCAT(A1, B1)does what?A. Adds A1 and B1
B. Returns the larger of A1 and B1
C. Combines text from A1 and B1
D. Converts values to upper case
✅ Answer: C. Combines text from A1 and B1
🔸 Q10. What does the Wrap Text option do?
A. Hides overflow text
B. Merges text in multiple cells
C. Displays long text within the cell boundaries
D. Inserts a line break
✅ Answer: C. Displays long text within the cell boundaries
🔸 Q11. Which Excel feature is used to quickly fill a series (e.g., Jan, Feb, Mar…)?
A. Flash Fill
B. AutoFill
C. Quick Fill
D. Format Painter
✅ Answer: B. AutoFill
🔸 Q12. What is the default file extension for an Excel workbook?
A. .xls
B. .xlsx
C. .xlsm
D. .csv
✅ Answer: B. .xlsx
🔸 Q13. Which formula finds the largest number in a range?
A. =MIN(A1:A10)
B. =COUNT(A1:A10)
C. =MAX(A1:A10)
D. =SUM(A1:A10)
✅ Answer: C. =MAX(A1:A10)
🔸 Q14. Which tab is used to apply borders in Excel?
A. Insert
B. Layout
C. Home
D. View
✅ Answer: C. Home
🔸 Q15. What is the purpose of Conditional Formatting?
A. Convert numbers to text
B. Format cells manually
C. Automatically format cells based on rules
D. Insert formulas
✅ Answer: C. Automatically format cells based on rules
