Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
+1 vote
1.5k views
in Computer by (31.4k points)
closed by

Explain the basic properties of a formula in excel.

1 Answer

+2 votes
by (35.0k points)
selected by
 
Best answer

1. A formula may consist of operators, cell references, range names, values and functions. 

2. A formula always start with an equal to (=) sign. 

3. When a formula is entered in the cell, and then the ENTER key is pressed, only the calculated result is displayed in the cell and not the formula. 

4. If a cell containing formula is made an active cell, though it still shows the value, but in the formula bar, the formula is displayed.

Related questions

0 votes
1 answer

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...