WIXLIB

8Computer BasicsHow to Use the LessonsEvery topic is presented on two facing pages, so that you can concentrate on the lessonwithout having to worry about turning the page. Since this is a hands-on course, each lessoncontains an exercise with step-by-step instructions for you to follow.To make learning easier, every exercise follows certain conventions: Anything you’re supposed to click, drag, or press appears like this. Anything you’re supposed to type appears like this. This book never assumes you know where (or what) something is. The first time you’retold to click something, a picture of what you’re supposed to click appears either in themargin next to the step or in the illustrations at the beginning of the lesson.Illustrations show what yourscreen should look like as youfollow the lesson. They alsodescribe controls, dialog boxes,and processes.2424Microsoft Excel 2000Microsoft Excel ValuesFigure 4-3TheFigureNumbers tab4-3of theFormatdialogtabbox.The CellsNumbersof theFormat Cells dialog box.Figure 4-4TheFigureExpense Report4-4worksheetvalues ReportbeforeThe Expensebeingformatted.worksheetvalues beforebeing formatted.Preview of theselectednumberPreviewof theformatselected numberformatSelect a numbercategorySelect a numbercategorySelect a numberformatSelect a numberformatFigure 4-5TheFigureExpense Report4-5An easy-to-understandintroduction explains the task ortopic covered in the lesson andwhat you’ll be doing in theexercise.worksheetvalues Reportafter beingThe Expenseformatted.worksheet values after beingformatted.Figure 4-3Figure 4-3Figure 4-4Figure 4-4Tips and traps appear in themargin.Icons and pictures appear in themargin, showing you what toclick or look for.Clear step-by-step instructionsguide you through the exercise.Anything you need to clickappears like this. 2002 CustomGuide, Inc.You can also formatvaluestheYou bycanusingalso formatFormattingvalues by toolbarusing theor Formattingby selectingtoolbarCellsFormator by selectingfromthe menuand CellsFormatclickingfrom the menu andNumbertab.clickingtheNumber tab.Comma StyleCommabutton StylebuttonFigure 4-5Figure 4-5In this lesson, you will learn how to apply number formats. Applying number formatting changeshoware displayed—itdoesn’tactualinformationin anyway. Excelis oftenIn valuesthis lesson,you will learnhow tochangeapply artsome numberformattingautomatically.For example,you Exceluse a dollarhowenoughvalues toareapplydisplayed—itdoesn’tchange theactual informationin anyifway.is oftensignto indicate 548.67),Excel willautomaticallythe currencysmartenoughcurrencyto apply (suchsome asnumberformattingautomatically.Forapplyexample,if you usenumbera dollarformatyou. currency (such as 548.67), Excel will automatically apply the currency numbersign forto indicateformat for you.The Formatting toolbar has five buttons (Currency, Percent, Comma, Increase Decimal, andThe Formattingbuttons al)toolbaryou canhasusefiveto quicklycommonnumberformats.If noneDecimal,of these andbuttonsDecimal)youcanuseneedto quicklyapplycommonformats.If none ofthese buttonshasDecreasewhat you’relookingfor,youto use theFormatCellsnumberdialog boxby selectingFormatmenulookingand clickingtheneedNumbernumberstheselectingFormat CellsCellshasfromwhattheyou’refor, youto usetab.theFormattingFormat Cellsdialog withbox byFormat fromtheasmenuandclickingthe NumberFormattingFormat options.CellsCellsboxdialogisn’tfast asusingthe toolbar,but ittab.givesyou morenumbersprecisionwithand theformattingdialogas fastinasthisusingthe toolbar, but it gives you more precision and formatting �ll use both methods in this lesson.1. Select the cell range D5:D17 and click the Comma Style button onthe celltoolbar.range D5:D17 and click the Comma Style button he comma) and two decimal places to the selected cellExcela hundreds separatorrange.Excel adds a hundreds separator (the comma) and two decimal places to the selected cellrange.

Introduction When you see a keyboard instruction like “press Ctrl B ,” you should press andhold the first key ( Ctrl in this example) while you press the second key ( B in thisexample). Then, after you’ve pressed both keys, you can release them. There is usually more than one way to do something in Word. The exercise explains themost common method of doing something, while the alternate methods appear in themargin. Use whatever approach feels most comfortable for you. Important terms appear in italics the first time they’re presented. Whenever something is especially difficult or can easily go wrong, you’ll see a:NOTE:immediately after the step, warning you of pitfalls that you could encounter if you’re notcareful. Our exclusive Quick Reference box appears at the end of every lesson. You can use it toreview the skills you’ve learned in the lesson and as a handy reference—when you needto know how to do something fast and don’t need to step through the sample exercises.Formatting a WorksheetFormatting a Worksheet925252. Click cell A4 and type Annual Sales.cell A4inandtype AnnualSales. as currency.2. ClickThe numbersthis columnshould be formattedAnything you need to typeappears like this.The numbers in this column should be formatted as currency.3. Press Enter to confirm your entry and overwrite the existing Enter to confirm your entry and overwrite the existing3. Pressinformation.information.4. Select the cell range G5:G17 and click the Currency Style button onthe cell rangeG5:G17 and click the Currency Style button on4. Selectthe Formattingtoolbar.theA Formattingdollar sign and toolbar.two decimal places are added to the values in the selected cell range.A dollar sign and two decimal places are added to the values in the selected cell range.5. Select the cell range F5:F17 and click the Percent Style button onthe cell rangeF5:F17 and click the Percent Style button on5. Selectthe s percentage style number formatting to the information in the Tax column.Noticetherepercentageisn’t a decimalplace—Excelroundsdecimal placesto thewholeExcelappliesstyle numberformattingto anythe informationin theTaxnearestcolumn.number.suitablehere—you wantto includea �tisn’ta decimalplace—Excelroundsany decimalplacesplaceto thewholenumber.Thattaxisn’tsuitable here—you want to include a decimal place to accurately showthe exactrate.the exact tax rate.Currency StyleCurrencyStylebuttonOtherbuttonWays to ApplyCurrencyFormatting:OtherWays toApplyCurrencyFormatting: Type thedollar sign ( )you entera number. Typebeforethe dollarsign ( )before you enter a number.6. With the Tax cell range still selected, click the Increase Decimalthe TaxcellFormattingrange still toolbar.selected, click the Increase Decimal6. Withbuttonon theWhenever there is more thanone way to do something, themost common method ispresented in the exercise andthe alternate methods arepresented in the margin.buttonon theFormattingExcel addsone decimalplace totoolbar.the information in the tax rate column.Exceladdsdecimalplacetheto datethe informationin datethe taxrate column.Next,youonewantto changeformat in thecolumn.There isn’t a “Format Date”buttonthetoFormattingso youhavecolumn.to formatthe dateusingtheNext,youonwantchange thetoolbar,date formatinwillthe dateThereisn’tcolumna “FormatDate”buttonon theFormattingtoolbar, so you will have to format the date column using theFormatCellsdialog box.FormatCells dialogtoolbarbox. is great for quickly applying the most common formatting options toThe Formattingbut it doesn’teveryformattingTo see and/oruse everypossibleThecells,Formattingtoolbarofferis greatforavailablequickly applyingtheoption.most commonformattingoptionstocells,but it ion.CellsTo seeand/oruseYoueverycharacterformattinghave touse the Formatdialogbox.canpossibleopen thecharacteroptionyoueitherhaveselectingto use theFormat Format Cellsbox.menuYou orcanright-clickingopen theFormatformattingCells dialogbox byCellsdialogfrom thefromselectingthe shortcutmenu.Cells from the menu or right-clickingand selectingFormatFormatCells dialogbox Cellsby eitherFormat and selecting Format Cells from the shortcut menu.7. With the Date cell range still selected, select Format Cells fromDateselectcell rangestill fromselected,selectFormat clickCells OK.from7. Withthethemenu,4-Mar-97the Typelistbox andthe menu, select 4-Mar-97 from the Type list box and click OK.That’s all there is to formatting values–not as difficult as you thought it would be, was it? Thefollowingtableliststhe five buttonson theFormattingtoolbaryou itcanuse tobe,applyThat’sall thereis toformattingvalues–notas difficultas youthoughtwouldwas numberit? Theformattingthe valuesyour worksheets.followingtabletoliststhe fiveinbuttonson the Formatting toolbar you can use to apply numberformatting to the values in your worksheets.Table 4-2: Number Formatting Buttons on the Formatting ToolbarTable4-2:Number Formattingon the Formatting ToolbarButtonNameExample ButtonsFormattingButton NameExample 1,000.00 FormattingAdds a dollar sign, comma, and two decimal places.Currency 1,000.00 Adds a dollar sign, comma, and two decimal places.Currency100%Displays the value as a percentage with no decimal places.Percent100%Displays the value as a percentage with no decimal places.Percent1,000Separates thousands with a comma.Comma1,000Separates thousands with a comma.Comma1000.00Increases the number of digits after the decimal point by oneIncrease Decimal1000.00Increases the number of digits after the decimal point by oneIncrease Decimal1000.0Decreases the number of digits after the decimal point by oneDecrease Decimal1000.0Decreases the number of digits after the decimal point by oneDecrease DecimalQuick ReferenceQuick ReferenceTo Apply NumberTo Formatting:Apply NumberFormatting: Select the cell or cell rangeyouthewantand click Selectcelltoorformatcell rangeappropriatenumberyouthewantto format andclickthe formattingappropriatebutton(s)number on theFormattingtoolbar.formattingbutton(s)on theFormattingtoolbar.Or.Or. Select the cell or cell range youwantformat,select Selectthetocellor cellrangeFormatyoufromthe menu,want toCellsformat,selectFormatclickthe Numberand clickspecify Cellsfrom thetab,menu,numberyou wantthe theNumbertab,formattingand specifyapply.formatting you wantthe tonumbertoOr.apply.Or. Select the cell or cell range youwantformat,right-clickthe Selectthetocellor cellrange youcell rangeand selectwantcellto orformat,right-clicktheCellsandfromselectthe shortcutcell Formator cell rangemenu,clickfromthe bermenu,the theNumbertab,want to apply.andformattingspecify theyounumberformatting you want to apply.Tables provide summaries of theterms, toolbar buttons, orshortcuts covered in the lesson.CustomGuide’s exclusive QuickReference is great for when youneed to know how to dosomething fast. It also lets youreview what you’ve learned inthe lesson.

Chapter One: TheEssentialsChapter Objectives: Learn the difference between hardware and software Discover the various types of computers and their roles See what’s on the front, back, and inside of a computer Learn about the various ports on a computer Understand what determines a computer’s performance See what you should look for when buying a computerComputers are useful: they help us write letters, find information on the Internet, andeven create our own music CDs. Some people love computers—they speak a differentlanguage that includes nonsensical words like IP address and gigabytes. But most of usare somewhat clueless when it comes to computers. We know how to turn our computeron, how to surf th

Welcome to CustomGuide: Computer Basics. CustomGuide courseware allows instructors to create and print manuals that contain the specific lessons that best meet their students’ needs. In othe