Benchmark series microsoft office 2016 pdf free free download.Benchmark series microsoft excel 2016 levels 1 and 2 pdf

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Click the File tab and then click the Open option, if necessary. Click the Browse option. Save the workbook with the name 1-FillCells by completing the following steps: a. Press the F12 function key to display the Save As dialog box. Press the Home key on the keyboard to position the insertion point at the beginning of the name in the File name text box and then type Click the Save button. Add data to cells as shown in Figure 1. Begin by making cell B1 active and then typing January. Position the mouse pointer on the fill handle for cell B1, click and hold down the left mouse button, drag across into cell G1, and then release the 4 mouse button.

Type a sequence and then use the fill handle to fill the remaining cells by completing the following steps: a. Make cell A2 active and then type Year 1. Make cell A3 active and then type Year 3. Select cells A2 and A3 by clicking in cell A2 and holding down the left mouse button, dragging into cell A3, and then releasing the mouse button.

Drag the fill handle for cell A3 into cell A5. This inserts Year 5 in cell A4 and Year 7 in cell A5. Use the fill handle to fill adjacent cells with a number but not the formatting by completing the following steps: a.

Make cell B2 active. This cell contains with bold formatting. Drag the fill handle for cell B2 to the right into cell E2. This inserts in cells C2, D2, and E2. Click the Auto Fill Options button at the bottom right of the selected cells.

Click the Fill Without Formatting 6d option at the drop-down list. Use the fill handle to apply formatting only by completing the following steps: a. Drag the fill handle into cell B5. Make cell A10 active and then type Qtr 1. Drag the fill handle for cell A10 into cell A Save 1-FillCells.

For example, the total cost of an item can be determined by inputting the AutoSum button individual costs of the item into a sum formula and the result will be the total of 1. Click in cell. Click AutoSum those costs. An active cell that contains a formula will display the results in the button. Formulas can be inserted using various 3.

Check range methods, such as typing, using the mouse, and using buttons on the ribbon. When values are added to cells A1 and A2, their sum will automatically appear in cell A3. Formulas can also be written that calculate averages, percentages, minimum and maximum values, and much more.

Make active the cell in which the formula will be inserted this cell AutoSum should be empty and then click the AutoSum button. Excel looks for a range of cells containing numbers above the active cell. If no cell above contains numbers, Hint You can use then Excel looks to the left of the active cell. If the suggested range is not correct, drag through the range of cells SUM function in a cell.

With 1-FillCells open, make cell A6 active and then type Total. Make cell B6 active and then calculate the sum of the cells by clicking the AutoSum button in the Editing group on the Home tab. This is the correct range of cells, so press the Enter key.

Make cell C6 active and then click the AutoSum button in the Editing group. Make cell D6 active. Double-click the AutoSum button. Insert the sums in cells E6, F6, and G6. With this function, a 1. Click AutoSum cell entries. Click button arrow. Click Average. Specify range. When copying a formula to other locations in a worksheet, use a relative cell reference. Insert formula in cell.

Use 2. Make active cell the fill handle to copy a formula relatively in a worksheet. To do this, position the containing formula. Drag fill handle across or down to fill cross, click and hold down the left mouse button, drag and select the cells, and cells. With 1-FillCells open, make cell A14 active and then type Average. Insert the average of the range BB13 by completing the following steps: a. Make cell B14 active. Click the AutoSum button arrow in the Editing group and then click Average at the drop-down list.

Copy the formula relatively to the range CG14 by completing the following steps: a. Position the mouse pointer on the fill handle, click and hold down the left mouse 3b button, drag across into cell G14, and then release the mouse button. Save, print, and then close 1-FillCells. For example, change the alignment of data in cells or rows or add character formatting.

To identify the cells that are to be affected by the formatting, select the specific cells. Selecting Cells Using the Mouse Hint The first cell Select specific cells, columns, or rows in a worksheet using the mouse. Selected cells, except the active cell, display with a gray background this may vary rather than a white background. The active cell is the first cell in the selection block and displays in the normal manner white background with black data.

Selected cells remain selected until another cell is clicked with the mouse or an arrow key is pressed on the keyboard. Selecting Cells Using the Keyboard Keys on the keyboard can be used to select specific cells within a worksheet. Refer to Figure 1. To do this with the mouse, or rows by holding position the cell pointer in a cell and then double-click the left mouse button. Drag with the I-beam pointer through the data to be selected.

Data selected within a cell appears with a gray background. To select data in a cell using the keyboard, press and hold down the Shift key and then press the arrow key that moves the insertion point in the desired direction. All the data the insertion point passes through will be selected. Press the F8 function key to turn on the Extend Selection mode, move the insertion point in the desired direction to select the data, and then press F8 to turn off the Extend Selection mode.

When the Extend Selection mode is on, the words Extend Selection are shown at the left of the Status bar. Applying Basic Formatting uick Steps Excel provides a wide range of formatting options that can be applied to cells in a Change Column worksheet.

Some basic formatting options that are helpful when creating a Width worksheet include changing the column width, merging and centering cells, and Drag column boundary line. OR Double-click column boundary line.

Changing Column Width Merge and Center Cells If data in a cell overlaps into the next column, increase the width of the column 1. Select cells. To do this, position the mouse pointer on the gray 2. If the column contains data, double-click the column boundary line at the right to automatically adjust the width of the column to accommodate the longest entry. A more precise way to change the width of a column is to display the Column Width dialog box, type in the desired width and then press the OK button.

Open the Column Width dialog box by clicking the Format button in the Cells group and then click the Column Width option in the drop-down list. Alternatively, right-click the column header and then click Column width at the shortcut menu.

If other cells contain data, only Center the data in the first cell will be placed in the newly merged cell. Open MoExps and then save it with the name1-MoExps.

Change column widths by completing the following steps: a. Position the mouse pointer in the column header on the boundary line between columns A and B until the pointer turns into a double-headed arrow pointing left and right. Double-click the left mouse button. Position the mouse pointer in the column header on the boundary line between columns E and F and then double-click the left mouse button. Click in any cell in column F, click the Format button in the Cells group on the Home tab and then click the Column Width option at the drop down list.

At the Column Width dialog box, type Merge and center cells by completing the following steps: a. Select the range A1:C1. Select the range A2:C2. Save 1-MoExps. As numbers are typed, Excel will recognize the formatting. Currency format, Percentage format, and other formats recognized by Excel are shown in the Number Format option box in the Number group on the Home tab. Number formatting can also be applied to cells in a worksheet before or after the data is typed. To do this, select the cell or cells and then click an option in the Number Format option box, or click one of the buttons in the Number group on the Home tab described in Table 1.

If the number. Use the Increase Decimal and Decrease Decimal buttons to control how many digits are displayed after the decimal point, without changing the actual value in the cell.

For example, the number 1. A general guideline in accounting is to insert a dollar symbol before the first amount in a column and before the total amount but not before the number amounts between them. To follow this guideline, format the first amount and total amount using the Accounting Number Format button and applying the Comma format to the number amounts between them.

The Accounting number format and Comma number format are the same, except the Accounting number format includes the dollar sign. To differentiate between the two Accounting formats, steps in this textbook will use the term Accounting format when the Accounting Number Format button in the Number group on the Home tab is to be clicked.

The term Comma format will be used when the Comma Style button is to be clicked. Percent Style Multiply the cell value by and display the result with a percent symbol; right-align the number in the cell. Comma Style Add any necessary commas and a decimal point followed by two digits even if none are typed; right-align the number in the cell.

Increase Decimal Increase the number of digits displayed after the decimal point in the selected cell. Decrease Decimal Decrease the number of digits displayed after the decimal point in the selected cell. This inserts the total of the numbers in the range B4:B Make cell C13 active and then double-click the AutoSum button.

Apply the Accounting format to cells by completing the following steps: a. Select cells B4 and C4. Decrease the number of digits displayed after the decimal point to none by clicking the Decrease Decimal button in the Number group two times. Select cells B13 and C Click the Accounting Number Format button. Click the Decrease Decimal button two times.

Apply the Comma format to numbers by completing the following steps: a. Select the range B5:C Click the Comma Style button in the Number group.

Apply the Percentage format to numbers by completing the following steps: a. Select the range F3:F9. Click the Percent Style button in the Number group on the Home tab. Click in cell A1. You will use the Help feature to learn more about entering data in cells, changing the font color, and printing a workbook. Use the Tell Me feature by clicking in the Tell Me text box on the ribbon to the right of the Help tab and then typing a term, or action.

The drop-down list contains options for 1. Click in Tell Me text box. Type topic or feature. Click option at drop- down list. The Tell Me drop-down list also includes a Smart Lookup option.

Smart Lookup can also be accessed using the Smart Lookup button on the Review tab or by selecting a cell, right-clicking in the selected cell, and then clicking the Smart Lookup option at the shortcut menu. With the Explore option Close button selected, the Smart Lookup task pane provides information about the topic or feature from various internet sources. With the Define option selected, the Smart Lookup task pane provides definitions of the topic or feature from various internet sources. With 1-MoExps open, select the range A1:E1.

Click in the Tell Me text box and then type font size. At the drop-down list, click the Font Size option. At the side menu, click the 14 option. This 2 increases the font size of the text in the range A1:E1, and the height of row 1 automatically adjusts to accommodate the larger text. Use the Tell Me feature to display the Help task pane with information 3 on wrapping text by completing the following steps: 4 a.

Click in the Tell Me text box and then type wrap text. At the Help task pane, read the information on wrapping text and then close the Help task pane by clicking the Close button in the upper right corner of the task pane. Display information on scrolling in a workbook in the Smart Lookup task pane by completing the following steps: a. Click in the Tell Me text box and then type scrolling.

The first time you use the Smart Lookup feature, a message may appear asking to turn on Intelligent Services. In a school setting, ask your instructor for assistance.

If two options—Explore and Define—are shown at the top of the Smart Lookup task pane, click the Define option. This will display a definition of the word scrolling in the Smart Lookup task pane. Close the Smart Lookup task pane by clicking the Close button in the upper right corner of the task pane. Save, print, and then close 1-MoExps. Press F1. Type term or action Alternatively, type a term or action in the Tell Me text box, position the mouse in search text box.

OR to open the Help task pane with the selected article displayed. In the Help task 1. Click in Tell Me text pane, type a topic, feature, or question in the search text box and then press box. Articles related to the search text 2. Type term or action. Click Get Help on display in the Help task pane. Click an article and the article information displays option. The Help task pane contains buttons at the top, as identified in Figure 1. Use the Back button to navigate to the previous page in the task pane.

Click the three dots button to display more options, such as Home, Office help center, and Contact us. Resize or move the task pane by clicking the down arrow left of the Close button. The Help task pane can be made larger so it is easier to read the articles. The Help task pane can also be moved to the other side of the screen or made into a window that can be moved anywhere on the screen. Back Moving, sizing, and closing options Additional options. Some button ScreenTips display with a Help icon and the Tell me more hyperlink.

Click the Tell me more hyperlink text or press the F1 function key and the Help task pane opens with information about the button feature. Click the Help tab and then click the Help button. With the insertion point in the search text box in the Help task pane, type enter data and then press the Enter key. When the Help task pane displays with a list of articles, click the article Enter data manually in worksheet cells hyperlink.

In the displayed article, expand some of the topics in the article and then read the information about entering data in cells. Click the down arrow button in the Help task pane and then click the Size option at the drop-down list. Resize the Help task pane to make the information in the article easier to read by moving the mouse pointer to a desired point approximately one inch wider than it was previously and then clicking the left mouse button.

Click the Back button to return to the previous page. Click another article hyperlink in the Help task pane and then read in the information in the article. Click the three dots button and then click the Home option at the drop-down list.

Click the Close button to close the Help task pane. Click the Home tab, hover the mouse pointer over the Font Color button in the Font group until the ScreenTip displays, and then click the Tell me more hyperlink at the bottom of the ScreenTip. Read the information that displays in the Help task pane, and then close the task pane.

Click this button and the Microsoft Office support website opens in a browser window with specific information about the dialog box or backstage area. After reading the information, close the browser window and return to Excel.

If a dialog box is open in Excel, close it by clicking the Close button in the upper right corner. Exit the backstage area by clicking the Back button or pressing the Esc key. At the blank workbook, click the File tab and then click the Print option. At the Print backstage area, click the Microsoft Excel Help button in the upper right corner of the backstage area. At the Microsoft Office support website, click the hyperlink to an article on printing that interests you. Read the article and then close the window.

Click the Back button to return to the blank workbook. At the blank workbook, click the Home tab and then click the Number group dialog box launcher. At the Format Cells dialog box with the Number tab selected, click the Help button in the upper right corner of the dialog box. Read the information at the Microsoft Office support website and then close the browser window to return to Excel.

In Excel, close the Format Cells dialog box. Close the blank workbook. Gridlines are the horizontal and vertical lines that define cells. The cell name includes the column letter and row number. If the data consists of numbers and does not fit into the cell, the numbers change to number symbols. At the Save As dialog box, navigate to the desired folder, type the workbook name in the File name text box, and then press the Enter key.

To edit data within a cell, double-click in the cell and then make the necessary changes. The AutoCorrect feature corrects many common typing errors. The AutoFill fill handle adds the same or consecutive data into a range of cells.

At the Open dialog box, double-click the workbook name. The fill handle is the solid box in the bottom right of an active cell. Select all the cells in a row by clicking the row header. Select all the cells in a worksheet by clicking the Select All button immediately to the left of the column headers.

The Tell Me text box is located on the ribbon to the right of the Help tab. At this task pane, type a topic in the search text box and then press the Enter key. Help task pane Help, Help F1. Insert a formula in a worksheet and then manipulate the data to make projections, answer specific questions, and plan for the future. For example, the owner of a company might prepare a worksheet on production costs and then determine the impact on company revenues if production is increased or decreased.

Chapter 1 described how to use the AutoSum button to insert formulas for calculating totals and averages. In Chapter 2, you will learn to use the Formulas tab to create formulas with a variety of different functions. Data Files The online course includes Before beginning chapter work, copy the EL1C2 folder to your additional training storage medium and then make EL1C2 the active folder.

A formula in a cell, press formula can also be written using mathematical operators. The column reference letters used in formulas can be entered as either lowercase or uppercase letters. If the column reference letters are entered in a formula in lowercase, Excel will automatically convert the column reference letters to uppercase. Formulas entered in a cell will also display in the Formula bar, where the formula can be modified.

In a situation where a formula is copied to other locations in a worksheet, use a relative cell reference. Copy a formula containing relative cell references and the cell references change. You used the fill handle to copy a formula in Chapter 1.

To use the Fill button, select the cell containing the formula and all the cells to which the uick Steps formula is to be copied and then click the Fill button in the Editing group on the Copy Formulas Home tab. At the Fill button drop-down list, click the direction.

For example, click with Relative Cell References the Down option if the formula is being copied down the worksheet. Select cell containing Table 2. Operator Purpose Operator Purpose 3. Click Fill button. Insert a formula by completing the following steps: a.

Make cell D3 active. Press the Enter key. Copy the formula to the range D4:D10 by completing the following steps: a. Select the range D3:D Click the Fill button in the Editing group on the Home tab and then click Down at the drop-down list.

Save 2-HCReports. With the worksheet open, make the following changes to cell contents: B4: Change 48, to C6: Change 61, to B8: Change 55, to B9: Change 12, to 6.

Make cell D3 active, apply the Accounting format by clicking the Accounting Number Format button in the Number group on the Home tab, and then click the Decrease Decimal button two times to decrease the digits displayed past the decimal point to none.

Hint Use the As explained in Chapter 1, the fill handle can be used to copy a formula up, fill handle to copy a down, left, or right within a worksheet. To use the fill handle, insert the data in the relative version of a cell text, value, formula, etc. With the cell active, position the mouse pointer on formula.

Click and hold down the left mouse button, drag and select the cells, and then release the mouse button. When dragging a cell containing a formula, a relative version of the formula is copied to the selected cells. Checking Cell References in a Formula To verify if a formula is using the correct cell references, double-click in a cell containing the formula and the cells referenced in the formula display with a colored border and shading in the worksheet.

This feature makes it easy to identify which cells are being referenced in a formula and is helpful when trying to identify errors that may occur in a formula.

With 2-HCReports open, insert a 1c 1b formula by completing the following steps: a. Make cell D15 active. Click the Enter button on the Formula bar.

Copy the formula to the range DD20 by completing the following steps: a. Make sure cell D15 is still the active cell. Position the mouse pointer on the fill handle at the lower right corner of cell D15 until the pointer turns into a thin black cross. Click and hold down the left mouse button, drag into cell D20, and then release the mouse button. Double-click in cell D20 to display the formula with cell references color coded to ensure the formula was copied relatively and then press the Enter key to exit the Edit mode.

Make the following changes to cell contents in the worksheet: B Change 20 to 28 C Change Creating a formula by pointing is more accurate than uick Steps typing the cell reference because a mistake can be made when the cell reference is Write Formula typed. Click in cell that will To write a formula by pointing, click in the cell that will contain the contain formula.

Type equals sign. This inserts a moving border around the cell and 3. Click in cell to be referenced in changes the mode from Enter to Point. The word Point displays at the left side formula. Type the mathematical operator and then click in the next 4. Type mathematical operator. Continue in this manner until all the cell references are specified 5. Click in next cell and then press the Enter key.

This ends the formula and inserts the result of the reference. When a formula is written by pointing, the range of 6. With 2-HCReports open, enter a formula by pointing that calculates the percentage of actual budget by completing the following steps: a. Make cell D25 active. Click in cell B This inserts a moving border around the cell and changes the mode from Enter to Point.

Click in cell C Make cell D25 active, click the fill handle and hold down the left mouse button, drag into cell D31, and then release the mouse button. Tutorial Determining the Order of Operations Determining the If a formula contains two or more operators, Excel uses the same order of Order of Operations operations used in algebra. To change the order of operations, put parentheses around the part of the formula that is to be calculated first. Excel requires each left parenthesis to be paired with a right parenthesis.

If a formula is missing a left or right parenthesis, a message box will display explaining that an error exists in the formula and providing a possible correction, which can be accepted or declined. This feature is useful when creating a formula that contains multiple layers of parentheses called nested parentheses because it will identify any missing left or right parentheses in the formula. Parentheses can also be used in various functions to further determine the order of operations. The general term for this button is a smart tag.

The display of the smart tag button varies depending on the action performed. In Activity 1d, you will insert a formula that causes a smart tag button named the Trace Error button to appear. When the Trace Error button appears, a small dark-green triangle also appears in the upper left corner of the cell. Click the Trace Error button and a drop-down Trace Error list displays with options for updating the formula to include specific cells, getting help with the error, ignoring the error, editing the error in the Formula bar, and completing an error check.

In Activity 1d, two of the formulas you insert return the correct results. You will click the Trace Error button, read about what Excel perceives to be the error, and then tell Excel to ignore the error. Identifying Common Formula Errors Excel is a sophisticated program that requires data input and formula creation to follow strict guidelines in order to function properly.

When guidelines that specify how data or formulas are entered are not followed, Excel will display one of many error codes. When an error is identified with a code, determining and then fixing the problem is easier than if no information is provided.

Table 2. Most errors in Excel result from the user incorrectly inputting data into a worksheet. However, most error messages will not display until the data is used in a formula or function. Common mistakes made while inputting data include placing text in a cell that requires a number, entering data in the wrong location, and entering numbers in an incorrect format.

Other errors result from entering a formula or function improperly. A formula will often produce an error message if it is trying to divide a number by 0 or contains a circular reference that is, when a formula within a cell uses the results of that formula in the same cell.

A function name is not entered correctly. A referenced cell no longer exists within a worksheet. With 2-HCReports open, enter a formula by pointing that calculates the percentage of equipment down time by completing the following steps: a.

Make cell B45 active. Type a minus symbol -. Make cell B45 active, click the fill handle and press and hold down the left mouse button, drag into cell G45, and then release 3b the mouse button. Enter a formula by dragging to a range of cells by completing the following steps: a. Select the range BD This inserts 7, in cell B Click in cell B47 and then complete steps similar to those in Step 3 to create a formula that totals hours available from April through June the range EG Click in cell B46 and notice the Trace Error button.

Complete the following steps to read about the error and 5a then tell Excel to ignore it: a. Click the Trace Error button. At the drop-down list, click the Help on this Error option. Read the information in the Excel Help window and then close the window. Click the Trace Error button again and then click Ignore Error at the drop-down list. Remove the dark-green triangle from cell B47 by completing the following steps: a.

Click the Trace Error button and then click Ignore Error at the drop-down list. Save, print, and then close 2-HCReports. You will also use date and time functions and display a formula in a cell rather than the result of a formula.

Functions are built-in formulas. Inserting a formula takes fewer keystrokes than creating one from scratch. Excel provides other functions for writing formulas. A function operates on what is referred to as an argument. An argument may consist of a constant, a cell reference, or another function. An argument may also contain a constant. A constant is a value entered directly into the formula. In this formula, is always added to the sum of the cells.

The phrase returning the result is used to describe when a value calculated by the formula is inserted in a cell. The term returning refers to the process of calculating the formula and the term result refers to the value inserted in the cell.

Insert Type a function in a cell in a worksheet or use the Insert Function button on Function the Formula bar or the Formulas tab to write the formula.

Figure 2. Click the Insert Function button on the Formula bar or the Formulas tab and the Insert Function dialog box displays, as shown in Figure 2. At the Insert Function dialog box, the most recently used functions display in the Select a function list box. With the insertion point positioned in the Criteria text box, type 1 and then they have completed the activity correctly. Excel returns the value in cell M Between activity parts, the text presents instruction on the 2d features and skills necessary to accomplish the next section of 2e the activity.

Typically, a file remains open throughout all parts of the activity. Students save their work incrementally. At the end of the 3. Apply the Comma format with no digits after the decimal point to cell M With cell M17 active, drag the fill handle into cell M Check Your Work.

Chapter Summary Using range names in formulas makes it easier to manage complex formulas and. Use options at the Name Manager dialog box to create, edit, or delete a range name or edit the cells that a range.

Alternatively, you can click a button in the Function Library group on the Formulas tab, click the name of the function at the drop-down list, and then enter arguments at the Insert Function dialog box. Nest an IF function to test an additional condition. Cirrus seamlessly delivers complete course content in a cloud-based learning environment that puts students on the fast track to success. Students can access their content from any device anywhere, through a live internet connection; plus, Cirrus is platform independent, ensuring that students get the same learning experience whether they are using PCs, Macs, or Chromebook computers.

Cirrus provides Benchmark Series content in a series of scheduled assignments that report to a grade book to track student progress and achievement. Assignments are grouped in modules, providing many options for customizing instruction. Dynamic Training The online Benchmark Series courses include interactive resources to support learning.

Watch and Learn Lessons include a video demonstrating how to perform the chapter activity, a reading to provide background and context, and a short quiz to check understanding of concepts and skills.

Guide and Practice Tutorials provide interactive, guided training and measured practice. Hands On Activities enable students to complete chapter activities, compare their solutions against a Check Your Work model answer image, and submit their work for instructor review. Concepts Check completion exercises assess comprehension and recall of application features and functions as well as key terminology. Skills Assessment Hands On Activity exercises evaluate the ability to apply chapter skills and concepts in solving realistic problems.

Each is completed live in Excel and is uploaded through Cirrus for instructor evaluation. Visual Benchmark assessments test problem-solving skills and mastery of application features. A Case Study requires analyzing a workplace scenario and then planning and executing a multipart project. Exercises and Projects provide opportunities to develop and demonstrate skills learned in each chapter.

Each is completed live in the Office application and is automatically scored by Cirrus. Detailed feedback and how-to videos help students evaluate and improve their performance. Skills Check Exams are completed live in the Office application and are scored automatically.

Detailed feedback and instructor-controlled how-to videos help student evaluate and improve their performance. Multiple-choice Concepts Exams assess understanding of key commands and concepts presented in each chapter. Assessing Proficiency exercises check mastery of software application functions and features.

Writing Activities challenge students to use written communication skills while demonstrating their understanding of important software features and functions.

Internet Research assignments reinforce the importance of research and information processing skills along with proficiency in the Office environment. A Job Study activity at the end of Unit 2 presents a capstone assessment requiring critical thinking and problem solving.

Unit-Level Projects allow students to practice skills learned in the unit. Each is completed live in the Office application and automatically scored by Cirrus. Student eBook The Student eBook, accessed through the Cirrus online course, can be downloaded to any device desktop, laptop, tablet, or smartphone to make Benchmark Series content available anywhere students wish to study.

With Exam Watch, instructors can observe students in a virtual, live, skills-based exam and join remotely as needed—a helpful option for struggling students who need one-to-one coaching, or for distance learners.

In her years as an instructor, she taught many courses in software applications to students in postsecondary information technology certificate and degree programs. Since , Nita has been a leading author of courseware for computer applications training and instruction. She is a contributor to the Cirrus online content for Office application courses and has also written textbooks for keyboarding, desktop publishing, computing in the medical office, and essential skills for digital literacy.

Jan Davidson started her teaching career in as a corporate trainer and postsecondary instructor and holds a Social Science degree, a writing certificate, and an In-Service Teacher Training certificate. In this role, she has developed curriculum and taught a variety of office technology, software applications, and office administration courses to domestic and international students in a variety of postsecondary programs.

As a consultant and content provider for Paradigm Education Solutions since , Jan has contributed to textbook and online content for various titles. Audrey has also been a content provider for Paradigm Education Solutions since Getting Started in Office Microsoft Office is a suite of applications for personal computers and other devices.

These programs, known as software, include Word, a word processor; Excel, a spreadsheet editor; Access, a database management system; and PowerPoint, a presentation program used to design and present slideshows. Microsoft Office is a subscription service that delivers continually updated versions of those applications. The Benchmark courseware was developed using features available in Office You may find that with your computer and version of Office, the appearance of the software and the steps needed to complete an activity vary slightly from what is presented in the courseware.

Identifying Computer Hardware The Microsoft Office suite can run on several types of computer equipment, referred to as hardware. If you are not sure what equipment you will be operating, check with your instructor. The computer system shown in Figure G. Each component is discussed separately in the material that follows.

Ethernet port USB ports microphone speaker video port connection connection. This is the brain of the computer, where all processing occurs. Input and output ports are used for attaching peripheral equipment such as a keyboard, monitor, printer, and so on, as shown in Figure G. When a user provides input, the PC computes it and outputs the results.

Monitor Hint Monitor size A computer monitor looks like a television screen. It displays the visual is measured diagonally information output by the computer. Monitor size can vary, and the quality of and is generally the display for monitors varies depending on the type of monitor and the level of distance from the bottom left corner to resolution.

Keyboard The keyboard is used to input information into the computer. The number and location of the keys on a keyboard can vary. In addition to letters, numbers, and symbols, most computer keyboards contain function keys, arrow keys, and a numeric keypad. Figure G. The 12 keys at the top of the keyboard, labeled with the letter F followed by a number, are called function keys. Use these keys to perform functions within each of the Office applications.

To the right of the regular keys is a group of special or dedicated keys. These keys are labeled with specific functions that will be performed when you press the key. Below the special keys are arrow keys.

Use these keys to move the insertion point in the document screen. Some keyboards include mode indicator lights to indicate that a particular mode, such as Caps Lock or Num Lock, has been turned on. Pressing the Caps Lock key disables the lowercase alphabet so that text is typed in all caps, while pressing the Num Lock key disables the special functions on the numeric keypad so that numbers can be typed using the keypad.

When you select these modes, a light appears on the keyboard. Drives and Ports An internal hard drive is a disk drive that is located inside the PC and that stores data. External hard drives may be connected via USB ports for additional storage. Most PCs will have a few USB ports, at least one display port, audio ports, and possibly an ethernet port used to physically connect to the internet or a network.

Printer An electronic version of a file is known as a soft copy. If you want to create a hard copy of a file, you need to print it. To print documents, you will need to access a printer, which will probably be either a laser printer or an ink-jet printer.

A laser printer uses a laser beam combined with heat and pressure to print documents, while an ink-jet printer prints a document by spraying a fine mist of ink on the page. Mouse Most functions and commands in the Microsoft Office suite are designed to be performed using a mouse or a similar pointing device.

A mouse is an input device that sits on a flat surface next to the computer. You can operate a mouse with your left or right hand. Moving the mouse on the flat surface causes a corresponding pointer to move on the screen, and clicking the left or right mouse buttons allows you to select various objects and commands.

The mouse generally has two buttons on top, which you press to execute specific functions and commands. A mouse may also contain a wheel, which can be used to scroll in a window or as a third button. To use the mouse, rest it on a flat surface or a mouse pad. Put your hand over it with your palm resting on top of the mouse and your index finger resting on the left mouse button.

As you move your hand, and thus the mouse, a corresponding pointer moves on the screen. Office Getting Started GS To point means to position the mouse pointer on a desired item, such as an option, button, or icon. With the mouse pointer positioned on the item, click Hint Instructions the left mouse button once to select the item. In some cases you may right-click, in this course use which means to click the right mouse button, but generally, click refers to the left the verb click to refer button.

To complete two steps at one time, such as choosing and then executing a to tapping the left mouse button and the function, double-click the left mouse button by tapping it twice in quick succession. Clicking and keyboard. The I-beam pointer can be used to move the insertion point or to select text. The four-headed arrow means that you can move the object left, right, up, or down. The mouse pointer also displays as a hand with a pointing index finger when you hover over a hyperlink.

Touchpad If you are working on a laptop Figure G. A touchpad allows you to move the mouse pointer by moving your finger across a surface at the base of the keyboard as shown in Figure G. You click and right-click by using your thumb to press the buttons located at the bottom of the touchpad.

Some touchpads have special features such as scrolling or clicking something by tapping the surface of the touchpad instead of pressing a button with a thumb.

Multiple fingers or both thumbs can be used on most touchscreens, giving users the ability to zoom, rotate, and manipulate items on the screen. While many activities in this textbook can be completed using a device with a touchscreen, a mouse or touchpad might be required to complete a few activities. Choosing Commands A command is an instruction that tells an application to complete a certain task.

When an application such as Word or PowerPoint is open, the ribbon at the top of the window displays buttons and options for commands. To select a command with the mouse, point to it and then click the left mouse button. Notice that the ribbon is organized into tabs, including File, Home, Insert, and so on. When the File tab is clicked, a backstage area opens with options such as opening or saving a file. Clicking any of the other tabs will display a variety of commands and options on the ribbon.

Above the ribbon, buttons on the Quick Access Toolbar provide fast access to frequently used commands such as saving a file and undoing or redoing an action. Using Keyboard Shortcuts and Accelerator Keys As an alternative to using the mouse, keyboard shortcuts can be used for many commands. Shortcuts generally require two or more keys. A complete list of keyboard shortcuts can be found by searching the Help files in any Office application.

Office also provides shortcuts known as accelerator keys for every command or action on the ribbon. These accelerator keys are especially helpful for users with motor or visual disabilities or for power users who find it faster to use the keyboard than click with the mouse. To identify accelerator keys, press the Alt key on the keyboard. KeyTips display on the ribbon, as shown in Figure G. Press the keys indicated to execute the desired command. For example, to begin checking.

Choosing Commands from a Drop-Down List Some buttons include arrows that can be clicked to display a drop-down list of options. Point and click with the mouse to choose an option from the list. Some options in a drop-down list may have a letter that is underlined. This indicates that typing the letter will select the option. For instance, to select the option Insert Table, type the letter I on the keyboard. If an option in a drop-down list is not available to be selected, it will appear gray or dimmed.

If an option is preceded by a check mark, it is currently active. 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. Working with Multiple Applications As you learn the various applications in the Microsoft Office suite, you will notice many similarities between them.

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 With the folder Files and folders in the Navigation name highlighted, appear in the pane.

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. Buttons for managing files. 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 drop- down 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. 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. Microsoft Excel is a spreadsheet program that allows users to organize, analyze, and evaluate numerical and financial data. 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.

Data Files The online course includes Before beginning the chapter work, copy the EL1C1 folder to additional training your storage medium and then make EL1C1 the active folder.

Tutorial Creating a Worksheet Opening a Blank Open Excel by clicking the Excel tile at the Windows Start menu, or by following Workbook 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. 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. Name box Formula bar dialog box Collapse the active cell launcher Ribbon button. 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 Tutorial key. Table 1. Navigating and 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 Hint To make a should display at the left. As data is typed in a cell, the word Ready changes to cell active, position the cell pointer in the cell Enter. Data typed in a cell is shown in the cell and in the Formula bar.

If the and then click the left data entered in a cell is longer than the cell can accommodate, the data overlaps mouse button. It does not become a part of the next cell—it simply overlaps it.

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. Tutorial Saving a Workbook Saving with the Save an Excel workbook, including all sheets within it, by clicking the Save button Same Name 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 Saving with a New desired location in the Navigation pane, type a name for the workbook in the Name File name text box, and then press the Enter key or click the Save button.

Click Save button on Quick Access A workbook file name can contain up to characters, including the drive Toolbar. Each file should have a 2. At Save As distinct name. Excel will not allow two workbooks to be saved with the same file backstage area, click Browse option.

For 3. Also, some box, navigate to symbols cannot be used in a file name, such as the following: folder. Press Enter key. It is a good practice to save periodically while working with a file to be sure no changes are lost if the application crashes or freezes or if power is interrupted.

Multiple users can edit a file and AutoSave will save the workbook every few seconds so that changes can be seen by everyone. AutoSave can be turned on or off by clicking the toggle switch in the upper left corner of the Excel screen. Open Excel by clicking the Excel tile at the Windows Start menu. Depending on your operating system, the steps to open Excel may vary. This opens a workbook with a blank worksheet.

At the blank Excel worksheet, create the worksheet shown in Figure 1. Press the Enter key to make cell A2 the active cell. Type Employee in cell A2. Press the Tab key. This makes cell B2 active. Type Location and then press the Tab key. This makes cell C2 active. Type Benefits and then press the Enter key to move the insertion point to cell A3. Type Avery in cell A3. Continue typing the data shown in Figure 1. After typing the data shown in the cells in Figure 1.

Click the Save button on the Quick Access Toolbar. At the Save As backstage area, click the Browse option. Select the text in the File name text box and then type 1-EmpBene. Press the Enter key or click the Save button. If multiple documents are open, hovering the mouse pointer on the Word button or clicking the Word button on the taskbar will display thumbnails of all the documents above the buttons.

To make a change to a document, click the thumbnail that represents the document. Another method for determining what documents are open is to click the View tab and click the Switch Windows button in the Window group. The document name in the list with the check mark in front of it is the active document. The active document contains the insertion point. To make a different document active, click the document name.

To switch to another document using the keyboard, type the number shown in front of the desired document. Click View tab. Click Arrange All button. If several documents are open, they can be arranged so a portion of each displays. The portion that displays includes the title if present and the opening paragraph of each document. Minimize button Maximize button If all of the open documents are arranged on the screen, clicking the Maximize button in the active document causes that document to expand to fill the screen.

In addition, the Maximize button changes to the Restore button. To return the active document back to its original size, click the Restore button. Click the Minimize button in the active document and the document is reduced and a button displays on the taskbar representing it. To maximize a document that has been minimized, click the button on the taskbar representing it. Click Split button.

A window can be split into two panes, which is helpful for viewing different parts of a document at one time. The location of the split bar can be changed by positioning the mouse pointer on the split bar until it displays as an up-and-down-pointing arrow with two small lines in the middle, holding down the left mouse button, dragging to the new location, and releasing the mouse button. When a window is split, the insertion point is positioned in the bottom pane. To remove the split bar from the document, click the View tab and click the Remove Split button in the Window group.

The split bar can also be double-clicked or dragged to the top or bottom of the screen. Click View Side by Side button.

By default, synchronous scrolling is active. With this feature active, scrolling in one document causes the same scrolling in the other document. This feature is useful for comparing the text, formatting, or another feature between documents. To scroll in one document and not the other, click the Synchronous Scrolling button in the Window group to turn it off. Click New Window button. When a new window is opened, the document name in the Title bar displays followed by The document name in the original window displays followed by Any change made to the document in one window is reflected in the document in the other window.

Click Object button arrow. Click Text from File. Navigate to folder. Double-click document. The contents of one document can be inserted into another using the Object button in the Text group on the Insert tab. The Insert File dialog box contains similar features as the Open dialog box. Click Print. At the Print backstage area, a preview of the page where the insertion point is positioned displays at the right side.

Click the Next Page button right-pointing triangle below and to the left of the page, to view the next page in the document and click the Previous Page button left-pointing triangle to display the previous page in the document. Use the Zoom slider bar to increase or decrease the size of the page and click the Zoom to Page button to fit the page in the viewing area in the Print backstage area.

Click first gallery in Settings category. Click Print Current Page. Click Print button. Click the first gallery in the Settings category and a drop-down list displays with options for printing all the pages in the document, selected text, the current page, or a custom range of pages.

Click the Print Current Page option to print only the page on which the insertion point is located. Click File tab. Click Print Selection. This option is dimmed unless text is selected in the document. To print specific pages, use a comma , to indicate and use a hyphen – to indicate through.

Click the Copies measurement box up arrow. If several copies of a multiple-page document are printed, Word collates the pages as they print. Printing collated pages is helpful for assembling them but takes more printing time. To reduce printing time, tell Word not to print collated pages by clicking the Collated gallery in the Settings category and then click Uncollated. The last gallery contains options for printing 1, 2, 4, 6, 8, or 16 pages on one sheet of paper.

The last gallery also contains the Scale to Paper Size option. To send a document directly to the printer without displaying the Print backstage area, consider adding the Quick Print button to the Quick Access Toolbar. To do this, click the Customize Quick Access Toolbar button at the right side of the toolbar, and click Quick Print at the drop-down gallery.

Click the Quick Print button and all the pages of the active document print. Click Envelopes button. Type delivery address. Click in Return address text box. Type return address. Click Add to Document button or Print button. Word automates the creation of envelopes with options at the Envelopes and Labels dialog box with the Envelopes tab selected. The Envelopes and Labels dialog box contains a Preview sample box and a Feed sample box. The Preview sample box shows how the envelope will appear when printed and the Feed sample box shows how the envelope should be inserted into the printer.

To omit the printing of the return address, insert a check mark in the Omit check box. If a document contains a name and address, they are automatically inserted in the Delivery address text box. If a return address is entered before printing the envelope, Word will display the question Do you want to save the new return address as the default return address?

At this question, click Yes to save the current return address for future envelopes or click No if the return address should not be used as the default.

 
 

 

Center for Internet Security (CIS) Benchmarks – Microsoft Compliance | Microsoft Docs.

 
With the insertion point positioned in the Criteria text box, type 1 and then they have completed the activity correctly. Select columns A and B. Most bencgmark in Excel result from the user incorrectly inputting data into a worksheet. Information can be moved or copied from one document and pasted into another.

 
 

Benchmark series microsoft office 2016 pdf free free download.ISBN 13: 9780763869793

 
 

From adding graphics and visual elements to enhance written communication, to planning and researching documents, students will be proficient in using Word to organize, analyze, and present information. Адрес course content is delivered in the Cirrus learning environment through a series of /4626.txt assignments that report to a grade book to track student progress and achievements.

Editing and Formatting Documents 1. Preparing a Word Document 2. Formatting Characters and Paragraphs 3. Customizing Paragraphs 4. Formatting Pages and Documents Unit 2. Enhancing and Customizing Documents 5. Inserting and Formatting Objects 6. Managing Documents 7. Creating Tables 8. Applying and Customizing Formatting. Formatting and Customizing Documents 1. Applying Advanced Formatting 2. Benchmark series microsoft office 2016 pdf free free download Documents 3.

Inserting Headers, Footers, and References 4. Editing and Formatting Documents 5. Customizing Objects and Benchmark series microsoft office 2016 pdf free free download Charts 6.

Merging Documents 7. Managing Building Blocks and Fields 8. Managing Shared Documents. Formatting with Special Features 1.

Designing with Styles 2. Benchmsrk Merge Options 3. Managing Macros Unit 2. Customizing Word and Word Elements 4. Creating Forms 5. Creating a Table of Authorities and Index 6.

Using Outline View 7. Integrating and Sharing Documents and Data 8. Customizing Word. Cirrus seamlessly delivers complete course content in a cloud-based learning environment that puts students on the fast-track to success. Students can access their content from any device anywhere, through a live internet connection.

Cirrus is platform independent, ensuring that students get the same learning experience детальнее на этой странице they are using PCs, Macs, or Chromebook computers. Cirrus provides access to all the Benchmark Series content, delivered in a series of scheduled assignments that report to a grade book nenchmark track student progress and achievement.

Cirrus for the Benchmark Series delivers interactive ссылка на продолжение to guide student learning.

Section review and assessment activities in the Cirrus learning environment reinforce and assess student learning. Cirrus tracks students’ step-by-step interactions, giving instructors visibility into students’ progress and missteps. With Exam Watch, instructors can remotely join a virtual, live, skills-based exam with students’a helpful option for bencbmark students who need one-to-one coaching, or for distance learners.

Accessed through Cirrus and visible only to instructors, the Instructor eResources for the Benchmark Series include the following support:. Ссылка на страницу to main content. Order today. Learn more. Dynamic Training Cirrus for the Benchmark Series delivers interactive assignments to guide student learning. Watch and Learn Lessons include video and text content explaining how to perform the chapter activities, and a seires quiz that allows students to check their understanding of the content.

Guide and Practice Продолжить provide interactive, guided training and measured practice.

Hands On Activities enable students to complete the chapter activities in provided data files, compare their solutions against a Completed Skill model answer image, and submit their work for instructor review. Section Review and Assessment Section review and assessment activities in the Cirrus learning environment reinforce and assess student learning.

Multiple-choice Features Review exercises assess student comprehension and recall of program features, terminology, and functions. Skills Exams evaluate students’ ability to complete specific tasks. Skills Exams are completed live in the Office application and are automatically scored by Cirrus.

Exercises and Projects provide opportunities for students to further develop and demonstrate skills covered in each chapter and unit. Exercises and Projects are completed live in the Office application and are automatically scored. Detailed feedback and how-to videos читать students evaluate and improve their performance. Multiple-choice Concepts Exams assess student understanding of the chapter content. Instructor Support Cirrus benchmark series microsoft office 2016 pdf free free download students’ step-by-step interactions, vownload instructors visibility into students’ progress and missteps.

View additional Instructor eResources. Accessed through Cirrus and visible only to instructors, the Instructor eResources for the Benchmark Series include the following support: Planning resources, such as lesson seeries, teaching hints, and sample course syllabi. Frre resources, such as activity answer keys and online benchmark series microsoft office 2016 pdf free free download and templates. Assessment resources, including live and annotated PDF model answers for section work and review and assessment activities, rubrics for evaluating student work, and section-based exam banks in RTF format.