FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The number of worksheets in a workbook are preset, no more can be added.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Inside the General options, you will find an option “Include this many sheets". You can change it to between 1 to 255.

Detailed explanation-2: -Insert multiple worksheets at the same time For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the selected sheet tabs, and then click Insert.

Detailed explanation-3: -In MS-Excel, the address of any cell starts with “A1‟. Hence statement 2 is false.

Detailed explanation-4: -Each workbook can contain up to 255 worksheets, but by default it displays only three. Worksheet is the area where the data is stored and work is performed.

There is 1 question to complete.