`
`A Bit of
`Background
`
`very book has to start somewhere. This chapter starts
`from square one by Introducing you to the concept of a
`spreadsheet. Also included is a lot of interesting background
`information about Excel and Windows.
`
`What Is Excel?
`pec at.Scat Excel is one of ianarat spreadsheet
`
`products that you can run on your PC. Others include 1-2-3
`and Quattro Pro,
`
`A spreadsheet (including Excel) is a highly interactive
`computer program that consists of a collection of rows and
`columns displayed onscreen in a scrollable window. The
`Intersection of each row and column is called a cell, which
`an hold a number, a text string, or a formula that performs
`a calculation by using one or more other cells. Copying and
`moninisose ant modifying formulas is easy with a
`
`T hope to explain why in this book.
`
`4 spreadsheet can be saved inafile for later use or discarded
`after It has served its Intended purpose. The cells Ina
`spreadsheet can be formatted in varlous ways and printed for
`ard-copy reference. In addition, groups of numerical cells can
`be used ta generate charts and maps.
`
`The most significant advantage of an electronic spreadsheet ls
`at the formulas recalculate their results if you change any of
`the cells that they use. As a result. after you set up your
`spreadsheet by defining formulas, you can use this “model” to
`explore different possibilities, with very little additional effort,
`lis currently the best-selling Windows spreadsheet—and
`
`
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 1 of 5
`Exhibit 2004/ Page 1 of 5
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
` aathe ras ry a]
`
`Figure 1-2: The Office Assistant pops up to provide help when needed.
`
`Built-in Functions
`Excel includes an enormous collection of built-in functions that you can use in your
`formulas. In addition to common functions, such as 3UM and AVERAGE, you can
`choose functions that perfarm sophisticated operations that otherwiseare difficult
`or impossible to da. For example, the CORREL function caleulates the correlation
`coefficient for two sets of data. You also can develop other functions by using the
`VBA macro language(it's not as difficult as you may think).
`
`Customizable Toolbars
`Excel's toolbars— groups of buttons representing commands —are real time-savers,
`enabling you to perform common commands without using the menu. You can
`customize your toolbars by adding buttons for tasks that you do mostoften. Tofind
`out what a button does, drag the mouse over a toolbar button and pause for a
`second. Excel pops up a briei description of the button.
`
`Beginning with Excel 97, the menu bar at the top of the screen is actually a toolbar.
`As such, you can easily customize tt or even move it to a different location on the
`screen.
`
`Flexible Text Handling
`Although Excel's forte is number crunching,it’s not too shabby at handling text.
`You can format or orlent text that you putin cells. You also can insert text boxes
`
`(which you can move and resize) anywhere on your worksheet.
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 2 of 5
`Exhibit 2004/ Page 2 of 5
`
`
`
`
`
`
`Excel is the only spreadsheet that enables you easily to format individual
`characters within a cell, For examole,if a cell contains text, you can make one letter
`bold or a different color.
`
`
`
`
`
`
`
`E
`
`
`
`
`
`Great Charts
`Excel's charting features —among the best available in any spreadsheet— enable
`you to modify and augment a wide assortmentof graph types. You can Insert a
`chart anywhere in a worksheet or place It on a special chart sheet.
`
`Integrated Mapping
`Excel's mapping feature lets you display your data in the form of a geographic map
`(see Figure 1-2). For example, you can easily create an attractive map that shows
`your company's salea volume by state.
`
`Figure 1-3: This map was generated with only a few mouse clicks.
`
`1 hasbeen
`
`Drawing Tools
`Exeel includes an excellent set of drawing tools that enables you to create
`attractive dlagrams and basic drawings directly on your worksheet or chart. For
`example, you can include a simple flow diagram along with your numerical analysis.
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 3 of 5
`Exhibit 2004/ Page 3 of 5
`
`
`
`
`Li
`
`gram — including Excel —\s that you can use formulas
`<9 create dynamic modelsthatinstantly recalculate when you
`change values in cells to which the formulas refer. When you
`change values in cells in a systematic manner and observethe
`effects on specific formula cells, you're performing a type of
`what-if analysis. What-if analysis is the process of asking ques-
`tions such as, “Whatif the interest rate on the loan changes to
`3.5 rather than 9.0 percent?” or “Whatif we raise the prices of
`our products by 5 percent?"
`
`
`
`
`
`Performing
`oF readsheet
`
`at-If Analysis
` O- ofthe most appealingaspects of a spreadsheet pro-
`
`
`Stdestataayea
`
`
`
`
`seeeeerie
`
`
`
`
`# you set up your spreadsheet properly, answering such ques-
`tions is a matter of plugging in new values and observing the
`
`
`_
`results of the recalculation. Excel provides useful tools to
`
`
`assist you in your what-if endeavors.
`
`
`
`4 What-if Example
`
`Figure 26-1 shows a spreadsheet that calculates information
`| pertaining to a mortgage loan. The worksheetis divided into
`two sections: the input cells and the result cells. Column D
`shows the formulas stored in column C.
`
`-
`
`With this worksheet, you can easily answer thefollowing
`|
`- what-if questions:
`
`+ What ifI can negotiate a lower purchase price on the
`property?
`Whatif the lender requires a 20-percent down payment?
`+ Whatif] can get a 40-year mortgage?
`+ Whatif the Interest rate decreases to 7.5 percent?
`
`BE |
`
`
`
`Tarye)
`
`+
`
`+¢ + +
`
`In This Chapter |
`
`_ A WheExample
`
`:
`
`Macro-Assisted
`WholAnalysis
`Creating Dato Tables
`Using ‘Scenario
`Manager
`ScenarioManager
`__ Limitations
`
`+ + + +
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 4 of 5
`Exhibit 2004/ Page 4 of 5
`
`
`
`
`H m ‘"’) Most ofths major Windows appliations supportOLE. Youcan embed an object ip
`
`inf
`an objectirom another
`It: The OLE objects can
`+ Textdocuments from otherproducts' such as wort processors
`:
`- . * Dravings orpictures from dher products
`»)* Infomation from special OIE server Applications, sich as Microsoft Equatse a
`“ * Sour files
`* Vides or animationfiles
`
`your docunentin either:of two ways:
`
`:
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 5 of 5
`Exhibit 2004/ Page 5 of 5
`
`
`
`
`Paste type
`Microseft Excel
`WorksheetObject
`Formatied Text
`(RTF)
`Unformatted Text
`
`Picture
`
`z
`:
`A linked‘object thatincludesthe Excelformatting. Double-click &
`Ls
`object afterpastingittoeditthesoyrcedata in Excel.
`A Wordtable that is formatted as the criginal Excel range. Changes in
`the source we reflected automatically,
`Text (nota table)that corresponds to Word's Normalstyle.
`Forma
`from Excel isnot transferred. Changes i the source ate reflected
`automatically.
`;
`3
`A picture obpctthat retaihs the formatingfrom Excel; Changes inthe
`*
`ae
`1
`a
`a
`source are tdlectedautorfiatically. This usually produces better reais
`than the Bitnap option. Double-click the object after pastingit to sc
`the source dea in Excel, i
`A bitmap obpct thatretaingthe formatting from Excel, Changes
`int
`Source are rdlected automatically. Double-click theobject after
`pax
`it to edit the source data in Excel,
`=
`i
`A table that isformatted as the original txcel range. Use this forma
`when you exrect to publishthe documet as a Web page,
`
`i
`
`mbedding Objects
`
`: E
`
`
Accessing this document will incur an additional charge of $.
After purchase, you can access this document again without charge.
Accept $ Charge
Still Working On It
This document is taking longer than usual to download. This can happen if we need to contact the court directly to obtain the document and their servers are running slowly.
Give it another minute or two to complete, and then try the refresh button.
A few More Minutes ... Still Working
It can take up to 5 minutes for us to download a document if the court servers are running slowly.
Thank you for your continued patience.
This document could not be displayed.
We could not find this document within its docket. Please go back to the docket page and check the link. If that does not work, go back to the docket and refresh it to pull the newest information.
Your account does not support viewing this document.
You need a Paid Account to view this document. Click here to change your account type.
Your account does not support viewing this document.
Set your membership
status to view this document.
With a Docket Alarm membership, you'll
get a whole lot more, including:
- Up-to-date information for this case.
- Email alerts whenever there is an update.
- Full text search for other cases.
- Get email alerts whenever a new case matches your search.
One Moment Please
The filing “” is large (MB) and is being downloaded.
Please refresh this page in a few minutes to see if the filing has been downloaded. The filing will also be emailed to you when the download completes.
Your document is on its way!
If you do not receive the document in five minutes, contact support at support@docketalarm.com.
Sealed Document
We are unable to display this document, it may be under a court ordered seal.
If you have proper credentials to access the file, you may proceed directly to the court's system using your government issued username and password.
Access Government Site
