A blank workbook opens with A1 as the active cell. IG you have just launched Excel, Book1 – Excel appears in the Excel gives you options Gor starting a blank workbook, takingĪ tour, or using templates (see Figure 2-2). STEP BY STEP Create a Workbook from Scratch In this exercise, you create two Excel workbooks: one with a company address and one with a quick phone message. Worksheets oGten include text that describes the content oG the work- sheet. IG you are working in Excel and want to begin a new workbook, click the File tab, click New, and then click Blank workbook. Creating a Workbook from Scratch 5o create a new workbook, launch Excel and select a blank workbook or another type oG template. A template is a model that has already been set up to display certain kinds oG data, such as sales reports, invoices, and so on. You can also use a template to create a new workbook. You can open an existing Excel workbook, enter new or additional data, and save the õle with a new name, thus creating a new workbook. You can open a new, blank work- book when you launch Excel or by using the File tab to access Backstage view. Working with Microsoft Excel 2016 13 CREATING WORKBOOKS Tere are three ways to create a new MicrosoGt Excel workbook. In Figure 2-1, the Clipboard, Font, Alignment, and Number groups have associated dialog boxes or task panes, whereas Styles, Cells, and Editing do not. Clicking these displays additional commands not shown on the ribbon. Similarly, some oG the groups have Dialog Box Launchers associated with them. Tis indicates that in addition to the deGault task, other options are available Gor the task. In Figure 2-1, you see the button arrows associated with AutoSum and Find & Select. Each tab contains groups oG commands related to speciõc tasks or Gunctions.Ĭommand Dialog Box launchers Command groups Command button arrowsĬommand options Some commands have an arrow associated with them. Having commands visible on the work surGace enables you to see at a glance most tasks you want to perGorm. Te Home tab, shown in Figure 2-1, contains the com- mands that people use the most when creating Excel documents. SOFTWARE ORIENTATION Excel’s Home Tab Te ribbon in MicrosoGt O÷ce Excel 2016 is made up oG a series oG tabs, each related to speciõc kinds oG tasks that you perGorm in Excel. Editing a Workbook’s Properties ModiGy document properties. Cutting, Copying, and Pasting Data Cut, copy, or paste data. Using Data Types to Populate a Worksheet Apply number Gormats. Entering and Editing Basic Data in a Worksheet Replace data. Inspect a workbook Gor compatibility issues. Saving Workbooks Save workbooks in alternative fle Gormats. Activity 1 Solving the Earth’s Puzzle ELS Module 12ġ2 Working with Microsoft Excel 2016 2 12 LESSON SKILL MATRIX Skills Exam Objective Objective Number Creating Workbooks Create a workbook.cblm-participate-in-workplace-communication English-for-academic-and-professional-purposes-quarter-2-module-2 compress.History OF Medical Technology IN Global Context.ABM FABM2 Module 1 Lesson 1 SFP Elements.Different literary periods during the colonialism in the Philippines that is useful for student.How did the society shape science and how did science shape the society.L1 Teaching and Assessment of Literature Studies.Accounting quiz (Introduction to accounting).Kalagayan o sitwasyon ng wikang Filipino sa mga kabataan sa kasalukuyang panahon.Contemporary Arts 12 Q1 Mod1 Contemporary Arts Forms ver3.Medical Technology Board Exam Compilation.A Guided Content Analysis of the Tejeros Convention.Psychological assessment CH9 Intelligence and its Measurement.Grade 8 Math Module 1 - Mathematics Learning Material.Halimbawa ng Konseptong Papel (Pagbasa at Pagsusuri).Bachelor in Secondary Education (ESP001).Financial Accounting And Reporting (AC108).Entrepreneurship In Tourism And Hospitality (THC1109).Disaster Readiness & Risk Reduction (DRRR 01).Reading in Philippine History (NGEC0113).Komunikasyon sa Akademikong Filipino (Fil 1 ).Readings in Philippine History (PCSH112).Understanding Culture, Society and Politics.Professional Conduct and ethical Standard (Crim 4).Understanding culture, society and politics (UCSN11S).Bachelor of Science in Computer Science (BSCS).Science, Technology and Society (STS01).Bachelor in elementary education (Idunno).
0 Comments
Leave a Reply. |