Pokrewne
- Strona Główna
- Ebook Pdf Ms Press Programming Microsoft Sql Server 2000 With Microsoft Visual Basic Net
- Joanna.Chmielewska. .Ksiazka.Poniekad.Kucharska.PL.PDF.eBook.(osloskop.net)
- (ebook pdf) Teach Yourself SQL in 21 Days
- (eBook) James, William The Principles of Psychology Vol. I
- (ebook Pdf) Stephen Hawking A Brief History Of Time
- [eBook] DirectX 3D Graphics Programming Bible
- Koontz Dean R Mroczne sciezki serca (SCAN dal
- Przypadki Robinsona Kruzoe DEFOE
- Chmielowski Benedykt Nowe Ateny
- Arthur Avalon Shakta And Shakti
- zanotowane.pl
- doc.pisz.pl
- pdf.pisz.pl
- pozycb.xlx.pl
[ Pobierz całość w formacie PDF ]
.653Simple Functions.653Does a Cell Contain a Formula?.654Returning a Cell s Formula.654Is the Cell Hidden?.654Returning a Worksheet Name.655Returning a Workbook Name.656Returning the Application s Name.657Returning Excel s Version Number.657Returning Cell Formatting Information.657Determining a Cell s Data Type.659A Multifunctional Function.660Generating Random Numbers.662Generating Random Numbers That Don t Change.663Selecting a Cell at Random.663Calculating Sales Commissions.664A Function for a Simple Commission Structure.665A Function for a More Complex Commission Structure.666Text Manipulation Functions.668Reversing a String.668Scrambling Text.669Returning an Acronym.669Does the Text Match a Pattern?.670Does a Cell Contain Text?.671Extracting the nth Element from a String.672Spelling Out a Number.674Counting and Summing Functions.674Counting Cells Between Two Values.675Counting Visible Cells in a Range.675Summing Visible Cells in a Range.676Date Functions.677Calculating the Next Monday.677Calculating the Next Day of the Week.678Which Week of the Month?.678Working with Dates Before 1900.679 4800-x FM.F 8/27/01 11:54 AM Page xxxivxxxiv ContentsReturning the Last Nonempty Cellin a Column or Row.680The LASTINCOLUMN Function.680The LASTINROW Function.681Multisheet Functions.681Returning the Maximum Value Across All Worksheets.682The SHEETOFFSET Function.683Advanced Function Techniques.685Returning an Error Value.685Returning an Array from a Function.687Returning an Array of Nonduplicated Random Integers.689Randomizing a Range.691Using Optional Arguments.693Using an Indefinite Number of Arguments.694AppendixesAppendix A Working with Imported 1-2-3 Files.699About 1-2-3 Files.699Lotus 1-2-3 Formulas.700Calculation Order.701Text in Calculations.702Logical Values.702Date Problems.703Database Criteria.703Lotus 1-2-3 Function Compatibility.704Function Equivalents.704Converting Database Functions.714Appendix B Excel Function Reference.717Excel Functions by Category.717Appendix C Using Custom Number Formats.733About Number Formatting.733Automatic Number Formatting.733Formatting Numbers Using Toolbar Buttons.734Using Shortcut Keys to Format Numbers.735Using the Format Cells Dialog Box to Format Numbers.736Creating a Custom Number Format.738About Custom Number Formats.738Parts of a Number Format String.739Custom Number Format Codes.740Custom Number Format Examples.742Scaling Values.742Hiding Zeros.746Displaying Leading Zeros.747Formatting Percentages.747 4800-x FM.F 8/27/01 11:54 AM Page xxxvContents xxxvDisplaying Fractions.748Displaying N/A for Text.749Displaying Text in Quotes.749Repeating Text.749Displaying a Negative Sign on the Right.750Conditional Number Formatting.750Coloring Values.751Formatting Dates and Times.752Displaying Text with Numbers.753Displaying a Zero with Dashes.753Using Special Symbols.754Suppressing Certain Types of Entries.755Filling a Cell with a Repeating Character.756Displaying Leading Dots.757Appendix D Additional Excel Resources.759Microsoft Technical Support.759Support Options.759Microsoft Knowledge Base.759Microsoft Excel Home Page.760Microsoft Office Tools on the Web.760Internet Newsgroups.760Spreadsheet Newsgroups.761Microsoft Newsgroups.761Searching Newsgroups.762Internet Web sites.763The Spreadsheet Page.763Excel Web Source.764Stephen Bullen s Excel Page.764Spreadsheet FAQ.764Appendix E What s on the CD-ROM.765CD-ROM Overview.765Chapter Examples.766Chapter 5.766Chapter 6.766Chapter 7.767Chapter 8.767Chapter 9.768Chapter 10.768Chapter 11.768Chapter 12.769Chapter 13.769Chapter 15.770Chapter 16.770Chapter 17.771Chapter 18.772 4800-x FM.F 8/27/01 11:54 AM Page xxxvixxxvi ContentsChapter 19.772Chapter 20.772Chapter 25.773Power Utility Pak.773Registering Power Utility Pak.774Installing the trial version.774Uninstalling Power Utility Pak.774Sound-Proof 2000.775Installing the demo version.775Uninstalling Sound-Proof.776Electronic Version of Excel 2002 Formulas.776Adobe Acrobat Reader.776Index [ Pobierz całość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl agnieszka90.opx.pl
.653Simple Functions.653Does a Cell Contain a Formula?.654Returning a Cell s Formula.654Is the Cell Hidden?.654Returning a Worksheet Name.655Returning a Workbook Name.656Returning the Application s Name.657Returning Excel s Version Number.657Returning Cell Formatting Information.657Determining a Cell s Data Type.659A Multifunctional Function.660Generating Random Numbers.662Generating Random Numbers That Don t Change.663Selecting a Cell at Random.663Calculating Sales Commissions.664A Function for a Simple Commission Structure.665A Function for a More Complex Commission Structure.666Text Manipulation Functions.668Reversing a String.668Scrambling Text.669Returning an Acronym.669Does the Text Match a Pattern?.670Does a Cell Contain Text?.671Extracting the nth Element from a String.672Spelling Out a Number.674Counting and Summing Functions.674Counting Cells Between Two Values.675Counting Visible Cells in a Range.675Summing Visible Cells in a Range.676Date Functions.677Calculating the Next Monday.677Calculating the Next Day of the Week.678Which Week of the Month?.678Working with Dates Before 1900.679 4800-x FM.F 8/27/01 11:54 AM Page xxxivxxxiv ContentsReturning the Last Nonempty Cellin a Column or Row.680The LASTINCOLUMN Function.680The LASTINROW Function.681Multisheet Functions.681Returning the Maximum Value Across All Worksheets.682The SHEETOFFSET Function.683Advanced Function Techniques.685Returning an Error Value.685Returning an Array from a Function.687Returning an Array of Nonduplicated Random Integers.689Randomizing a Range.691Using Optional Arguments.693Using an Indefinite Number of Arguments.694AppendixesAppendix A Working with Imported 1-2-3 Files.699About 1-2-3 Files.699Lotus 1-2-3 Formulas.700Calculation Order.701Text in Calculations.702Logical Values.702Date Problems.703Database Criteria.703Lotus 1-2-3 Function Compatibility.704Function Equivalents.704Converting Database Functions.714Appendix B Excel Function Reference.717Excel Functions by Category.717Appendix C Using Custom Number Formats.733About Number Formatting.733Automatic Number Formatting.733Formatting Numbers Using Toolbar Buttons.734Using Shortcut Keys to Format Numbers.735Using the Format Cells Dialog Box to Format Numbers.736Creating a Custom Number Format.738About Custom Number Formats.738Parts of a Number Format String.739Custom Number Format Codes.740Custom Number Format Examples.742Scaling Values.742Hiding Zeros.746Displaying Leading Zeros.747Formatting Percentages.747 4800-x FM.F 8/27/01 11:54 AM Page xxxvContents xxxvDisplaying Fractions.748Displaying N/A for Text.749Displaying Text in Quotes.749Repeating Text.749Displaying a Negative Sign on the Right.750Conditional Number Formatting.750Coloring Values.751Formatting Dates and Times.752Displaying Text with Numbers.753Displaying a Zero with Dashes.753Using Special Symbols.754Suppressing Certain Types of Entries.755Filling a Cell with a Repeating Character.756Displaying Leading Dots.757Appendix D Additional Excel Resources.759Microsoft Technical Support.759Support Options.759Microsoft Knowledge Base.759Microsoft Excel Home Page.760Microsoft Office Tools on the Web.760Internet Newsgroups.760Spreadsheet Newsgroups.761Microsoft Newsgroups.761Searching Newsgroups.762Internet Web sites.763The Spreadsheet Page.763Excel Web Source.764Stephen Bullen s Excel Page.764Spreadsheet FAQ.764Appendix E What s on the CD-ROM.765CD-ROM Overview.765Chapter Examples.766Chapter 5.766Chapter 6.766Chapter 7.767Chapter 8.767Chapter 9.768Chapter 10.768Chapter 11.768Chapter 12.769Chapter 13.769Chapter 15.770Chapter 16.770Chapter 17.771Chapter 18.772 4800-x FM.F 8/27/01 11:54 AM Page xxxvixxxvi ContentsChapter 19.772Chapter 20.772Chapter 25.773Power Utility Pak.773Registering Power Utility Pak.774Installing the trial version.774Uninstalling Power Utility Pak.774Sound-Proof 2000.775Installing the demo version.775Uninstalling Sound-Proof.776Electronic Version of Excel 2002 Formulas.776Adobe Acrobat Reader.776Index [ Pobierz całość w formacie PDF ]