Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

The error ##### occurs when?

(A) Column is not wide enough

(B) Negative date

(C) Negative time

(D) Row is not wide enough

Choose the correct answer from the options given below:

Options:

(A), (B) and (C) only

(A), and (C) only

(B), (C) and (D) only

(A), (B), (C) and (D)

Correct Answer:

(A), (B) and (C) only

Explanation:

The correct answer is option 1- (A), (B) and (C) only.

 

Correct a ##### error- This error occur when a column is not wide enough, or a negative date or time is used.
Reason: The column is not wide enough to display the content

1. Select the column by clicking the column header.

2. On the Home tab, in the Cells group, click Format, and then click AutoFit Column Width. Alternatively also we can double- click the boundary to the right of the column heading.

3. Select the column.

4. On the Home tab, in the Cells group, click Format, click Format Cells, and then click the Alignment tab.

5. Select the Shrink to fit check box.