FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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: -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.

Detailed explanation-5: -Solution(By Examveda Team) Excel 2003 and earlier 65, 536 Rows. Excel 2007 and higher 1, 048, 576 Rows.

There is 1 question to complete.