USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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: -Go to Home –> Conditional Formatting –> Highlighting Cell Rules –> Greater Than.. / Less Than.. Based on what option you select (greater than or less than), a dialogue box would open. Let’s say, you select the ‘Greater than’ option. In the dialogue box, enter the number in the field on the left.
Detailed explanation-3: -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-4: -This statement is true. 1. If you want to show any numbers as fiscal values, you must arrange those specific numbers as currency.
Detailed explanation-5: -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.