Pengenalan Microsoft Excel 2010
Pengenalan Excel 2010 Abaciubi Video. Unsubscribe from Abaciubi Video? Pengenalan Tampilan MIcrosoft Excel - Duration: 15:29. Idris Mustafid 134,286 views. Pengenalan dan fungsi menu bar microsoft excel 2010 Microsoft Excel 2010 Hallo berjumpa lagi pada tutorial kali ini di osibaok semoga tutorial kali ini ada manfaatnya buat kita semua. Oke kali ini osibaok akan membahas tentang pengenalan dan fungsi-fungsi menu bara yang ada pada aplikasi ms. Microsoft Excel adalah aplikasi pengolahan angka yang merupakan salah satu bagian dalam Microsoft office. Microsoft Excel atau di singkat excel merupakan program aplikasi yang banyak digunakan untuk membantu menghitung, memproyeksikan, menganaisis, dan mempresentasikan data. Istilah –istilah di Microsoft excel: 1. Sel: Perpotongan antara baris dan kolom 2.
Excel Starter 2010Microsoft Excel Starter 2010 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items. Excel Starter is part of Microsoft Office Starter 2010, and comes pre-loaded on your computer.Excel Starter 2010 is very similar to Microsoft Excel 2010 in appearance.
If you are new to the Ribbon interface or the Backstage view, Excel Starter gives you an opportunity to get accustomed to the new interface before upgrading to Excel 2010.Excel Starter differs from the complete version of Excel in that it includes display advertising, and it does not support the advanced features of the complete version of Excel. If you find that you want more features, you can upgrade to Excel 2010 right from Excel Starter 2010. Just click Purchase on the Home tab on the ribbon. What do you want to do?Open Excel Starter and take a look aroundOpen Excel Starter with the Windows Start button.Click the Start button. If Excel Starter is not included among the list of programs you see, click All Programs, and then click Microsoft Office Starter.Click Microsoft Excel Starter 2010.The Excel Starter startup screen appears, and a blank spreadsheet is displayed.
In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them.1. Columns (labeled with letters) and rows (labeled with numbers) make up the cells of your worksheet.2. Clicking the File tab opens the Backstage view of your workbook, where you can open and save files, get information about the current workbook, and perform other tasks that do not have to do with the content of the workbook, such as printing it or sending a copy of it in e-mail.3. Each tab in the ribbon displays commands that are grouped by task.
You'll probably spend most of your time using the Home tab, when you're entering and formatting data. Use the Insert tab to add tables, charts, pictures, or other graphics to your worksheet. Use the Page Layout tab to adjust margins and layout, especially for printing. Use the Formulas tab to make calculations on the data in your worksheet.4.
The pane along the side of the Excel Starter window includes links to Help and shortcuts to templates and clip art, to give you a head-start on creating workbooks for specific tasks, such as managing a membership list or tracking expenses. The pane also displays advertising and a link to purchase a full-feature edition of Office.Create a new workbookWhen you create a workbook in Microsoft Excel Starter 2010, you can start from scratch or you can start from a template, where some of the work is already done for you.Click File, and then click New.If you want to start with the equivalent of a blank grid, click Blank workbook.If you want a head-start on a particular kind of workbook, choose one of the templates available on Office.com. Choose from budgets, event planners, membership lists, and more.Excel Starter opens the blank workbook or template, ready for you to add your data.Save a workbookWhen you interrupt your work or quit, you must save your worksheet, or you will lose your work.
Microsoft Excel Creating a Pie Chart on a PictureName Date 1. In order to create a pie chart on a picture, you need to first find the picture you want to use.
Click on the Internet Explorer icon.2. When the browser launches, type into the address bar. You are going to use a picture of a globe for this activity. When the screen loads, type “globe” into the search box.Then choose “Search Images.”4.
Choose the first picture of the globe. Right click on the globe and choose copy from the drop down menu.6. Open Microsoft Excel by clicking on your start menu on the bottom left of your screen. Choose “All Programs” from the menu.
Now choose the Microsoft Office folder and open Microsoft Office Excel 2007.8. Since you have already copied your picture of the globe, right click on any empty cell and choose paste.Congratulations! You have successfully copied your picture of the globe off of the internet and into Microsoft Excel! The next step is to create the pie chart. For your convenience, click on the picture of the globe and drag it over to the right hand side of your screen so that it is not in the way of the pie chart you will make.10.The pie chart you will create represents the number ofpeople in millions who speak certain languages throughout the world. Copy the following information into the corresponding cells: AB1LanguagePopulation in Millions2Chinese, Mandarin11203English4804Spanish3325Arabic2356Bengali1897Hindi1828Russian1809Portuguese17010Japanese12511German98Your spreadsheet should look like this:11.Highlight rows 2 through 11 for both columns.12.Choose the Insert tab at the top of the screen and choosePie.
From that drop down menu, choose the first option under 2-D Pie.Congratulations! You have just made a pie chart for the information you entered!13.Click on the pie chart and press CTRL + 1. This will bring upthe Format Data Series box. 14.From the menu on the left hand side, choose Fill. Select NoFill from the checklist on the right hand side. This will make the pie graph transparent.15.Choose the Border Color tab from the left hand side andchoose Solid Line. Change the color to Black.16.Choose the Border Styles tab from the left hand side andchange the width of the line to 2.25 pt.
Click close at the bottom of the box.17.Click on the white space outside of the pie chart. Use theCTRL + 1 feature again to change to No Fill. This will make the background transparent too.
18.Now you will make the labels appear by their pie sliceinstead of them all listed on the right hand side. To do this, click on the labels. Click on the Layout tab from the tool bar at the top of the page. Choose Legend, then None.19.Still in the Layout tab, choose Data Labels, then More DataLabel Options.20.Under the Label Options Tab on the left hand side, check theboxes for Category Name, Percentage, and Show Leader Lines. Click close at the bottom of the box.21.Take the picture of the globe that you pasted into thisspreadsheet and make it larger or smaller to fit inside of your piechart. Drag the picture of the globe into the pie chart and resize the picture so that the sections of the pie chart are dividing up the globe. 22.If the labels of the pie chart are on top of the picture andyou can’t read them, drag the label off of the picture.
It will make a line to that piece instead. You have just made your pie chart on a picture! 23.Now you have the completed graph and can answer thefollowing questions: a.
What percentage of people in the world speaks English?b. What percentage speaks Hindi?c. What percentage speaks Japanese?d. What language do most people speak?e. What language does the least amount of people speak?f. Draw your pie chart below:Try it yourself! Make a pie chart on a picture just like above.
Larry Bird was a famous basketball player. He played from 1979 to 1992 for the Boston Celtics. Use the following information to create a pie chart on a picture of a basketball.Season: 1979-1980 1980-1981 1981-1982 1982-1983 1983-1984 1984-1985 1985-1986 1986-1987 1987-1988 1988-1989 1989-1990 1990-1991 1991-1992# of Points Scored 1745 1741 1761 1867 1908 2295 2115 2076 2275 116 1820 1164 908When you are finished creating your pie chart, draw it below including the labels.Answer the following questions using your pie chart: a. In what season did Larry Bird score the most points?b.
Pengenalan Microsoft Excel 2003
Microsoft Excel Panduan
In what season did he score the least amount of points?c. What percent of his career points came from the 1983 season?d. What percent of his career points came from the 1980 season?Created by: Edith Franks.