Pokrewne
- Strona Główna
- Famous Flyers Rachel A. Koestler Grack Eddie Rickenbacker (2003)
- Harvard Business School Press Working Identity 2003
- Mark W. Harris Historical Dictionary of Unitarian Universalism (2003)
- Ellen Meiksins Wood Empire of Capital (2003)
- Science Fiction (28) lipiec 2003
- Science Fiction (25) kwiecien 2003
- Science Fiction (31) pazdziernik 2003
- Science Fiction (32) listopad 2003
- Moj swiat w obrazach
- Tolkien J.R.R Dwie Wieze
- zanotowane.pl
- doc.pisz.pl
- pdf.pisz.pl
- aniadka.keep
[ Pobierz całość w formacie PDF ]
.After you finish typing, you must lock in the entry to store it permanently in the cell bypressing Enter.Pressing Enter normally causes the active cell to move down one row.You canchange this so that when you press Enter, either the active cell doesn t change or it moves toan adjacent cell in another direction.Choose Tools, Options, click the Edit tab, and eitherclear the Move Selection After Enter option or change the selection in the Direction list.Youcan also lock in an entry when you move the selection to a different cell by pressing Tab,Shift+Tab, Shift+Enter, or an arrow key, among other methods, after you type the entry, asshown in the following table.Press To ActivateEnter The cell below the active cell, or whatever Direction is set for the MoveSelection After Enter option on the Edit tab of the Options dialog boxShift+Enter The cell above the active cell, or the opposite of the Direction set for theMove Selection After Enter option on the Edit tab of the Options dialog boxTab The cell one column to the right of the active cellShift+Tab The cell one column to the left of the active cellArrow Key The adjacent cell in the direction of the arrow key that you pressWhen you begin typing an entry, three buttons appear on the formula bar: the Cancel but-ton, the Enter button, and the Insert Function button.When typing a formula where theentry begins with an equal sign (=), a plus sign (+), or a minus sign ( ), a drop-down list offrequently used functions becomes available, as shown in Figure 5-7.For more about editing formulas, see Chapter 12, Building Formulas. 109Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutCancelFunctions list Enter Insert Functionf05ie07Figure 5-7.When you start entering a formula by typing an equal sign, the formula baroffers ways to help you finish it.Entering Simple Numeric and Text ValuesAn entry that includes only numerals 0 through 9 and certain special characters, such as + E e ( )., $ % and /, is a numeric value.An entry that includes almost any other characteris a text value.The following table lists some examples of numeric and text values.Numeric Values Text Values123 Sales123.456 B-1$1.98 Eleven1% 123 Main Street1.23E+12 No.324Using Special CharactersA number of characters have special effects in Excel.Here are some guidelines for using spe-cial characters:Ï% If you begin a numeric entry with a plus sign (+), Excel drops the plus sign.Ï% If you begin a numeric entry with a minus sign ( ), Excel interprets the entry as a neg-ative number and retains the sign.110Part 2: Building WorksheetsChapter 5 Part 1: Part TitleHow to Work a WorksheetÏ% In a numeric entry, the characters E and e specify an exponent used in scientific nota-tion.For example, it interprets 1E6 as 1,000,000 (1 times 10 to the sixth power), whichis displayed in Excel as 1.00E+06.To enter a negative exponential number, enter aminus sign before the exponent.For example, 1E6 (1 times 10 to the negative sixthpower) equals 1,000,000, and is displayed in Excel as 1.00E-06.Ï% Excel interprets numeric constants enclosed in parentheses as negative numbers, whichis a common accounting practice.For example, Excel interprets (100) as 100.Ï% You can use decimal points and commas as you normally would.When you enter num-bers that include commas as separators, however, the commas appear in the cell but notin the formula bar; this is the same as if you had applied one of Excel s built-in Numberformats.For example, if you enter 1,234.56, 1234.56 is displayed in the formula bar.Ï% If you begin a numeric entry with a dollar sign, Excel assigns a Currency format to thecell.For example, if you enter $123456, Excel displays $123,456 in the cell and 123456in the formula bar.In this case, Excel adds the comma to the worksheet displaybecause it s part of the Currency format.Ï% If you end a numeric entry with a percent sign (%), Excel assigns a Percentage formatto the cell.For example, if you enter 23%, Excel displays 23% in the formula bar andassigns a Percentage format to the cell, which also displays 23%.Ï% If you use a forward slash (/) in a numeric entry and the string cannot be interpreted asa date, Excel interprets the number as a fraction.For example, if you enter 11 5/8 (witha space between the number and the fraction), Excel assigns a Fraction format to theentry, meaning that the formula bar displays 11.625 and the cell displays 11 5/8.Tip Enter numbers as fractionsTo make sure Excel does not interpret a fraction as a date, precede the fraction with a zeroand a space.For example, to prevent Excel from interpreting the fraction 1/2 as January 2,type 0 1/2.For more about Excel s built-in Number formats, see Formatting in Cells on page 200.For moreinformation about date and time formats, see How Autofill Handles Dates and Times on page 173.Understanding the Difference Between Displayed Valuesand Underlying ValuesAlthough you can type 32,767 characters into a cell, a numeric cell entry can maintain pre-cision to only a maximum of 15 digits.This means that you can enter numbers longer than15 digits into a cell, but Excel converts any digits after the fifteenth to zeros.If you areworking with figures over 999 trillion, or decimals smaller than trillionths, perhaps youneed to look into alternative solutions, such as a Cray supercomputer.111Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutIf you enter a number that is too long to appear in a cell, Excel converts it to scientific nota-tion in the cell, if no other formatting has been applied.Excel adjusts the precision of thescientific notation depending on the cell width.If you enter a very large or a very smallnumber that is longer than the formula bar, Excel displays it in the formula bar using scien-tific notation.In Figure 5-8, we entered the same number into both cells A1 and B1; how-ever, because cell B1 is wider, Excel displays more of the number, but it is still displayedusing scientific notation.f05ie08Figure 5-8.Because the number 123456789012 is too long to fit in either cell A1 or B1,Excel displays it in scientific notation.For more information about increasing the width of a cell, see Changing Column Widths on page 234.The values that appear in formatted cells are called displayed values; the values that arestored in cells and that appear in the formula bar are called underlying values.The numberof digits that appear in a cell its displayed value depends on the width of the column andany formatting that you have applied to the cell.If you reduce the width of a column thatcontains a long entry, Excel might display a rounded-off version of the number, a string ofpound signs (#), or scientific notation, depending on the display format you re using.Tip Shed those poundsIf you see a series of pound signs (######) in a cell where you expect to see a number,simply increase the width of the cell to see the numbers again [ Pobierz caÅ‚ość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl agnieszka90.opx.pl
.After you finish typing, you must lock in the entry to store it permanently in the cell bypressing Enter.Pressing Enter normally causes the active cell to move down one row.You canchange this so that when you press Enter, either the active cell doesn t change or it moves toan adjacent cell in another direction.Choose Tools, Options, click the Edit tab, and eitherclear the Move Selection After Enter option or change the selection in the Direction list.Youcan also lock in an entry when you move the selection to a different cell by pressing Tab,Shift+Tab, Shift+Enter, or an arrow key, among other methods, after you type the entry, asshown in the following table.Press To ActivateEnter The cell below the active cell, or whatever Direction is set for the MoveSelection After Enter option on the Edit tab of the Options dialog boxShift+Enter The cell above the active cell, or the opposite of the Direction set for theMove Selection After Enter option on the Edit tab of the Options dialog boxTab The cell one column to the right of the active cellShift+Tab The cell one column to the left of the active cellArrow Key The adjacent cell in the direction of the arrow key that you pressWhen you begin typing an entry, three buttons appear on the formula bar: the Cancel but-ton, the Enter button, and the Insert Function button.When typing a formula where theentry begins with an equal sign (=), a plus sign (+), or a minus sign ( ), a drop-down list offrequently used functions becomes available, as shown in Figure 5-7.For more about editing formulas, see Chapter 12, Building Formulas. 109Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutCancelFunctions list Enter Insert Functionf05ie07Figure 5-7.When you start entering a formula by typing an equal sign, the formula baroffers ways to help you finish it.Entering Simple Numeric and Text ValuesAn entry that includes only numerals 0 through 9 and certain special characters, such as + E e ( )., $ % and /, is a numeric value.An entry that includes almost any other characteris a text value.The following table lists some examples of numeric and text values.Numeric Values Text Values123 Sales123.456 B-1$1.98 Eleven1% 123 Main Street1.23E+12 No.324Using Special CharactersA number of characters have special effects in Excel.Here are some guidelines for using spe-cial characters:Ï% If you begin a numeric entry with a plus sign (+), Excel drops the plus sign.Ï% If you begin a numeric entry with a minus sign ( ), Excel interprets the entry as a neg-ative number and retains the sign.110Part 2: Building WorksheetsChapter 5 Part 1: Part TitleHow to Work a WorksheetÏ% In a numeric entry, the characters E and e specify an exponent used in scientific nota-tion.For example, it interprets 1E6 as 1,000,000 (1 times 10 to the sixth power), whichis displayed in Excel as 1.00E+06.To enter a negative exponential number, enter aminus sign before the exponent.For example, 1E6 (1 times 10 to the negative sixthpower) equals 1,000,000, and is displayed in Excel as 1.00E-06.Ï% Excel interprets numeric constants enclosed in parentheses as negative numbers, whichis a common accounting practice.For example, Excel interprets (100) as 100.Ï% You can use decimal points and commas as you normally would.When you enter num-bers that include commas as separators, however, the commas appear in the cell but notin the formula bar; this is the same as if you had applied one of Excel s built-in Numberformats.For example, if you enter 1,234.56, 1234.56 is displayed in the formula bar.Ï% If you begin a numeric entry with a dollar sign, Excel assigns a Currency format to thecell.For example, if you enter $123456, Excel displays $123,456 in the cell and 123456in the formula bar.In this case, Excel adds the comma to the worksheet displaybecause it s part of the Currency format.Ï% If you end a numeric entry with a percent sign (%), Excel assigns a Percentage formatto the cell.For example, if you enter 23%, Excel displays 23% in the formula bar andassigns a Percentage format to the cell, which also displays 23%.Ï% If you use a forward slash (/) in a numeric entry and the string cannot be interpreted asa date, Excel interprets the number as a fraction.For example, if you enter 11 5/8 (witha space between the number and the fraction), Excel assigns a Fraction format to theentry, meaning that the formula bar displays 11.625 and the cell displays 11 5/8.Tip Enter numbers as fractionsTo make sure Excel does not interpret a fraction as a date, precede the fraction with a zeroand a space.For example, to prevent Excel from interpreting the fraction 1/2 as January 2,type 0 1/2.For more about Excel s built-in Number formats, see Formatting in Cells on page 200.For moreinformation about date and time formats, see How Autofill Handles Dates and Times on page 173.Understanding the Difference Between Displayed Valuesand Underlying ValuesAlthough you can type 32,767 characters into a cell, a numeric cell entry can maintain pre-cision to only a maximum of 15 digits.This means that you can enter numbers longer than15 digits into a cell, but Excel converts any digits after the fifteenth to zeros.If you areworking with figures over 999 trillion, or decimals smaller than trillionths, perhaps youneed to look into alternative solutions, such as a Cray supercomputer.111Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutIf you enter a number that is too long to appear in a cell, Excel converts it to scientific nota-tion in the cell, if no other formatting has been applied.Excel adjusts the precision of thescientific notation depending on the cell width.If you enter a very large or a very smallnumber that is longer than the formula bar, Excel displays it in the formula bar using scien-tific notation.In Figure 5-8, we entered the same number into both cells A1 and B1; how-ever, because cell B1 is wider, Excel displays more of the number, but it is still displayedusing scientific notation.f05ie08Figure 5-8.Because the number 123456789012 is too long to fit in either cell A1 or B1,Excel displays it in scientific notation.For more information about increasing the width of a cell, see Changing Column Widths on page 234.The values that appear in formatted cells are called displayed values; the values that arestored in cells and that appear in the formula bar are called underlying values.The numberof digits that appear in a cell its displayed value depends on the width of the column andany formatting that you have applied to the cell.If you reduce the width of a column thatcontains a long entry, Excel might display a rounded-off version of the number, a string ofpound signs (#), or scientific notation, depending on the display format you re using.Tip Shed those poundsIf you see a series of pound signs (######) in a cell where you expect to see a number,simply increase the width of the cell to see the numbers again [ Pobierz caÅ‚ość w formacie PDF ]