ENTREPRENEURSHIP

ENTREPRENEURSHIP AND THE GLOBAL ECONOMY

EXPORTING AND IMPORTING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Is there a limit to the number of spreadsheets you can merge into one worksheet?
A
Yes
B
No
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily. An excel file is known as a workbook. Although a maximum number of sheets in a worksheet is said to be 255 sheets.

Detailed explanation-2: -Excel allows inserting around 255 worksheets within a single workbook.

Detailed explanation-3: -Microsoft says that the maximum size of a single Excel spreadsheet is 1, 048, 576 rows by 16, 384 columns.

Detailed explanation-4: -Use horizontal number keypad. We can specify any type of range in the scroll area to limit access. Once the rows are hidden, we can unhide at any point in time. In the latest version of excel, a maximum of 1, 048, 576 rows by 16, 384 columns are available.

Detailed explanation-5: -On the Data tab, under Tools, click Consolidate. In the Function box, click the function that you want Excel to use to consolidate the data. In each source sheet, select your data, and then click Add. The file path is entered in All references.

There is 1 question to complete.