New Perspectives on Microsoft Excel 2010: Comprehensive (Advanced Spreadsheet Applications)
Format: PDF / Kindle (mobi) / ePub
With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of MICROSOFT OFFICE EXCEL 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.
soft skills: decision making, problem solving, teamwork, verbal communication, and written communication. • Important steps are highlighted in yellow with attached margin notes to help students pay attention to completing the steps correctly and avoid time-consuming rework. System Requirements This book assumes a typical installation of Microsoft Excel 2010 and Microsoft Windows 7 Ultimate using an Aero theme. (You can also complete the material in this text using another version of Windows 7,
and 7, being careful to move the pointer directly over the Mini toolbar in Step 7. ◗ 8. On the Mini toolbar, click the Bold button . The text in cell A1 is bold. The Mini toolbar remains visible so you can continue formatting the selected text. See Figure 14. Figure 14 Mini toolbar with the Bold button selected Mini toolbar remains open for additional formatting Bold button toggled on bold text in cell A1 ◗ 9. Press the Enter key. The Mini toolbar disappears, and cell A2 is selected.
extensions .doc (Word), .xls (Excel), .mdb (Access), and .ppt (PowerPoint). To save in an earlier format, click the Save as type button in the Save As dialog box and click the 97-2003 format. When you open an earlier version file in Office 2010, you can save it in the same format or the Office 2010 format. As you create and modify an Ofﬁce ﬁle, your work is stored only in the computer’s temporary memory, not on a hard drive. If you were to exit the program without saving, turn off your computer,
and then select the adjacent range F1:G5. ◗ 3. Release the Ctrl key. As shown in Figure 1-15, all the cells in the nonadjacent range A1:A5;F1:G5 are selected. Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience.
EX 47 Amanda wants a printout of the formula view. The Customer Orders worksheet will not ﬁt on one page because of the expanded column widths. You can scale the worksheet to force the contents to ﬁt on a single page. Scaling a printout reduces the width and the height of the printout to ﬁt the number of pages you specify by shrinking the text size as needed. You can also scale a printout proportionally to a percentage of its actual size. You’ll scale the Customer Orders worksheet to a width and