Marquee Series: Microsoft Office Text.Marquee Series: Microsoft Office Text – PDF Free Download
Looking for:
Marquee series microsoft office 2016 pdf free
How to get ebooks on Reader How to get ebooks on Reader Click for instant access! A cell is a singular container that you can use to input and store data. Move the model to the upper left corner of cell A1. Smu mba transfer. 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.
– Benchmark Series: Microsoft Excel Levels 1 And 2 [PDF] [6ed3baemi7b0]
If you use the AutoFill feature to fill in the remaining cells in column class. Encourage A, Excel will follow the pattern and fill in the remaining cells with 5, 6, 7, 8, 9, 10, and so on. If you students to experiment would like AutoFill to recognize a repeating pattern, say 1, 2, 3, 1, 2, 3, you would need to enter at with a variety of different data sets. If you have least two cycles of the pattern to be sure Excel recognizes it as a pattern and not a sequence of students participating numbers.
If you start with only a single value, Excel will simply repeat it. AutoFill works for text as remotely, ask them to well as numeric values, so Excel would, for example, recognize a pattern such as lettering the first screen share interesting column instead of numbering, entering the days of the week, or entering the months of the year. To use the AutoFill feature, you must first select the sequence of cells you want the pattern to be based on.
When you select a cell or a range, Excel displays the cell or range within a solid green border. At the bottom-right corner of the border, Excel displays a fill handle. To use the AutoFill feature, you simply drag the fill handle until the border surrounds the desired range of cells, and then release it. When the mouse pointer is directly over the fill handle, it is displayed as a thin black plus symbol. The AutoFill feature can also assist you with entering duplicate text entries in the same column.
If you begin to type something into a cell that matches the beginning of another cell’s content, Excel will attempt to automatically complete the entry for you to match the existing content.
If you intended to enter a duplicate entry, you can simply press the Enter key, and Excel will automatically complete the entry. However, as you type, if the sequence of characters deviates from the other cell’s content, Excel will stop displaying the entry and will simply let you continue to type the desired cell content.
This works only with entries that consist of just text or a combination of text and numbers. Excel will not automatically complete duplicate entries of numeric values.
After you release the fill handle, Excel displays a small icon on the lower-right side of the range. Selecting that icon opens a menu, providing you with access to a series of options for choosing how to apply the AutoFill. These options can change depending on the type of data you have entered into the range. The following table describes the most commonly used AutoFill options. AutoFill Option Description Copy Cells Ignores any recognizable pattern and fills the remaining cells with the same data the originally selected cells contain.
Fill Series The default AutoFill option. Excel applies the pattern it recognizes in filling the remaining cells. Fill Formatting Only Applies any formatting in the originally selected cells to the remaining cells without populating the cells with content.
Fill Without Formatting Fills the remaining cells with data based on the recognized pattern while ignoring any formatting applied to the originally selected cells. Flash Fill If Excel recognizes a pattern in cell entries in one column based on the cells in other columns, it can fill in the remaining cell entries following that pattern. Flash Fill In addition to being an AutoFill option, the Flash Fill feature can automatically recognize patterns Flash Fill across rows as you enter data, and then copy those patterns down a column of entries.
The key difference between this and the AutoFill feature is that it depends on a recognizable pattern based on the entries in cells in other columns. Essentially, you can use this feature to combine entries, or parts of entries, from cells in the same row to another cell in that row, and then copy that combined data down a column.
Let’s look at a simple example to illustrate the point. Suppose you have a worksheet that lists employee names. The last names are in column A and the first names are in column B. But you also need a column for each employee’s email address.
These email addresses always follow the same pattern: firstname. So, in the first row in column C, you manually type the first employee’s first name followed by a period, then the employee’s last name, then develetech. Excel can recognize that this data is based on the entries in the first two columns, and then it can copy all of the names down column C, following the pattern, for each of the employees.
You have to begin entering subsequent entries by following the same pattern before it can do so. Flash Fill can end up saving you an incredible amount of time. It works only down columns. Note: The Flash Fill feature will work only if there are no empty columns between the original data and the column you’re trying to fill following a pattern.
There can, however, be columns of data that don’t relate to the pattern in between the cells containing the original data and the cells you are trying to fill. Figure The Flash Fill feature recognizes that cell C3 is following the pattern of C2 using data from its adjacent cells. It can then fill in the pattern for the rest of the cells in column C. The Clear Command Because you need to enter data into worksheet cells, it stands to reason that you will also need to delete cell data from time to time.
The most basic method of doing this is to select the cell that contains the data you wish to remove and then press the Delete key.
Excel also provides an alternative with the Clear command, which gives you access to a number of options for removing cell content that don’t always include removing everything from the cell. The Clear command is available in the Editing group on the Home tab. The following table describes each of the Clear command options.
Clear Formats Only formatting applied to the selected cell s. The content is left in place, including any existing comments. Clear Contents Only the contents of the selected cell s , but not the formatting. Clear Comments Only comments from the selected cell s. Clear Hyperlinks Hyperlinks from cell contents.
The formatting is left in place, including formatting applied to the text when the hyperlink was created. Scenario Your colleague has emailed you a text file with some additional new products that Develetech will be adding to its catalog. In order to keep track of the new product lines all in one place, you decide to add the new items to the My New Products. In addition to tracking the cost and quantity of your new products, you also want to list each product’s unique number and product code as identifiers.
These will be used both internally and on the public-facing online store to assist with inventory. These identifiers follow certain patterns, so rather than wasting time entering them manually for each product, you’ll let Excel do the work for you. Open the My New Products. Ensure that students are b From the Open screen, ensure that Recent is selected and, in the Today list, select My New opening the version of Products.
Open the Future Products. While c Double-click the Future Products. Copy and paste the new product names into the My New Products. If students ask about the Paste Options menu that appears after pasting the content, let them know that it will be covered later in the course. It will have no effect on the current activity. Use the AutoFill feature to add unique product numbers for each new product entry. Note: You can also drag the fill handle manually, but double-clicking is a faster way of populating every cell down a column that has adjacent row data.
Use Flash Fill to quickly generate a product code based on the product name and number. Code and then press Enter. If students notice that the Prod. Code column label spills over onto the next cell, assure them that they will learn how to modify the appearance of cells in a later lesson. Save and close the My New Products. Excel comes packaged with its own Help system that can assist you in finding answers to your questions.
Taking the time to learn how to use Excel Help now could save you countless hours of research down the road. Microsoft Excel Help Microsoft Excel Help provides you with access to articles that can answer your Excel questions and show you how to perform various tasks within the application.
Excel Help checks Microsoft Office’s support website for these articles, which can include text, screenshots, and video. In order to access Help articles, you must have an active Internet connection. You can also reach Help on specific topics by searching for the topic in Tell Me. You can use The Excel Help the Excel Help window to search for, browse through, and review the various web articles Window available to you. Figure The Excel Help window. The Excel Help window is divided into a number of sections and displays a variety of commands to help you locate the desired Help resources.
The following table describes each of these in some detail. Search field Enter search terms for locating Help resources. Search button Execute Help searches. Content section Display the results of a search or the contents of an online Help article. This activity requires an Scenario Internet connection. As you’ve been working with Excel more and more, you have come across some features that you have some questions about.
You have heard there is a particular command that you might have use for, but you want to learn more about what it does first. You decide to use the Excel Help system to find out more about the application. Time permitting, allow students to run their own 1. Open Excel Help.
Search for Excel Help resources online. It’s not important that c Review the content. The d On the Excel Help toolbar, select the Home button. Close the Excel Help window. Excel Help to find information. You navigated the Excel user interface, used Excel commands, created and saved a basic workbook, entered cell data, and used the Excel Help system. As you build upon these foundational skills, you will begin to unlock Excel’s robust functionality and discover the power that lies within your organizational data.
Encourage students to use the social Do you think you’ll prefer to use the mouse or the keyboard navigation options as you develop your networking tools workbooks? Some students may be uncomfortable at first with the ribbon and Backstage view, continued learning. They might find that it’ll take some getting used to. Still, others may see the value in the ribbon system, especially from a visual point of view.
Students may see the Tell Me feature as a good equalizer when they’re unable to find what they’re looking for with the ribbon.
From the Course screen you can also access available resources for a more continuous learning experience. Excel contains an incredible array of functionality to help you do this, particularly when it comes to working with numerical data. In order to take full advantage of Excel’s abilities to quickly, efficiently, and accurately calculate data, you must first understand how Excel thinks, and how to tell it what to do.
In this lesson, you’ll do just that. Every time a single value changes, you might have to change entire rows or columns of data. Keeping up with such calculations manually is not only impractical and tedious, but it is also unnecessary and, in some cases, nearly impossible. Why not have Excel do it for you?
Performing calculations is one of the most critical, foundational tasks in Excel, forming the basis for nearly all of the data analysis you’ll need to perform. By gaining a solid, clear understanding of how Excel performs such calculations, you’ll save yourself valuable time, avoid a ton of headaches, and ensure a level of accuracy not possible when performing the same calculations on your own. Excel Formulas Excel Formulas Excel formulas perform simple or complex mathematical computations in worksheets.
You can use formulas to perform tasks such as adding up a row or a column of numbers, multiplying sales figures by commission rates, and applying tax to sales. One of the key benefits of using formulas in Excel is that you can change some of the values used in the formulas and, by default, Excel will automatically adjust the calculations accordingly.
It is important to remember that, in Excel, what you see isn’t necessarily what you get. When you enter a formula into a worksheet cell, by default, Excel will display the result of calculating the formula in the cell, and not the formula itself. Excel can perform calculations by using fixed numbers, or by referring to values in other cells. This is one of the truly powerful features of using Excel to perform calculations. Excel provides you with an incredible array of options for performing calculations in your workbooks and worksheets.
Figure A formula in a worksheet cell. As you’ve seen, the Formula Bar allows you to edit cell contents and select, navigate to, and view the contents of selected cells. It’s also useful for quickly inserting pre-existing formulas.
Additionally, to the left of the Formula Bar text box are buttons that provide supplementary options. The following table describes the Formula Bar options in greater detail. Selecting the Cancel button will undo any changes you have made to a cell since selecting it and will keep that cell active.
Basically, it reverts the cell back to its state before you began editing it. When you select the Enter button, Excel enters whatever content is in the active cell and keeps the cell active.
Insert Function button The Insert Function button opens the Insert Function dialog box, providing you with access to a wide variety of pre-existing Excel formulas. Elements of Excel Formulas The first rule of using formulas in Excel is that all formulas begin with an equal sign. This may seem A Basic Mathematical a bit counter-intuitive at first, as you are used to seeing figures on both sides of a formula when it’s Formula written out.
But Excel displays formula results in cells, which takes care of the result side of the equal sign. You enter the expression side of a formula after the equal sign. To understand this better, let’s first look at a simple mathematical formula. Formulas basically consist of an expression on one side of the equal sign and a result on the other. Expressions consist of a series of constants, variables, and mathematical operators.
Operators indicate where to perform such basic computations as adding, subtracting, multiplying, dividing, calculating exponents, and so on. Here are the basic elements of a mathematical formula as written on paper. Elements of Excel Excel formulas work pretty much the same way. When you enter a formula in a worksheet cell, the Formulas cell displays the result.
The equal sign and the mathematical expression make up the content that’s This is an excellent actually entered in the cell. In Excel formulas, you can think of constants as numbers you manually opportunity to enter into formulas, and variables as references to other cells. When you manually type a number demonstrate how into an Excel formula, that number remains the same unless you manually edit it; this is referred to constants and as “hard coding” the value in the formula.
When you enter a cell reference in an Excel formula, the references work in Excel result of the calculation will change if you change the value in the referenced cell. Change the value in A2 to demonstrate the result changing automatically. Figure An Excel formula. Basic Excel formulas consist of the following elements: the equal sign, constants, references, and mathematical operators.
The equal sign tells Excel to perform a calculation based on the formula components and then to display the result of the calculation in the cell. All formulas in Excel must start with an equal sign. Constants Numbers and text that do not change unless manually altered. References Essentially, the variables in Excel formulas. When you include a reference to a cell or a range, Excel uses the value s from that cell or range to perform the calculation. Mathematical operators Symbols that specify the kind of calculation that Excel should perform on the elements of a formula.
These are simply symbols Excel uses to identify the calculations it should perform. This is how Excel determines The Order of Operations which operation to perform first, second, third, and so on in a complex formula. It is important that Consider mentioning the you understand how Excel will compute a formula before you create one to ensure that Excel will mnemonic device perform the calculation exactly as you want it to. Note: While often used for subtraction, the minus sign — can also be used to denote a negative value.
In these cases, the minus sign takes greater precedence than exponents, allowing you to calculate the exponential value of a negative number. Figure Excel performs mathematical computations in a specific order. In fact, there are four different kinds of operators you can use to perform calculations. Reference operators are one of the most important.
Reference operators tell Excel which cell or range values to use as variables in your formulas. There are three reference operators: the comma, the colon, and the space. Other than the reason provided, using Reference Symbol Function intersection operators is Operator a good practice in avoiding direct cell Comma , The comma is used as a union operator, which tells Excel to references. This will include each reference in a series of references.
This is similar become more apparent to how you would use a comma when writing a serial list; you when students learn are telling Excel to include each of the references. Colon : The colon is used as a range operator, which you’ve already seen when selecting a range of cells.
The colon tells Excel to include all cells in a range between the cell references on either side of the colon. This tells Excel to look for a value in the cell where two ranges intersect. For example, A9:J9 E2:E22 tells Excel to look for the value in the cell where these two ranges intersect, which in this case would be the value in cell E9.
If you have a spreadsheet of salespeople as the rows and their quarterly sales as the columns, you can use an intersection to find how well Salesperson X did in Q3. While you might be able to find this information by simply looking at the spreadsheet, this can become a hassle in larger spreadsheets that require scrolling through multiple pages. Note: Excel reads a blank space only as an intersection operator if no other operator is present between cell or range references.
If you enter another reference operator between the cell or range references, Excel will read the operator and ignore the spaces. Here, the spaces don’t matter because of the commas. Excel will not look for the intersection, which in this case makes sense as the cells don’t actually intersect.
Scenario Develetech plans to introduce five new products. Company management wants you to analyze the projected sales figures to determine how much the company can plan to profit from the new items. You have entered the sales estimates into an Excel worksheet. Now, you must use Excel formulas to get Excel to perform the calculations for you. Open the New Product Income. Calculate the sales before tax based on the sales estimates for each product.
Ask students to explain Note: Although Excel displays cell and range references, and many other what this formula will elements of formulas and functions, in all capital letters, it is not necessary to calculate. Consider type them in all capital letters. The Campaign for America s Libraries. Simple steps that will help you create an your library campaign Marketing Simple steps that will help you create an your library campaign Marketing your library Table of Contents I.
Children will cover: – Using a digital camera to take photographs and More information. If you have not done so already, More information. Introduction Assignment Communications 12 Introduction Assignment This assignment is an opportunity for you to demonstrate your ability to conduct a close reading of an informational text, and to respond to the text effectively.
Some e-book readers are limited to More information. Together they’ve downloaded over 50 billion More information. You live in a culture where people watch More information. Contents What is the Opportunity? It has two components: More information. There are some techniques and methods More information.
About Kobo Desktop Downloading and installing Kobo Desktop Buying ebooks with Kobo Desktop Buying a book When and how do I receive my ebook after purchasing it? Do ebooks come in different formats? What s the difference between these formats? Objection handling workbook Sales Training Programme. It is a self More information. What hardware More information. First Things First. Hi, Hi, Congratulations for downloading this pdf guide on lead generation. If you More information. How to get ebooks on Reader How to get ebooks on Reader Click for instant access!
Systems More information. But if done well, email can still deliver More information. A fresh look at equity release For financial adviser use only. A fresh look at equity release How you could add an extra dimension to your business How you could add an extra dimension to your business More information. JVZoo is a digital marketplace where product More information. Short Selling With PennyStocker. Sunnyhills School.
This is not a definitive list of apps and we will add to this list as appropriate. We recommend More information. You ll want to place a More information. Now, you will be happy that at this time Hazelden More information.
English T: Young Adult Fiction. Teacher Notes www. Genre Written and visual information Reading level More information. Department of Education Rod Paige Secretary. Rich Assistant Secretary U. Set internet safety parental controls with Windows How to Microsoft lets parents set up internet safety settings on a Windows computer for their kids, using Family Safety. Family Safety provides a website and a free program that you install on the computers More information.
There is an excellent site called Ideas4Writers co. You could do worse than subscribe to it for life, a great investment as you can download Mba marketing research projects free download. Cancel Delete. Cancel Overwrite Save. Terms of service.
Privacy policy. Cookie policy. Change language. Made with love in Switzerland. Choose a topic for study. Here is a way to start: Observe the world around you. What interests you about it? What hobbies do you like. What you should know about: Windows 7 What s changed? Why does it matter to me? Do I have to upgrade? Tim Wakeling Contents What s all the fuss about?
Writing Thesis Defense Papers The point of these papers is for you to explain and defend a thesis of your own critically analyzing the reasoning offered in support of a claim made by one of the philosophers. Information in regular type inside the boxes and all information. When you purchase any of our Retail Product Packages you will have access to a. This is a free ebook from Frank Jones.
You should not have paid for it. All Rights Reserved:. No portion of this book may be reproduced mechanically, electronically, or by any other means,. This material has been prepared by. It s that Science Fair time of year.
No amount of groaning is going to make it go away. Just imagine the inquiry and organizational skills you ll learn and practice. The short answer. Passive Study Be actively involved in managing the learning process, the mathematics and your study. HE Leaflet 69 Rev. Whenever two people come into contact, the potential for conflict arises. All rights reserved. The journey of speaker starting up his business has inspired me a lot. The reason for me to study computer science is to build my own computer games.
But during working. I Miss My Pet. It s the lifeline of any. You are also welcome to visit and download from our free. Log in Registration. Search for. Marquee Series: Microsoft Office Text. Size: px. Start display at page:. Kelly Norton 2 years ago Views:. Similar documents. How To Really. ShadoW the. More information. Objection handling workbook Sales Training Programme. It is a self More information. Sell on Amazon Start a Selling Account. AmazonGlobal Ship Orders Internationally.
ComiXology Thousands of Digital Comics. DPReview Digital Photography. Shopbop Designer Fashion Brands. Deals and Shenanigans. Ring Smart Home Security Systems. Blink Smart Security for Every Home. PillPack Pharmacy Simplified. Amazon Renewed Like-new products you can trust.
(PDF) Microsoft ® Office Excel ® Part 1 | Mohamed Hamza –
Topic 3. Thesis 4. Sources 5. Notes 6. Draft 7. Use video grow your dental practice Welcome. Lisa White lwhite sfsu. Social media is a powerful tool. Many people are well aware of this and with the 1. Choose a topic for study. Here is a way to start: Observe the world around you. What interests you about it?
What hobbies do you like. What you should know about: Windows 7 What s changed? Why does it matter to me? Do I have to upgrade? Tim Wakeling Contents What s all the fuss about? Writing Thesis Defense Papers The point of these papers is for you to explain and defend a thesis of your own critically analyzing the reasoning offered in support of a claim made by one of the philosophers. Information in regular type inside the boxes and all information. When you purchase any of our Retail Product Packages you will have access to a.
This is a free ebook from Frank Jones. You should not have paid for it. All Rights Reserved:. No portion of this book may be reproduced mechanically, electronically, or by any other means,. This material has been prepared by. It s that Science Fair time of year. No amount of groaning is going to make it go away. Just imagine the inquiry and organizational skills you ll learn and practice.
The short answer. Passive Study Be actively involved in managing the learning process, the mathematics and your study. HE Leaflet 69 Rev. Whenever two people come into contact, the potential for conflict arises. All rights reserved. The journey of speaker starting up his business has inspired me a lot.
The reason for me to study computer science is to build my own computer games. But during working. I Miss My Pet. It s the lifeline of any. You are also welcome to visit and download from our free. Log in Registration. Search for. Marquee Series: Microsoft Office Text. The editors will have a look at it as soon as possible. Self publishing. Share Embed Flag.
TAGS download exploring microsoft volume utah computing author faculty various currently. You also want an ePaper? She holds a B. Mary Anne has more than 12 years of educational experience. Click the Keep Changes button. At the Settings window, take note of the current DPI percentage next to the text Change the size of text, apps, and other items. Click the Close button to close the Settings window. You can download all the files at once described in the activity below , or download only the files needed for a specific chapter.
Make sure you have an active internet connection before starting this activity. Check with your instructor if you do not have access to your Cirrus online course. Navigate to the Course Resources section of your Cirrus online course. Note: The steps in this activity assume you are using the Chrome browser. If you are using a different browser, the following steps may vary. A zip file containing the student data files will automatically begin downloading from the Cirrus website.
Click the button in the lower left corner of the screen once the files have finished downloading. Right-click the StudentDataFiles folder in the Content pane. Click the Copy option in the shortcut menu. Click the Home tab in the File Explorer window. Click the Paste button in the Clipboard group. Close the File Explorer window by clicking the Close button in the upper right corner of the window.
An Excel spreadsheet can be used for such activities as creating financial statements, preparing budgets, managing inventory, and analyzing cash flow. This chapter will introduce the basics of creating a worksheet, opening workbooks, and saving workbooks.
In a worksheet, learn to enter data, as well as the use of formulas to calculate sums and averages. Learn to enter data quickly and efficiently using features such as the fill handle and to apply basic formatting to data in conventional accounting style.
Creating a Worksheet Tutorial Open Excel by clicking the Excel tile at the Windows Start menu, or by following other steps as needed depending on the operating system. At the Excel opening screen, click the Blank workbook template.
This displays a workbook with a blank worksheet, as shown in Figure 1. The elements of a blank Excel worksheet are described in Table 1. Opening a Blank Workbook A file created in Excel is referred to as a workbook. Notice the tab named Sheet1, at the bottom of the Excel window. The area containing the gridlines in the Excel window is called the worksheet area.
Figure 1. Create a worksheet in the worksheet area that will be saved as part of a workbook. Columns in a worksheet are labeled with letters of the alphabet and rows are labeled with numbers. The intersection of a column and a row creates a box, which is referred to as a cell. A cell is where data and formulas are entered. When a cell is clicked, it becomes active and a thick green border appears around it.
The cell address, also called the cell reference, appears in the Name box. The cell reference includes the column letter and row number. For example, if the first cell of the worksheet is active, the cell reference A1 is shown in the Name box. Any number of adjacent cells can be made active and form a range.
A range is typically identified by the first cell reference and last cell reference separated by a colon. To enter data in a cell, make the cell active and then type the data. To make the next cell active, press the Tab key. Table 1. Another method for making a cell active is to use the Go To feature. Before typing data into the active cell, check the Status bar. The word Ready should display at the left.
As data is typed in a cell, the word Ready changes to Enter. Data typed in a cell is shown in the cell and in the Formula bar. If the data entered in a cell is longer than the cell can accommodate, the data overlaps the next cell to the right.
It does not become a part of the next cell—it simply overlaps it. How to change column widths to accommodate data is explained later in this chapter. If, however, a number is entered in a cell and the number is too long to fit in the cell, Excel changes the display of the number to number symbols.
This change is made because Excel does not want to mislead users by showing only part of a number in a cell. Along with the keyboard, the mouse can be used to make a specific cell active.
To make a specific cell active with the mouse, position the mouse pointer, which appears as a white plus symbol called the cell pointer , in the cell and then click the left mouse button. The pointer appears as a white plus sign when positioned in a cell in the worksheet and as an arrow when positioned on other elements of the Excel window, such as options and buttons on tabs and scroll bars.
Scrolling shifts the display of cells in the worksheet area but does not change the active cell. Scroll through a worksheet until the desired cell is visible and then click in the cell to make it active. Click Save button on Quick Access Toolbar. At Save As backstage area, click Browse option. At Save As dialog box, navigate to folder. Type workbook name.
Press Enter key. Saving a Workbook Save an Excel workbook, including all sheets within it, by clicking the Save button on the Quick Access Toolbar or by clicking the File tab and then clicking the Save As option at the backstage area. At the Save As dialog box, click the desired location in the Navigation pane, type a name for the workbook in the File name text box, and then press the Enter key or click the Save button.
Bypass the Save As backstage area and go directly to the Save As dialog box by using the keyboard shortcut F A workbook file name can contain up to characters, including the drive letter and any folder names, and it can include spaces. Each file should have a distinct name. Excel will not allow two workbooks to be saved with the same file name in the same folder, even if one is in uppercase and one is lowercase.
If the sales amount is not greater than the quota amount, then the salesperson will not receive a bonus. In this formula, the condition, or logical test, is whether the number in cell C4 is greater than the number in cell B4. If the condition is true and the number is greater, then the number in cell C4 is multiplied by 0. If the condition is false and the number in cell C4 is less than the number in cell B4, then nothing happens no bonus. Notice how commas are used to separate the logical test from the action.
If the quota has not been met, the formula will insert a 0. Write the formula by completing the following steps: a. Make cell D4 active. Make cell D4 active and then use the fill handle to copy the formula to the range D5:D9. Print the worksheet. Copy the formula in cell D4 to the range D5:D9. Save 7-CMPReports. To use the Function Arguments dialog box to write a formula with the IF function, click the Formulas tab, click the Logical button in the Function Library group, and then click IF at the drop-down list.
This displays the Function Arguments dialog box, shown in Figure 7. The Function Arguments dialog box displays the information you will type in the three argument text boxes for Activity 5b. In this text box, type the cell designation followed by what is evaluated. Insert the action that will occur if the logical test is true.
Insert the action that will occur if the logical test is false. Make cell C14 active. Click the Formulas tab. Click the Logical button in the Function Library group.
Click IF at the drop-down list. Click OK to close the Function Arguments dialog box. Copy the formula in cell C14 to the range CC Apply the Accounting format with a dollar symbol and two digits after the decimal point to cell C For example, in Step 2 of Activity 5c, you will write a formula with an IF function that looks like this when written out: If the new employee averages more than 79 on the quizzes, then he or she passes.
If the new employee does not average more than 79 on the quizzes, then he or she fails. In Activity 5c, you will write the formula so the word PASS is inserted in a cell if the average of the new employee quizzes is greater than 79 and the word FAIL is inserted if the condition is not met.
The Function Arguments dialog box can be used to write a formula with an IF function that contains text. With 7-CMPReports open, insert quiz averages by completing the following steps: a.
Make cell E31 active and then insert a formula that calculates the average of the test scores in the range BD Copy the formula in cell E31 to the range EE Make cell F31 active. Copy the formula in cell F31 to the range FF Make cell D14 active. Click the Logical button in the 3e 3f Function Library group. Copy the formula in cell D14 to the range DD Save and then print 7-CMPReports. Print the worksheet again. The worksheet will print on two pages. Save and then close 7-CMPReports. To create a chart, select the cells, click the Insert tab, and then click a specific chart button in the Charts group.
Click the Recommended Charts button in the Charts group and Excel will recommend a type of chart for the data. A chart is inserted in the same worksheet as the selected cells by default. Change the size of a chart using the mouse by dragging one of the sizing handles that display around the border of the chart.
When changing the chart size, maintain the proportions of the chart by pressing and holding down the Shift key while dragging a sizing handle. Move a chart by positioning the mouse pointer on the chart border until the pointer displays with a four-headed arrow attached and then dragging with the mouse. The cells selected to create a chart are linked to the chart. Changes made to the data are reflected in the chart.
Three buttons appear outside the right border of a selected chart. Use the Chart Elements button to insert or remove chart elements, use the Chart Styles button to apply chart styles, and use the Chart Filters button to isolate specific data in the chart.
Print a chart by selecting it, displaying the Print backstage area, and then clicking the Print button. Use buttons and options on this tab to add chart elements, change the chart type, specify a different layout or style for the chart, and change the location of the chart.
Create a chart and it is inserted in the currently open worksheet. The chart can be moved to a new worksheet in the workbook with the New sheet option at the Move Chart dialog box.
Move a chart element by selecting it and then dragging it with the mouse. Use the sizing handles around a chart element to change its size. Delete a chart element by selecting it and then pressing the Delete key or by right-clicking the element and then clicking Delete at the shortcut menu. Customize the formatting of a chart and chart elements with options on the Chart Tools Format tab. Use these options to identify specific elements in the chart for formatting, insert a shape, apply formatting to a shape, apply WordArt formatting to data in a chart, insert alt text, and arrange, align, and size a chart.
Insert a shape by clicking it in the Insert Shapes group on the Chart Tools Format tab and then clicking or dragging in the chart. Create alternate text for an object such as a chart and the text is read by a screen reader, helping people with a visual impairment understand what objects are included in the worksheet. Excel provides additional formatting options at a formatting task pane.
A formatting task pane displays at the right side of the screen; the name and the contents in the task pane vary depending on whether the entire chart or an element in the chart is selected.
Display a task pane by clicking the chart or element in the chart and then clicking the Format Selection button in the Current Selection group on the Chart Tools Format tab.
To delete a chart in a worksheet, click the chart to select it and then press the Delete key. To delete a chart created in a separate sheet, position the mouse pointer on the chart sheet tab, click the right mouse button, and then click Delete. A logical test is a question that can be answered with true or false.
Use the IF function to create a logical test that performs one action if the answer is true condition met or another action if the answer is false condition not met. Some of the methods for adding visual appeal that you will learn in this chapter include inserting and modifying images, screenshots, shapes, text boxes, icons, 3D models, SmartArt, and WordArt. You will also insert an arrow shape, type and format text in the shape, and then copy the shape. Click in cell. Click Insert tab.
Click Symbol button. Double-click symbol. Insert Special Character 1. Click Special Characters tab. Double-click special character. Hint Increase or decrease the size of the Symbol dialog box by positioning the mouse pointer on the lower right corner until the pointer displays as a two-headed arrow and then dragging with the mouse.
Click the button and the Symbol dialog box displays, as shown in Figure 8. At the dialog box, double-click a symbol to insert it, click the symbol and then click the Insert button, or type the code in the Character code text box.
Click the Close button to exit the dialog box. At the Symbol dialog box with the Symbols tab selected, additional symbols are available with different fonts. Change the font by clicking the Font option box arrow and then clicking a font at the drop-down list.
Click the Special Characters tab at the Symbol dialog box and a list of special characters displays. Insert a special character by double-clicking a character and then clicking the Close button or by clicking the character, clicking the Insert button, and then clicking the Close button. Figure 8. Use the Font option box to select a font with a set of characters. This section of the dialog box displays the most recently used symbols.
The Character code text box displays the code that can be entered at the keyboard to insert the symbol. Insert a symbol by completing the following steps: a. Double-click in cell A2.
Delete the e at the end of Qualite. With the insertion point positioned immediately right of the t in Qualit, click the Insert tab. Click the Symbol button in the Symbols group. You can also type 00E9 in the Character code text box to select the symbol. Click the Insert button and then click the Close button. Insert a special character by completing the following steps: 2e a. With cell A2 selected and in Edit mode, move the insertion point so it is positioned immediately right of Group.
At the Symbol dialog box, click the Special Characters tab. Click the Close button. At the Symbol dialog box, click the Font option box arrow and then click Wingdings at the drop-down list. You will need to scroll down the list to see this option. Click the symbol located in approximately the fifth or sixth row.
You can also type in the Character code text box to select the symbol. Click in cell A3. Click the Pictures button to display the Insert Picture dialog box with options for inserting an image from a folder on the computer or a removable drive. Or click the Online Pictures button and search for images online. When an image is inserted in a worksheet, the Picture Tools Format tab appears, as shown in Figure 8.
Customizing and Formatting an Image Use buttons in the Adjust group on the Picture Tools Format tab to remove unwanted parts of an image, correct the image brightness and contrast, change the image color, apply artistic effects to the image, change to a different image, and Compress restore the original image formatting.
Use the Compress Pictures button in the Pictures Adjust group to compress the size of an image file and reduce the amount of space the image requires on the storage medium. Use buttons in the Picture Styles group uick Steps to apply a predesigned style to the image, change the image border, or apply other Insert Image effects to the image.
Use the Alt Text button in the Accessibility group to add 1. With options in the Arrange group, position the 2. Click Pictures button. Navigate to folder.
Double-click image. Use the Crop button in the Size group to remove any unwanted parts of the image and use the Shape Height and Shape Width measurement boxes to specify the image size. Modifying Images In addition to options at the Picture Tools Format tab, options at the shortcut menu can be used to format an image.
Display this menu by right-clicking the image. Use options at the shortcut menu to change the image, choose text wrapping around the image, insert alt text, size and position the image, and display the Format Picture task pane. To change size with a sizing handle, position the mouse pointer on a sizing handle until the pointer turns into a double-headed arrow and then drag in or out to decrease or increase the size of the image.
Use the middle sizing handles at the left and right sides of the image to make the image wider or thinner. Use the middle sizing handles at the top and bottom of the image to make the image taller or shorter. Use the sizing handles at the corners of the image to change both the width and height at the same time. Press and hold down the Shift key while dragging a sizing handle to maintain the proportions of the image. Move an image by positioning the mouse pointer on the image border until the pointer displays with a four-headed arrow attached and then dragging the image to the new location.
Rotate the image by positioning the mouse pointer on the white round rotation handle until the pointer displays as a circular arrow. Click and hold down the left mouse button, drag in the desired direction, and then release the mouse button. Click the Insert tab and then click the Pictures button in the Illustrations group. Change the size of the image by clicking in the Shape Height measurement box in the Size group on the Picture Tools Format tab, typing 1.
Remove the yellow background from the image by completing the following steps: a. Click the Remove Background button in the Adjust group.
Paradigm Education Solutions. Publication date. January 1, See all details. Next page. What other items do customers buy after viewing this item? Page 1 of 1 Start over Page 1 of 1. Marquee Office Brief Text. Nita Rutkosky. Marquee Series: Microsoft Office Text. Flash Fill If Excel recognizes a pattern in cell entries in one column based on the cells in other columns, it can fill in the remaining cell entries following that pattern.
Flash Fill In addition to being an AutoFill option, the Flash Fill feature can automatically recognize patterns Flash Fill across rows as you enter data, and then copy those patterns down a column of entries. The key difference between this and the AutoFill feature is that it depends on a recognizable pattern based on the entries in cells in other columns. Essentially, you can use this feature to combine entries, or parts of entries, from cells in the same row to another cell in that row, and then copy that combined data down a column.
Let’s look at a simple example to illustrate the point. Suppose you have a worksheet that lists employee names. The last names are in column A and the first names are in column B. But you also need a column for each employee’s email address. These email addresses always follow the same pattern: firstname. So, in the first row in column C, you manually type the first employee’s first name followed by a period, then the employee’s last name, then develetech.
Excel can recognize that this data is based on the entries in the first two columns, and then it can copy all of the names down column C, following the pattern, for each of the employees. You have to begin entering subsequent entries by following the same pattern before it can do so. Flash Fill can end up saving you an incredible amount of time. It works only down columns.
Note: The Flash Fill feature will work only if there are no empty columns between the original data and the column you’re trying to fill following a pattern. There can, however, be columns of data that don’t relate to the pattern in between the cells containing the original data and the cells you are trying to fill.
Figure The Flash Fill feature recognizes that cell C3 is following the pattern of C2 using data from its adjacent cells. It can then fill in the pattern for the rest of the cells in column C. The Clear Command Because you need to enter data into worksheet cells, it stands to reason that you will also need to delete cell data from time to time.
The most basic method of doing this is to select the cell that contains the data you wish to remove and then press the Delete key. Excel also provides an alternative with the Clear command, which gives you access to a number of options for removing cell content that don’t always include removing everything from the cell.
The Clear command is available in the Editing group on the Home tab. The following table describes each of the Clear command options. Clear Formats Only formatting applied to the selected cell s. The content is left in place, including any existing comments. Clear Contents Only the contents of the selected cell s , but not the formatting. Clear Comments Only comments from the selected cell s. Clear Hyperlinks Hyperlinks from cell contents.
The formatting is left in place, including formatting applied to the text when the hyperlink was created. Scenario Your colleague has emailed you a text file with some additional new products that Develetech will be adding to its catalog. In order to keep track of the new product lines all in one place, you decide to add the new items to the My New Products.
In addition to tracking the cost and quantity of your new products, you also want to list each product’s unique number and product code as identifiers. These will be used both internally and on the public-facing online store to assist with inventory. These identifiers follow certain patterns, so rather than wasting time entering them manually for each product, you’ll let Excel do the work for you.
Open the My New Products. Ensure that students are b From the Open screen, ensure that Recent is selected and, in the Today list, select My New opening the version of Products. Open the Future Products.
While c Double-click the Future Products. Copy and paste the new product names into the My New Products. If students ask about the Paste Options menu that appears after pasting the content, let them know that it will be covered later in the course. It will have no effect on the current activity.
Use the AutoFill feature to add unique product numbers for each new product entry. Note: You can also drag the fill handle manually, but double-clicking is a faster way of populating every cell down a column that has adjacent row data. Use Flash Fill to quickly generate a product code based on the product name and number. Code and then press Enter. If students notice that the Prod. Code column label spills over onto the next cell, assure them that they will learn how to modify the appearance of cells in a later lesson.
Save and close the My New Products. Excel comes packaged with its own Help system that can assist you in finding answers to your questions. Taking the time to learn how to use Excel Help now could save you countless hours of research down the road. Microsoft Excel Help Microsoft Excel Help provides you with access to articles that can answer your Excel questions and show you how to perform various tasks within the application.
Excel Help checks Microsoft Office’s support website for these articles, which can include text, screenshots, and video. In order to access Help articles, you must have an active Internet connection. You can also reach Help on specific topics by searching for the topic in Tell Me.
You can use The Excel Help the Excel Help window to search for, browse through, and review the various web articles Window available to you.
Figure The Excel Help window. The Excel Help window is divided into a number of sections and displays a variety of commands to help you locate the desired Help resources.
The following table describes each of these in some detail. Search field Enter search terms for locating Help resources. Search button Execute Help searches. Content section Display the results of a search or the contents of an online Help article. This activity requires an Scenario Internet connection. As you’ve been working with Excel more and more, you have come across some features that you have some questions about.
You have heard there is a particular command that you might have use for, but you want to learn more about what it does first. You decide to use the Excel Help system to find out more about the application. Time permitting, allow students to run their own 1. Open Excel Help.
Search for Excel Help resources online. It’s not important that c Review the content. The d On the Excel Help toolbar, select the Home button. Close the Excel Help window. Excel Help to find information. You navigated the Excel user interface, used Excel commands, created and saved a basic workbook, entered cell data, and used the Excel Help system.
As you build upon these foundational skills, you will begin to unlock Excel’s robust functionality and discover the power that lies within your organizational data. Encourage students to use the social Do you think you’ll prefer to use the mouse or the keyboard navigation options as you develop your networking tools workbooks? Some students may be uncomfortable at first with the ribbon and Backstage view, continued learning.
They might find that it’ll take some getting used to. Still, others may see the value in the ribbon system, especially from a visual point of view. Students may see the Tell Me feature as a good equalizer when they’re unable to find what they’re looking for with the ribbon.
From the Course screen you can also access available resources for a more continuous learning experience. Excel contains an incredible array of functionality to help you do this, particularly when it comes to working with numerical data.
In order to take full advantage of Excel’s abilities to quickly, efficiently, and accurately calculate data, you must first understand how Excel thinks, and how to tell it what to do. In this lesson, you’ll do just that. Every time a single value changes, you might have to change entire rows or columns of data.
Keeping up with such calculations manually is not only impractical and tedious, but it is also unnecessary and, in some cases, nearly impossible. Why not have Excel do it for you? Performing calculations is one of the most critical, foundational tasks in Excel, forming the basis for nearly all of the data analysis you’ll need to perform. By gaining a solid, clear understanding of how Excel performs such calculations, you’ll save yourself valuable time, avoid a ton of headaches, and ensure a level of accuracy not possible when performing the same calculations on your own.
Excel Formulas Excel Formulas Excel formulas perform simple or complex mathematical computations in worksheets. You can use formulas to perform tasks such as adding up a row or a column of numbers, multiplying sales figures by commission rates, and applying tax to sales. One of the key benefits of using formulas in Excel is that you can change some of the values used in the formulas and, by default, Excel will automatically adjust the calculations accordingly.
It is important to remember that, in Excel, what you see isn’t necessarily what you get. When you enter a formula into a worksheet cell, by default, Excel will display the result of calculating the formula in the cell, and not the formula itself. Excel can perform calculations by using fixed numbers, or by referring to values in other cells.
This is one of the truly powerful features of using Excel to perform calculations. Excel provides you with an incredible array of options for performing calculations in your workbooks and worksheets. Figure A formula in a worksheet cell. As you’ve seen, the Formula Bar allows you to edit cell contents and select, navigate to, and view the contents of selected cells.
It’s also useful for quickly inserting pre-existing formulas. Additionally, to the left of the Formula Bar text box are buttons that provide supplementary options. The following table describes the Formula Bar options in greater detail.
Selecting the Cancel button will undo any changes you have made to a cell since selecting it and will keep that cell active. Basically, it reverts the cell back to its state before you began editing it. When you select the Enter button, Excel enters whatever content is in the active cell and keeps the cell active.
Insert Function button The Insert Function button opens the Insert Function dialog box, providing you with access to a wide variety of pre-existing Excel formulas. Elements of Excel Formulas The first rule of using formulas in Excel is that all formulas begin with an equal sign. This may seem A Basic Mathematical a bit counter-intuitive at first, as you are used to seeing figures on both sides of a formula when it’s Formula written out.
But Excel displays formula results in cells, which takes care of the result side of the equal sign. You enter the expression side of a formula after the equal sign. To understand this better, let’s first look at a simple mathematical formula. Formulas basically consist of an expression on one side of the equal sign and a result on the other.
Expressions consist of a series of constants, variables, and mathematical operators. Operators indicate where to perform such basic computations as adding, subtracting, multiplying, dividing, calculating exponents, and so on.
Here are the basic elements of a mathematical formula as written on paper. Elements of Excel Excel formulas work pretty much the same way. When you enter a formula in a worksheet cell, the Formulas cell displays the result. The equal sign and the mathematical expression make up the content that’s This is an excellent actually entered in the cell. In Excel formulas, you can think of constants as numbers you manually opportunity to enter into formulas, and variables as references to other cells.
When you manually type a number demonstrate how into an Excel formula, that number remains the same unless you manually edit it; this is referred to constants and as “hard coding” the value in the formula. When you enter a cell reference in an Excel formula, the references work in Excel result of the calculation will change if you change the value in the referenced cell. Change the value in A2 to demonstrate the result changing automatically.
Figure An Excel formula. Basic Excel formulas consist of the following elements: the equal sign, constants, references, and mathematical operators.
The equal sign tells Excel to perform a calculation based on the formula components and then to display the result of the calculation in the cell. All formulas in Excel must start with an equal sign. Constants Numbers and text that do not change unless manually altered. References Essentially, the variables in Excel formulas.
When you include a reference to a cell or a range, Excel uses the value s from that cell or range to perform the calculation. Mathematical operators Symbols that specify the kind of calculation that Excel should perform on the elements of a formula. These are simply symbols Excel uses to identify the calculations it should perform. This is how Excel determines The Order of Operations which operation to perform first, second, third, and so on in a complex formula.
It is important that Consider mentioning the you understand how Excel will compute a formula before you create one to ensure that Excel will mnemonic device perform the calculation exactly as you want it to. Note: While often used for subtraction, the minus sign — can also be used to denote a negative value. In these cases, the minus sign takes greater precedence than exponents, allowing you to calculate the exponential value of a negative number.
Figure Excel performs mathematical computations in a specific order. In fact, there are four different kinds of operators you can use to perform calculations. Reference operators are one of the most important. Reference operators tell Excel which cell or range values to use as variables in your formulas. There are three reference operators: the comma, the colon, and the space. Other than the reason provided, using Reference Symbol Function intersection operators is Operator a good practice in avoiding direct cell Comma , The comma is used as a union operator, which tells Excel to references.
This will include each reference in a series of references. This is similar become more apparent to how you would use a comma when writing a serial list; you when students learn are telling Excel to include each of the references. Colon : The colon is used as a range operator, which you’ve already seen when selecting a range of cells. The colon tells Excel to include all cells in a range between the cell references on either side of the colon. This tells Excel to look for a value in the cell where two ranges intersect.
For example, A9:J9 E2:E22 tells Excel to look for the value in the cell where these two ranges intersect, which in this case would be the value in cell E9. If you have a spreadsheet of salespeople as the rows and their quarterly sales as the columns, you can use an intersection to find how well Salesperson X did in Q3.
While you might be able to find this information by simply looking at the spreadsheet, this can become a hassle in larger spreadsheets that require scrolling through multiple pages.
Note: Excel reads a blank space only as an intersection operator if no other operator is present between cell or range references. If you enter another reference operator between the cell or range references, Excel will read the operator and ignore the spaces. Here, the spaces don’t matter because of the commas. Excel will not look for the intersection, which in this case makes sense as the cells don’t actually intersect.
Scenario Develetech plans to introduce five new products. Company management wants you to analyze the projected sales figures to determine how much the company can plan to profit from the new items. You have entered the sales estimates into an Excel worksheet. Now, you must use Excel formulas to get Excel to perform the calculations for you.
Open the New Product Income. Calculate the sales before tax based on the sales estimates for each product. Ask students to explain Note: Although Excel displays cell and range references, and many other what this formula will elements of formulas and functions, in all capital letters, it is not necessary to calculate. Consider type them in all capital letters. Excel’s functionality enables it to determine doing this for all what is a formula or function and what is standard text based on the context of formulas in the activity.
Excel will automatically display formulas and functions in all capital letters, even if you type them as lowercase letters. Calculate sales with tax. Subtract expenses from sales before tax to calculate the estimated profit on the new product sales. Save the file as My New Product Income. Excel provides you with the ability to do this quickly and easily through a massive set of built-in formulas. Excel includes functionality to help you fill in and interpret these formulas, enabling you to focus more on the information you need to extract from your data and less on the mathematical operations themselves.
Taking the time to learn how to use this functionality now will save you time, effort, and possibly a few headaches down the road.
Functions In Excel, functions are simply built-in, predefined formulas that you can quickly and easily insert into Functions worksheet cells. Like formulas, all functions begin with an equal sign. Unlike formulas, in functions The concepts in this the equal sign is followed by the function name and then a set of arguments in parentheses, which are topic are covered in a lot separated by commas. Arguments can be cell references, constants, formulas, or even other of detail.
Consider using functions or logical values. Functions use their arguments in specific ways to calculate a result. The the activities to cover function name is typically the name, or an abbreviated version, of the actual mathematical function.
Remind would use the EXP function to calculate an exponential expression. Each function has its own students they can use specific structure and order of arguments. You can manually type functions into worksheet cells or the book as a reference you can enter them by using various commands and dialog boxes.
Figure The SUM function with a single argument. The Function Library Group Excel provides you with a central location for accessing all of its available functions: the The Function Library Function Library group. The Function Library group contains a set of menus that organize Excel Group functions according to specific categories for ease of reference. You can access the Function Library group on the Formulas tab.
The following table provides a brief description of the function categories in the Function Library group. When you first install possible function. Excel, you can access a set of commonly used functions from this Database functions must menu. Logical Functions that determine if an argument is true or false, or if it meets other logical conditions.