FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What are the pieces of information that describe the appearance of a cell’s content?

A	Paste attributes
B	Edit attributes
C	Format attributes
D	Active attributes

Explanation:

Detailed explanation-1: -How are a cell’s content and format related? They are independent and not related. Changing the format affects the content.

Detailed explanation-2: -Select the cell or range of cells from which you want to clear formatting. On the Home tab, in the Editing group, click the arrow next to the Clear button. Select the Clear Formats option.

Detailed explanation-3: -Copy the completed cell (CTRL +C), then select the cells (SHIFT + Arrow Keys) where you want to repeat the formula and do a Paste (CTRL + V or Enter), or Paste Special (CTRL + ALT + V) if you only want to paste some attributes of the copied cell.

Detailed explanation-4: -Answer: Option a-Currency is the number format used to apply to the cell showing the total sales for the month. Explanation: Numbers must be formatted as currency in order to be displayed as monetary values.

There is 1 question to complete.