DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Basic Latin subset.
|
|
|
The IPA Extensions subset.
|
|
|
The Wingdings subset.
|
|
|
The Latin-1 Supplement subset.
|
Detailed explanation-1: -When you manually insert an international currency symbol using the Symbol dialog box, which of the following subset options would you likely select? The Basic Latin subset.
Detailed explanation-2: -To do this, simply select the cells that you want to format and then click on the “Format Cells” option from the ribbon. In the “Number” tab, select the “Currency” option from the list and then choose your desired options such as the number of decimal places, the currency symbol, etc.
Detailed explanation-3: -On the Ribbon’s Home tab, click Conditional Formatting, then click New Rule. In the New Formatting Rule dialog box, select ‘Use a formula to determine which cells to format’ In the ‘Format values where this formula is true’ box, type this formula, to check the selected currency (CurrSel). =CurrSel="Pound"
Detailed explanation-4: -Conditional Formatting Based on Another Cell Not Empty Click on ‘Format’ in the navigation bar, then select ‘Conditional Formatting.’ Under ‘Format Rules, ’ select ‘Custom formula is.’ Write your formula using the following format: =NOT(ISBLANK([cell#)), select your formatting style, then click ‘Done.’