Summarize the following:
Excel can filter the data in all selected cells within a range, as long as there are no completely blank rows or columns within the selected range. Once a blank row or column is encountered, filtering stops. If the data in the range you wish to filter is separated by blank rows or columns, remove them before proceeding with the AutoFilter. Conversely, if there is data on the worksheet that you do not want to be part of the filtered data, separate that data using one or more blank rows or blank columns. If the data you don't want to filter is located beneath the data to be filtered, use at least one completely blank row to end filtering. If the data you don't want to filter is located to the right of data to be filtered, use a completely blank column. It is also good practice to have column headings within the range of data being filtered. Drop-down arrows will appear at the top of each column range. If the range of cells contains column headings, the drop-down arrows will appear in the headings. Do one of the following: To filter the data by criteria, click to clear the "(Select All)" check box. All other check boxes will be cleared. Click to select the check boxes of the criteria that you want to appear in the filtered list. Click "OK" to filter the range by the selected criteria. To set up a number filter, click "Number Filters" and then click the desired comparison operator from the list that appears. The "Custom AutoFilter" dialog box appears. In the box to the right of the comparison operator selection, either select the desired number from the drop-down list box or type the desired value. To set up the number filter by more than one comparison operator, click either the "And" radio button to indicate that both criteria must be true, or click the "Or" radio button to indicate that at least 1 criterion must be true. Select the second comparison operator, and then select or type the desired value in the box to the right. Click "OK" to apply the number filter to the range. To filter the data by color-coded criteria, click "Filter by Color." Click the desired color from the "Filter by Font Color" list that appears. The data is filtered by the selected font color.

summary: Open the spreadsheet in which you want to filter data. Prepare your data for an Excel 2007 AutoFilter. Click any cell within the range that you would like to filter. Click the "Data" tab of the Microsoft Excel ribbon. Click "Filter" from the "Sort & Filter" group. Click the drop-down arrow of the column containing the desired criteria to be filtered.

Summarize the following:
The formula for calculating percentage error is simple: [(|Approximate Value - Exact Value|) / Exact Value] x 100. You will use this as a reference to plug in the two values you need to know. The approximate value is your estimated value, and the exact value is the real value. For example, if you guess that there will be 9 oranges in a bag, but there are actually 10, 9 is the approximate value, and 10 is your exact value. In the example of oranges, you will subtract 10 (the exact value) from 9 (the estimated value). In this case, the result is 9 - 10 = -1. This difference is considered the magnitude of difference in approximate and estimated values. This begins to tell you how far off the results were from what they were expected to be. Since the formula uses the absolute value of the difference, you can discard a negative sign. In this example, -1 will become just 1. In the oranges example, 9 - 10 = -1. The absolute value of -1, written as |-1|, is 1. If your result is positive, leave the number as it is. For example, 12 apples (approximate) - 10 apples (exact) = 2. The absolute value of 2 (|2|) is just 2. In statistics, taking the absolute value simply means you don't care which direction your guess was off (either too highpositiveor too lownegative). You just want to know how far off the estimate was from the exact value. Either with a calculator or by hand, divide the top number by the absolute value of your exact variable. In this example, the exact value is already positive, so you just need to divide 1 (from the previous step) by 10 (the exact number of oranges). For this example, 1/|10| = 1/10. In some cases, the exact value might be a negative number to begin with. If this is the case, you want to ignore the negative (i.e. take the absolute value of the exact number).

summary: Write down the formula for percentage error. Subtract the exact value from the approximate one. Find the absolute value of the top result. Divide that result by the absolute exact value.

Summarize the following:
If fiber is affecting your health or making you uncomfortable, it may be ideal to consume less fiber than what's recommended for an average, healthy person. The total fiber intake recommended for women is: 25 g daily. The total fiber intake recommended for men is: 38 g daily. Keep track of how much fiber you eat throughout the day. You may find it easy to use a food journaling app to help you accurately calculate fiber each day. Fiber is found in a wide range of foods including grains, fruits, vegetables and legumes. Limiting the fiber in each meal or snack can help cut down on your overall consumption and may alleviate GI symptoms. Choose lower fiber fruits or remove fibrous parts of fruits. For example: eat applesauce instead of an apple, because the skin of the apple contains a large amount of fiber, or drink six ounces of 100% juice daily. Fruits that are lower in fiber include: canned fruit, cooked fruit, and fruit without the skin or peel. Choose lower fiber vegetables or remove fibrous parts. For example: take the skin off your potato or remove the seeds from your zucchini. Vegetables that are lower in fiber include: canned vegetables, well-cooked and very soft vegetables, vegetables without seeds, and 100% vegetable juice. Choose lower fiber grains. For example: avoid 100% whole grain foods since these are higher in fiber. Choose lower fiber grains like: white rice, white bread, cream of wheat or cream of rice, or plain pasta. There are two types of fiber soluble and insoluble. Insoluble fiber is sometimes called "roughage," as it's main function is speed the process of digestion. Insoluble fiber may stimulate bowls more than desired causing diarrhea in those who are susceptible or have a chronic health condition. Insoluble fiber is found in the following foods: whole grains, vegetables and wheat bran. Soluble fiber absorbs water, makes stools easier to pass and may slow digestion slightly. This type of fiber is more gentle and may be more appropriate for some people. Although insoluble fiber may have negative side effects for some, in general, it's a healthy addition to your diet and can help prevent constipation. Many food companies now add fiber into different foods to help increase fiber intake. Fiber may be added to foods that typically have little to no fiber and should be avoided by those minimizing fiber in their diets. Examples of foods to limit include: Orange juice with pulp and added fiber. Artificial sweeteners with added fiber. Yogurts with added fiber. Soy milk with added fiber. Granola bars or bread that have additional added fiber (these may be lower in fiber prior to processing additional added fiber). There are a variety of fiber supplements that are available to help people increase their fiber intake. However, these should be discontinued immediately if fiber is posing a problem for you or your health. Discontinue the use of any stool softeners or laxatives that contain added fiber. Do not take oral gummies or fiber capsules. Do not add extra powdered fiber or psyllium husk to foods or beverages. Writing up a meal plan can help you plan out all the meals and snacks you eat in a day and provide a framework for you to follow throughout the week. Calculate how much fiber is in each meal or snack and what your total daily intake will be. A meal plan will allow you to change things up, make substitutions or swaps so that you don't go over your target fiber goal each day. Take some of your free time to plan your meals and snacks for one week. Include all meals and snacks you typically eat everyday. Repeat this exercise every week or as needed.
summary: Consume less than the recommended amounts of fiber daily. Minimize fiber in meals and snacks. Limit insoluble fiber. Minimize fiber-fortified foods. Discontinue fiber supplements. Write up a meal plan.