`
`
`
`
`
`Background
`
`very book has to start somewhere. Tllll chapter stem
`from square one by introducing you to the concept ola
`spreadsheet. Also Included is I lot of Interesting tacky-mind
`information about Excel and “orbital
`
`What is Excel?
`category ofspreadsheets. Enclal i; one of selveral spreadsheet
`mediates that you can run on your PC. fitters Include 1-2-3
`and Quettro Pm.
`
`- MM [including Excel) 1: I highly interactive
`mmpiflerpmgramflafleonstmofacoflecfimotrm and
`columns die-played onscreen In a ecrollehle mallow. The
`Intersection oi each row and wiume 1: allied e cur—it which
`an hold anumber. it text string. or a Ion-null that perform:
`= calculation by using one or more other oella. Coming and
`moungcellaend medlfytog lot-molest: month a.
`
` A Bit ofI hope to explain why in this book.
`
`
`
`- spreadsheet can be served in e file for leter use or discarded
`- erfihuemedlta Intended pup-ase'l'hueflstn a
`-. preeflsheet can be formatted in earloue wear: and printed for
`are-copy reference. 111 addifien. ermine of numerical cells can
`tuned to [meme chute and nape.
`
`-
`
`' ereoetsignifieantadvamageolandeetreoleepreefieheetie
`-t the ioro‘mles recdculete their new“: "we change my of
`I e cells that meyuae. he a result, efleryrou set uproot
`. pleadshget by defining i'ornaulas, you can use this "model“ to
`-
`Iore difiermt poeeihllltlee. with new little eddltlonel effort.
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 1 of 5
`Exhibit 2004/ Page 1 of 5
`
`
`
`
`
`
`E...
`
`I '
`
`prflhnm:
`ruminant:
`
`-
`
`l our-
`
`I.
`
`figur- i-1: The Office Assistant pops up to provide help when needed.
`
`Built-in Functions
`Est-eel includes an enonnous collection of built-in functions that you can use Ln your
`iotrauias. [n auntiilon to common functions. such as SUM and AVEMC-E, you can
`choose Functions that perform sophisticated operations that otherwise are oilflcuit
`or Impossible to do. For example. the CDRREL function calculates the correlation
`coefficient for two sets of data. 1i'ou also can develop other functions by using the
`we. macro language [it's not as dlEfloult as you may think}.
`
`Customirable Toolbars
`Exeel's toolbon— groups ot‘ buttons representlng commends—are real time-Savers.
`enaoung you to perform common commands without. using the menu. 1i'ou can
`customize your toolbars as adding buttons for tasks that you do most often. To find
`out what a button does. drag the mouse over a toolbar button and pause for a
`second. Excel pops up a brief description oi the button.
`
`Beginning with Excel 9?. the menu bar at the top of the screen is actuallyr a toolbar.
`As such. you can easily customize it or even those it to a dlflerent location on the
`SHEER.
`
`lFlexlble Text sansling
`Although Excel'e forte is number crunching. it‘s not too shabby at handling text.
`the can tonnat or orient test that you put in cells. You also can insert text boxes
`
`{which you can mote and resizej anywhere on your worksheet.
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 2 of 5
`Exhibit 2004/ Page 2 of 5
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`Excel in the ml}r spreadsheet that enables you Easily tn [cm-nut main-Mun!
`characters mm: a cell. For turnple. if a cell contains bent. 3m nan snake one letter
`
`you tn monthly and nugmnnt a wide assortment net graph types. You can Insert a
`chart anywhere. in amt-lent nrr plant It on a special chart sheet.
`
`Integrated Mapping
`Exnnl's mapplng feature ints you display your data in the form at a anagraphlc map
`{see Figure 1-3}. For mple. ycru can mil}! create an. nfirnflhl'e map that shuws
`you: nomparry’: sales volume by state.
`
`bold war a different cn-lnr. Enters aha-ting {natures — among the best available In any spreadsheet— Enable
`gem-Inland 'M‘I‘J‘l. nnlv n im- mnuse didss.
`
`I
`
`figur- 1-3: This map
`
`'u._.'..'l
`
`I
`
`Drawing Tools
`Eucnl Enduring an “talent set of :irnvnng tool: that ennhles y'nu In create
`ammve dtaa'rams and basic draw-tugs dEI-nclly on your worlnlhnet or chart. Fur
`mph. you can Include a BMW: flow diagram along with your numerical anally-nu.
`
`
`
`
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 3 of 5
`Exhibit 2004/ Page 3 of 5
`
`
`
`
`gram -— In cIudlng Excel — is that you can use formulas
`to create dynamic models that instantly recalculate when you
`change values in cells to which the formulas refer. When you
`change 1values in cells in a systematic manner and observe the
`fleets on specific formula cells. you're performing a type of
`teller-if a11alysis.What-it analysis is the process of asking quesa
`tions such asr “What if the interest rate on the loan changes to
`3.5 rather than 9i] percent?“ or “What if we raise the prices of
`our products by 5 percent?"
`
`
`
`'
`
`._:.
`
`
`
`;f--rforming
`readsheet
`
`at-If Analysis
`
`
`One of the most appealing aspects of a spreadsheet pro
`
`
`.r.pjl."--:':~".'-_-..-_--'
`
`
`
`-'-1251-34,4:'-".-_:
`
`
`
`
`ti you set up your spreadsheet properly. answering such ques»
`tions is a matter ol plugging In new values and observing the
`*
`results of the recalculation. Excel provides useful tools to
`
`assist you in your what-[E endeavors.
`
`
`What-If Example
`
`_
`:-§'_'.'_
`
`
`
`--I.r_.|'.-
`
`.
`
`Figure 26-1 shows a spreadsheet that calculates inlorn'iation
`pertaining to a mortgage loan. The worksheet is dltdded into
`two sections: the input cells and the result cells. Column D
`shows the formulas stored in column C.
`
`'t‘.1th this worksheet. you can easilyr answer the inllowlng
`what—if questions:
`
`1* What it] can negotiate a tower purchase price on the
`property?
`
`}rfii
`
`+ 1ails-alt ii the lender requires a Ell-percent down payment?
`4- What III can get a sores:- mortgage?
`
`+ What it the interest rate decreases to 7.5 percent?
`
`
`
`_r'l'"
`is)
`
`+
`
`_"+ ”+1
`
`+
`
`In Wellhew'
`
`_. awn-tat seeps
`
`Types swans;
`Analysis
`
`Manuel What-ti
`firmly-sis ,
`
`Macro-Assisted
`Wh‘et-lthnolysis
`
`.-
`
`-
`
`-
`
`cleanse Dee "tastes
`
`. using Scenario
`Manager
`ScenaridManager I
`-_ Limitohons;
`
`+ es +
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 4 of 5
`Exhibit 2004/ Page 4 of 5
`
`
`
`
`' I
`
`gfrom Excel:- Changes inh-ie
`_
`source are rd’leclefl eutori-iaficallyi This asualiy pmdufiés befier ream i
`than the Bin-lap option. Double-click the object after pasting ittoyfl
`—':
`fhe source data in Ekeei.
`:
`A bitmap om thaigehmifiae famethg from ensue. chime '-
`-suurce are refl‘ecteé autum‘afically. Danie-did: ther object afier
`r;
`ittoedittheuurceéa‘kainflcel.
`'
`I
`A table that isfermatted as the en‘ginai Excei range: Use this form:
`when you expect to publish-the docummt as a Web page.
`
`A linked:6pr meapdudes the angel iqqfiamng. 'Duuhlfifick =-
`ohied afterpasting he editthe soqrce age in Excel.
`A Word table that is icrmatted es the
`aigina! Ezra! range. Changs it
`the source ae reflected automatically
`Text (m: a uhlenfiat eprrespunds :1}sz HmmeWe.
`from Excel ismt' hinge-fled. Changes in the seam: aye reflected
`
`2'
`
`[
`
`_-
`
`Miceosifi line!
`Woriisl'eet Ghiert
`Furrnarhed Text
`(RTFJ
`Urifflfl'ratted ”rec;
`
`Picture
`
`Bin-nap
`
`HTML Fame!
`
`._
`
`-.
`
`_
`.
`
`'
`
`+ TExtdocuments fmm ntherproduete: such as wart procrassors
`_ + Drawings or pictures from dher profit-Mt!
`' + Iniemation from special 01E server éfiblieations. filth as Microsoft Equal! Ii}.
`|
`' _+ Sound files
`
`+ Vida: or animationiiies
`
`“I I'
`
`I
`
`E
`
`.
`‘
`
`.
`'. Most of thg major Wind-awe appiiatlans support OLE. Youcan embed an abject inc.
`your document in eithernf two wets:
`
`
`
`
`
`IPR 2018-00044
`PR 2018-00044
`Exhibit 2004/ Page 5 of 5
`Exhibit 2004/ Page 5 of 5
`
`
`