Benchmark series microsoft word 2016 levels 1&2 ebook free download. Return Process
If it is followed by an ellipsis … , clicking the option will open a dialog box. Choosing Options from a Dialog Box or Task Pane Some buttons and options open a dialog box or a task pane containing options for applying formatting or otherwise modifying the data in a file.
For example, the Font dialog box shown in Figure G. The dialog box contains two tabs—the Font tab and the Advanced tab. The tab that displays in the front is the active tab. Alternately, press the Alt key and then type the letter that is underlined in the tab name. To move forward from option to option using the keyboard, you can press the Tab key. If the option displays with an underlined letter, you can choose it by pressing the Alt key and the underlined letter.
When an option is selected, it is highlighted in blue or surrounded by a dotted or dashed box called a marquee. A dialog box contains one or more of the following elements: list boxes, option boxes, check boxes, text boxes, command buttons, radio buttons, and measurement boxes. Click an option in the list to select it. If the list is long, click the up or down arrows in the scroll bar at the right side of the box to scroll through all the options. Alternately, press the up or down arrow keys on the keyboard to move through the list, and press the Enter key when the desired option is selected.
Option boxes contain a drop-down list or gallery of options that opens when the arrow in the box is clicked. An example is the Font color option box in Figure G. To display the different color options, click the arrow at the right side of the box. If a check mark appears in the box, the option is active turned on. If the check box does not contain a check mark, the option is inactive turned off. Click a check box to make the option active or inactive. For example, see the Find and Replace dialog box shown in Figure G.
In a text box, type or edit text with the keyboard, using the left and right arrow keys to move the insertion point without deleting text and use the Delete key or Backspace key to delete text. Use a command button to execute or cancel a command. Some command buttons display with an ellipsis To choose a command button, click with the mouse or press the Tab key until the command button is surrounded by a marquee and then press the Enter key.
Only one radio button can be selected at any time. When the button is selected, it is filled with a dark circle. Click a button to select it, or press and hold down the Alt key, press the underlined letter of the option, and then release the Alt key. An example is shown in Figure G.
To increase or decrease the number in a measurement box, click the up or down arrow at the right side of the box. Using the keyboard, press and hold down the Alt key and then press the underlined letter for the option, press the Up Arrow key to increase the number or the Down Arrow key to decrease the number, and then release the Alt key.
Choosing Commands with Shortcut Menus The Office applications include shortcut menus that contain commands related to different items. The shortcut menu will appear wherever the insertion point is positioned. In some cases, the Mini toolbar will also appear with the shortcut menu. To select an option from a shortcut menu with the mouse, click the option. If you are using the keyboard, press the Up or Down Arrow key until the option is selected and then press the Enter key. To close a shortcut menu without choosing an option, click outside the menu or press the Esc key.
For example, the steps to save, close, and print are virtually the same whether you are working in Word, Excel, or PowerPoint. This consistency greatly enhances your ability to transfer knowledge learned in one application to another within the suite.
Another benefit to using Microsoft Office is the ability to have more than one application open at the same time and to integrate content from one program with another. For example, you can open Word and create a document, open Excel and create a worksheet, and then copy a worksheet from the workbook into Word. The Windows taskbar at the bottom of the screen displays buttons representing all the programs that are currently open.
For example, Figure G. To move from one program to another, click the taskbar button representing the desired application. Maintaining Files and Folders Windows includes a program named File Explorer that can be used to maintain files and folders. To open File Explorer, click the folder icon on the Windows taskbar. Use File Explorer to complete tasks such as copying, moving, renaming, and deleting files and folders and creating new folders.
Some file management tasks can also be completed within Word, Excel, PowerPoint, or Access by clicking File and then Open or Save As and then clicking the Browse option to browse folders and files in a dialog box.
If you are using your OneDrive account or another cloud-based storage service, some of the file and folder management tasks may vary. In File Explorer and in the Open or Save As dialog box, the names of files and folders are displayed in the Content pane. Each file has an icon showing what type of file it is, while folders are identified with the icon of a folder. See Figure G. Create a new folder by clicking the New folder button at the top of the File Explorer window or in the dialog box.
A new folder displays with the name New folder highlighted. Type a name for the folder to replace the highlighted text, and then press the Enter key. Folder names can include numbers, spaces, and some symbols. Selecting and Opening Files and Folders Select files or folders in the window to be managed. To select one file or folder, simply click on it. To select several adjacent files or folders, click the first file or folder, hold down the Shift key, and then click the last file or folder.
To select files or folders that are not adjacent, click the first file or folder, hold down the Ctrl key, click any other files or folders, and then release the Ctrl key. To deselect, click anywhere in the window or dialog box.
When a file or folder is selected, the path to the folder displays in the Address bar. If the folder is located on an external storage device, the drive letter and name may display in the path. A right-pointing arrow displays to the right of each folder name in the Address bar. Click the arrow to view a list of subfolders within a folder. Double-click a file or folder in the Content pane to open it. You can also select one or more files or folders, right-click, and then click the Open option in the shortcut menu.
Select a location in the Navigation pane. GS With the folder name highlighted, type a new name. Files and folders appear in the Content pane. To delete a file or folder, select it and then press the Delete key. Alternatively, use the Delete button on the Home tab of the File Explorer window, or click the Organize button and then Delete in the dialog box.
You can also right-click a file or folder and then choose the Delete option in the shortcut menu. Files and folders deleted from the hard drive of the computer are automatically sent to the Recycle Bin, where they can easily be restored if necessary. If a file or folder is stored in another location, such as an external drive or online location, it may be permanently deleted. In this case, a message may appear asking for confirmation. To confirm that the file or folder should be deleted, click Yes.
To view the contents of the Recycle Bin, display the Windows desktop and then double-click the Recycle Bin icon. Deleted items in the Recycle Bin can be restored to their original locations, or the Recycle Bin can be emptied to free up space on the hard drive.
Moving and Copying Files and Folders A file or folder may need to be moved or copied to another location. If a copy is pasted to the same folder as the original, it will appear with the word Copy added to its name.
To copy files in the Open or Save As dialog box, use the Organize button drop-down list or right-click to access the shortcut menu. Files can also be dragged from one location to another. To do this, open two File Explorer windows. Click a file or folder and drag it to the other window while holding down the left mouse button. Renaming Files and Folders To rename a file or folder in File Explorer, click its name to highlight it and then type a new name, or right-click the file or folder and then select Rename at the shortcut menu.
You can also select the file or folder and then click the Rename button on the Home tab of the File Explorer window or click Rename from the Organize button drop-down list at the Open or Save As dialog box. Type in a new name and then press the Enter key. Viewing Files and Folders Change how files and folders display in the Content pane in File Explorer by clicking the View tab and then clicking one of the view options in the Layout group. View files and folders as large, medium, or small icons; as tiles; in a list; or with details or information about the file or folder content.
At the Open or Save As dialog box, click the Change your view button arrow and a list displays with similar options for viewing folders and files.
Click to select an option in the list or click the Change your view button to see different views. Excel files have the extension. By default, file extensions are turned off.
To view file extensions, open File Explorer, click the View tab, and then click the File name extensions check box to insert a check mark. Click the check box again to remove the check mark and stop viewing file extensions. Viewing all files at the Open dialog box can be helpful in determining what files are available. Turn on the display of all files at the Open dialog box by clicking the file type button arrow at the right side of the File Name text box and then clicking All Files at the drop-down list.
Managing Files at the Info Backstage Area The Info backstage area in Word, Excel, and PowerPoint provides buttons for managing files such as uploading and sharing a file, copying a path, and opening File Explorer with the current folder active.
Click the File tab and then click the Info option. Click the Upload button to upload the open file to a shared location such as a OneDrive account. Click the Share button and a window displays indicating that the file must be saved to OneDrive before it can be shared and provides an option that, when clicked, will save the file to OneDrive. Click the Copy Path button and a copy of the path for the current file is saved in a temporary location. Click the Open file location button and File Explorer opens with the current folder active.
Click the Share button to display a window with options for sharing the file with others and specifying whether the file can be viewed and edited, or only viewed.
Click the Open file location button to open File Explorer with the current folder active. Some references in the text might not perfectly match what you see on your screen, so you may not be able to perform certain steps exactly as written.
For example, an item in a dropdown gallery might appear in a different column or row than what is indicated in the step instructions. Before you begin learning the applications in the Microsoft Office suite, take a moment to check the display settings on the computer you are using. A computer monitor set at a high resolution will have the ability to show more buttons in the ribbon than will a monitor set to a low resolution. At the Windows desktop, right-click in a blank area of the screen.
In the shortcut menu, click the Display settings option. At the Settings window with the Display option selected, scroll down and look at the current setting displayed in the Resolution option box. Note: Depending on the privileges you are given on a school machine, you may not be able to complete Steps 4—5.
If necessary, check with your instructor for alternative instructions. Click the Keep Changes button. At the Settings window, take note of the current DPI percentage next to the text Change the size of text, apps, and other items. Click the Close button to close the Settings window. You can download all the files at once described in the activity below , or download only the files needed for a specific chapter.
Make sure you have an active internet connection before starting this activity. Check with your instructor if you do not have access to your Cirrus online course. Navigate to the Course Resources section of your Cirrus online course. Note: The steps in this activity assume you are using the Chrome browser. If you are using a different browser, the following steps may vary. A zip file containing the student data files will automatically begin downloading from the Cirrus website. Click the button in the lower left corner of the screen once the files have finished downloading.
Right-click the StudentDataFiles folder in the Content pane. Click the Copy option in the shortcut menu. Click the Home tab in the File Explorer window. Click the Paste button in the Clipboard group. Close the File Explorer window by clicking the Close button in the upper right corner of the window.
An Excel spreadsheet can be used for such activities as creating financial statements, preparing budgets, managing inventory, and analyzing cash flow. This chapter will introduce the basics of creating a worksheet, opening workbooks, and saving workbooks.
In a worksheet, learn to enter data, as well as the use of formulas to calculate sums and averages. Learn to enter data quickly and efficiently using features such as the fill handle and to apply basic formatting to data in conventional accounting style.
Creating a Worksheet Tutorial Open Excel by clicking the Excel tile at the Windows Start menu, or by following other steps as needed depending on the operating system. At the Excel opening screen, click the Blank workbook template. This displays a workbook with a blank worksheet, as shown in Figure 1. The elements of a blank Excel worksheet are described in Table 1.
Opening a Blank Workbook A file created in Excel is referred to as a workbook. Notice the tab named Sheet1, at the bottom of the Excel window. The area containing the gridlines in the Excel window is called the worksheet area.
Figure 1. Create a worksheet in the worksheet area that will be saved as part of a workbook. Columns in a worksheet are labeled with letters of the alphabet and rows are labeled with numbers. The intersection of a column and a row creates a box, which is referred to as a cell. A cell is where data and formulas are entered.
When a cell is clicked, it becomes active and a thick green border appears around it. The cell address, also called the cell reference, appears in the Name box. The cell reference includes the column letter and row number. For example, if the first cell of the worksheet is active, the cell reference A1 is shown in the Name box. Any number of adjacent cells can be made active and form a range. A range is typically identified by the first cell reference and last cell reference separated by a colon.
To enter data in a cell, make the cell active and then type the data. To make the next cell active, press the Tab key. Table 1. Another method for making a cell active is to use the Go To feature.
Before typing data into the active cell, check the Status bar. The word Ready should display at the left. As data is typed in a cell, the word Ready changes to Enter. Data typed in a cell is shown in the cell and in the Formula bar. If the data entered in a cell is longer than the cell can accommodate, the data overlaps the next cell to the right. It does not become a part of the next cell—it simply overlaps it.
How to change column widths to accommodate data is explained later in this chapter. If, however, a number is entered in a cell and the number is too long to fit in the cell, Excel changes the display of the number to number symbols. This change is made because Excel does not want to mislead users by showing only part of a number in a cell.
Along with the keyboard, the mouse can be used to make a specific cell active. To make a specific cell active with the mouse, position the mouse pointer, which appears as a white plus symbol called the cell pointer , in the cell and then click the left mouse button.
The pointer appears as a white plus sign when positioned in a cell in the worksheet and as an arrow when positioned on other elements of the Excel window, such as options and buttons on tabs and scroll bars. Scrolling shifts the display of cells in the worksheet area but does not change the active cell. Scroll through a worksheet until the desired cell is visible and then click in the cell to make it active.
Click Save button on Quick Access Toolbar. At Save As backstage area, click Browse option. At Save As dialog box, navigate to folder. Type workbook name. Press Enter key. Saving a Workbook Save an Excel workbook, including all sheets within it, by clicking the Save button on the Quick Access Toolbar or by clicking the File tab and then clicking the Save As option at the backstage area.
At the Save As dialog box, click the desired location in the Navigation pane, type a name for the workbook in the File name text box, and then press the Enter key or click the Save button. Bypass the Save As backstage area and go directly to the Save As dialog box by using the keyboard shortcut F A workbook file name can contain up to characters, including the drive letter and any folder names, and it can include spaces.
Each file should have a distinct name. Excel will not allow two workbooks to be saved with the same file name in the same folder, even if one is in uppercase and one is lowercase. If the sales amount is not greater than the quota amount, then the salesperson will not receive a bonus.
In this formula, the condition, or logical test, is whether the number in cell C4 is greater than the number in cell B4. If the condition is true and the number is greater, then the number in cell C4 is multiplied by 0.
If the condition is false and the number in cell C4 is less than the number in cell B4, then nothing happens no bonus. Notice how commas are used to separate the logical test from the action.
If the quota has not been met, the formula will insert a 0. Write the formula by completing the following steps: a. Make cell D4 active. Make cell D4 active and then use the fill handle to copy the formula to the range D5:D9. Print the worksheet.
Copy the formula in cell D4 to the range D5:D9. Save 7-CMPReports. To use the Function Arguments dialog box to write a formula with the IF function, click the Formulas tab, click the Logical button in the Function Library group, and then click IF at the drop-down list.
This displays the Function Arguments dialog box, shown in Figure 7. The Function Arguments dialog box displays the information you will type in the three argument text boxes for Activity 5b. In this text box, type the cell designation followed by what is evaluated. Insert the action that will occur if the logical test is true.
Insert the action that will occur if the logical test is false. Make cell C14 active. Click the Formulas tab. Click the Logical button in the Function Library group. Click IF at the drop-down list. Click OK to close the Function Arguments dialog box.
Copy the formula in cell C14 to the range CC Apply the Accounting format with a dollar symbol and two digits after the decimal point to cell C For example, in Step 2 of Activity 5c, you will write a formula with an IF function that looks like this when written out: If the new employee averages more than 79 on the quizzes, then he or she passes.
If the new employee does not average more than 79 on the quizzes, then he or she fails. In Activity 5c, you will write the formula so the word PASS is inserted in a cell if the average of the new employee quizzes is greater than 79 and the word FAIL is inserted if the condition is not met.
The Function Arguments dialog box can be used to write a formula with an IF function that contains text. With 7-CMPReports open, insert quiz averages by completing the following steps: a. Make cell E31 active and then insert a formula that calculates the average of the test scores in the range BD Copy the formula in cell E31 to the range EE Make cell F31 active.
Copy the formula in cell F31 to the range FF Make cell D14 active. Click the Logical button in the 3e 3f Function Library group. Copy the formula in cell D14 to the range DD Save and then print 7-CMPReports. Print the worksheet again. The worksheet will print on two pages. Save and then close 7-CMPReports. To create a chart, select the cells, click the Insert tab, and then click a specific chart button in the Charts group.
Click the Recommended Charts button in the Charts group and Excel will recommend a type of chart for the data. A chart is inserted in the same worksheet as the selected cells by default.
Change the size of a chart using the mouse by dragging one of the sizing handles that display around the border of the chart. When changing the chart size, maintain the proportions of the chart by pressing and holding down the Shift key while dragging a sizing handle. Move a chart by positioning the mouse pointer on the chart border until the pointer displays with a four-headed arrow attached and then dragging with the mouse.
The cells selected to create a chart are linked to the chart. Changes made to the data are reflected in the chart. Three buttons appear outside the right border of a selected chart. Use the Chart Elements button to insert or remove chart elements, use the Chart Styles button to apply chart styles, and use the Chart Filters button to isolate specific data in the chart.
Print a chart by selecting it, displaying the Print backstage area, and then clicking the Print button. Use buttons and options on this tab to add chart elements, change the chart type, specify a different layout or style for the chart, and change the location of the chart.
Create a chart and it is inserted in the currently open worksheet. The chart can be moved to a new worksheet in the workbook with the New sheet option at the Move Chart dialog box. Move a chart element by selecting it and then dragging it with the mouse. Use the sizing handles around a chart element to change its size. Delete a chart element by selecting it and then pressing the Delete key or by right-clicking the element and then clicking Delete at the shortcut menu.
Customize the formatting of a chart and chart elements with options on the Chart Tools Format tab. Use these options to identify specific elements in the chart for formatting, insert a shape, apply formatting to a shape, apply WordArt formatting to data in a chart, insert alt text, and arrange, align, and size a chart.
Insert a shape by clicking it in the Insert Shapes group on the Chart Tools Format tab and then clicking or dragging in the chart. Create alternate text for an object such as a chart and the text is read by a screen reader, helping people with a visual impairment understand what objects are included in the worksheet.
Excel provides additional formatting options at a formatting task pane. A formatting task pane displays at the right side of the screen; the name and the contents in the task pane vary depending on whether the entire chart or an element in the chart is selected.
Display a task pane by clicking the chart or element in the chart and then clicking the Format Selection button in the Current Selection group on the Chart Tools Format tab. To delete a chart in a worksheet, click the chart to select it and then press the Delete key.
To delete a chart created in a separate sheet, position the mouse pointer on the chart sheet tab, click the right mouse button, and then click Delete. A logical test is a question that can be answered with true or false. Use the IF function to create a logical test that performs one action if the answer is true condition met or another action if the answer is false condition not met.
Some of the methods for adding visual appeal that you will learn in this chapter include inserting and modifying images, screenshots, shapes, text boxes, icons, 3D models, SmartArt, and WordArt. You will also insert an arrow shape, type and format text in the shape, and then copy the shape.
Click in cell. Click Insert tab. Click Symbol button. Double-click symbol. Insert Special Character 1.
Click Special Characters tab. Double-click special character. Hint Increase or decrease the size of the Symbol dialog box by positioning the mouse pointer on the lower right corner until the pointer displays as a two-headed arrow and then dragging with the mouse.
Click the button and the Symbol dialog box displays, as shown in Figure 8. At the dialog box, double-click a symbol to insert it, click the symbol and then click the Insert button, or type the code in the Character code text box.
Click the Close button to exit the dialog box. At the Symbol dialog box with the Symbols tab selected, additional symbols are available with different fonts. Change the font by clicking the Font option box arrow and then clicking a font at the drop-down list. Click the Special Characters tab at the Symbol dialog box and a list of special characters displays.
Insert a special character by double-clicking a character and then clicking the Close button or by clicking the character, clicking the Insert button, and then clicking the Close button. Figure 8. Use the Font option box to select a font with a set of characters.
This section of the dialog box displays the most recently used symbols. The Character code text box displays the code that can be entered at the keyboard to insert the symbol.
Insert a symbol by completing the following steps: a. Double-click in cell A2. Delete the e at the end of Qualite.
With the insertion point positioned immediately right of the t in Qualit, click the Insert tab. Click the Symbol button in the Symbols group. You can also type 00E9 in the Character code text box to select the symbol. Click the Insert button and then click the Close button. Insert a special character by completing the following steps: 2e a.
With cell A2 selected and in Edit mode, move the insertion point so it is positioned immediately right of Group. At the Symbol dialog box, click the Special Characters tab. Click the Close button. At the Symbol dialog box, click the Font option box arrow and then click Wingdings at the drop-down list. You will need to scroll down the list to see this option. Click the symbol located in approximately the fifth or sixth row. You can also type in the Character code text box to select the symbol.
Click in cell A3. Click the Pictures button to display the Insert Picture dialog box with options for inserting an image from a folder on the computer or a removable drive. Or click the Online Pictures button and search for images online. When an image is inserted in a worksheet, the Picture Tools Format tab appears, as shown in Figure 8.
Customizing and Formatting an Image Use buttons in the Adjust group on the Picture Tools Format tab to remove unwanted parts of an image, correct the image brightness and contrast, change the image color, apply artistic effects to the image, change to a different image, and Compress restore the original image formatting.
Use the Compress Pictures button in the Pictures Adjust group to compress the size of an image file and reduce the amount of space the image requires on the storage medium. Use buttons in the Picture Styles group uick Steps to apply a predesigned style to the image, change the image border, or apply other Insert Image effects to the image.
Use the Alt Text button in the Accessibility group to add 1. With options in the Arrange group, position the 2. Click Pictures button. Navigate to folder. Double-click image. Use the Crop button in the Size group to remove any unwanted parts of the image and use the Shape Height and Shape Width measurement boxes to specify the image size.
Modifying Images In addition to options at the Picture Tools Format tab, options at the shortcut menu can be used to format an image.
Display this menu by right-clicking the image. Use options at the shortcut menu to change the image, choose text wrapping around the image, insert alt text, size and position the image, and display the Format Picture task pane.
To change size with a sizing handle, position the mouse pointer on a sizing handle until the pointer turns into a double-headed arrow and then drag in or out to decrease or increase the size of the image. Use the middle sizing handles at the left and right sides of the image to make the image wider or thinner.
Use the middle sizing handles at the top and bottom of the image to make the image taller or shorter. Use the sizing handles at the corners of the image to change both the width and height at the same time. Press and hold down the Shift key while dragging a sizing handle to maintain the proportions of the image.
Move an image by positioning the mouse pointer on the image border until the pointer displays with a four-headed arrow attached and then dragging the image to the new location.
Rotate the image by positioning the mouse pointer on the white round rotation handle until the pointer displays as a circular arrow. Click and hold down the left mouse button, drag in the desired direction, and then release the mouse button. Click the Insert tab and then click the Pictures button in the Illustrations group. Change the size of the image by clicking in the Shape Height measurement box in the Size group on the Picture Tools Format tab, typing 1.
Remove the yellow background from the image by completing the following steps: a. Click the Remove Background button in the Adjust group. Change the color by clicking the Color button in the Adjust group and then clicking the Blue, Accent color 1 Light option second column, third row in the Recolor section.
Apply an artistic effect by clicking the Artistic Effects button in the Adjust group and then clicking the Glow Edges option last option in 6 the drop-down gallery.
Move the image by completing the following steps: a. Position the mouse pointer on the image displays with a four-headed arrow attached. Click and hold down the left mouse button, drag the image to the upper left corner of the worksheet, and then release the mouse button. Click the Picture Styles group task pane launcher or the Size group task pane launcher and the Format Picture task pane displays at the right side of the screen.
The formatting options may need to be expanded. Close the task pane by clicking the Close button in the upper right corner. Click Online Pictures button. Type search word or topic. Use the Bing Image Search feature to search for images online. To use this feature, click the Insert tab and then click the Online Pictures button in the Illustrations group. This displays the Online Pictures window, shown in Figure 8.
Click in the search text box, type the search term or topic, and then press the Enter key. Images that match the search term or topic display in the window.
To insert an image, click the image and then click the Insert button or double-click the image. This downloads the image to the document.
Customize the image with options and buttons on the Picture Tools Format tab. Click this button to search for images in your OneDrive account. Insert a different image by completing the following steps: a. Make cell A1 active. Click the Insert tab and then click the Online Pictures button in the Illustrations group.
At the Online Pictures window, type stock market clip art in the search box and then press the Enter key. Double-click the graph image shown below and to the right. If this image is not available online, click the Pictures button on the Insert tab. If necessary, click Size in the task pane to display the sizing options. Change the height of the image by selecting the current measurement in the Height measurement box, typing 1.
The width automatically changes to maintain the proportions of the image. Change the properties of the image by clicking Properties in the Format Picture task pane to expand the options and then clicking the Move and size with cells option. With this option selected, changing the size of the row also changes the size of the image. Make a correction to the image by completing the following steps: a. Click the Picture icon at the top of the task pane. Click Picture Corrections to expand the options.
Select the current percentage in the Brightness text box and then type Select the current percentage in the Contrast text box, type 40, and then press the Enter key.
Close the Format Picture task pane by clicking the Close button in the upper right corner. Create alternative text for the image by completing the following steps: a. At the Alt Text task pane, click in the description text box and then type Chart containing an up-pointing arrow. Close the Alt Text task pane. Click outside the image to deselect it. Increase the height of row 1 to Open window to be captured. Make Excel active. Open workbook.
Click Screenshot button. Click window at drop-down list. Click Screenshot button and then Screen Clipping. Drag to specify capture area. Creating and Inserting a Screenshot The Illustrations group on the Insert tab contains a Screenshot button that can be used to capture all or part of the contents of a screen as an image.
This is useful for capturing information from a web page or a file in another program. To create a screenshot, open the web page or file to be captured so that it is visible on the screen. Next, make Excel active and open a workbook. Click the Insert tab, click the Screenshot button, and then look in the drop-down list to see thumbnails of windows open in other programs.
Click the thumbnail of the screen to be captured and the screenshot is inserted as an image in the open workbook, the image is selected, and the Picture Tools Format tab is active.
Use buttons on this tab to customize the screenshot image. A screenshot can also be made of a specific portion of the screen by clicking the Screen Clipping option at the Screenshot button drop-down list. Using the mouse, draw a border around the specific area of the screen to be captured. The area identified is inserted in the workbook as an image, the image is selected, and the Picture Tools Format tab is active. Click the Excel button on the taskbar. Insert a screenshot of the table in the Word document by completing the 4a following steps: a.
Click the Insert tab. Click the Screenshot button in the Illustrations group and then click Screen Clipping at the drop-down list.
When SMFProfile displays in a dimmed manner, position the mouse crosshairs in the upper left corner of the table, click and hold down the left mouse button, drag down to the lower right corner of the table, and then release the mouse button. This creates a screenshot of the entire table. Using the mouse, drag the screenshot image one row below the data in row Make cell A4 active. Click Shapes button. Click shape option at drop-down list.
Click or drag in worksheet. Copy Shape 1. Select shape. Click Copy button. Position insertion point in new location. Click Paste button. Press and hold down Ctrl key. Drag shape to new location. Inserting and Formatting a Shape Chapter 7 covered how to insert shapes in a chart with options on the Chart Tools Format tab.
Shapes can also be inserted in a worksheet with the Shapes button in the Illustrations group on the Insert tab. Use the Shapes button to draw shapes in a worksheet, including lines, basic shapes, block arrows, flow chart symbols, callouts, stars, and banners. Click a shape and the mouse pointer displays as crosshairs. Click in the worksheet or position the crosshairs where the shape is to begin, click and hold down the left mouse button, drag to create the shape, and then release the mouse button.
Click or drag in the worksheet and the shape is inserted and the Drawing Tools Format tab, shown in Figure 8. Use options and buttons on this tab to choose a shape, apply a style to a shape, arrange a shape, and change the size of a shape.
Choose a shape in the Lines section of the Shapes button drop-down list and the shape that is drawn is considered a line drawing. Choose an option in another section of the drop-down list and the shape drawn is considered an enclosed object.
When drawing an enclosed object, maintain the proportions of the shape by pressing and holding down the Shift key while dragging with the mouse. Text can be typed in an enclosed object and then formatted using buttons in the WordArt Styles group or options on the Home tab.
Copy a shape in a worksheet by selecting the shape and then clicking the Copy button in the Clipboard group on the Home tab. Make active the cell where the shape is to be copied and then click the Paste button. A shape can also be copied by pressing and holding down the Ctrl key while dragging the shape to the new location. Click the Shapes button in the Illustrations group and then click the Arrow: Up shape third column, first row in the Block Arrows section.
Position the mouse pointer appears as crosshairs near the upper left corner of cell D1 and then click the left mouse button. This inserts the arrow in the worksheet. Click in the Shape Height measurement box and then type 3. Click in the Shape Width measurement box, type 2. If necessary, drag the arrow so it is positioned as shown in Figure 8. To drag the arrow, position the mouse pointer on the border of the selected arrow until the pointer displays with a four-headed arrow attached, click and hold down the left mouse button, drag the arrow to the new position, and then release the mouse button.
Click the Shape Effects button in the Shape Styles group, point to Glow, and then click the Glow: 11 point; Orange, Accent color 2 option second column, third row in the Glow Variations section. Insert text in the arrow by completing the following steps: a.
With the arrow selected, type McGuire Mutual Shares 5. Select the text you just typed McGuire Mutual Shares 5. Click the More WordArt Styles button in the WordArt Styles group and then click the option in the fourth column, third row orange outline with white fill.
With the arrow selected, copy it by completing the following steps: a. Press and hold down the Ctrl key. Position the mouse pointer on the arrow border until the pointer displays with a square box and plus symbol attached. Click and hold down the left mouse button and drag to the right so the outline of the arrow is positioned at the right of the existing arrow. Release the mouse button and then release the Ctrl key. Format the second arrow by completing the following steps: a.
With the second arrow selected, click in the Shape Height measurement box on the Drawing Tools Format tab and then type 2. Click in the Shape Width measurement box, type 1. Select the text McGuire Mutual Shares 5. Drag the arrow so it is positioned as shown in Figure 8. Change to landscape orientation. Make sure the cells containing the data, screenshot image, and arrows will print on the same page. Check Your Work Figure 8. You will also insert a text box and then format the text.
This causes the mouse pointer to display as a long, thin, upside-down cross. Position the pointer in the worksheet and then drag to create the text box. When a text box is selected, the Drawing Tools Format tab displays with options for customizing it. Click a text box to select it and a dashed border and sizing handles display around it.
To delete the text box, click the border again to change the dashed lines to solid lines and then press the Delete key. Click Text Box button. Click or drag in worksheet to create text box. Insert Icons 1. Click Icons button. Click icon. Click Insert button. Inserting and Customizing Icons Use the Icons button in the Illustrations group on the Insert tab to insert an icon in a Word document. An icon is a simple graphic used to represent a concept or idea, such as emotions, weather, nature, the arts, and so on.
Icons can be used to highlight or label data in a worksheet. These simple graphics draw the eye to important information and can be understood at a glance. At this window, scroll down the list box to view the various icons or click a category in the left panel to display a specific category of icons. To insert an icon in a document, double-click the icon in the list box or click the icon and then click the Insert button. Click an option in this list box and then click the Insert button to insert the icon into the worksheet.
Use options on this tab to apply a graphic style, fill, outline, and effect; type alternate text for the icon; position, align, group, rotate, and size the icon; and apply text wrapping. Icons, like other images, can be formatted with options at the Format Graphic task pane. Display this task pane by clicking the Graphics Styles group or Size group task pane launcher. Use options at the Format Graphic task pane to format an icon in a manner similar to formatting an image, shape, and text box.
Insert and format an icon by completing the following steps: a. Click in cell A2. Click the Icons button in the Illustrations group. At the Insert Icons window, click Arts at the left side of the window. Click the video camera icon shown below and then click the Insert button. With the Icon selected, click the Rotate button in the Arrange group and then click the Flip Horizontal option at the dropdown list. Click the More Graphic Styles button in the Graphics 2f Styles group and then click the Transparent, Colored Outline – Dark 1 option at the drop-down gallery first column, last row.
Move the icon it so it is positioned as shown in Figure 8. Draw a text box by completing the following steps: a. Click the Text Box button in the Text group. Drag to cell A1 to draw a text box the approximate size and shape shown below. Format the text box by completing the following steps: a. Click the Drawing Tools Format tab. Insert text in the text box by completing the following steps: a.
With the text box selected, click the Home tab. Click the Font option box arrow and then click Lucida Calligraphy at the drop-down gallery. Scroll down the gallery to display this font. Click the Font Size option box arrow and then click 24 at the drop-down gallery. Click the Align Right button in the Alignment group.
Type Hummingbird Productions. Move the text box so the text is positioned in cell A1, as shown in Figure 8. Save 8-SPDivSales. Click 3D Models button. Click category. Click model. The model can be rotated or tilted to allow viewing from various angles or to display a specific portion or feature.
Access these images by clicking the 3D Models button in the Illustrations group on the Insert tab. At the Online 3D Models window, shown in Figure 8. Insert a 3D model in a worksheet by double-clicking the model or clicking the model and then clicking the Insert button.
Use buttons in the Adjust group to insert a different 3D model or reset the selected model to its original size and position. The 3D Model Views group includes a gallery of preset views for the model. Click the Alt Text button in the Accessibility group and the Alt Text task pane displays, where a description of the model can be added.
Use options in the Arrange group to position the model, apply text wrapping, send the model forward or backward, and align the model. Change the height and width of the model with options in the Size group. Click this button to lock the position of the 3D model and a button a magnifying glass with a plus symbol inside will display at the right of the selected model. Position the mouse pointer on this button, hold down the left mouse button, and then drag up to increase the size of the model zoom in or drag down to decrease the size zoom out.
Use the 3D control in the middle of the model to freely rotate the model. Use the 3D control that displays in the middle of a selected 3D model to rotate or tilt the model. To use the 3D control, position the mouse pointer on the control, click and hold down the left mouse button, and then drag with the mouse to rotate or tilt the model.
Options for formatting and customizing a 3D model are available at the Format 3D Model task pane. Display the task pane by clicking the 3D Model Views group or Size group task pane launcher. Use options at the task pane with the Effects icon selected to apply formatting effects, such as shadow, reflection, glow, and soft edges, and to format and rotate the model. Insert a 3D model from the Remix 3D library by completing the following steps: a. Click the 3D Models button in the Illustrations group.
At the Online 3D Models window, click the Animals category. Scroll down and click the hummingbird model. Click the Insert button. This workbook contains the 3D hummingbird model. Print length. Publication date. See all details.
Next page. Special offers and product promotions No cost EMI available on select cards. Please check ‘EMI options’ above for more details. Sign up for free Here’s how Super Offer: Claim your offer on any product of your choice and save – Click here to claim.
Here’s how. Audrey Roggenkamp , Pierce College at Puyallup. Ian Rutkosky , Pierce College at Puyallup. Small Business Deals Week Shop now! Customer reviews. How are ratings calculated? Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon.
It also analyses reviews to verify trustworthiness. Top reviews Most recent Top reviews. Top reviews from India. There are 0 reviews and 0 ratings from India.
Top reviews from other countries. Verified Purchase. Sorry not happy..
Benchmark series microsoft word 2016 levels 1&2 ebook free download –
They receive benchmark series microsoft word 2016 levels 1&2 ebook free download instructions in creating letters, reports, research papers, brochures, newsletters, and other documents. Key Features A graduated, three-level approach to mastering Microsoft Office applications. Mentoring instructional style guides students step-by-step in creating letters, reports, research papers, brochures, newsletters, and взято отсюда documents.
Case study assessments at chapter and unit levels test students’ abilities to solve problems independently. Key application skills are clearly demonstrated using the user-friendly two-page spread found throughout this and all books in the popular Illustrated Microsoft Office Series.
This edition highlights updated Office content with a new seriew that benchmark series microsoft word 2016 levels 1&2 ebook free download Productivity Apps. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version. This all-in-one book makes the computer concepts and skills your students need to know easily accessible.
Key application skills are clearly demonstrated using the user-friendly two-page spread found in the popular Microsoft Office Illustrated Introductory, First Course. A wealth of real-world examples emphasizes critical thinking and IT skills in a dynamic, business-related environment. You will find numerous projects, insightful assignments, and helpful end-of-chapter exercises to help ссылка на подробности refine the IT skills you need for success in today’s intensely competitive business world.
Designed specifically to meet the needs of professional developers, this benchmark series microsoft word 2016 levels 1&2 ebook free download briefly introduces functional programming before skipping directly to the heart of using Clojure in a real-world setting.
Seriees discussion details the read—eval—print workflow that enables fast feedback loops, then dives into enterprise-level Clojure development with expert guidance on web services, testing, datomics, performance, and more.
Read from beginning to end, this book serves as a clear, direct guide to Clojure programming—but the comprehensive coverage and detail makes it extraordinarily useful as a quick reference for mid-project snags. The author team includes four professional Clojure developers, ensuring professional-level instruction from a highly practical perspective. Clojure is an open-source programming language maintained and supported by Cognitect.
This guide provides a benchmark series microsoft word 2016 levels 1&2 ebook free download, yet thorough resource for professional developers needing to quickly put Clojure to work.
Parse the difference between functional leveks object-oriented programming Understand Clojure performance and capabilities Develop reactive web pages using ClojureScript Adopt an REPL-driven development workflow Clojure is a modern dialect of Lisp, designed for concurrency and Java compatibility.
As адрес grow increasingly complex, stepping away from imperative programming can dramatically streamline the development workflow. Professional Clojure provides the expert instruction that gets professionals up. Fiscal Monitor October Author : Ms. The analytical framework explicitly models the interlinkages between private and public debt in analyzing the role of fiscal policy in the deleveraging process.
Country case studies provide useful insights on what fiscal policy should and should not do to facilitate enook while minimizing the drag on the economy. The 32 revised full papers and 18 poster papers were carefully reviewed and selected from submissions. The papers are organized thematically starting with mobile and network security, followed by applied cryptography, ATCS workshops, web security and privacy, system security, hardware security and finally the poster session. The reports cover all fields of levwls science and engineering ranging from CFD to computational physics and from chemistry /97991.txt computer science with a special emphasis on industrially relevant applications.
The book covers the main methods in high-performance computing. Адрес страницы outstanding results in achieving the best performance for production codes are of particular interest for both scientists and engineers. The book comes with a wealth of color illustrations and tables of results.
Popular Books. Falling by T. Nine Lives by Danielle Steel. The Bone Code by Kathy Reichs.
20 Best Microsoft Word Books of All Time – BookAuthority.
: Benchmark Series Word Level 2 Text (): Benchmark Series: Microsoft Word Levels 1&2. Get your Kindle here, or download a FREE Kindle Reading App. Listen with Pride. Explore the diverse array of titles—some funny, some brave, some thrilling, some sad—to find connection and inspiration. /5(56). Benchmark Series: Microsoft® Word is designed for students who want to learn how to use this powerful word processing program to create professional looking documents for school, work, and personal communication needs. Order ted Reading Time: 3 mins. Benchmark Series: Microsoft® Office is designed for students who want to learn how to use the new version of Microsoft’s popular suite to enhance their productivity at school, work, and home. Throughout this text, students are expected to develop and execute strategies for solving information processing and management problems using Word Estimated Reading Time: 4 mins.
[PDF] Benchmark Microsoft Access Level 1 Access Code | Download F.20 Best Microsoft Word Books of All Time – BookAuthority
This chapter will introduce the basics of creating a worksheet, opening workbooks, and saving workbooks. Click the Picture icon at the top of the task pane. In this formula, the condition, or logical test, is whether the number in cell C4 is greater than the number in cell B4. Add a double-line border around the range A1:E Create the worksheet shown in Figure 1. Type the worksheet data shown in Figure 1. Type Sales Department in cell A2 and then press the Enter key.