USING MICROSOFT EXCEL
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 makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.