HPRCA JOA IT Formulas, Cell References and Functions PYQs

41 previous year questions on Formulas, Cell References and Functions (MS Office - Excel) in 11 HP Junior Office Assistant (IT) papers, 2026, 2022, 2021: 2.2% of all the JOA IT questions we hold.

Questions
41
Papers
11
Years
2021-2026

What to study in Formulas, Cell References and Functions

  • Operators and order of precedence
  • Relative, absolute and mixed references
  • Mathematical, statistical, logical, text and date functions (SUM, AVERAGE, COUNT, IF, VLOOKUP, ROUND, CONCAT, LEN, TODAY)
  • Error values (#DIV/0!, #VALUE!, #REF!, #NAME?)

Formulas, Cell References and Functions questions by year

YearQuestions
202615
202212
202114

Sample Formulas, Cell References and Functions questions

Answers, explanations and all 41 questions are in the practice app.

Question 35 · Syllabus as per Essential Qualification

How does the TRIM function affect a text string in Excel?

  1. (A)It converts all text to lowercase letters
  2. (B)It removes extra spaces from the text except for single spaces between words
  3. (C)It counts the number of characters in the text
  4. (D)It joins two text strings together
Show in Hindi

एक्सेल (Excel) में TRIM फ़ं क्शन टे क्स्ट स्ट्रिंग (text string) को कैसे प्रभावित करता है?

  1. (A) यह सभी टे क्स्ट को छोटे अक्षरों में बदल दे ता है।
  2. (B) यह शब्दों के बीच के सिंगल स्पेस को छोड़कर, टे क्स्ट से अतिरिक्त स्पेस हटा दे ता है।
  3. (C) यह टे क्स्ट में कैरेक्टर की संख्या गिनता है
  4. (D) यह दो टे क्स्ट स्ट्रिंग को एक साथ जोड़ता है

Question 36 · Syllabus as per Essential Qualification

MS Excel (Microsoft 365 और Office 2021) में, कौन-सा फ़ं क्शन TRUE रिटर्न करता है यदि इसके तर्कों की विषम संख्या TRUE और FALSE है?

  1. (A)NOT
  2. (B)AND
  3. (C)XOR
  4. (D)OR
Show in English

In MS Excel (Microsoft 365 and Office 2021), which function returns TRUE if an odd number of its arguments are TRUE and FALSE otherwise?

  1. (A) NOT
  2. (B) AND
  3. (C) XOR
  4. (D) OR

Papers with Formulas, Cell References and Functions questions

Frequently asked questions

How many Formulas, Cell References and Functions questions have come in JOA IT?
41 questions in 11 of the 16 papers on AiPYQs (2026, 2022, 2021), about 2.2% of all JOA IT questions we hold.
Are these the official JOA IT previous year papers?
No. They are memory-based sample papers submitted by students for analysis, not official papers. Answers in the practice app are labelled with their source.
Where can I practise Formulas, Cell References and Functions PYQs with answers?
In the AiPYQs practice app: sign in with Google and the first 50 questions of JOA IT are free every day. The exam plan unlocks every question with answers, AI Insights and a study planner.