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]

Carl noticed that the data in cell E4 reads ######. What command could Carl use to correct this problem?

A	special formatting
B	subscript formatting
C	AutoFit
D	wrap text

Explanation:

Detailed explanation-1: -You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways.

Detailed explanation-2: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.

Detailed explanation-3: -Go to the Formulas tab and select More Functions > Information > TYPE. Select a cell in the worksheet to enter the cell reference. Select OK to complete the function. A number appears in the active cell.

Detailed explanation-4: -In a Data Model, each column has an associated data type that specifies the type of data the column can hold: whole numbers, decimal numbers, text, monetary data, dates and times, and so on.

There is 1 question to complete.