[Microsoft Office Step by Step [Book]

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
This Step by Step book has been designed to make it easy for you to learn about key aspects of four of the Microsoft Office apps—Word, Excel. Before you can complete the practice tasks in this book, you need to download the book’s practice files to your computer from replace.me
 
 

[Microsoft office book 2016 pdf free download

 

От изумления у Джаббы глаза вылезли на лоб. «Похоже, она от меня не отвяжется!» И он решил не реагировать на сообщение. ГЛАВА 79 Стратмор спрятал пейджер в карман и, посмотрев в сторону Третьего узла, протянул руку, чтобы вести Сьюзан за .

 

Microsoft office book 2016 pdf free download. Microsoft Office Books

 
In the Office Background list, point to any background to display a live preview in the app window, and then click the background you want. To create a hanging indent or first line indent 1. Close the presentation without saving changes. Saving a file in either type of OneDrive location provides the option of shar- ing the file with other people. Click OK and the new table appears in your document. Display the rulers and adjust the zoom level to display most or all of the paragraphs in the document.

 
 

Download free tutorials and courses on microsoft office – Documents PDF – PDF EPUB Download

 
 

Using a concise, focused approach and user-friendly format, this book incorporates Learning Outcomes that outline the skills addressed in each lesson. Larger full-color images reflect exactly what readers should see on their own computer screens.

Each module begins with a brief overview of the principles of the lesson and introduces an updated case study for further application. This new edition is part of the acclaimed Shelly Cashman Series that has effectively introduced computer skills to millions of students like you.

A trademark step-by-step, screen-by-screen approach helps expand your understanding of Microsoft Office through experimentation, critical thought, and personalization. This new edition delivers some of today’s most effective educational materials specifically designed to capture your attention, improve retention, and prepare you for success in working with Microsoft Office Skills are accessible and easy to follow thanks to the Illustrated Series’ hallmark two-page layout, which allows you to work through an entire task without turning the page.

Praised for its concise, focused, user-friendly format, this book guides efficient study with Learning Outcomes that outline the skills covered in each lesson. Larger full-color images reflect exactly what you should see on your own computer screen. Each module begins with a brief overview of the principles of the lesson and introduces a case study for further application.

Each two-page spread focuses on a single skill, making information easy to follow and absorb. This focused, user-friendly approach uses a proven two-page layout that allows students to work through an entire task without turning the page. Clear Learning Outcomes outline the skills for each lesson, while large full-color screen images reflect exactly what students see on their own computers.

Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers.

Exit Word Online. If necessary, sign out of your OneDrive account and your Microsoft account in Word. What is Word Online? Which features that are covered in this module are not available in Word Online? Do you prefer using Word Online or the Word desktop app?

Labs 1 and 2, which increase in difficulty, require you to create solutions based on what you learned in the module; Lab 3 requires you to apply your creative thinking and problem-solving skills to design and implement a solution. First, you prepare the unformatted flyer shown in Figure 1—75a, and then you format it so that it looks like Figure 1—75b. Hint: Remember, if you make a mistake while formatting the flyer, you can use the Undo button on the Quick Access Toolbar to undo your last action.

Run Word. Display formatting marks on the screen. Type the flyer text, unformatted, as shown in Figure 1—75a, inserting a blank line between the headline and the body copy. If Word flags any misspelled words as you type, check their spelling and correct them. Save the document using the file name, Lab 1—1 Commodity Trading Flyer. Center the headline and the signature line.

Change the theme colors to Green. Change the font size of the headline to 48 point and the font to Franklin Gothic Heavy or a similar font.

Change the font size of body copy between the headline and the signature line to 24 point. Change the font size of the signature line to 26 point. Change the font of the body copy and signature line to Book Antiqua.

Bullet the four lines paragraphs of text above the signature line. Italicize the word, all, in the paragraph above the bulleted list. Insert the picture centered on a blank line below the headline. The picture is called Harvest, which is on the Data Files.

Reduce the size of the picture to approximately 3. Apply the Bevel Rectangle picture style to the inserted picture. Change the spacing after the paragraph containing the headline to 0 pt. Change the spacing above before the paragraph below the picture to 12 pt. Change the spacing above before the signature line to 18 pt. If requested by your instructor, change the street address in the flyer to your home street address. Save the flyer again with the same file name. Submit the document, shown in Figure 1—75b, in the format specified by your instructor.

Why do you think this flyer used shades of green? Problem: Your boss at Gingham Travel has asked you to prepare a flyer that promotes its business.

You prepare the flyer shown in Figure 1— Hint: Remember, if you make a mistake while format- ting the flyer, you can use the Undo button on the Quick Access Toolbar to undo your last action. Perform the following tasks: 1. Type the flyer text, unformatted. Save the document using the file name, Lab 1—2 Spring Break Flyer. Change the theme colors to the Aspect color scheme. Add bullets to the four paragraphs shown in the figure. Center all paragraphs, except the paragraphs containing the bulleted list.

Change the font size of both lines in the headline to 48 point. Change the font of the first line in the headline to Ravie, or a similar font, and the second line in the headline to Arial Rounded MT Bold, or a similar font. Shade the second line of the headline to the Dark Green, Accent 4 color, and change the font color to White, Background 1. Change the font size of the company name to 28 point, the company address to 24 point, and the bulleted list and signature line to 22 point. Underline the company name.

Italicize the word, and, in the first bulleted paragraph. Bold the word, Discounted, in the second bulleted paragraph. Change the color of this same word to Dark Purple, Accent 5. Shade the signature line to the Dark Green, Accent 4 color, and change the font color to White, Background 1. Insert two pictures on the same blank line below the headline.

Resize the top picture so that it is approximately 2. Apply the Simple Frame, White picture style to both pictures. Resize the pictures, if necessary, so that they fit on the same line. Add space as necessary between the two pictures. Change the spacing before and after the paragraph containing the company name to 0 pt, the spacing after the company address to 12 pt, and the spacing before the signature line to 12 pt.

If it flows to two pages, resize the pictures or decrease spacing before and after paragraphs until the entire flyer text fits on a single page. Add the 6-point page border shown in Figure 1—76, using the color Dark Purple, Accent 5. Center the page contents vertically. If requested by your instructor, change the company name to your last name. Submit the document, shown in Figure 1—76, in the format specified by your instructor.

Why do you think this flyer used shades of purple and green? Problem: Your boss at Antiques Galore has asked you to prepare a flyer that promotes its business. Perform the following tasks: Part 1: The flyer should contain two digital pictures appropriately resized; the Data Files contains two pictures called Vintage Phone and Vintage Scale, or you can use your own digital pictures if they are appropriate for the topic of the flyer.

The flyer should contain the headline, Antiques Galore, and this signature line: Questions? Call or find us on Facebook. The body copy consists of the following text, in any order: We sell all types of vintage items and also buy items individually or as an entire estate. Bring your items in for a free appraisal! Use the concepts and techniques presented in this module to create and format this flyer.

Be sure to check spelling and grammar. Submit your assignment and answers to the Part 2 critical thinking questions in the format specified by your instructor. Part 2: You made several decisions while creating the flyer in this assignment: where to place text, how to format the text i. What was the rationale behind each of these decisions?

When you proofread the document, what further revisions did you make and why? How would you recommend distributing this flyer? Often, data is consolidated into a summary so that people in the organization better understand the meaning of the data.

An Excel worksheet allows data to be summarized and charted easily. A chart conveys a visual representation of data. In this module, you will create a worksheet that includes a chart. The data in the worksheet and chart comprise a personal budget that contains monthly estimates for each income and expense category. Project — Personal Budget Worksheet and Chart The project in this module follows proper design guidelines and uses Excel to create the worksheet and chart shown in Figure 1 — 1a and Figure 1 — 1b.

The worksheet contains budget data for Linda Fox. She has compiled a list of her expenses and sources of income and wants to use this information to create an easy-to-read worksheet to see how much she will be ahead or behind each month. In addition, she would like a 3-D pie chart to show her estimated expenses by category for each of the 12 months.

The person or persons requesting the worksheet may supply their requirements in a requirements document, or you can create one. A requirements document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet, such as charting and web support. Figure 1 — 2 shows the requirements document for the new workbook to be created in this module. For each month, a total for income and expenses 2. For each budget item, a total for the item 3.

For the year, total all income and expenses For an introduction 4. Assign a name to the sheet tab. Why is it important to plan a worksheet? Careful planning can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful. When analyzing a problem and designing a worksheet solution, what steps should you follow?

After carefully reviewing the requirements document Figure 1— 2 and making the necessary decisions, the next step is to design a solution or draw a sketch of the worksheet based on the requirements, including titles, column and row headings, the location of data values, and the 3-D pie chart, as shown in Figure 1— 3.

The dollar signs and commas that you see in the sketch of the worksheet indicate formatted numeric values. The easiest way to select a cell make it run an application, active is to use the mouse to move the block plus sign pointer to the cell and then click. An arrow key selects the cell adjacent application, use Help, to the active cell in the direction of the arrow on the key. You know a cell is selected, or active, when a heavy border surrounds the cell and the active cell reference appears in the Name box on the left side of the formula bar.

For this In Excel, any set of characters containing a letter, hyphen as in a telephone number , reason, you might notice that or space is considered text. Text is used for titles, such as column and row titles, on the the function or appearance worksheet.

A worksheet subtitle, if included, could include a more detailed description of the content of the worksheet. Examples of worksheet titles are January Payroll and Year Projected Budget, and examples of subtitles are Finance Department and Monthly Projections, respectively.

As shown in Figure 1 — 4, data in a worksheet is identified by row and column titles so that the meaning of each entry is clear. Rows typically contain information such as categories of data. Columns typically describe how data is grouped in the worksheet, such as by month or by department. The worksheet subtitle, Monthly Estimates, identifies the type of data contained in the worksheet.

A title and subtitle help the reader to understand clearly what the worksheet contains. The following steps enter the worksheet titles in cells A1 and A2. Later in this module, the worksheet titles will be formatted so that they appear as shown in Figure 1 — 4.

When you begin typing a cell entry, Excel enables two additional boxes in the formula bar: the Cancel button and the Enter button. Clicking the Enter button text in active cell overflows into adjacent completes an entry. Clicking the cells to the right Cancel button cancels an entry. When the text is longer than the Enter button width of a cell, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

If the adjacent cells contain data, Excel hides the overflow text entered characters. The overflow characters in cell A1 are visible in the formula bar whenever that cell is active. When you complete an entry by clicking the Enter button, the insertion point disappears and the cell in which the text is entered zoom slider remains the active cell. Figure 1 — 8 Other Ways 1. To complete entry, click any cell other than active cell 3.

When you zoom in, fewer columns and rows display on your screen, and you might have to scroll more often. To zoom in, drag the zoom slider on the right of the status bar, or click the plus button on the zoom slider, until you reach your desired zoom level. In addition to the zoom slider, you also can zoom by clicking the Zoom button View tab Zoom group , selecting a desired zoom percentage Zoom dialog box , and then clicking the OK button Zoom dialog box.

AutoCorrect makes three types of Screen Resolution corrections for you: Excel may change how the groups and buttons within 1. Corrects two initial uppercase letters by changing the second letter to lowercase.

Capitalizes the first letter in the names of days. Replaces commonly misspelled words with their correct spelling. For example, Thus, your ribbon may look different from the ones in it will change the misspelled word recieve to receive when you complete the entry. Grouping income and expense data by month is a common method for organizing budget data. The column titles shown in row 3 identify the income section of the worksheet and indicate that the income values will be grouped by month.

Likewise, row 8 is clearly identified as the expense section and similarly indicates that the expense values will be estimated on a per month basis. The following steps enter the column titles in row 3. Data entered in columns should be identified using column titles to identify what the column contains. Pressing an arrow key to complete an entry makes the adjacent cell in the direction of the arrow up, down, left, or right the next active cell. However, if your next entry is in a nonadjacent cell, you can complete your current entry by clicking the next cell in which you plan to enter data.

You also can press the enter key and then click the appropriate cell for the next entry. For the Personal Budget Worksheet data, the row titles contain a list of income types and expense types. Each income or expense item should be placed in its own row. Entering one item per row allows for maximum flexibility, in case more income or expense items are added in the future. The following steps enter the row titles in the worksheet. Why is the text left-aligned in the cells? Excel treats any combination of numbers, spaces, and nonnumeric characters as text.

How to change the text alignment in a cell is discussed later in this module. Figure 1 — 13 Entering Numbers In Excel, you enter a number into a cell to represent an amount or value. The use of special characters is explained when they are used in this book. These numbers, which represent yearly income and expense amounts, are entered in rows 4—5 and 9— One of the most powerful features of Excel is the ability to perform calculations on numeric data.

Before you can perform calculations, you first must enter the data. The following steps enter the numbers in Table 1 — 1 one row at a time. You are not required When you enter a dollar value that has cents, Figure 1 — 14 however, you must add the decimal point and the numbers representing the cents. Later in this module, you will learn how to format numbers with dollar signs, commas, and trailing zeros to improve their appearance and readability.

Why are the numbers right-aligned? In Excel, you easily can perform calculations using a function, or a predefined formula. When you use functions, Excel performs the calculations for you, which helps to prevent errors and allows you to work more efficiently. The first calculation is to determine the total income for Wages and Dividends in the month of January column B.

To calculate this value in cell B6, Excel must add, or sum, the numbers in cells B4 and B5. The SUM function adds all the numbers in a range of cells. A range is a series of two or more adjacent cells in a column, row or rectangular group of cells. For example, the group of adjacent cells B4 and B5 is a range.

Many Excel operations are performed on a range of cells. After calculating the total income for January, the monthly totals for income and expenses and the yearly total for each budget item will be calculated. The following steps sum the numbers in column B. What if my screen displays the Sum menu? In this case, select the desired option Sum on the Sum menu.

How does Excel know which cells to sum? Excel automatically selects what it considers to be your choice of the range to sum. When proposing the range, Excel first looks for a range of cells with numbers above the active cell and then to the left. If Excel proposes the wrong range, you can correct it by dragging through the correct range before pressing the enter key. You also can enter the correct range by typing the beginning cell reference, a colon : , and the ending cell reference.

What is the purpose of the arrow next to the Sum button on the ribbon? To calculate each total for each range across the worksheet, you could follow the same steps shown previously in Figure 1 — 17 and Figure 1 — The cell being copied is called the source area or copy area. The range of cells receiving the copy is called the destination area or paste area. The range in each SUM function entry uses cell references that are one column to the right of the previous column. When you copy formulas that include cell references, Excel automatically adjusts them for each new position, resulting in the SUM function entries illustrated in Table 1 — 2.

Each adjusted cell reference is called a relative reference. Using the fill handle copies content to adjacent cells more efficiently. The fill handle is the small green square located in the lower-right corner of the heavy border around the active cell. The following steps use the fill handle to copy cell B6 to the adjacent cells C6:M6. Your pointer changes to a crosshair Figure 1 — If you are using a touch screen, the fill handle appears as a black and white rectangle with a blue down pointer changes to crosshair indicating fill handle is selected arrow in it.

Select source area, click Copy button Home tab Clipboard group , 2. To calculate these totals, you use the SUM function similar to how you used it to total the income and expenses for each month in rows 6 and In this example, however, Excel will determine totals for all of the rows at the same time. By determining multiple totals at the same time, the number of steps to add totals is reduced.

The following steps sum multiple totals at once. How does Excel create unique totals for each row? Sometimes a predefined function does not fit your needs; therefore, you enter a formula of your own. The formula is displayed in the formula bar and the current cell, and colored borders are drawn around the cells referenced in the formula formula displayed Figure 1 — Because the most common error when entering a formula is to reference the wrong cell, Excel highlights the cell references in the formula formula entered in B19 green outline , which will display B6 blue in color, and uses same colors to highlight highlight minus B17 red highlight the borders of the cells to help you ensure that your cell references are correct.

The minus sign — following b6 in the formula is the arithmetic operator that directs Excel to perform the subtraction operation. The following steps use the fill handle to copy the formula in cell B19 to the adjacent cells CN Release the mouse button to copy the simple formula function from the active cell to the destination area and calculate the results.

Why should I save the workbook at this time? You can exit Excel. To resume at a later time, run Excel, open the file called Linda Fox Budget, and continue following the steps from this location forward. The next store files in folders so that you easily can find the files step is to format the worksheet. You format a worksheet to emphasize certain entries later. For example, if you and make the worksheet easier to read and understand. Figure 1 — 29b shows the technology class called CIS worksheet after formatting.

As you can see from the two figures, a worksheet that is , a good practice would be to save all Excel files in formatted not only is easier to read but also looks more professional. For a discussion of formatted worksheet in Figure 1 — 29b, the following tasks must be completed: folders and detailed examples of creating folders, refer to the Office and Windows module at the beginning of this book.

What steps should I consider when formatting a worksheet? Change the font, change the font style, increase the font size, and change the font color of the worksheet titles in cells A1 and A2. Center the worksheet titles in cells A1 and A2 across columns A through N. Format the body of the worksheet. The body of the worksheet, range A3:N19, includes the column titles, row titles, and numbers. Formatting the body of the worksheet changes the numbers to use a dollars-and-cents format, with dollar signs in rows 4 and 9 and in the total rows row 6 and 17 ; changes the styles of some rows; adds underlining that emphasizes portions of the worksheet; and modifies the column widths to fit the text in the columns and make the text and numbers readable.

Although the formatting procedures are explained in the order described above, you could make these format changes in any order. Modifying the column widths, however, usually is done last because other formatting changes may affect the size of data in the cells in the column. The font, or font face, defines the appearance and shape of the letters, numbers, and special characters. Font style indicates how the characters are emphasized.

Common font styles include regular, bold, underline, and italic. The font size specifies the size of the characters. Font size is gauged by a measurement system called points. Finally, Excel has a wide variety of font colors from which to choose to define the color of the characters. When Excel first runs, the default font for the entire workbook is Calibri, with a font size, font style, and font color of point regular black. You can change the font characteristics in a single cell, a range of cells, the entire worksheet, or the entire workbook.

A cell style is a predefined font, font size, and font color that you can apply to a cell. Using the predefined styles provides a consistent appearance to common portions of your worksheets, such as worksheet titles, worksheet subtitles, column headings, and total rows. The following steps assign the Title cell style to the worksheet title in cell A1. The font and font size change to cell A1 formatted using Title cell style reflect the font changes applied to the active cell, cell A1, as a result of applying the Title Figure 1 — 32 cell style.

Different fonts often are used in a worksheet to make it more appealing to the reader and to relate or distinguish data in the worksheet. If necessary, scroll to Calibri Light. Right-click cell to display mini toolbar, 3. You apply bold style to a cell to emphasize it or make it stand out from the rest of the worksheet. The following steps apply bold style to the worksheet title and subtitle.

If the active cell contains bold text, then Excel displays the Bold button with a darker gray background. How do I remove the bold style from a cell? Clicking the Bold button Home tab Font group a second time removes the bold style.

Right-click selected cell, click Bold button on mini toolbar 4. You increase the font size of a cell so that the entry stands out and is easier to read. The following steps increase the font size of the worksheet subtitle in cell A2. An alternative to selecting a font size in the Font Size gallery is to click the Font Size box Home tab Font group , type the font size you want, and then press the enter key.

Click Font Settings Dialog box 3. Right-click cell to display 4. Changing the font color of cell entries can help the text stand out more. The following steps change the font color of a cell entry. How many colors are in the Font Color gallery? Your Font Color gallery may have more or fewer colors, depending on the color settings of your operating system.

Why does the Font Color button change after I select the new font color? Then when you font color changed Font Color button shows font color for want to change the font color of another cell to the same color, you need cell currently selected only to select the cell and then click the Font Color button Home tab Font group.

Right-click the cell to display mini 3. To do this, the 14 cells in the range A1:N1 are combined, or merged, into a single cell that is the width of the columns in the body of the worksheet. The 14 cells in the range A2:N2 are merged in a similar manner. Merging cells involves creating a single cell by combining two or more selected cells. The following steps center the worksheet title and subtitle across columns by merging cells. What happened to cells B1 through N1? After the merge, cells B1 through N1 no longer exist.

The new cell A1 now extends across columns A through N. Follow TipTrickNet. Get latest updates via email:. All Rights Reserved. You will learn how to: Get around PowerPoint Add text, tables, pictures, SmartArt, charts and more to your slides Use the Slide Master to control the way the presentation looks Add Media — audio and video to your slides Control slide transition Add animation to objects And a whole lot more.

Word This guide will help you to be confident with the basic functions of Word Outlook This user guide will enable you to save time when working in Outlook You will learn how to: Create folders to keep your email tidy See how Outlook handles attachments Use QuickSteps to do things such as filing or creating standard emails speedily Add appointments — all day events and Scheduled Meetings Create Tasks Perform an email mail merge Shortcuts for working with email and calendar Learn how to use Groups to collaborate with others Download the Outlook eBook here!

Read now. Related Posts 4 eBooks to help master the top office programs Post by: Bookboon. Why eBooks are a great addition to your learning strategy Post by: Bookboon. How to improve soft skills in your workplace in Bangladesh Post by: Bookboon.