Formula & Functions MCQs in Calc – Class 10 Computer Science Objective Questions
Formula & Functions MCQs in Calc – Class 10 Computer Science
Class: 10
Subject: Computer Science
Unit: Unit 2 – Electronic Spreadsheet
Topic: Formula & Functions MCQs in Calc
Board: CBSE Board Examinations (NCERT Based)
Q1. A formula in Calc always begins with which symbol?
Answer: B. =
All formulas start with = so Calc recognizes it as a calculation instruction.
All formulas start with = so Calc recognizes it as a calculation instruction.
Q2. Which function adds a range of cells?
Answer: B. SUM
SUM is the standard function used to add numeric values in spreadsheets.
SUM is the standard function used to add numeric values in spreadsheets.
Q3. =AVERAGE(A1:A5) calculates?
Answer: B. Mean
AVERAGE adds values and divides by number of entries.
AVERAGE adds values and divides by number of entries.
Q4. Function to find highest value?
Answer: A. MAX
MAX returns the largest number from a range.
MAX returns the largest number from a range.
Q5. Function to find lowest value?
Answer: A. MIN
MIN identifies the smallest value.
MIN identifies the smallest value.
Q6. COUNT function counts?
Answer: B. Numbers
COUNT counts only numeric entries.
COUNT counts only numeric entries.
Q7. COUNTA counts?
Answer: B
COUNTA counts all filled cells regardless of data type.
COUNTA counts all filled cells regardless of data type.
Q8. Absolute reference example?
Answer: B
$ locks row and column when copied.
$ locks row and column when copied.
Q9. Relative reference changes when copied?
Answer: A
Cell reference adjusts automatically.
Cell reference adjusts automatically.
Q10. =IF(A1>50,"Pass","Fail") is?
Answer: A
IF evaluates condition and returns result.
IF evaluates condition and returns result.
Q11. SUMIF performs?
Answer: A
Adds values meeting criteria.
Adds values meeting criteria.
Q12. COUNTIF counts?
Answer: B
Counts cells matching condition.
Counts cells matching condition.
Q13. Concatenation joins?
Answer: B
Combines text strings.
Combines text strings.
Q14. Operator for multiplication?
Answer: B
* is arithmetic multiply operator.
* is arithmetic multiply operator.
Q15. Operator for exponent?
Answer: A
Used for power calculations.
Used for power calculations.
Q16. =TODAY() returns?
Answer: B
Displays current system date.
Displays current system date.
Q17. Nested function means?
Answer: B
Example: IF with AVERAGE.
Example: IF with AVERAGE.
Q18. Error for wrong formula?
Answer: D
Different errors indicate formula issues.
Different errors indicate formula issues.
Q19. =ROUND(45.678,2) gives?
Answer: B
Rounds to 2 decimal places.
Rounds to 2 decimal places.
Q20. Function wizard helps to?
Answer: B
Guides users to apply functions correctly.
Guides users to apply functions correctly.
