JRFSmart › UGC NET Paper 1 › Unit 8: Information and Communication Technology (ICT) › Spreadsheets

UGC NET Spreadsheets Previous Year Questions

JRFSmart holds 28 previous-year questions on Spreadsheets from UGC NET Paper 1 (Teaching and Research Aptitude), filed under Unit 8: Information and Communication Technology (ICT), drawn from 28 of the 149 papers analysed (2018–2026). Each question can be practised with a full explanation and shows how often NTA has returned to the same idea.

28Questions
28 of 149Papers containing it
MediumFrequency
2018–2026Years covered
Start free with Digital initiatives: 21 real NTA questionsDigital initiatives is the free topic of Unit 8, with explanations. Spreadsheets itself is part of the pass. Try 3 now without signing in, then carry on free with Google sign-in. No card needed.See passes for Spreadsheets
Try 3 questions now

What is asked in Spreadsheets

The questions in this topic fall under these subtopics, ordered by how many previous-year questions each has.

SubtopicQuestions
Absolute and relative references2
MS-Excel cell references2
Absolute cell references1
VLOOKUP with absolute references1
COUNTIFS criteria1
SUMIF with a criteria range1
Excel error messages1
SUMIFS with two criteria1
Features of spreadsheet software1
AVERAGE, SUM and range syntax1
SUM syntax and ranges1
Absolute references when copying1

NTA repeat analysis

Spreadsheets appears in 28 of 149 papers (19%), which JRFSmart rates as medium frequency.

4 questions use a question template that NTA has set again with a key word changed, so read the changed word carefully.

Sample previous-year questions

Match the LIST-I with LIST-II in the context of MS-Excel: LIST-I (Cell Reference) | LIST-II (Definition and Feature) A. $E$5 | I. Absolute reference. Column and row are fixed when fill handle is used. B. E$5 | II. Mixed reference. Row is fixed and column is…

December 2025NTA Question ID 6119872346Template repeat in 1 paper

In the following MS-Excel spreadsheet, you are given a list of 100 customers. Column 'A' represents their names, 'B' is for customer category, 'C' for payment category (0 means discounted price and 1 means full price), 'D' indicates price that customer pays…

June 2023NTA Question ID 1682Template repeat in 1 paper

A teacher uses the following table in MS-EXCEL in the range A1 : E2 to assign grades based on marks. If a student's marks are entered in cell A10, then which formula should be entered in cell B10 to display the correct grade ? Reference Table (A1 : E2) : Row…

June 2026NTA Question ID 76878116538

Radha tries different ways to explore the alternative methods of getting the average value of the numbers as indicated in the worksheet below : A B C D 1 12 2 5 3 10 4 Which of the following formulae A-E when entered in cell A4, would given an incorrect…

January 2025NTA Question ID 512701189

With reference to the snapshot of MS-EXCEL worksheet given below, which of the following formule A-E when entered into cell A4 can be used to add the values 10, 20 and 30? A B C 1 10 2 20 3 30 4 A. = SUM (A1:A3) B. = SUM (A1, A3) C. =A1+A2+A3 D. =SUM (A1…

January 2025NTA Question ID 376749343

Consider the following MS-EXCEL spreadsheet: A B C D E 1 Item Quantity Price Revenue 2 A-11 12 5 60 3 B-32 31 9 279 4 C-44 24 12 288 If the formula = $B$2 * $C$2 is entered into cell E2, and the formula is then copied to cells E3 and E4, then the values in…

January 2025NTA Question ID 3767492036

Consider the following MS-EXCEL function entered in cell C1: =IF(A1>B1, 1, IF (A1=10, 2, IF(A1<B1, 3, 4))) The above function will return a value of 4 in cell C1 if the values in cell A1 and cell B1 are ____ respectively.

January 2025NTA Question ID 37674911507

Consider the following snapshot of MS-EXCEL worksheet : A B C 1 90 70 2 60 170 3 150 20 4 30 110 5 50 40 6 130 30 7 What will be the value of the cell C1 containing the formula = SUMIF(A1:A6,">100",B1:B6) in the above worksheet ?

August 2024NTA Question ID 5330721935

Showing 8 of 28 questions, without answers. Practise the full set with options, the official answer and JRFSmart's explanations. Every question shows an ID: NTA’s own Question ID where NTA published one, or a JRFSmart ID. It also shows the exam session and date it appeared in. Answers follow NTA’s final answer keys. Quote the ID when you report a mistake, and we fix it and log it on our public corrections page.

Start free with Digital initiatives: 21 real NTA questionsDigital initiatives is the free topic of Unit 8, with explanations. Spreadsheets itself is part of the pass. Try 3 now without signing in, then carry on free with Google sign-in. No card needed.See passes for Spreadsheets
Try 3 questions now

Related topics in this unit

InternetNetworkingCyber securityNumber systemsDigital initiativesComputer fundamentalsEd-tech toolsSoftware
All of Information and Communication Technology (ICT)UGC NET Paper 1 unitsSearch Spreadsheets

Explanations are built from solutions by UGC NET and JRF qualified students and teachers, and edited by JRFSmart. Questions come from NTA papers and are attributed to their session. See how we check and the corrections log. Last updated 18 November 2026.