دسترسی نامحدود
برای کاربرانی که ثبت نام کرده اند
دانلود کتاب Benchmark Series: Microsoft Excel 365 Levels 1 and 2
دانلود کتاب سری بنچمارک: Microsoft Excel 365 Levels 1 و 2
مشخصات کتاب
Benchmark Series: Microsoft Excel 365 Levels 1 and 2
ویرایش: 2019
نویسندگان: Nita Rutkosky
سری:
ISBN (شابک) : 9780763887223, 9780763887094
ناشر: Paradigm
سال نشر: 2019
تعداد صفحات: 666
زبان: English
فرمت فایل : PDF (درصورت درخواست کاربر به PDF، EPUB یا AZW3 تبدیل می شود)
حجم فایل: 27 مگابایت
قیمت کتاب (تومان) : 54,000
در صورت تبدیل فایل کتاب Benchmark Series: Microsoft Excel 365 Levels 1 and 2 به فرمت های PDF، EPUB، AZW3، MOBI و یا DJVU می توانید به پشتیبان اطلاع دهید تا فایل مورد نظر را تبدیل نمایند.
توجه داشته باشید کتاب سری بنچمارک: Microsoft Excel 365 Levels 1 و 2 نسخه زبان اصلی می باشد و کتاب ترجمه شده به فارسی نمی باشد. وبسایت اینترنشنال لایبرری ارائه دهنده کتاب های زبان اصلی می باشد و هیچ گونه کتاب ترجمه شده یا نوشته شده به فارسی را ارائه نمی دهد.
توضیحاتی درمورد کتاب به خارجی
فهرست مطالب
Microsoft Excel 365, 2019 Edition, Levels 1-2 Copyright Page Brief Contents Contents Preface Achieving Proficiency in Excel Proven Instructional Design Chapter Openers Present Learning Objectives Activities Build Skill Mastery within Realistic Context Chapter Review Tools Reinforce Learning The Cirrus Solution Dynamic Training Chapter Review and Assessment Unit Review and Assessment Student eBook Instructor eResources About the Authors Getting Startedin Office 365 Identifying Computer Hardware System Unit (PC/Tower) Monitor Keyboard Drives and Ports Printer Mouse Touchpad Touchscreen Choosing Commands Using Keyboard Shortcuts and Accelerator Keys Choosing Commands from a Drop-Down List Choosing Options from a Dialog Box or Task Pane Choosing Commands with Shortcut Menus Working with Multiple Applications Maintaining Files and Folders Creating and Naming a Folder Selecting and Opening Files and Folders Deleting Files and Folders Moving and Copying Files and Folders Renaming Files and Folders Viewing Files and Folders Managing Files at the Info Backstage Area Customizing Settings Retrieving and Copying Data Files Microsoft Excel, Level 1, Unit 1 - Preparing and Formatting Worksheets 1 - Preparing an Excel Workbook Performance Objectives Creating a Worksheet Entering Data in a Worksheet Saving a Workbook Editing Data in a Cell Printing a Worksheet Closing a Workbook and Closing Excel Using Automatic Entering Features Using AutoComplete Using AutoCorrect Using AutoFill Opening a Workbook Opening a Workbook from the Recent Option List Pinning and Unpinning Workbooks and Folders Entering Formulas Using the AutoSum Button to Add Numbers Using the AutoSum Button to Average Numbers Using the Fill Handle to Copy a Formula Selecting Cells Selecting Cells Using the Mouse Selecting Cells Using the Keyboard Selecting Data within Cells Applying Basic Formatting Changing Column Width Merging and Centering Cells Formatting Numbers Using the Tell Me Feature Using Help Getting Help from a ScreenTip Getting Help in a Dialog Box or at the Backstage Area Chapter Summary Commands Review 2 - Inserting Formulas in a Worksheet Performance Objectives Writing Formulas with Mathematical Operators Copying a Formula with Relative Cell References Checking Cell References in a Formula Writing a Formula by Pointing Determining the Order of Operations Using the Trace Error Button Identifying Common Formula Errors Inserting Formulas with Functions Writing Formulas with Statistical Functions Writing Formulas with the NOW and TODAY Functions Displaying Formulas Using Absolute and Mixed Cell References in Formulas Using an Absolute Cell Reference in a Formula Using a Mixed Cell Reference in a Formula Chapter Summary Commands Review 3 - Formatting a Worksheet Performance Objectives Changing Column Width Changing Column Width Using Column Boundaries Changing Column Width at the Column Width Dialog Box Inserting and Deleting Cells, Rows, and Columns Inserting Rows Inserting Columns Deleting Cells, Rows, or Columns Clearing Data in Cells Applying Formatting Applying Font Formatting Formatting with the Mini Toolbar Applying Alignment Formatting Applying a Theme Formatting Numbers Formatting Numbers Using Number Group Buttons Applying Number Formatting at the Format Cells Dialog Box Applying Formatting Using the Format Cells Dialog Box Aligning and Indenting Data Changing the Font Adding Borders to Cells Adding Fill and Shading to Cells Repeating the Last Action Formatting with Format Painter Hiding and Unhiding Columns and Rows Chapter Summary Commands Review 4 - Enhancing a Worksheet Performance Objectives Formatting a Worksheet Page Changing Margins Centering a Worksheet Horizontally and/or Vertically Changing Page Orientation Changing the Paper Size Inserting and Removing Page Breaks Printing Column and Row Titles on Multiple Pages Scaling Data Inserting a Background Picture Printing Gridlines and Row and Column Headings Printing a Specific Area of a Worksheet Inserting Headers and Footers Customizing Print Jobs Checking Spelling Using Undo and Redo Finding and Replacing Data and Cell Formatting Sorting Data Completing a Custom Sort Sorting More Than One Column Filtering Data Chapter Summary Commands Review Microsoft Excel LEvel 1, Unit 2 - Enhancing the Display of Workbooks 5 - Moving Data within and between Workbooks Performance Objectives Creating a Workbook with Multiple Worksheets Inserting a New Worksheet Deleting a Worksheet Selecting Multiple Worksheets Copying, Cutting, and Pasting Cells Copying and Pasting Selected Cells Using Paste Options Moving Selected Cells Copying and Pasting Using the Clipboard Task Pane Pasting Values Only Managing Worksheets Hiding and Unhiding a Worksheet in a Workbook Printing a Workbook Containing Multiple Worksheets Changing the Zoom Splitting a Worksheet and Freezing and Unfreezing Panes Naming and Using a Range Working with Windows Opening Multiple Workbooks Arranging Workbooks Hiding and Unhiding Workbooks Sizing and Moving Workbooks Moving, Linking, Copying, and Pasting Data between Workbooks Moving and Copying Data Linking Data Copying and Pasting Data between Programs Chapter Summary Commands Review 6 - Maintaining Workbooks Performance Objectives Managing the Recent Option List Pinning and Unpinning a Workbook Recovering an Unsaved Workbook Clearing the Recent Option List and the Recent List Managing Worksheets Copying a Worksheet to Another Workbook Moving a Worksheet to Another Workbook Formatting with Cell Styles Applying a Cell Style Defining a Cell Style Modifying a Cell Style Copying Cell Styles to Another Workbook Removing a Cell Style Deleting a Cell Style Inserting Hyperlinks Linking to an Existing Web Page or File Navigating Using Hyperlinks Linking to a Place in the Workbook Linking to a New Workbook Linking Using a Graphic Linking to an Email Address Modifying, Editing, and Removing a Hyperlink Using Excel Templates Inserting and Managing Comments Inserting a New Comment Posting a Comment Editing and Deleting a Comment Viewing and Managing Comments at the Comments Task Pane Writing Formulas with Financial Functions Finding the Periodic Payments for a Loan Finding the Future Value of a Series of Payments Chapter Summary Commands Review 7 - Creating Charts and Inserting Formulas Performance Objectives Creating a Chart Sizing and Moving a Chart Editing Data and Adding a Data Series Formatting with Chart Buttons Printing a Chart Changing the Chart Design Changing the Chart Style Switching Rows and Columns Changing Chart Layout and Colors Changing the Chart Location Adding, Moving, and Deleting Chart Elements Changing Chart Formatting Formatting a Selection Inserting a Shape Creating Alternative Text for an Image Using the Quick Analysis Feature Applying Formatting at a Task Pane Changing Chart Height and Width Measurements Deleting a Chart Writing Formulas with the Logical IF Function Writing Formulas with an IF Function Using the Function Arguments Dialog Box Writing IF Statements Containing Text Chapter Summary Commands Review 8 - Adding Visual Interest to Workbooks Performance Objectives Inserting Symbols and Special Characters Inserting an Image Customizing and Formatting an Image Sizing and Moving an Image Formatting an Image at the Format Picture Task Pane Inserting an Online Image Creating and Inserting a Screenshot Inserting and Formatting a Shape Inserting and Modifying Text Boxes Inserting and Customizing Icons Inserting and Customizing 3D Models Inserting a SmartArt Graphic Entering Data in a SmartArt Graphic Sizing, Moving, and Deleting a SmartArt Graphic Changing the SmartArt Graphic Design Changing the SmartArt Graphic Formatting Creating, Sizing, and Moving WordArt Chapter Summary Commands Review Index Microsoft Excel, Level 2, Unit 1 - Advanced Formatting, Formulas,and Data Management 1 - Advanced Formatting Techniques Performance Objectives Applying Conditional Formatting Applying Conditional Formatting Using a New Rule Editing and Deleting a Conditional Formatting Rule Applying Conditional Formatting Using an Icon Set Applying Conditional Formatting Using Data Bars and Color Scales Applying Conditional Formatting Using a Formula Applying Conditional Formatting Using Quick Analysis Applying Fraction Formatting and Scientific Formatting Applying Special Number Formatting Creating a Custom Number Format Filtering a Worksheet Using a Custom AutoFilter Filtering and Sorting Data and Removing a Filter Filtering and Sorting Data Using Conditional Formatting or Cell Attributes Removing a Filter Defining a Custom Sort Applying an Advanced Filter Chapter Summary Commands Review 2 - Advanced Functions and Formulas Performance Objectives Managing Range Names Using Statistical Functions Using Statistical Functions: COUNTIF and COUNTIFS Using Statistical Functions: AVERAGEIF and AVERAGEIFS Using Math and Trigonometry Functions: SUMIF and SUMIFS Using Lookup Functions Using the VLOOKUP Function Using the HLOOKUP Function Using the PPMT Financial Function Using and Nesting Logical Functions Using the Nested IF Logical Function Using Logical Functions: Nested IF, AND, and OR Using the ROUND Function Using the IFS Logical Function Viewing Long Formulas in the Formula Bar Chapter Summary Commands Review 3 - Working with Tables and Data Features Performance Objectives Formatting Data as a Table Modifying a Table Applying Table Styles, Table Style Options, and Table Properties Sorting and Filtering a Table Working with Data Tools Separating Data Using Text to Columns Identifying and Removing Duplicate Records Validating Data Entry Converting a Table to a Normal Range and Subtotaling Related Data Modifying Subtotals Selecting Data from Different Outline Levels Grouping and Ungrouping Data Chapter Summary Commands Review 4 - Summarizing and Consolidating Data Performance Objectives Summarizing Data in Multiple Worksheets Using Range Names and 3-D References Summarizing Data by Linking to Ranges in Other Worksheets or Workbooks Maintaining External References Summarizing Data Using the Consolidate Feature Creating PivotTables Creating a Recommended PivotTable Building a PivotTable Formatting and Filtering a PivotTable Changing the PivotTable Summary Function Filtering a PivotTable Using Slicers Filtering a PivotTable Using a Timeline Creating a PivotChart Summarizing Data with Sparklines Creating Sparklines Customizing Sparklines Chapter Summary Commands Review Microsoft Excel, Level 2, Unit 2 - Managing and Integrating Data and the Excel Environment 5 - Using Data Analysis Features Performance Objectives Pasting Data Using Paste Special Options Selecting Other Paste Special Options Transposing Data Performing a Mathematical Operation While Pasting Using Goal Seek to Populate Cells Adding, Editing, and Applying Scenarios Applying a Scenario Editing a Scenario Deleting a Scenario Generating a Scenario Summary Report Performing What-If Analysis Using Data Tables Creating a One-Variable Data Table Creating a Two-Variable Data Table Using Auditing Tools Tracing Precedent and Dependent Cells Troubleshooting Formulas Circling Invalid Data Watching a Formula Cell Chapter Summary Commands Review 6 - Exporting, Importing, and Transforming Data Performance Objectives Exporting Data from Excel Copying and Pasting Data into Word Breaking a Link to an Excel Object Copying and Pasting Data into PowerPoint Copying and Pasting Data into Access Exporting a Worksheet as a Text File Importing Data into Excel Importing Data from Access Modifying Data with the Power Query Editor Importing Data from a Text File Refreshing, Modifying, and Deleting Queries Editing or Removing the Source for a Query Transforming Data Using Flash Fill Using Text Functions Chapter Summary Commands Review 7 - Automating Repetitive Tasks and Customizing Excel Performance Objectives Changing Display Options Minimizing the Ribbon Customizing Ribbons and the Quick Access Toolbar Exporting and Importing Customizations Customizing the Ribbon Customizing the Quick Access Toolbar Resetting the Ribbons and the Quick Access Toolbar Creating and Applying a Custom View Automating Tasks Using Macros Creating a Macro Saving Workbooks Containing Macros Running a Macro Assigning a Macro to a Shortcut Key Editing a Macro Managing and Deleting Macros Inserting and Configuring Form Controls Inserting Form Controls Configuring Form Controls Creating a Macro Button Form Control Saving a Workbook as a Template Using a Custom Template Deleting a Custom Template Customizing Save Options Viewing Trust Center Settings Chapter Summary Commands Review 8 - Protecting and Distributing a Workbook Performance Objectives Adding Workbook Properties Protecting and Unprotecting Worksheets Protecting and Unprotecting the Structure of a Workbook Adding and Removing a Password to Open a Workbook Preparing a Workbook for Distribution Checking for Accessibility Issues Inspection Results Inspecting a Workbook and Removing Information before Distributing It Marking a Workbook as Final Using the Compatibility Checker Distributing Workbooks Publishing a Workbook as a PDF File Publishing a Workbook as an XPS File Publishing a Worksheet as a Web Page Exporting and Importing XML Data Creating an XML Schema Exporting a Worksheet as an XML File Importing an XML File Chapter Summary Commands Review Index Benchmark Series: Microsoft Excel 365, 2019 Edition, Level 1, Review and Assessment Copyright Page Contents Microsoft Excel, Level 1, Unit 1 - Preparing and Formatting Worksheets 1 - Preparing an Excel Workbook Skills Assessment Assessment 1 - Create a Worksheet Using AutoCorrect and AutoComplete Assessment 2 - Create and Format a Worksheet Assessment 3 - Create a Worksheet Using the Fill Handle Assessment 4 - Insert Formulas in a Worksheet Visual Benchmark Create, Format, and Insert Formulas in a Worksheet Case Study Part 1 Part 2 Part 3 Part 4 2 - Inserting Formulas in a Worksheet Skills Assessment Assessment 1 - Insert AVERAGE, MAX, and MIN Functions Assessment 2 - Insert the SUM Function and Enter Formulas with Mathematical Operators Assessment 3 - Write Formulas with Absolute Cell References Assessment 4 - Write Formulas with Mixed Cell References Assessment 5 - Use Help to Learn about Excel Options Visual Benchmark Create a Worksheet and Insert Formulas Case Study Part 1 Part 2 Part 3 Part 4 3 - Formatting a Worksheet Skills Assessment Assessment 1 - Format a Sales Worksheet Assessment 2 - Format an Overdue Accounts Worksheet Assessment 3 - Format a Supplies and Equipment Worksheet Assessment 4 - Format a Financial Analysis Worksheet Visual Benchmark Create a Worksheet and Insert Formulas Case Study Part 1 Part 2 Part 3 Part 4 4 - Enhancing a Worksheet Skills Assessment Assessment 1 - Format a Data Analysis Worksheet Assessment 2 - Format a Test Results Worksheet Assessment 3 - Format an Equipment Rental Worksheet Assessment 4 - Format an Invoices Worksheet Assessment 5 - Create a Worksheet Containing Keyboard Shortcuts Visual Benchmark Create and Format an Expense Worksheet Case Study Part 1 Part 2 Part 3 Unit 1 Performance Assessment Assessing Proficiency Assessment 1 - Calculate Total, Maximum, Minimum, and Average Yearly Sales Assessment 2 - Create a Worksheet with AutoFill and Calculate Total Hours and Gross Pay Assessment 3 - Create a Sales Bonus Workbook Assessment 4 - Format a Department Budget Assessment 5 - Format a Weekly Payroll Workbook Assessment 6 - Format a Customer Sales Analysis Workbook Assessment 7 - Format an Invoices Workbook Writing Activities Activity 1 - Plan and Prepare an Orders Summary Workbook Activity 2 - Prepare a Depreciation Workbook Activity 3 - Insert a Straight-Line Depreciation Formula Internet Research Create a Travel Planning Worksheet Microsoft Excel, Level 1, Unit 2 - Enhancing the Display of Workbooks 5 - Moving Data within and between Workbooks Skills Assessment Assessment 1 - Copy and Paste Data between Worksheets in a Sales Workbook Assessment 2 - Copy, Paste, and Format Worksheets in an Income Statement Workbook Assessment 3 - Freeze and Unfreeze Window Panes in a Test Scores Workbook Assessment 4 - Create, Copy, Paste, and Format Cells in an Equipment Usage Workbook Assessment 5 - Copying and Linking Excel Data in a Word Document Visual Benchmark Create and Format a Sales Worksheet Using Formulas Case Study Part 1 Part 2 Part 3 Part 4 6 - Maintaining Workbooks Skills Assessment Assessment 1 - Define and Apply Cell Styles to a Projected Earnings Workbook Assessment 2 - Insert Hyperlinks in a Bookstore Workbook Assessment 3 - Write a Formula with the PMT Function Assessment 4 - Write a Formula with the FV Function and Insert Comments Assessment 5 - Apply Conditional Formatting to a Sales Workbook Visual Benchmark Fill in an Expense Report Form Case Study Part 1 Part 2 Part 3 Part 4 7 - Creating Charts and Inserting Formulas Skills Assessment Assessment 1 - Create a Net Profit Chart Assessment 2 - Create a Company Sales Column Chart Assessment 3 - Create Quarterly Domestic and Foreign Sales Bar Chart Assessment 4 - Create a Fund Allocations Pie Chart Assessment 5 - Write a Formula with the IF Function Assessment 6 - Create a Stacked Column Chart Assessment 7 - Learn about Excel Options Visual Benchmark Create and Format a Pie Chart Case Study Part 1 Part 2 Part 3 Part 4 Part 5 8 - Adding Visual Interest to Workbooks Skills Assessment Assessment 1 - Insert an Image and WordArt in an Equipment Sales Workbook Assessment 2 - Insert Formulas and an Icon and Format a Travel Company Workbook Assessment 3 - Insert and Format Shapes in a Company Sales Workbook Assessment 4 - Insert and Format a SmartArt Graphic in a Sales Workbook Assessment 5 - Insert and Modify a 3D Model Visual Benchmark Insert Formulas, WordArt, an Image, and a Shape in a Worksheet Case Study Part 1 Part 2 Part 3 Part 4 Microsoft Excel Unit 2 Performance Assessment Assessing Proficiency Assessment 1 - Copy and Paste Data and Insert WordArt in a Training Scores Workbook Assessment 2 - Manage Multiple Worksheets in a Projected Earnings Workbook Assessment 3 - Create Charts in Worksheets in a Sales Totals Workbook Assessment 4 - Create a Line Chart and Insert a Comment Assessment 5 - Create a Pie Chart and Insert an Icon Assessment 6 - Use the PMT Function and Apply Formatting to a Workbook Assessment 7 - Use the IF Function and Apply Formatting to a Workbook Assessment 8 - Insert a Text Box and Hyperlinks in a Travel Workbook Assessment 9 - Insert an Image and a SmartArt Graphic in a Workbook Assessment 10 - Insert a Symbol, WordArt, and Screenshot in a Sales Workbook Assessment 11 - Insert and Format a Shape in a Budget Workbook Writing Activities Activity 1 - Prepare a Projected Budget Activity 2 - Create a Travel Tours Bar Chart Activity 3 - Prepare a Ski Vacation Worksheet Internet Research Find Information on Excel Books and Present the Data in a Worksheet Job Study Create a Customized Time Card for a Landscaping Company Benchmark Series: Microsoft Excel 365, 2019 Edition, Level 2, Review and Assessment Copyright Page Contents Microsoft Excel, Level 2, Unit 1- Advanced Formatting, Formulas, and Data Management 1 - Advanced Formatting Techniques Skills Assessment Assessment 1 - Use Conditional and Fraction Formatting Assessment 2 - Apply Custom Number Formatting Assessment 3 - Use Custom AutoFilter and Filter and Sort by Color Assessment 4 - Create, Edit, and Delete Formatting Rules Assessment 5 - Apply an Advanced Filter Visual Benchmark Format a Billing Summary Case Study Part 1 Part 2 Part 3 Part 4 2 - Advanced Function sand Formulas Skills Assessment Assessment 1 - Create Range Names and Use the Lookup Function Assessment 2 - Use Conditional Statistical and Math Functions Assessment 3 -Use the PMT and PPMT Financial Functions Assessment 4 - Use Logical Functions Assessment 1 - Use the HLOOKUP Function Visual Benchmark Activity 1 - Use Lookup, Statistical, and Math Functions in a Billing Summary Activity 2 - Use Lookup and Logical Functions to Calculate Cardiology Costs Case Study Part 1 Part 2 Part 3 Part 4 3 - Working with Tables and Data Features Skills Assessment Assessment 1 - Create and Format a Table Assessment 2 - Use Data Tools Assessment 3 - Subtotal Records Visual Benchmark Activity 1 - Using Table and Data Tools in a Call List Activity 2 - Using Subtotals in a Call List Case Study Part 1 Part 2 Part 3 Part 4 4 - Summarizing and Consolidating Data Skills Assessment Assessment 1 - Summarize Data in Multiple Worksheets Using Range Names Assessment 2 - Summarize Data Using Linked External References Assessment 3 - Summarize Data Using 3-D References Assessment 4 - Summarize Data in a PivotTable and a PivotChart Assessment 5 - Filter a PivotTable Using a Slicer and a Timeline Assessment 6 - Create and Customize Sparklines Visual Benchmark Summarize Real Estate Sales and Commission Data Case Study Part 1 Part 2 Part 3 Part 4 Unit 1 Performance Assessment Assessing Proficiency Assessment 1 - Conditionally Format and Filter a Help Desk Worksheet Assessment 2 - Use Conditional Logic Formulas in a Help Desk Worksheet Assessment 3 - Use Table and Data Management Features in a Help Desk Worksheet Assessment 4 - Add Subtotals to and Outline a Help Desk Worksheet andApply an Advanced Filter Assessment 5 - Use Financial and Text Functions to Analyze Data for a Project Assessment 6 - Analyze Sales Using a PivotTable, a PivotChart, and Sparklines Assessment 7 - Link to an External Data Source and Calculate Distributor Payments Writing Activities Activity 1 - Create a Worksheet to Track Memberships Activity 2 - Create a Worksheet to Log Hours Walked in a Company Fitness Contest Internet Research Create a Worksheet to Compare Online Auction Listing Fees Microsoft Excel 365, 2019 Edition, Level 2, Unit 2 - Managing and Integrating Dataand the Excel Environment 5 - Using Data Analysis Features Skills Assessment Assessment 1 - Convert Columns to Rows, Add Source Cells to Destination Cells, and Filter Data Assessment 2 - Use Goal Seek Assessment 3 - Use Scenario Manager Assessment 4 - Create a Two-Variable Data Table Assessment 5 - Find and Correct Formula Errors Visual Benchmark Activity 1 - Find the Base Hourly Rate for Drum Lessons Activity 2 - Create Scenarios for Drum Lesson Revenue Case Study Part 1 Part 2 Part 3 Part 4 6 - Exporting, Importing, and Transforming Data Skills Assessment Assessment 1 - Link Data to a Word Document Assessment 2 - Embed Data in a PowerPoint Presentation Assessment 3 - Export Data as a Text File Assessment 4 - Import Data from Access and a Text File Assessment 5 - Import and Transform Data Visual Benchmark Import, Analyze, and Export Population Data Case Study Part 1 Part 2 Part 3 7 - Automating Repetitive Tasks and Customizing Excel Skills Assessment Assessment 1 - Customize the Excel Environment Assessment 2 - Create Custom Views Assessment 3 - Create Macros and Save as a Macro-Enabled Workbook Assessment 4 - Run Macros Assessment 5 - Create Macros and Save as a Macro-Enabled Workbook Assessment 6 - Print Macros Assessment 7 - Create and Use a Template Visual Benchmark Activity 1 - Customize the Ribbon Activity 2 - Create a Custom Template Case Study Part 1 Part 2 Part 3 8 - Protecting and Distributing a Workbook Skills Assessment Assessment 1 - Enter and Display Workbook Properties Assessment 2 - Protect an Entire Worksheet and Add a Password to a Workbook Assessment 3 - Unlock Cells and Protect a Worksheet and Protect a Workbook Structure Assessment 4 - Prepare a Workbook for Distribution Assessment 5 - Prepare and Distribute a Workbook Assessment 6 - Import an XML file Visual Benchmark Import, Analyze, and Export Population Data Case Study Part 1 Part 2 Part 3 Part 4 Unit 2 Performance Assessment Assessing Proficiency Assessment 1 - Use Goal Seek and Scenario Manager to Calculate Investment Proposals Assessment 2 - Calculate Investment Outcomes for a Portfolio Using a Two-Variable Data Table Assessment 3 - Solve an Error and Check for Accuracy in Investment Commission Formulas Assessment 4 - Export a Chart and Prepare and Distribute an Investment Portfolio Worksheet Assessment 5 - Import Investment Clients into a Workbook Assessment 6 - Automate and Customize an Investment Portfolio Workbook Assessment 7 - Create and Use an Investment Planner Template Assessment 8 - Protect a Confidential Investment Portfolio Workbook Writing Activity Create a Computer Maintenance Form Template Internet Research Activity 1 - Apply a What-If Analysis to a Planned Move Activity 2 - Research and Compare Smartphones Job Study Prepare a Wages Budget and Link the Budget to a Word Document
نظرات کاربران
کتاب های تصادفی
دانلود کتاب The Ships of Christopher Columbus: Santa Maria, Nina and Pinta (Anatomy of the Ship)
دانلود کتاب Großstadt: Soziologische Stichworte
دانلود کتاب Diccionario De Materiales Ceramicos
دانلود کتاب The Development of International Insurance (Financial History, 15)
