Formula in Excel starts with: - Solved MCQ | Agrigyan

Q.1

ICAR AIEEA PG 2024 - Statistical Sciences (Q.63)

MCQ (Single Correct) +4 −1

Formula in Excel starts with:

एक्सेल (Excel) में सूत्र (formula) किससे प्रारंभ होता है?

+ + - - Excel data analysis tools एक्सेल डेटा विश्लेषण उपकरण = = Correct

In Microsoft Excel, every formula must strictly begin with an equal sign (=).
The equal sign signals to Excel that the succeeding characters constitute a formula to be computed rather than plain static text or numerical values.

Hence, Option 4 is correct.

माइक्रोसॉफ्ट एक्सेल (Microsoft Excel) में प्रत्येक सूत्र (formula) सदैव बराबर के चिह्न (=) से शुरू होता है।
बराबर का चिह्न एक्सेल को यह निर्देश देता है कि आगे दर्ज की गई सामग्री एक गणना योग्य सूत्र है, सामान्य टेक्स्ट नहीं।

अतः विकल्प 4 सही उत्तर है।

Explanation not matching this question? क्या व्याख्या इस प्रश्न से मेल नहीं खा रही? Report

Want to practice this paper in exam conditions? क्या आप परीक्षा जैसे माहौल में अभ्यास करना चाहते हैं? Test yourself in 5-question batch format with timer and hidden answers. 5-प्रश्नों के बैच फॉर्मैट, टाइमर और छिपे उत्तरों के साथ खुद को परखें।

Start Practice Mode → प्रैक्टिस टेस्ट मोड शुरू करें →

General Agriculture, Economics & Extension

8 Topics

Agronomy, Agro-Climatic Zones, Cropping Systems, Tillage and Soil Fertility Management Major Plant Diseases, Insect Pests, Weeds and Integrated Pest Management (IPM) Plant Physiology, Mineral Nutrition, Genetics and Plant Breeding Fundamentals Historical Milestones, Agricultural Research Infrastructure and ICAR Institutes Micro & Macro Economics: Demand, Supply, Production Costs and Market Structures Agricultural Marketing, Market Intermediaries, Price Policy, MSP and Buffer Stocking Agricultural Finance, Credit Institutions (NABARD, RRBs, Commercial Banks) and KCC Extension Education Principles, Rural Development Programs and Community Reconstruction

Mathematics

9 Topics

Differential Calculus: Limits, Continuity, Differentiability, Successive Differentiation and Expansion of Functions Sequences and Series: Arithmetic, Geometric, Harmonic Progressions and Infinite Series Convergence Matrices and Determinants: Matrix Operations, Rank, Inverse, Systems of Linear Equations and Eigenvalues Sets, Relations, Functions, Mathematical Induction and Theory of Equations Integral Calculus: Definite and Indefinite Integrals, Reduction Formulas and Areas Under Curves Differential Equations: First Order Ordinary Differential Equations, Linear Differential Equations with Constant Coefficients Applications of Derivatives: Tangents, Normals, Maxima-Minima, Mean Value Theorems and Indeterminate Forms Numerical Methods: Interpolation, Numerical Differentiation, Integration (Trapezoidal, Simpson) and Root Finding Coordinate Geometry: Straight Lines, Circles, Parabola, Ellipse and Hyperbola in Two Dimensions

Statistical Methods & Experimental Designs

14 Topics

Theoretical Discrete Probability Distributions: Bernoulli, Binomial, Poisson, Geometric and Hypergeometric Design of Experiments: Principles of Experimentation, CRD, RBD, Latin Square Design (LSD) and Factorial Experiments Probability Theory: Classical, Axiomatic Definitions, Addition, Multiplication Theorems and Bayes Theorem Small Sample Tests: Students t-test, Snedecors F-test, Chi-Square Test of Goodness of Fit and Contingency Tables Measures of Central Tendency: Arithmetic Mean, Geometric Mean, Harmonic Mean, Median and Mode Theoretical Continuous Probability Distributions: Uniform, Normal, Exponential, Beta and Gamma Distributions Sampling Theory: Census vs Sample Survey, Sampling Errors, SRSWOR, SRSWR, Stratified, Systematic and Cluster Sampling Measures of Dispersion: Range, Quartile Deviation, Mean Deviation, Standard Deviation and Coefficient of Variation Testing of Hypotheses: Null and Alternative Hypotheses, Type I and II Errors, Significance Level, Large Sample Tests (Z-test) Collection, Classification and Tabulation of Data, Frequency Distributions and Graphical Representations Regression Analysis: Simple and Multiple Linear Regression, Least Squares Principle, Properties and R-Squared Random Variables, Probability Mass and Density Functions, Expectation and Moment Generating Functions Correlation Analysis: Simple, Partial, Multiple Correlation, Pearson Coefficient and Rank Correlation Moments, Skewness (Karl Pearson, Bowley) and Kurtosis

Computer Applications & Bioinformatics

10 Topics

Computer Networks and Internet: Topologies (LAN, WAN, MAN), OSI Model, TCP/IP, Protocols (HTTP, FTP) and Web Active Computer Architecture and Hardware: Generations of Computers, CPU, Memory Hierarchy (RAM, ROM, Cache), Input-Output System Software and Operating Systems: Functions of OS, DOS Commands, Windows OS, Linux/Unix Architecture Application Software: Word Processing, Spreadsheets (MS Excel Formulas, Functions, Charts), DBMS Basics Number Systems and Boolean Algebra: Binary, Octal, Hexadecimal Conversions, Logic Gates and Truth Tables Sequence Alignment and Computational Genomics: Pairwise and Multiple Alignment (BLAST, FASTA, Clustal), Scoring Matrices Cyber Security and Data Protection: Computer Viruses, Malware, Firewalls, Cryptography Basics and IPR Programming Fundamentals: Algorithms, Flowcharts, Control Structures, Loops, Functions, Arrays and Pointers in C/C++ Object-Oriented Programming and Modern Languages: Concepts of OOP (Classes, Objects, Inheritance), Python and R Introduction to Bioinformatics: Scope, Biological Databases (NCBI, GenBank, EMBL, UniProt, PDB) and Data Retrieval

ICAR AIEEA PG 2024 - Statistical Sciences

120 Questions Bilingual

ICAR AIEEA PG Statistical Science 14 July 2023 Shift-1 Paper

120 Questions Bilingual

ICAR AIEEA PG Statistical Sciences 09 July 2023 (Shift 1) Paper

120 Questions Bilingual

RPSC Agriculture Exams

5 Exams

Food Safety Officer Assistant Agriculture Officer Agriculture Officer RPSC Agriculture Research Officer RPSC AARO

RSSB Agriculture Exams

1 Exam

RSSB Agriculture Supervisor

National & PG Entrances

4 Exams

ICAR AIEEA PG CUET UG Rajasthan Agriculture Pre-PG ICAR JRF/SRF