30.00$ - Pay Now
Digital File Direct & Fast Download ( Bank Exam ZIP & PDF) only for 30.00$
All chapters are included in the test Bank Exam
Free samples included once needed (ZIP & PDF)
Multiple payment options (Paypal , Credit Card) - NO account Required
Dedicated support / instant chat – Email - Whatsapp
Digital file of GO! with Microsoft Excel 2013 Introductory (Subscription) for sale
***THIS IS NOT THE ACTUAL BOOK. YOU ARE BUYING the Test Bank in e-version of the following book***
Category : Higher Education
Office Chapter 1 Introduction to Microsoft Office 2013 Features Project 1A Note Form Objective 1 Use File Explorer to Download, Extract, and Locate Files and Folders Activity 1.01 Using File Explorer to Download, Extract, and Locate Files and Folders Objective 2 Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App Activity 1.02 Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App Objective 3 Enter, Edit, and Check the Spelling of Text in an Office 2013 Program Activity 1.03 Entering and Editing Text in an Office 2013 Program Activity 1.04 Checking Spelling Objective 4 Perform Commands from a Dialog Box Activity 1.05 Performing Commands from a Dialog Box Activity 1.06 Using Undo Objective 5 Create a Folder and Name and Save a File Activity 1.07 Creating a Folder and Naming and Saving a File Objective 6 Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App Activity 1.08 Inserting a Footer, Inserting Document Info, and Adding Document Properties Activity 1.09 Printing a File and Closing a Desktop App Project 1B Memo Objective 7 Open an Existing File and Save It with a New Name More Knowledge Read-Only Objective 8 Sign In to Office and Explore Options for a Microsoft Office Desktop App Activity 1.00 Perform Commands from the Ribbon and Quick Access Toolbar More Knowledge Customizing the Ribbon Objective 9 Apply Formatting in Office Programs More Knowledge Zooming to Page Width Objective 10 Compress Files and Use the Microsoft Office 2013 Help System Objective 11 Install Apps for Office and Create a Microsoft Account Summary, GO! Learn It Online Glossary Excel Introduction to Microsoft Excel 2013 Chapter 1 Creating a Worksheet and Charting Data Project 1A Sales Report with Embedded Column Chart and Sparklines Objective 1 Create, Save, and Navigate an Excel Workbook Activity 1.01 Starting Excel, Navigating Excel, and Naming and Saving a Workbook More Knowledge Creating a New Workbook by Using a Template Objective 2 Enter Data in a Worksheet Activity 1.02 Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell Activity 1.03 Using Auto Fill and Keyboard Shortcuts Activity 1.04 Aligning Text and Adjusting the Size of Columns Activity 1.05 Entering Numbers Objective 3 Construct and Copy Formulas and Use the SUM Function Activity 1.06 Constructing a Formula and Using the SUM Function Activity 1.07 Copying a Formula by Using the Fill Handle Objective 4 Format Cells with Merge & Center, Cell Styles, and Themes Activity 1.08 Using Merge & Center and Applying Cell Styles Activity 1.09 Formatting Financial Numbers Activity 1.10 Changing the Workbook Theme More Knowledge Formatting a Cell’s Font, Style, Size, or Color with Individual Commands Objective 5 Chart Data to Create a Column Chart and Insert Sparklines Activity 1.11 Charting Data and Using Recommended Charts to Select and Insert a Column Chart Activity 1.12 Using the Chart Tools to Apply Chart Styles Activity 1.13 Creating and Formatting Sparklines Objective 6 Print a Worksheet, Display Formulas, and Close Excel Activity 1.14 Creating a Footer and Centering a Worksheet Activity 1.15 Adding Document Properties and Printing a Workbook More Knowledge Inserting a Watermark Activity 1.16 Printing a Section of the Worksheet Activity 1.17 Changing Page Orientation and Displaying, Printing, and Hiding Formulas Activity 1.18 Creating a Sales Report with Embedded Column Chart Using the Excel Web App Project 1B Inventory Valuation More Knowledge Calculate a Percentage if You Know the Total and the Amount More Knowledge Hiding Rows and Columns Summary, GO! Learn It Online, GO! For Job Success Glossary Skills Review Mastering Excel Rubric GO! Think Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks Project 2A Inventory Status Report Objective 1 Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions Activity 2.01 Using Flash Fill Activity 2.02 Moving a Column Activity 2.03 Using the SUM and AVERAGE Functions Activity 2.04 Using the MEDIAN Function Activity 2.05 Using the MIN and MAX Functions Objective 2 Move Data, Resolve Error Messages, and Rotate Text Activity 2.06 Moving Data and Resolving a # # # # # Error Message Activity 2.07 Rotating Text Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting Activity 2.08 Using the COUNT and COUNTIF Functions Activity 2.09 Using the IF Function Activity 2.10 Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars Activity 2.11 Using Find and Replace More Knowledge NOW Function Recalculates Each Time a Workbook Opens Objective 4 Use Date & Time Functions and Freeze Panes Activity 2.12 Using the NOW Function to Display a System Date Activity 2.13 Freezing and Unfreezing Panes More Knowledge Freeze Columns or Freeze Both Rows and Columns Objective 5 Create, Sort, and Filter an Excel Table Activity 2.14 Creating an Excel Table and Applying a Table Style Activity 2.15 Sorting an Excel Table More Knowledge Band Rows and Columns in a Table Activity 2.16 Filtering an Excel Table and Displaying a Total Row Activity 2.17 Clearing Filters and Converting a Table to a Range of Data Objective 6 View, Format, and Print a Large Worksheet Activity 2.18 Modifying and Shrinking the Worksheet View Activity 2.19 Splitting a Worksheet Window into Panes Activity 2.20 Printing Titles and Scaling to Fit More Knowledge Scaling for Data That Is Slightly Larger Than the Printed Page Activity 2.21 Sort, Filter, and Use Functions in a Table Project 2B Weekly Sales Summary More Knowledge Copying a Worksheet More Knowledge Clearing an Entire Worksheet More Knowledge Hide Worksheets Summary, GO! Learn It Online, GO! For Job Success Glossary Skills Review Mastering Excel Rubric GO! Think Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Project 3A Enterprise Fund Pie Chart Objective 1 Chart Data with a Pie Chart Activity 3.01 Calculating Values for a Pie Chart Activity 3.02 Creating a Pie Chart in a Chart Sheet Objective 2 Format a Pie Chart Activity 3.03 Formatting a Chart Title by Applying a WordArt Style and Changing Font Size Activity 3.04 Formatting Chart Elements by Removing a Legend and Adding and Formatting Data Labels Activity 3.05 Formatting a Data Series with 3-D Effects Activity 3.06 Formatting a Data Series with a Shadow Effect Activity 3.07 Rotating a Pie Chart by Changing the Angle of the First Slice Activity 3.08 Exploding and Coloring a Pie Slice Activity 3.09 Formatting the Chart Area Objective 3 Edit a Workbook and Update a Chart Activity 3.10 Editing a Workbook and Updating a Chart Objective 4 Use Goal Seek to Perform What-If Analysis Activity 3.11 Using Goal Seek to Perform What-If Analysis Activity 3.12 Preparing and Printing a Workbook with a Chart Sheet Activity 3.13 Creating a JPEG Photo of a Chart and Uploading It to a OneNote Web App Notebook Project 3B Tourism Spending Projection with Line Chart More Knowledge Use of Parentheses in a Formula More Knowledge Percentage Calculations More Knowledge Percent Increase or Decrease More Knowledge Resizing a Chart Summary, GO! Learn It Online, GO! For Job Success Glossary Skills Review Mastering Excel Rubric GO! Think Chapter 4 Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets Project 4A Amortization Schedule and -Merchandise Costs Objective 1 Use Financial Functions Activity 4.01 Inserting the PMT Financial Function Objective 2 Use Goal Seek Activity 4.02 Using Goal Seek to Produce a Desired Result Activity 4.03 Using Goal Seek to Find an Increased Period Objective 3 Create a Data Table Activity 4.04 Designing a Two-Variable Data Table Activity 4.05 Using a Data Table to Calculate Options Objective 4 Use Defined Names in a Formula Activity 4.06 Defining a Name Activity 4.07 Inserting New Data into a Named Range Activity 4.08 Creating a Defined Name by Using Row and Column Titles Activity 4.09 Using Defined Names in a Formula Project 4B Lookup Form and Revenue Report More Knowledge Creating Validation Messages More Knowledge Summary, GO! Learn It Online, GO! For Job Success Glossary Skills Review Mastering Excel Rubric GO! Think Chapter 5 Managing Large Workbooks and Using Advanced Sorting and Filtering Project 5A Large Worksheet for a Class Schedule Objective 1 Navigate and Manage Large Worksheets Activity 5.01 Using the Go To Special Command Activity 5.02 Hiding Columns Activity 5.03 Using the Go To Command Activity 5.04 Arranging Multiple Workbooks and Splitting Worksheets Objective 2 Enhance Worksheets with Themes and Styles Activity 5.05 Changing and Customizing a Workbook Theme Activity 5.06 Creating and Applying a Custom Table Style Objective 3 Format a Worksheet to Share with Others Activity 5.07 Previewing and Modifying Page Breaks Activity 5.08 Repeating Column or Row Titles Activity 5.09 Inserting a Hyperlink in a Worksheet Activity 5.10 Modifying a Hyperlink Objective 4 Save Excel Data in Other File Formats Activity 5.11 Viewing and Saving a Workbook as a Web Page Activity 5.12 Saving Excel Data in CSV File Format Activity 5.13 Saving Excel Data as a PDF or XPS File More Knowledge Converting a Tab Delimited Text File to a Word Table Project 5B Sorted, Filtered, and Outlined Database More Knowledge A Custom List Remains Available for All Workbooks in Excel More Knowledge Using Wildcards Summary, GO! Learn It Online, GO! For Job Success Glossary Skills Review Mastering Excel Rubric GO! Think Chapter 6 Creating Charts, Diagrams, and Templates Project 6A Attendance Charts and Diagrams Objective 1 Create and Format Sparklines and a Column Chart Activity 6.01 Creating and Formatting Sparklines Activity 6.02 Creating a Column Chart More Knowledge Sizing Handles and Selection Handles Activity 6.03 Changing the Display of Chart Data More Knowledge Changing the Data in a Chart Activity 6.04 Editing and Formatting the Chart Title Activity 6.05 Adding, Formatting, and Aligning Axis Titles Activity 6.06 Editing Source Data Activity 6.07 Formatting the Chart Floor and Chart Walls Objective 2 Create and Format a Line Chart Activity 6.08 Creating a Line Chart Activity 6.09 Changing a Chart Title Activity 6.10 Changing the Values on the Value Axis Activity 6.11 Formatting the Plot Area and the Data Series Activity 6.12 Inserting a Trendline Objective 3 Create and Modify a SmartArt Graphic Activity 6.13 Creating a Process SmartArt Graphic Activity 6.14 Modifying the Diagram Style Objective 4 Create and Modify an Organization Chart Activity 6.15 Creating and Modifying a SmartArt Organization Chart Activity 6.16 Adding Effects to a SmartArt Graphic Activity 6.17 Preparing Worksheets Containing Charts and Diagrams for Printing Project 6B Order Form Template More Knowledge Setting the Default Font for New Worksheets More Knowledge Modifying a Template Summary, GO! Learn It Online, GO! For Job Success Glossary Skills Review Mastering Excel Rubric GO! Think Table of Contents
0 commentaires:
Enregistrer un commentaire