Cyber Class 5 MS Excel Basics

Asked by AKSHAY GURU VARADHARAJAN · SRI CHAITANYA TECHNO SCHOOL, JAYANTI NAGAR.

In MS Excel, what happens if you type a number into a cell that is too narrow to display it?

Answer as guest — Start Free Practice Test to earn Practice PointsHow to earn pointsAsk a question+3Answer a question+1Someone answers yours+1Your Q gets upvoted+1Pioneer bonus (first 5)+5, ask questions & climb the leaderboard!

A The number is automatically deleted.
B The cell displays a series of hash symbols (#######).
C The number is rounded to the nearest zero.
D The computer starts a system update.

Show answer and explanation

Answer: B. The cell displays a series of hash symbols (#######).

Answer: (B) The cell displays a series of hash symbols (#######).
Simple Explanation: When a cell is too small to show a long number, Excel shows ####### to tell you, "I don't have enough space!" You can fix this by making the column wider.

Answering after opening this box earns no Practice Points.

1 answered 100% got it right

Rules for asking and answering

In MS Excel, what happens if you type a number into a cell that is too narrow to display it?

More questions like this