DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To format the cell value 44.54 as 44.540, you can use the Increase Decimal button. To paste only a copied cell’s formats, use the Paste Special command. For use as watermark, Alba wants to insert a picture as a worksheet background.
Detailed explanation-2: -On the Home tab, in the Number group, click the icon next to Number to display the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Percentage. In the Decimal places box, enter the number of decimal places that you want to display.
Detailed explanation-3: -Formatting changes only the appearance of data-it does not affect the data itself. If the DonationsData worksheet were not formatted, it would look like the unformatted worksheet below. It is simply more difficult to read the unformatted version, but the data is exactly the same as the formatted version.
Detailed explanation-4: -Quick formatting On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.