FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A typical worksheet has ____ Number of columns
A
128
B
256
C
512
D
1024
Explanation: 

Detailed explanation-1: -Source: Linus’s Excel package. Dear Friends, A typical worksheet has 256 columns and 65536 rows.

Detailed explanation-2: -The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

Detailed explanation-3: -Solution(By Examveda Team) Excel 2007 and higher 16, 384 (as label ‘XFD’) columns.

Detailed explanation-4: -The Microsoft Excel spreadsheet software limits the size of a worksheet size to 65, 536 rows by 256 columns. If your report contains more than 65, 536 rows, it is split into multiple worksheets. The number of worksheets that your report can contain is limited by the physical memory of your computer.

Detailed explanation-5: -A workbook automatically shows in the workspace when you open Microsoft Excel 2003. Each workbook contains three worksheets. A worksheet is a grid of cells consisting of 65, 536 rows by 256 columns.

There is 1 question to complete.