DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
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.