Note that the button will be highlighted in orange before you click it, then will not be highlighted after you click it. Step 3: Click the Split button to remove the split screen. Step 2: Click the View tab at the top of the window. Step 1: Open the Excel spreadsheet that you want to modify. So continue reading below to learn how to remove this split screen on your Excel 2010 spreadsheet.
The split screen that I am referring to in this article looks like the image below –Īs you can see, there is a horizontal bar that separates the rows that I have locked in the window, while the remainder of the rows scroll normally below the split. Fortunately it is a simple process to disable the split and view the spreadsheet as you normally would. While this can be beneficial in certain situations, it can be annoying if you aren’t used to it. But there is another option that splits the screen, keeping a set group of rows at the top of the window as you scroll to the bottom. You can return to normal view if that is the view you prefer, which is just one way to begin restoring a heavily edited spreadsheet to the default view settings. For example, there are several different worksheet views that can be used, some of which are more helpful in certain situations than others. Once we use Goal Seek, cell B6 will show us the minimum grade we'll need to make on the final assignment.There are a lot of ways to customize the appearance of a worksheet in Excel 2010, and many of them are more useful to some people than others. In this case, each assignment is weighted equally, so all we have to do is average all five grades by typing =AVERAGE(B2:B6). Even though we don't know what the fifth grade will be, we can go ahead and write a formula or function that calculates the final grade. In the image below, you can see that the grades on the first four assignments are 58, 70, 72, and 60. You can use Goal Seek to find out what grade you need on the final assignment to pass the class.
Luckily, you have one final assignment that might be able to raise your average.
You currently have a grade of 65, and you need at least a 70 to pass the class. We'll use a few examples to show how to use Goal Seek. Goal Seek works in the opposite way: It lets you start with the desired result, and it calculates the input value that will give you that result. When you create a formula or function in Excel, you put various parts together to calculate a result. Optional: You can download this example for extra practice.
0 kommentar(er)
