numbers

Tue
04
Jul
Dennis Faas's picture

Enter Numbers, Dates and Time: MS Excel

When entering numbers in Excel you can type the numbers into a cell by using the keys on the top row of the keyboard or, if Num Lock is turned on, by using the keypad on the right side of the keyboard. To do so, follow the steps below: Type the ... numbers in the cell and press Enter. If you type decimals, such as 1.5000, Excel often eliminates the trailing zeros and displays 1.5. Note that another future article will tell you how to control this. You can also type dollar signs, commas, or percent signs, and Excel displays them with the numbers. Even when you type these symbols, Excel interprets ... (view more)

Sun
02
Jul
Dennis Faas's picture

Use AutoSum: MS Excel

Suppose your Excel worksheet has a long list of numbers to add. You can sum them instantly using Excel's AutoSum feature. Don't count on your fingers or pull out a calculator; Excel can calculate more quickly and accurately. Even more importantly, ... whenever a number changes, Excel instantly recalculates and displays the corrected sum. You can use either of these two methods to total the numbers using Excel: Click the cell below the list to make it the active cell. Click the AutoSum button. Excel surrounds the cells it thinks you want to total with a moving border. Press Enter or click the ... (view more)

Tue
06
Jun
Dennis Faas's picture

Aligning at a Decimal: MS PowerPoint

Many presentations involve slides containing numbers. They could be financial figures, measurements or other key indicators. If these figures include decimals, they should be aligned at the decimal point. In this manner, your audience can easily ... compare numbers by looking at the figures to the left and right of the decimal point. Having said that: the default alignment when you use the Tab key is left alignment of the starting number. Some people try to use leading spaces to attempt to create decimal alignment, but it never works properly and looks strange to your audience when the numbers ... (view more)

Wed
31
May
Dennis Faas's picture

Insert Page Breaks: MS Word

As documents grow longer and extend past one page, MS Word automatically calculates how much room is available and starts a new page when needed (keeping widows, orphans, and other text flow options in mind). MS Word also allows you to specify where ... to begin a new page by inserting a hard page break where you want one. Sometimes you only need a short page, such as a cover page, or perhaps you want to start a new part of the text on a new page. You wouldn't want to have to press Enter repeatedly, just to force Word to insert a page break. Instead, you want to control where page breaks occur. ... (view more)

Pages

Subscribe to RSS - numbers