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
0 votes
291 views
in General by (114k points)
closed by
In MS Excel 2010, a cell may display '______' if that cell contains a number or a date and the width of its column cannot display all the characters that its format requires. 
1. ##### 
2. **### 
3. *****
4. $

1 Answer

0 votes
by (113k points)
selected by
 
Best answer
Correct Answer - Option 1 : ##### 

The correct answer is #####.

  • If Microsoft Excel displays ##### in a cell after you apply number formatting to it, the cell probably isn't wide enough to display the data.
  • To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error.
  • This automatically resizes the column to fit the number.

  • If your spreadsheet displays asterisks or pounds signs in a cell instead of data, this is usually because the column is not wide enough to display the value you've entered.
  • Lotus 1-2-3 displays asterisks ( *** ) when a column is too narrow.
  • Excel displays pound signs ( ### ).

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

...