Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

In total how many "columns" are there in a spreadsheet?

Options:

256

65536

65546

246

Correct Answer:

256

Explanation:

The correct answer is option 1- 256.

256 columns are there in a spreadsheet.

Rows are numbered numerically from top to bottom while Columns are referred by alpha characters from left to right. In Excel 2007, there are 65536 Rows which are numbered as 1, 2, 3, … 65,536. These numbers are shown on the left most portion of the worksheet. Columns (total 256 in Excel) are identified by letters, such as A, B, C,.. AA… IV, and are shown on the horizontal box just above Row 1. Thus, there are 65,536 x 256 = 1,65,00,000, approximately cells, which is indeed a huge work area, sufficient for all application requirements in one sheet.