DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The only way to change the currency format for numbers in your worksheet is to select the correct currency symbol and country in the Format Cells dialog box. When a cell style is applied to various cells in four different worksheets, any changes to the style will apply immediately to all of these cells.
Detailed explanation-2: -Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting.
Detailed explanation-3: -On the Home tab, click the Dialog Box Launcher next to Number. Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want.
Detailed explanation-4: -Convert currency text to number with formula Select a blank cell besides original currency text strings column, says Cell C2, type the formula =VALUE(B2) (B2 is the text cell with currency format you will convert to number) into it, and then drag this cell’s AutoFill Handle to the range as you need.