Benchmark series microsoft office 2016 pdf free free download. Benchmark Series: Microsoft Excel 365 Levels 1 and 2 FREE EBOOK PDF

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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. To change the data in a cell, click in the cell to make it active and then type the new data. When a cell containing data is active, anything typed will take the place of the existing data. If only a portion of the data in a cell needs to be edited, double-click in the cell.

This makes the cell active, moves the insertion point inside the cell, and displays the word Edit at the left side of the Status bar. Move the insertion point using the arrow keys or the mouse and then make the needed corrections.

Press the Home key to move the insertion point to the first character in the cell or Formula bar or press the End key to move the insertion point to the last character. When the editing of data in a cell is complete, be sure to change out of the Edit mode. Two other ways to change out of the Edit mode and return to the Ready mode are to click in another cell and to click the Enter button on the Formula bar. If the active cell does not contain data, the Name box displays only the cell reference by column letter and row number.

As data is typed, two buttons become active on the Formula bar to the right of the Name box, as shown in Cancel Figure 1.

Click the Cancel button to delete the current cell entry. A cell entry can also be deleted by pressing the Delete key. Click the Enter button when finished typing or editing the cell entry. With 1-EmpBene open, double-click in cell A7 contains Mikulich. Move the insertion point immediately left of the k and then type c.

This changes the spelling to Mickulich. Click in cell A4 contains Connors , type Bryant, and then press the Tab key. Clicking only once allows you to type over the existing data.

Edit cell C2 by completing the following steps: 4a a. Type Classification over Benefits. Click in any other cell. Click the Save button on the Quick Access Toolbar to 4b save the workbook again. Tutorial Printing a Worksheet Printing a With a workbook open, click the File tab and the Home backstage area displays, Worksheet as shown in Figure 1.

Use buttons and options at the backstage area to perform actions such as opening, closing, saving, and printing a workbook. Print a worksheet from the Print backstage area, as shown in Figure 1. To display this backstage area, click the File tab and then click the Print option. Click the Print button to send the worksheet worksheet to the printer. Use these options to specify how the workbook will be printed.

Click File tab. Below the Print button are two categories: Printer and Settings. Use the gallery 2. Click Print option. Click Print button. The Settings category contains a number of galleries, each with options for specifying how the workbook will be printed.

Use the galleries to specify whether the pages are collated when printed; what page orientation, page size, and margins the workbook should have; and whether the worksheet will be scaled to print all rows and columns of data on one page.

Another method for printing is to click the Quick Print button on the Quick Access Toolbar to send the workbook directly to the printer. To insert this button on the Quick Access Toolbar, click the arrow button at the right of the toolbar and then click Quick Print at the drop-down list. To remove the button, right-click it and then click Remove from Quick Access Toolbar at the drop-down list.

To close Excel, click the Close button in the upper right corner of the screen. The uick Steps Close button contains an X, and if the mouse pointer is positioned on the button, Close Workbook the button background changes from green to red and a ScreenTip displays with 1.

Click Close option. Close Excel Click Close button. These features include AutoComplete, which allows users to automatically complete multiple entries of the same data; AutoCorrect, which automatically corrects many common typographical errors; and AutoFill, which automatically inserts words, numbers, or formulas in a series. As the first few characters are typed into a cell, AutoComplete predicts what AutoCorrect will be typed next based on previous entries in the worksheet, and will automatically complete the entry based on its prediction.

If the AutoComplete entry is correct, accept it by pressing the Tab key or the Enter key. If it is incorrect, simply continue typing the correct data. This feature can be very useful in a worksheet that contains repetitive data entries. For example, consider a worksheet that repeats the word Payroll. The second and subsequent times this word is to be inserted in a cell, simply typing the letter P will cause AutoComplete to insert the entire word.

To see what symbols and words are included in AutoCorrect, click the File tab and then click Options. At the Excel Options dialog box, click Proofing in the left panel and then click the AutoCorrect Options button in the right panel. At the AutoCorrect dialog box, type the text shown in the first column in the list box and then press the spacebar and the text in the second column is inserted in the cell.

Along with symbols, the AutoCorrect dialog box contains commonly misspelled words and common typographical errors. Type the text shown in the first column of this list box in a worksheet and then press the spacebar and the text is replaced by the text in the second column of this list box. With 1-EmpBene open, make cell A1 active.

Type text in cell A1 as shown in Figure 1. Type the remaining text in the cells. Accept this by pressing the Tab key. Pressing the Tab key accepts West and also makes the cell to the right active. Use AutoComplete to enter the second and subsequent occurrences of Salaried and Hourly. Print 1-EmpBene by clicking the File tab, clicking the Print option, and then clicking the Print button at the Print backstage area.

The gridlines will not print. Close the workbook by clicking the File tab and then clicking the Close option at the backstage area. Tutorial Using AutoFill Entering Data Using When a cell is active, a thick green border surrounds it and a small green square the Fill Handle appears in the bottom right corner.

This green square is called the AutoFill fill handle see Figure 1. Use the fill handle to fill a range of cells with the same data or with consecutive data. For example, suppose the year is to be inserted into a row or column of cells. To do this quickly, type in the first cell, position the mouse pointer on the fill handle, click and hold down the left mouse button, drag across or down into the cells in which the year is to be inserted, and then release the mouse button.

Hint When filling The fill handle can also be used to insert a series in a row or column of cells. Type January in the first cell, position the mouse pointer on the fill down the Ctrl key if you want to copy the handle, click and hold down the left mouse button, drag down or across into 11 same data instead of more cells, and then release the mouse button. Excel automatically inserts the displaying the next other 11 months of the year in the proper order. When using the fill handle, the instance in the series.

Certain sequences—such as 2, 4 and Jan 12, Jan 13—require that both cells be selected before using the fill handle. If only the cell containing 2 is active, the fill handle will insert 2s in the selected cells. The list in Table 1. A variety of other sequences can be inserted in a worksheet using the fill handle.

Click this button and a list of options displays for filling the cells. By default, data and formatting are filled in each cell. Use the Auto Fill Options button to choose to fill only the formatting in the cells or to fill only the data without the formatting. Other fill options include choosing to copy data into the selected cells or to fill the data as a series. To display this dialog box, click Workbook the File tab and then click the Open option.

This displays the Open backstage area. At the Open backstage area, click the Browse option. At the Open dialog box, navigate to the desired folder and then double-click the workbook name in the Content pane. Tutorial Opening a Workbook from the Recent Option List Opening from the With the Recent option selected in the middle panel at the Open backstage area, a list Recent Option List displays with the most recently opened workbooks. Up to 50 workbook names appear in the list by default.

Open a workbook from this list by clicking the workbook name. Pinning and Unpinning Workbooks and Folders 2. Click Open option. Click Browse option. If a workbook is opened on a regular basis, consider pinning it to the Recent option 4. Navigate to folder. To pin a workbook, position the mouse pointer 5. Double-click workbook name. The left-pointing push pin icon changes to a down- Recent Option List pointing push pin icon and the pinned workbook appears in the Pinned category 1.

Position mouse Open backstage area is displayed. Click left-pointing and the Home backstage area. To unpin a workbook from the Recent or Recent push pin icon. More than one workbook can be pinned to a list. Recent Option List Another method for pinning and unpinning documents is to use the shortcut menu. Right-click a workbook name and then click the option Pin to list or Unpin from list.

Position mouse In addition to workbooks, folders can be pinned to a list at the Save As pointer over workbook name. The third panel in the Save As 4. Click down-pointing backstage area shows a list of the most recently opened folders and groups them push pin icon. Pin a folder or folders to the list to display them in the Pinned category at the top of the list. Open FillCells by completing the following steps: a. 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 CIS Microsoft Azure Foundations Benchmark is intended for customers who plan to develop, deploy, assess, or secure solutions that incorporate Azure.

The document provides prescriptive guidance for establishing a secure baseline configuration for Azure. CIS benchmarks are internationally recognized as security standards for defending IT systems and data against cyberattacks.

Used by thousands of businesses, they offer prescriptive guidance for establishing a secure baseline configuration. System and application administrators, security specialists, and others who develop solutions using Microsoft products and services can use these best practices to assess and improve the security of their applications.

Like all CIS benchmarks, the Microsoft benchmarks were created using a consensus review process based on input from subject matter experts with diverse backgrounds spanning software development, audit and compliance, security research, operations, government, and law.

Microsoft was an integral partner in these CIS efforts. For example, Office was tested against the listed services, and the resulting Microsoft Foundations Benchmark covers a broad range of recommendations for setting appropriate security policies that cover account and authentication, data management, application permissions, storage, and other security policy areas.

As stated by CIS , ‘they’ve been pre-tested for readiness and compatibility with the Microsoft Azure public cloud, Microsoft Cloud Platform hosted by service providers through the Cloud OS Network, and on-premises private cloud Windows Server Hyper-V deployments managed by customers’. Hardening is a process that helps protect against unauthorized access, denial of service, and other cyber threats by limiting potential weaknesses that make systems vulnerable to cyber attacks.

For additional customer assistance, Microsoft provides Azure Blueprints , which is a service that helps you deploy and update cloud environments in a repeatable manner using composable artifacts such as Azure Resource Manager templates to provision resources, role-based access controls, and policies. Resources provisioned through Azure Blueprints adhere to an organization’s standards, patterns, and compliance requirements.

The overarching goal of Azure Blueprints is to help automate compliance and cybersecurity risk management in cloud environments. When assigned to an architecture, resources are evaluated by Azure Policy for compliance with assigned policy definitions. Get a complete list of CIS benchmarks for Microsoft products and services. CIS benchmarks establish the basic level of security for anyone adopting in-scope Microsoft products and services. However, they shouldn’t be considered as an exhaustive list of all possible security configurations and architecture but as a starting point.

Each organization must still evaluate its specific situation, workloads, and compliance requirements and tailor its environment accordingly. The release of revised CIS Benchmarks changes depending on the community of IT professionals who developed it and on the release schedule of the technology the benchmark supports. CIS distributes monthly reports that announce new benchmarks and updates to existing benchmarks. To receive these, register for the CIS Workbench it’s free and check Receive newsletter in your profile.

 
 

 

– Benchmark Series: Microsoft® Office | Paradigm Education

 

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. Proofing Documents 3. Inserting Headers, Footers, and References 4. Editing and Formatting Documents 5. Customizing Objects and Creating Charts 6. Merging Documents 7. Managing Building Blocks and Fields 8. Managing Shared Documents. Formatting with Special Features 1. Designing with Styles 2. Managing 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 whether they are using PCs, Macs, or Chromebook computers. Download Handbook of Formal Languages: Volume 2.

Cormen PDF. NET Framework 3. Download Microsoft?? SQL Servera??? Applications, incl. Free Digital signal processing receivers for dynamic optical networks: DSP techniques for physical layer impairment mitigation in OOK optical packet networks by Jos?? Free From the architecture of the Internet to the spreading of an epidemic: An inspection of complex networks with the eyes of a statistical physicist by Thomas Petermann PDF Download.

Brooks PDF Download. Scott, Zimmerman, Beverly B. Guah PDF Online. Windows Servera??? Shelly PDF Online. Stanek PDF Kindle. Adamski PDF Online. Ray-Chaudhuri on the occasion of his 65th birthday. The Ohio State University Research Institute Publications Download. Papadimitriou ePub. Foley ePub. Mehlhorn Download. Chellen ePub. Lecture Notes in Computer Science Download. Computer Science and General Issues Download.

Lecture Notes in Computer Science ePub. Pratt ePub. Professional ADO. Fleischammer PDF Kindle.

 
 

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

 
 
Each file should have a 2. 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. Click this button and the Microsoft Office support website opens in a browser window with specific information about the dialog box or backstage area. Make the following changes to cell contents in the worksheet: B Change 20 to 28 C Change Upon completing the text, students can expect to be proficient in using the major applications of the Office suite to organize, analyze, and present information. Tutorials guide students through the steps for the skills and then allow them to practice on their own.