DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Comma
|
|
Semicolon
|
|
Parenthesis
|
|
Brackets
|
Detailed explanation-1: -The sections of code must be separated by semicolons (; ). The following example shows the four types of format code sections. If you specify only one section of format code, the code in that section is used for all numbers.
Detailed explanation-2: -The semicolon is used to separate independent clauses in specific situations. It also separates a series of items which contain internal punctuation. 1. Use a semicolon between independent clauses when the clauses are closely related in meaning and when there is no coordinating conjunction between them.
Detailed explanation-3: -A number format can have up to four sections of code, separated by semicolons. These code sections define the format for positive numbers, negative numbers, zero values, and text, in that order. You do not have to include all code sections in your custom number format.
Detailed explanation-4: -Semicolons are not only used to link main clauses. They can also be used in complicated lists. Elements in a list are usually separated by commas. But if the elements themselves contain commas, semicolons are used to separate them.
Detailed explanation-5: -If it’s a list where at least one item contains a comma, then use semi-colons, e.g. “We ordered 24 pickup trucks, Fords with all-wheel drive; 36 minivans, all seven-seaters; 48 ATVs, used but serviceable….”