{"id":92294,"date":"2025-06-01T11:20:08","date_gmt":"2025-06-01T11:20:08","guid":{"rendered":"https:\/\/exam.pscnotes.com\/mcq\/?p=92294"},"modified":"2025-06-01T11:20:08","modified_gmt":"2025-06-01T11:20:08","slug":"a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads","status":"publish","type":"post","link":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/","title":{"rendered":"A person wishes to apply a formula in the entire column of the spreads"},"content":{"rendered":"

A person wishes to apply a formula in the entire column of the spreadsheet, with regard to only one cell. Which type of referencing should he use to obtain correct result?<\/p>\n

[amp_mcq option1=”Relative referencing” option2=”Hybrid referencing” option3=”Hyperlink” option4=”Absolute referencing” correct=”option4″]<\/p>\n

\n
\n
This question was previously asked in<\/div>\n
UPSC CBI DSP LDCE – 2023<\/div>\n<\/div>\n
Download PDF<\/a>Attempt Online<\/a><\/div>\n<\/div>\n
\nThe correct answer is D) Absolute referencing.
\n<\/section>\n
\nAbsolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.
\n<\/section>\n
\nRelative referencing (e.g., A1) adjusts the cell reference based on the relative position when copied to other cells. Hybrid referencing (e.g., $A1$ or A$1$) fixes either the column or the row, but not both. A hyperlink is a link to another location or document and is unrelated to cell referencing in formulas.
\n<\/section>\n","protected":false},"excerpt":{"rendered":"

A person wishes to apply a formula in the entire column of the spreadsheet, with regard to only one cell. Which type of referencing should he use to obtain correct result? [amp_mcq option1=”Relative referencing” option2=”Hybrid referencing” option3=”Hyperlink” option4=”Absolute referencing” correct=”option4″] This question was previously asked in UPSC CBI DSP LDCE – 2023 Download PDFAttempt Online … <\/p>\n

Detailed SolutionA person wishes to apply a formula in the entire column of the spreads<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1086],"tags":[1105,1113],"class_list":["post-92294","post","type-post","status-publish","format-standard","hentry","category-upsc-cbi-dsp-ldce","tag-1105","tag-information-and-communication-technology","no-featured-image-padding"],"yoast_head":"\nA person wishes to apply a formula in the entire column of the spreads<\/title>\n<meta name=\"description\" content=\"The correct answer is D) Absolute referencing. Absolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A person wishes to apply a formula in the entire column of the spreads\" \/>\n<meta property=\"og:description\" content=\"The correct answer is D) Absolute referencing. Absolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/\" \/>\n<meta property=\"og:site_name\" content=\"MCQ and Quiz for Exams\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-01T11:20:08+00:00\" \/>\n<meta name=\"author\" content=\"rawan239\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rawan239\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"A person wishes to apply a formula in the entire column of the spreads","description":"The correct answer is D) Absolute referencing. Absolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/","og_locale":"en_US","og_type":"article","og_title":"A person wishes to apply a formula in the entire column of the spreads","og_description":"The correct answer is D) Absolute referencing. Absolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.","og_url":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/","og_site_name":"MCQ and Quiz for Exams","article_published_time":"2025-06-01T11:20:08+00:00","author":"rawan239","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rawan239","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/","url":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/","name":"A person wishes to apply a formula in the entire column of the spreads","isPartOf":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#website"},"datePublished":"2025-06-01T11:20:08+00:00","dateModified":"2025-06-01T11:20:08+00:00","author":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209"},"description":"The correct answer is D) Absolute referencing. Absolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.","breadcrumb":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exam.pscnotes.com\/mcq\/a-person-wishes-to-apply-a-formula-in-the-entire-column-of-the-spreads\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exam.pscnotes.com\/mcq\/"},{"@type":"ListItem","position":2,"name":"UPSC CBI DSP LDCE","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/upsc-cbi-dsp-ldce\/"},{"@type":"ListItem","position":3,"name":"A person wishes to apply a formula in the entire column of the spreads"}]},{"@type":"WebSite","@id":"https:\/\/exam.pscnotes.com\/mcq\/#website","url":"https:\/\/exam.pscnotes.com\/mcq\/","name":"MCQ and Quiz for Exams","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exam.pscnotes.com\/mcq\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209","name":"rawan239","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","caption":"rawan239"},"sameAs":["https:\/\/exam.pscnotes.com"],"url":"https:\/\/exam.pscnotes.com\/mcq\/author\/rawan239\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/92294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/comments?post=92294"}],"version-history":[{"count":0,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/92294\/revisions"}],"wp:attachment":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/media?parent=92294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/categories?post=92294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/tags?post=92294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}