This question "What would be the result if you type =A1=B1 in cell C1?" was asked in Computer Operator Examination of 2074 conducted by Public Service Commission PSC. The question was asked from Spreadsheet Calculation (Excel) and aims to test the candidate's knowledge about Excel Formula. Being more specific, it is about cell references.
Show Your Love! Share this page!
What would be the result if you type =A1=B1 in cell C1
Correct Answer: b) True or False
In Excel the operator = is relational operator and it compares two operands. In this case, the first = symbol is the indicator to mean it is excel formula and the second = symbol compares the values entered in cell A1 and cell B1. If the values in those cells are equal, the formula will return True otherwise it will return False.
Thus the option b) True or False is the correct answer for this question.