FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Excel will usually apply the ____ number format by default if the entered data such as the number 12 is entered.
A
Percentage
B
General
C
Date
D
Long Date
Explanation: 

Detailed explanation-1: -The General format is the default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way that you type them.

Detailed explanation-2: -Entering Numbers Valid numbers are right aligned by default as opposed to text which is left aligned by default. Excel only guarantees precision for the first 15 digits (or significant figures).

Detailed explanation-3: -Press Ctrl+1 to open the Format Cells dialog. Alternatively, you can right click the selected cells and choose Format Cells… from the context menu. In the Format Cells window, switch to the Number tab, and select Date in the Category list. Under Type, pick a desired date format.

Detailed explanation-4: -Just right click on the cell and choose Format cell. Change the format from General to Number with a zero number of decimal places.

There is 1 question to complete.
Previous
Next