In excel columns are labelled as
A. A,B,C, etc.
B. 1,2,3 etc.
C. A1,A2, etc.
D. $A$1,$A$2, etc.
Answer: Option A
Solution (By Examveda Team)
In Excel, columns are labelled using letters starting from A, followed by B, C, and so on. This alphabetical labeling continues up to Z, then AA, AB, and so forth.Key Points:
A, B, C, etc.: Columns are identified by letters to provide a straightforward way to reference them.
1, 2, 3, etc.: These represent row numbers, not column labels.
A1, A2, etc.: This format is used for cell references, combining column letters with row numbers.
$A$1, $A$2, etc.: This format represents absolute cell references in formulas, not column labels.
This Question Belongs to User Ask Question >> Miscellaneous
Join The Discussion
Comments (3)
Related User Ask Questions
Which of the following is not a primary function of a Bank?
A. Granting Loans
B. Collecting Cheques/Drafts customers
C. Facilitating import of goods
D. Issuing Bank Drafts
A. Regulatory jurisdictional fight between SEBI and IRDA
B. They don’t offer better tax benefits
C. They offer lesser returns compared to traditional insurance policies
D. All of the above
The Chameli Devi Jain Award is given for an outstanding woman ____?
A. Scientist
B. Reporter
C. Player
D. Teacher
it will be option c
7.Which of the following is TRUE?
(1 Point)
MATCH function can look up values from horizontally laid table
HLOOKUP can only look up the second row
VLOOKUP can use less than two arguments
None of the above
Which of the following will result in error in Excel?
I. Dividing a number by 0
II. Multiplying a number by 0
III. Looking up non-existent value in lookup functions
IV. Looking up values in a list containing more than ten lookup-values
(1 Point)
I and II
II and III
I and III
I, II and III