Handout used by the Westerville Public Library for the Introduction to Excel 2007 class. Provides basic information about creating a spreadsheet using Microsoft Excel 2007.
The document provides an overview of Microsoft Excel, including:
- Excel is used to organize and manipulate numerical data in electronic spreadsheets. It allows users to perform calculations, create charts and graphs, and format information.
- The Excel interface includes tabs for worksheets, a title bar, menu bar, and toolbars for common functions like formatting and calculations.
- Key functions covered include entering and formatting data, creating formulas for calculations, sorting and filtering data, inserting charts and graphs, printing worksheets, and using keyboard shortcuts.
Excel is an electronic spreadsheet program that allows users to store, organize, and manipulate data in a grid of rows and columns called a worksheet. Worksheets contain cells that can hold text, numbers, or formulas. Excel provides tools like functions, charts, and data analysis features to help work with large amounts of data. Users can enter values, edit data, search, zoom, and print worksheets.
This document provides an overview of key aspects of Microsoft Excel including its features, file formats, navigation keys, worksheets, formatting, cells and ranges, formulas, functions, and error values. It describes Excel's abilities for number crunching, creating charts and graphs, organizing lists, and accessing other data. It also outlines the basic components of formulas in Excel including operators, cell references, values/text, and functions. Finally, it provides examples of commonly used functions like SUM, AVERAGE, VLOOKUP, and COUNTIF.
Introduction to Microsoft Excel for beginnersBlogger Mumma
ย
Microsoft Excel is a spreadsheet application developed by Microsoft that features calculation and graphing tools. It consists of worksheets containing columns and rows where data is entered into cells referenced by their column letter and row number intersection. The basic Excel interface includes a title bar, menu bar, toolbars and worksheets. Formulas and functions can be used to perform calculations on the data in cells. Charts and graphs can be generated from cell data to visualize information. Data can be copied, filtered, and sorted as needed.
This document provides an overview of the basic features and interface of Microsoft Excel, including how to open and save worksheets, customize Excel, modify worksheets by formatting cells and adding formulas and functions, and sort and filter data. It describes the main parts of the Excel interface such as the ribbon, formula bar, rows and columns, scroll bars, and sheet tabs. It also explains how to exit Excel.
This document provides an introduction and tutorial for Microsoft Excel. It begins with an overview of Excel and what it can be used for, such as budget creation, data analysis, and presenting information. It then discusses key Excel components like the ribbon menu, cells, columns, rows, and worksheets. The document provides instructions for common tasks like navigating, entering data, formatting text and cells, inserting and deleting rows and columns, sorting data, and printing. It concludes by explaining how to copy and paste formatting between cells using tools like the format painter.
The document provides an introduction to Excel including its definition, basic components, and functions. It outlines how to create workbooks and worksheets, navigate within a spreadsheet, enter and format data, create formulas, and print graphs and charts. The key topics covered include the Excel interface and toolbars, entering and editing data, basic navigation techniques, formatting cells and numbers, building formulas using AutoSum, and a four-step process for inserting charts.
This document provides information about Microsoft Word 2007. It discusses the new user interface features like the ribbon and quick access toolbar. It describes how to perform common tasks like creating, opening, and saving documents. It also explains how to change fonts, insert pictures, tables, and other objects. Formatting options like bullets, numbering, and alignment are also covered.
The document provides an overview of Microsoft Excel, including:
- Excel is used to organize and manipulate numerical data in electronic spreadsheets. It allows users to perform calculations, create charts and graphs, and format information.
- The Excel interface includes tabs for worksheets, a title bar, menu bar, and toolbars for common functions like formatting and calculations.
- Key functions covered include entering and formatting data, creating formulas for calculations, sorting and filtering data, inserting charts and graphs, printing worksheets, and using keyboard shortcuts.
Excel is an electronic spreadsheet program that allows users to store, organize, and manipulate data in a grid of rows and columns called a worksheet. Worksheets contain cells that can hold text, numbers, or formulas. Excel provides tools like functions, charts, and data analysis features to help work with large amounts of data. Users can enter values, edit data, search, zoom, and print worksheets.
This document provides an overview of key aspects of Microsoft Excel including its features, file formats, navigation keys, worksheets, formatting, cells and ranges, formulas, functions, and error values. It describes Excel's abilities for number crunching, creating charts and graphs, organizing lists, and accessing other data. It also outlines the basic components of formulas in Excel including operators, cell references, values/text, and functions. Finally, it provides examples of commonly used functions like SUM, AVERAGE, VLOOKUP, and COUNTIF.
Introduction to Microsoft Excel for beginnersBlogger Mumma
ย
Microsoft Excel is a spreadsheet application developed by Microsoft that features calculation and graphing tools. It consists of worksheets containing columns and rows where data is entered into cells referenced by their column letter and row number intersection. The basic Excel interface includes a title bar, menu bar, toolbars and worksheets. Formulas and functions can be used to perform calculations on the data in cells. Charts and graphs can be generated from cell data to visualize information. Data can be copied, filtered, and sorted as needed.
This document provides an overview of the basic features and interface of Microsoft Excel, including how to open and save worksheets, customize Excel, modify worksheets by formatting cells and adding formulas and functions, and sort and filter data. It describes the main parts of the Excel interface such as the ribbon, formula bar, rows and columns, scroll bars, and sheet tabs. It also explains how to exit Excel.
This document provides an introduction and tutorial for Microsoft Excel. It begins with an overview of Excel and what it can be used for, such as budget creation, data analysis, and presenting information. It then discusses key Excel components like the ribbon menu, cells, columns, rows, and worksheets. The document provides instructions for common tasks like navigating, entering data, formatting text and cells, inserting and deleting rows and columns, sorting data, and printing. It concludes by explaining how to copy and paste formatting between cells using tools like the format painter.
The document provides an introduction to Excel including its definition, basic components, and functions. It outlines how to create workbooks and worksheets, navigate within a spreadsheet, enter and format data, create formulas, and print graphs and charts. The key topics covered include the Excel interface and toolbars, entering and editing data, basic navigation techniques, formatting cells and numbers, building formulas using AutoSum, and a four-step process for inserting charts.
This document provides information about Microsoft Word 2007. It discusses the new user interface features like the ribbon and quick access toolbar. It describes how to perform common tasks like creating, opening, and saving documents. It also explains how to change fonts, insert pictures, tables, and other objects. Formatting options like bullets, numbering, and alignment are also covered.
1. This document provides instructions for using basic Microsoft Excel functions like opening Excel, navigating the ribbon interface, entering data into cells, formatting cells, using autofill, and other common tasks.
2. It explains the different parts of the Excel interface like tabs, groups, commands, and describes the different data types Excel recognizes.
3. The document provides step-by-step examples for tasks like entering text and numbers, selecting cells, cutting/copying/pasting data, inserting and deleting rows and columns, and using basic formatting options.
Microsoft Excel 2007 is a widely used spreadsheet program that is part of the Microsoft Office suite, with capabilities for performing calculations, organizing data, creating charts and graphics, and automating tasks through macros. Excel allows users to enter and manipulate data in worksheets and perform calculations with formulas, analyze information with built-in functions and tools, and visualize data through a variety of chart types. Key features and functions of Excel 2007 include entering and editing data, working with formulas and functions, formatting worksheets, inserting objects and illustrations, printing and preparing files, reviewing and sharing workbooks, and customizing the Excel environment.
Microsoft Excel allows users to organize data into spreadsheets. It contains workbooks with multiple worksheets made of cells organized into rows and columns. Excel provides functions to perform calculations and analyze data. Users can format worksheets, insert charts and images, and print selections of cells or entire worksheets. Formulas using built-in functions can easily calculate and manipulate data in Excel.
Microsoft Office includes MS Word, Excel, PowerPoint, and Access. MS Word allows users to create documents through operations like opening, saving, printing and editing. It offers features like templates, spelling and grammar check, and mail merge. MS Excel is a spreadsheet program that performs calculations and displays results. It includes functions, charts, and tools for working with data. MS PowerPoint is used to create presentations with text, visuals, and audio. It provides layouts, colors, and transitions. MS Access creates and manages relational databases through tables, forms, queries and reports.
This document provides an introduction to Microsoft Excel. It begins with opening Excel and navigating within workbooks and worksheets. It describes entering different types of data like numbers, text, formulas. It discusses selecting cells, entering and editing data, copying and moving data using fill handle. It also covers saving workbooks in compatibility mode to allow opening in older Excel versions. The document is presented by Abdulbasit H. Mhdi and contains guidance, instructions and screenshots to explain key Excel concepts.
This document provides an overview of Microsoft Excel basics and functions. It covers topics such as formatting cells and data, using mathematical, logical, and financial functions, creating charts, sorting and filtering data, setting print options, and more. Examples of functions include SUM, MIN, MAX, COUNT, IF, NOW, TODAY, DATE, PMT and examples of charts include column, line, pie and bar charts. The document is intended as a training guide for learning Excel.
This document provides an overview of Microsoft Excel basics, including defining key terms like worksheet and workbook, identifying the parts of a worksheet, opening and saving workbooks, entering and editing data, searching and replacing values, zooming and printing worksheets, and closing files. The objectives are to learn the basic functions and navigation of Excel in order to effectively manage and analyze data in spreadsheets.
Microsoft Excel is the world's most widely used spreadsheet program and part of the Microsoft Office suite. Excel excels at creating charts, solving numerical problems, and handling non-numerical problems. Formulas in Excel use mathematical instructions and references to cells or ranges to perform calculations using operators, constants, and functions. Scenarios in Excel allow users to model different outcomes by changing inputs and seeing updated results.
This document provides instructions for using Microsoft Excel 2010. It covers how to open Excel, enter and format data, use formulas and functions to calculate totals, insert a column chart, apply themes and styles, and add a header and footer. The instructions culminate in saving the Excel worksheet as a file in the specified folder on the H: drive.
Excel is a spreadsheet program used to store and manipulate data. It consists of workbooks containing worksheets with rows and columns that intersect to form cells. The basic Excel features include functions, auto fill, charts, and pivot tables. Shortcut keys allow quick navigation between tabs, selecting ranges, editing cells, and common commands like save, print, open and close. The document provides an overview of Excel and its key components along with examples of functions and commonly used shortcut keys.
Microsoft Excel is a component of MS Office used to enter, analyze, and present quantitative data. It uses a spreadsheet format laid out in a grid of rows and columns. Excel is commonly used in business for tasks like budgeting, inventory management, and decision making. The Excel window interface includes elements like the ribbon, tabs, quick access toolbar, worksheet, formula bar, and status bar that allow the user to navigate, enter data and formulas, and view information. Formulas in Excel use operators to calculate and return values based on cell data.
PowerPoint is a program used to create professional presentations that can include text, graphics, tables, charts, audio, video and other media. It allows users to easily enter and edit information, incorporate content from other sources, and present information in various ways. Effective presentations require planning, including determining the message, audience and delivery method. PowerPoint provides various views and tools to organize, design and deliver presentations.
This document provides an overview of Microsoft Excel, including its main components and functions. It describes Excel's ribbon interface and the tabs and groups that make up the ribbon. It explains the File tab contains commands related to files, while the Home tab contains formatting and editing commands. The Insert tab adds items like tables, charts, and links. Tabs like Page Layout, Formulas, and Data relate to worksheets, calculations, and external data. The Review and View tabs involve checking, commenting on, and viewing worksheets and workbooks. Terminology for parts of the interface like the title bar, buttons, and worksheet are also defined.
Microsoft PowerPoint is a Microsoft Office product that allows users to design multimedia slide presentations. It incorporates various media types like images, sounds, videos, text, and charts. PowerPoint interacts with other Office applications and is included in most Microsoft Office software packages. The software provides tools for formatting, adding and removing slides, changing slide layouts and views, modifying backgrounds and fonts, and inserting elements like clipart, word art, animations, and smart art.
An introduction to microsoft office 2007 lectureSukh Sandhu
ย
Microsoft Office applications include Outlook, Word, Excel, PowerPoint, and Access. If you are new to this software or are upgrading from a previous version of Microsoft Office study this lecture to learn how to use them. Any questions, send those to me@sukh.co
An Introduction to MS word, Its Tools and Features, fonts, ribbons, and many more features of microsoft word. Adding up new templates and starting of MS Word.
The document provides instructions for formatting cells and cell contents in Excel, including changing cell alignment, merging and splitting cells, wrapping text, applying number formats, borders and styles, setting column width and row height, and other cell formatting options. Key steps include selecting the relevant cells, using formatting tools on the Home tab, and specifying format properties.
This power point can be used to teach children ages 7-12 about some basic functions of the Excel program. This power point helps explain columns, rows, creating graphs & analyzing data. This is a fun power point that can be used as a teaching aid that can allow kids to get excited!
PowerPoint as an Interactive Teaching ToolGeoff Cain
ย
PowerPoint can be an effective interactive teaching tool if used properly, but it also has some drawbacks if overused or used passively. When used interactively with activities like questions, games, and focusing exercises, it can help students engage with and process information. However, it tends to oversimplify information if it becomes the sole delivery method with too many bullet points and not enough discussion. The key is to use PowerPoint to supplement other materials and activities, not replace discussion or other learning methods.
This document provides guidance on using PowerPoint effectively for presentations. It discusses the various toolbars in PowerPoint and how to use them. It also offers tips on creating slides, such as using simple designs with short bullet points, consistent formatting, and colors. The document emphasizes keeping content concise and using visual elements like images, charts and animation effects sparingly to reinforce key points.
1. This document provides instructions for using basic Microsoft Excel functions like opening Excel, navigating the ribbon interface, entering data into cells, formatting cells, using autofill, and other common tasks.
2. It explains the different parts of the Excel interface like tabs, groups, commands, and describes the different data types Excel recognizes.
3. The document provides step-by-step examples for tasks like entering text and numbers, selecting cells, cutting/copying/pasting data, inserting and deleting rows and columns, and using basic formatting options.
Microsoft Excel 2007 is a widely used spreadsheet program that is part of the Microsoft Office suite, with capabilities for performing calculations, organizing data, creating charts and graphics, and automating tasks through macros. Excel allows users to enter and manipulate data in worksheets and perform calculations with formulas, analyze information with built-in functions and tools, and visualize data through a variety of chart types. Key features and functions of Excel 2007 include entering and editing data, working with formulas and functions, formatting worksheets, inserting objects and illustrations, printing and preparing files, reviewing and sharing workbooks, and customizing the Excel environment.
Microsoft Excel allows users to organize data into spreadsheets. It contains workbooks with multiple worksheets made of cells organized into rows and columns. Excel provides functions to perform calculations and analyze data. Users can format worksheets, insert charts and images, and print selections of cells or entire worksheets. Formulas using built-in functions can easily calculate and manipulate data in Excel.
Microsoft Office includes MS Word, Excel, PowerPoint, and Access. MS Word allows users to create documents through operations like opening, saving, printing and editing. It offers features like templates, spelling and grammar check, and mail merge. MS Excel is a spreadsheet program that performs calculations and displays results. It includes functions, charts, and tools for working with data. MS PowerPoint is used to create presentations with text, visuals, and audio. It provides layouts, colors, and transitions. MS Access creates and manages relational databases through tables, forms, queries and reports.
This document provides an introduction to Microsoft Excel. It begins with opening Excel and navigating within workbooks and worksheets. It describes entering different types of data like numbers, text, formulas. It discusses selecting cells, entering and editing data, copying and moving data using fill handle. It also covers saving workbooks in compatibility mode to allow opening in older Excel versions. The document is presented by Abdulbasit H. Mhdi and contains guidance, instructions and screenshots to explain key Excel concepts.
This document provides an overview of Microsoft Excel basics and functions. It covers topics such as formatting cells and data, using mathematical, logical, and financial functions, creating charts, sorting and filtering data, setting print options, and more. Examples of functions include SUM, MIN, MAX, COUNT, IF, NOW, TODAY, DATE, PMT and examples of charts include column, line, pie and bar charts. The document is intended as a training guide for learning Excel.
This document provides an overview of Microsoft Excel basics, including defining key terms like worksheet and workbook, identifying the parts of a worksheet, opening and saving workbooks, entering and editing data, searching and replacing values, zooming and printing worksheets, and closing files. The objectives are to learn the basic functions and navigation of Excel in order to effectively manage and analyze data in spreadsheets.
Microsoft Excel is the world's most widely used spreadsheet program and part of the Microsoft Office suite. Excel excels at creating charts, solving numerical problems, and handling non-numerical problems. Formulas in Excel use mathematical instructions and references to cells or ranges to perform calculations using operators, constants, and functions. Scenarios in Excel allow users to model different outcomes by changing inputs and seeing updated results.
This document provides instructions for using Microsoft Excel 2010. It covers how to open Excel, enter and format data, use formulas and functions to calculate totals, insert a column chart, apply themes and styles, and add a header and footer. The instructions culminate in saving the Excel worksheet as a file in the specified folder on the H: drive.
Excel is a spreadsheet program used to store and manipulate data. It consists of workbooks containing worksheets with rows and columns that intersect to form cells. The basic Excel features include functions, auto fill, charts, and pivot tables. Shortcut keys allow quick navigation between tabs, selecting ranges, editing cells, and common commands like save, print, open and close. The document provides an overview of Excel and its key components along with examples of functions and commonly used shortcut keys.
Microsoft Excel is a component of MS Office used to enter, analyze, and present quantitative data. It uses a spreadsheet format laid out in a grid of rows and columns. Excel is commonly used in business for tasks like budgeting, inventory management, and decision making. The Excel window interface includes elements like the ribbon, tabs, quick access toolbar, worksheet, formula bar, and status bar that allow the user to navigate, enter data and formulas, and view information. Formulas in Excel use operators to calculate and return values based on cell data.
PowerPoint is a program used to create professional presentations that can include text, graphics, tables, charts, audio, video and other media. It allows users to easily enter and edit information, incorporate content from other sources, and present information in various ways. Effective presentations require planning, including determining the message, audience and delivery method. PowerPoint provides various views and tools to organize, design and deliver presentations.
This document provides an overview of Microsoft Excel, including its main components and functions. It describes Excel's ribbon interface and the tabs and groups that make up the ribbon. It explains the File tab contains commands related to files, while the Home tab contains formatting and editing commands. The Insert tab adds items like tables, charts, and links. Tabs like Page Layout, Formulas, and Data relate to worksheets, calculations, and external data. The Review and View tabs involve checking, commenting on, and viewing worksheets and workbooks. Terminology for parts of the interface like the title bar, buttons, and worksheet are also defined.
Microsoft PowerPoint is a Microsoft Office product that allows users to design multimedia slide presentations. It incorporates various media types like images, sounds, videos, text, and charts. PowerPoint interacts with other Office applications and is included in most Microsoft Office software packages. The software provides tools for formatting, adding and removing slides, changing slide layouts and views, modifying backgrounds and fonts, and inserting elements like clipart, word art, animations, and smart art.
An introduction to microsoft office 2007 lectureSukh Sandhu
ย
Microsoft Office applications include Outlook, Word, Excel, PowerPoint, and Access. If you are new to this software or are upgrading from a previous version of Microsoft Office study this lecture to learn how to use them. Any questions, send those to me@sukh.co
An Introduction to MS word, Its Tools and Features, fonts, ribbons, and many more features of microsoft word. Adding up new templates and starting of MS Word.
The document provides instructions for formatting cells and cell contents in Excel, including changing cell alignment, merging and splitting cells, wrapping text, applying number formats, borders and styles, setting column width and row height, and other cell formatting options. Key steps include selecting the relevant cells, using formatting tools on the Home tab, and specifying format properties.
This power point can be used to teach children ages 7-12 about some basic functions of the Excel program. This power point helps explain columns, rows, creating graphs & analyzing data. This is a fun power point that can be used as a teaching aid that can allow kids to get excited!
PowerPoint as an Interactive Teaching ToolGeoff Cain
ย
PowerPoint can be an effective interactive teaching tool if used properly, but it also has some drawbacks if overused or used passively. When used interactively with activities like questions, games, and focusing exercises, it can help students engage with and process information. However, it tends to oversimplify information if it becomes the sole delivery method with too many bullet points and not enough discussion. The key is to use PowerPoint to supplement other materials and activities, not replace discussion or other learning methods.
This document provides guidance on using PowerPoint effectively for presentations. It discusses the various toolbars in PowerPoint and how to use them. It also offers tips on creating slides, such as using simple designs with short bullet points, consistent formatting, and colors. The document emphasizes keeping content concise and using visual elements like images, charts and animation effects sparingly to reinforce key points.
Microsoft PowerPoint is a presentation program developed by Microsoft as part of its Microsoft Office suite. It allows users to create slideshow presentations consisting of text, images, videos, and other objects that can be displayed on-screen or printed. PowerPoint has tools for inserting tables, charts, graphics, and other media and formatting slide layouts, as well as tools for animating and transitioning between slides during a live presentation. The main components of the PowerPoint interface include the ribbon, which contains tabs for commonly used tools, and the Microsoft Office button for creating new presentations or accessing recently opened ones.
Microsoft PowerPoint is a program used to create slideshow presentations. It allows users to choose layouts, content, designs, templates, animations and transitions for their slides. Originally called PRESENTER and developed by Forethought, Inc., it was acquired by Microsoft in 1987 and renamed to PowerPoint. It provides templates, design options and tips to help users create effective presentations.
How to create a basic power point presentationjoluisae
ย
This document provides instructions for creating a basic PowerPoint presentation in 9 steps:
1) Open PowerPoint and save your project, saving often to prevent data loss.
2) Create a title slide with the presentation title and subtitle.
3) Choose a slide design template.
4) Add new slides and edit the slide layout.
5) Add text to slides by adjusting font settings.
6) Add pictures to slides by inserting images from your computer.
7) Create multiple slides by following steps 4-6.
8) Add slide transitions by selecting different transition styles and settings.
9) Repeat step 8 to add transitions to other slides and preview the completed presentation.
This document provides an overview of key Excel features and functions for formatting worksheets, entering and editing data, printing worksheets, and more. It discusses topics like the Excel interface, creating and saving workbooks/worksheets, inserting and deleting rows/columns, formatting cells and worksheets, using auto-fill, and printing options for worksheets or the entire workbook. The document is intended as a basic introduction and reference for common Excel tasks.
This document provides an overview of key Excel features and functions for formatting worksheets, entering and editing data, printing worksheets, and more. It discusses topics like the Excel interface, creating and saving workbooks/worksheets, inserting and deleting rows/columns, formatting cells and worksheets, using auto-fill, and printing options for worksheets or selections. The document is intended as a basic introduction and reference for common Excel tasks.
This document provides an introduction and overview of Microsoft Excel. It discusses key aspects of Excel including its use as a spreadsheet program to record and analyze numerical data in columns and rows. It describes the Office button, formatting text, inserting rows and columns, sorting and editing data, using formulas and functions, and some shortcut keys.
Microsoft Excel is a spreadsheet application that allows users to organize and calculate data across rows and columns in a workbook. It can import various data types and formats them for analysis. Excel uses formulas and functions to perform calculations on cell values. Common functions include SUM to add values and AVERAGE to calculate means. Charts and graphs can visually represent spreadsheet data. Workbooks may contain multiple worksheets to organize different data sets.
Microsoft Excel is a spreadsheet application that allows users to organize and calculate data across rows and columns in a workbook. It can import various data types and formats them for analysis. Excel uses formulas and functions to perform calculations on cell values. Common functions include SUM to add values and AVERAGE to calculate means. Charts and graphs can visually represent spreadsheet data. Workbooks may contain multiple worksheets to organize different data sets.
Microsoft Excel is a spreadsheet application that allows users to organize and calculate data across rows and columns in a workbook. It can import various data types and formats them for analysis. Excel uses formulas and functions to perform calculations on cell values. Common functions include SUM to add values and AVERAGE to calculate means. Charts and graphs can visually represent data. Workbooks may contain multiple worksheets to organize related data in different tables.
Excel is an application used to create spreadsheets containing numerical values, formulas, and charts. It allows users to enter data into cells organized into rows and columns and perform calculations on that data. The basic elements of an Excel file include worksheets containing grids of cells organized by column letters and row numbers, grouped together in workbooks. Formulas and functions can be used to calculate and analyze the data in cells. Common tasks like formatting, sorting, conditional formatting, and summarizing data help users understand and visualize information in Excel spreadsheets.
This document provides an overview of basic MS Excel functions including creating and opening workbooks, navigating worksheets, entering different types of data like text, numbers, dates and times, formatting cells, editing data, inserting and deleting columns and rows, and using basic formulas. It explains key Excel concepts such as the ribbon, columns, rows and cells, worksheets, cell references, and functions. It provides step-by-step instructions for common tasks in Excel.
This document provides an introduction to Microsoft Excel by covering the Excel interface, opening and saving worksheets, entering and editing data, building formulas and functions, and formatting and printing data. It explores the components of the Excel window including the standard toolbar, formatting toolbar, formula bar, name box, row and column headings, active cell, and fill handle. It also describes how to enter and edit data, move around the worksheet, copy and move data, and work with Excel documents by opening, saving, and creating new workbooks.
Microsoft Excel is a spreadsheet program that allows users to enter, organize, and analyze data. It maintains records relating to finances, products, activities, events, and services. Excel workbooks contain individual worksheets made up of cells organized into rows and columns. Formulas can be used to perform calculations with cell values. Navigation between cells can be done using the mouse, keyboard shortcuts, or by entering cell references.
ms excel for mba first sem students of dr hs gour university sagar(m.p)gaurav jain
ย
This document provides an overview and introduction to Microsoft Excel. It discusses the Excel screen layout including titles bars, menus, toolbars, and worksheets. It describes how to navigate and enter data into cells. Various Excel functions are also outlined such as formulas for addition, subtraction, multiplication and division. Other topics covered include formatting worksheets, creating charts, printing, and keyboard shortcuts. The document serves as a basic guide for getting started using Excel.
The document provides an introduction to Microsoft Excel by covering key topics such as the Excel interface, entering and editing data, building formulas and functions, formatting cells and data, and printing. It explains how to open and save Excel files, navigate and select cells, clear cell contents, copy and move data, and get help. Formulas, functions, formatting, and printing are described in more detail.
This document defines key terms related to the Excel user interface and workbooks. It describes:
1) The main components of the Excel interface including the title bar, menus, toolbars, worksheet, cells, and sheet tabs.
2) How workbooks contain worksheets made up of columns and rows that intersect to form cells.
3) How to navigate within and between worksheets using keyboard shortcuts, scroll bars, and sheet tabs.
This document provides training on creating a workbook in Microsoft Excel 2007. It covers topics such as opening a new workbook, understanding worksheets and cells, entering data, and editing data. The training is broken into 3 lessons:
1) Meet the workbook - Covers basics like the ribbon interface, workbooks, worksheets, columns, rows, and cells.
2) Enter data - Explains how to enter text, numbers, dates, and times. Also covers quick data entry methods like AutoComplete and AutoFill.
3) Edit data and revise worksheets - Shows how to edit existing data, remove data formatting, and add or delete columns and rows. Practice questions and exercises are included.
This document provides a training course on creating a workbook in Microsoft Excel 2007. It covers topics such as opening a new workbook, entering data, editing data, and revising worksheets by inserting and deleting columns and rows. The training includes lessons on meeting the workbook, entering data, and editing data. It provides instructions, screenshots and examples for common tasks in Excel as well as practice questions for each lesson.
Microsoft Excel 2007: Create Your First Workbookomoviejohn
ย
This document provides an overview and lessons for a Microsoft Excel 2007 training course on creating a workbook. The course covers entering and editing data in Excel by teaching students how to create and navigate workbooks and worksheets, enter text, numbers, dates and times into cells, and use the ribbon interface. The goals are to create a new workbook, enter and edit data, and insert and delete columns and rows. Lesson 1 focuses on the workbook, worksheets, columns, rows and cells, and Lesson 2 covers entering data into cells.
This document provides an overview and contents of a 3-day Microsoft Excel 2010 training course. The training is intended for beginners and will cover setting up workbooks, customizing the Excel window, working with data and tables, applying visual effects, and printing workbooks. Specific topics include entering data into cells, editing data, formatting cells, and inserting and deleting columns and rows.
Uses & applications of microsoft excel in vph researchDr Alok Bharti
ย
Microsoft Excel is a spreadsheet application that allows users to enter and organize data into columns and rows, perform calculations with formulas, and visualize data through graphs and charts. It consists of worksheets where data is entered into cells that are organized by columns and rows. Common functions include formatting cells, filtering and sorting data, and using formulas to analyze data through calculations and pivot tables to examine relationships between variables.
This document provides instructions for starting a new workbook in Excel by creating a blank workbook, inserting text into cells, editing and deleting text, navigating through the worksheet using keyboard shortcuts, and saving the workbook. It explains how to select cells and enter text, delete text using backspace or delete keys, move through the sheet using tab and arrow keys, and save the workbook for the first time or with a new name. The challenge at the end asks the user to practice these skills in a new blank workbook.
This document provides an overview and lessons for creating your first workbook in Microsoft Excel 2007. It covers topics such as opening a new workbook, entering data into cells, editing data, and inserting/deleting columns and rows. The lessons include instructions and screenshots to help the reader learn Excel basics like working with the ribbon interface, entering text, dates, numbers, and using auto-complete and auto-fill functions. Practice questions and answers are provided to test comprehension. The overall goal is to teach the skills needed to work in Excel and create a basic workbook.
Slavery was introduced to the British North American colonies in 1619 when approximately 20 Africans were sold as slaves in Jamestown, Virginia. While slavery was banned in the Northwest Territory in 1787, it was not abolished nationwide until the passage of the 13th amendment in 1865 after the Civil War, which the South fought to protect their right to own slaves.
From a barn to a one-room schoolhouse to a system with over 25 buildings, discover the changes in education from 1808 to today. For more information, visit www.westervillelibrary.org.
The document provides information about upcoming events at the Westerville Public Library in Westerville, Ohio. It announces that Emily Giffin, a popular author of chick lit novels, will be visiting the library on April 6th for a presentation and book signing. It also advertises the library's hoopla digital service which allows patrons to instantly borrow movies, music, audiobooks and more with no wait times or late fees. Additionally, it provides a schedule of upcoming children's and adult programs at the library throughout April and May.
The document provides information about upcoming events at the Westerville Public Library in Westerville, Ohio for winter 2016-2017. It includes details about author presentations by Chris Bohjalian and Lisa Wood, cooking demonstrations, music performances, reading programs for adults and children, and assistance for students preparing Ohio History Day projects. The library has once again been recognized as a Five-Star Library by Library Journal, placing it in the top 1% of libraries nationally.
Hoopla for Libraries: Instructions for Your Computer or DeviceWesterville Library
ย
Hoopla is a digital media lending platform available through Westerville Library that allows users to stream or download movies, TV shows, music, eBooks, audiobooks and comics to their computers, tablets, phones and e-readers by accessing content with their library card. Users can browse and search Hoopla's catalog, check out available titles, and the loans will automatically return at the end of the lending period, ranging from 3 days for movies/TV to 21 days for eBooks/audiobooks. The instructions guide users through creating an account, accessing content from any device using the Hoopla app, and playing or downloading checked out titles.
The document provides information about upcoming events at the Westerville Public Library, including presentations on genealogy research, a water project in Congo, preventing child abduction, local author talks, and activities for youth like an ice cream social and making guacamole. It also announces that the Library Link program awarded top-participating schools Mark Twain Elementary and Heritage Middle School for most materials delivered to students this school year.
This document provides information about upcoming events at the Westerville Public Library in Westerville, Ohio. It announces that Pulitzer Prize-winning author Anthony Doerr will give a presentation and book signing on May 7. It also advertises sports-themed activities for children and teens from May 26-June 30 as part of the library's summer reading program. Additionally, it invites community members to participate in surveys and video interviews during National Library Week from April 10-16 for a chance to win a gift card.
This annual report summarizes the Westerville Public Library's activities and accomplishments in 2015. It highlights that the library hosted a popular author event series and circulated over 2 million items. It also details new services offered including 3D printing and WiFi hotspots, facility improvements like upgrades to the local history center, and strong financial support from the local community.
The first pioneers came to Westerville using an Indian trail that became 161. More than 150 years passed before the completion of I-270 at Westerville Road. Vehicles changed from horse and oxen-drawn wagons to cars, trucks and motorcycles fueled by gas, diesel and electricity. The arrival of the train and trolley were greeted with great excitement by Westerville citizens but both disappeared as new forms of transportation became popular.
If those pioneers who came here 200 years ago could visit today, we can only imagine their shock at the changes in transportation: forests have become roads; bridges span the local creeks; airplanes occupy the sky with the birds; and cars travel busy highways at 70 miles per hour arriving quickly at their destinations.
For more information, visit www.westervillelibrary.org
8+8+8 Rule Of Time Management For Better ProductivityRuchiRathor2
ย
This is a great way to be more productive but a few things to
Keep in mind:
- The 8+8+8 rule offers a general guideline. You may need to adjust the schedule depending on your individual needs and commitments.
- Some days may require more work or less sleep, demanding flexibility in your approach.
- The key is to be mindful of your time allocation and strive for a healthy balance across the three categories.
Information and Communication Technology in EducationMJDuyan
ย
(๐๐๐ ๐๐๐) (๐๐๐ฌ๐ฌ๐จ๐ง 2)-๐๐ซ๐๐ฅ๐ข๐ฆ๐ฌ
๐๐ฑ๐ฉ๐ฅ๐๐ข๐ง ๐ญ๐ก๐ ๐๐๐ ๐ข๐ง ๐๐๐ฎ๐๐๐ญ๐ข๐จ๐ง:
Students will be able to explain the role and impact of Information and Communication Technology (ICT) in education. They will understand how ICT tools, such as computers, the internet, and educational software, enhance learning and teaching processes. By exploring various ICT applications, students will recognize how these technologies facilitate access to information, improve communication, support collaboration, and enable personalized learning experiences.
๐๐ข๐ฌ๐๐ฎ๐ฌ๐ฌ ๐ญ๐ก๐ ๐ซ๐๐ฅ๐ข๐๐๐ฅ๐ ๐ฌ๐จ๐ฎ๐ซ๐๐๐ฌ ๐จ๐ง ๐ญ๐ก๐ ๐ข๐ง๐ญ๐๐ซ๐ง๐๐ญ:
-Students will be able to discuss what constitutes reliable sources on the internet. They will learn to identify key characteristics of trustworthy information, such as credibility, accuracy, and authority. By examining different types of online sources, students will develop skills to evaluate the reliability of websites and content, ensuring they can distinguish between reputable information and misinformation.
(๐๐๐ ๐๐๐) (๐๐๐ฌ๐ฌ๐จ๐ง 3)-๐๐ซ๐๐ฅ๐ข๐ฆ๐ฌ
Lesson Outcomes:
- students will be able to identify and name various types of ornamental plants commonly used in landscaping and decoration, classifying them based on their characteristics such as foliage, flowering, and growth habits. They will understand the ecological, aesthetic, and economic benefits of ornamental plants, including their roles in improving air quality, providing habitats for wildlife, and enhancing the visual appeal of environments. Additionally, students will demonstrate knowledge of the basic requirements for growing ornamental plants, ensuring they can effectively cultivate and maintain these plants in various settings.
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024yarusun
ย
Are you worried about your preparation for the UiPath Power Platform Functional Consultant Certification Exam? You can come to DumpsBase to download the latest UiPath UIPATH-ADPV1 exam dumps (V11.02) to evaluate your preparation for the UIPATH-ADPV1 exam with the PDF format and testing engine software. The latest UiPath UIPATH-ADPV1 exam questions and answers go over every subject on the exam so you can easily understand them. You won't need to worry about passing the UIPATH-ADPV1 exam if you master all of these UiPath UIPATH-ADPV1 dumps (V11.02) of DumpsBase. #UIPATH-ADPV1 Dumps #UIPATH-ADPV1 #UIPATH-ADPV1 Exam Dumps
Post init hook in the odoo 17 ERP ModuleCeline George
ย
In Odoo, hooks are functions that are presented as a string in the __init__ file of a module. They are the functions that can execute before and after the existing code.
The Science of Learning: implications for modern teachingDerek Wenmoth
ย
Keynote presentation to the Educational Leaders hui Koฬkiritia Marautanga held in Auckland on 26 June 2024. Provides a high level overview of the history and development of the science of learning, and implications for the design of learning in our modern schools and classrooms.
How to Download & Install Module From the Odoo App Store in Odoo 17Celine George
ย
Custom modules offer the flexibility to extend Odoo's capabilities, address unique requirements, and optimize workflows to align seamlessly with your organization's processes. By leveraging custom modules, businesses can unlock greater efficiency, productivity, and innovation, empowering them to stay competitive in today's dynamic market landscape. In this tutorial, we'll guide you step by step on how to easily download and install modules from the Odoo App Store.
2. Creatingโฉaโฉnewโฉworkbookโฉ
When you start Excel, you open a workbook that is called Book1. Each new workbook comes
with three worksheets, like pages in a document. You enter data into the worksheets.
(Worksheets are sometimes called spreadsheets.) The illustrated workbook has three tabs, one for
each of the three worksheets.
Clickโฉthisโฉtabโฉtoโฉaddโฉaโฉnewโฉworksheet.โฉ
โฉ
It's a good idea to rename the sheet tabs to make the information on each sheet easier to identify.
For example, you might have sheet tabs called January, February, and March for budgets or
student grades for those months, or Northcoast and Westcoast for sales regions.โฉYou can add and
delete additional worksheets as needed. To rename the sheet tabs right-click on the tab and click
Rename in the menu options.
To create a new workbook:
โข Click the Microsoft Office Button at the upper left.
โข Then click New.
โข In the New Workbook window, click Blank workbook.
โฉ
2โฉ
3. TheโฉOfficeโฉRibbonโฉ
1โฉ โฉ 2โฉ
4โฉ
3โฉ
โฉ
1. TheโฉMicrosoftโฉOfficeโฉButton:โฉThis button takes the place of the File menu in previous
office programs.โฉ
โฉ
ThingsโฉthatโฉyouโฉcanโฉdoโฉwithโฉtheโฉOfficeโฉButton:โฉ
โข Create a new document
โข Open a document
โข Save and Save as
โข Print
โข Prepare
โข Send
โข Publish
โข Close
โข Open recent documents
โข Word Options
โฉ
โฉ
3โฉ
4. 2. QuickโฉAccessโฉToolbar:โฉCommands can be added to and removed from this toolbar. This is
a good place to add commands that you use often.โฉ
3. Tabs:โฉSits across the top of the Ribbon. Once you select a given tab (Home, Insert, Page
Layout, etc.), different task buttons will appear.โฉ
4. HelpโฉButton:โฉThis button will open up a help window; you will need an Internet
connection to use this function.โฉ
HowโฉdataโฉisโฉorganizedโฉinโฉExcelโฉ
Excel organizes data in a grid of cells, columns (1), and rows (2).
โข Columns go from top to bottom on the worksheet, vertically. Column headings are
indicated by letters.
โข Rows go from left to right on the worksheet, horizontally. Row headings are indicated by
numbers.
โข A cell is the space where one column and one row meet. The content of a cell is uniquely
identified based on the intersection where the column and row meet. To refer to a cell,
you will need to find the column letter and the row number. (For example, the first cell
in a worksheet is referred to as A1).
โฉ
4โฉ
5. When you open a new workbook, the first cell is the active cell. It has a black outline. In the
second picture, cell C5 is selected and is the active cell. It is outlined in black.
1. Column C is highlighted.
2. Row 5 is highlighted.
3. Cell C5, the active cell, is shown in the Name Box in the upper-left corner of the
worksheet.
You can enter data by clicking any cell in the worksheet.
Keep in mind that there are 17,179,869,184 cells on each worksheet. You could get lost without
the cell reference to tell you where you are.
EnteringโฉDataโฉ
โฉ
โฉ
5โฉ
6. When you enter data, it's a good idea to start by entering titles at the top of each column and
beginning of each row so that anyone who shares your worksheet can understand what the data
means (and so that you can understand it yourself, later on).
In the above picture, the column titles are the months of the year, across the top of the worksheet.
To change the active cell, press TAB to move one cell to the right. Press ENTER to move down
one cell.
Enterโฉdateโฉandโฉtimeโฉ
โฉ
6โฉ
7. Excel aligns text on the left side of cells, but it aligns dates on the right side of cells.
To enter a date in column B, the Date column, you should use a slash or a hyphen to separate the
parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a date.
If you need to enter a time, type the numbers, a space, and then "a" or "p" โ for example, 9:00
p. If you enter just the number, Excel automatically recognizes a time and enters it as AM.
Tip: To enter today's date, press CTRL and the semicolon (;) together. To enter the current time,
press CTRL and SHIFT and the semicolon all at once.
Enterโฉnumbersโฉ
โฉ
Excel aligns numbers on the right side of cells.
To enter the sales amounts in column C, the Amount column, you would type the dollar sign ($),
followed by the amount.
Other numbers and how to enter them:
โข To enter fractions, leave a space between the whole number and the fraction. For
example, 1 1/8.
โข To enter a fraction only, enter a zero first. For example, 0 1/4. If you enter 1/4 without the
zero, Excel will interpret the number as a date, January 4.
โข To enter a negative number, type the number in parenthesis, such as (100). Excel will
display the number as -100.
Quickโฉwaysโฉtoโฉenterโฉdataโฉ
Here are two time-savers you can use to enter data in Excel:
AutoFill Enter the months of the year, the days of the week, multiples of 2 or 3, or other data
in a series. You type one or more entries, and then extend the series by dragging the corner of the
cell.
AutoComplete If the first few letters you type in a cell match an entry you've already made in
that column, Excel will fill in the remaining characters for you. Just press ENTER when you see
them added. This works for text or for text with numbers. It does not work for numbers only, for
dates, or for times.
โฉ
7โฉ
8. Editโฉdataโฉ
1. Double-click a cell to edit the data in it.
2. Or, after clicking in the cell, edit the data in the formula bar.
3. The worksheet displays Edit in the status bar.
Remember to press ENTER or TAB when you are finished so that your changes stay in the cell.
Removeโฉdataโฉformattingโฉ
โฉ
8โฉ
9. Excel often formats your cells based on certain criteria. If you want to remove any formatting
automatically created by Excel, click in the cell and then, on the Home tab, in the Editing group,
click the arrow on the Clear Button image. Then click Clear Formats, which removes the
format from the cell. Or you can click Clear All to remove both the data and the formatting at
the same time.
โฉ
Toโฉinsertโฉaโฉcolumn:โฉ
โข Click any cell in the column immediately to the right of where you want the new column
to go. So if you want to add a column between columns B and C, you'd click a cell in
column C, to the right of the new location.
โข Then, on the Home tab, in the Cells group, click the arrow on Insert.
โข On the drop-down menu, click Insert Sheet Columns.
โข A new blank column is inserted.
Toโฉinsertโฉaโฉrow:โฉ
โข Click any cell in the row immediately below where you want the new row to go.
โข For example, to insert a new row between row 4 and row 5, click a cell in row 5.
โข Then in the Cells group, click the arrow on Insert.
โข On the drop-down menu, click Insert Sheet Rows.
โข A new blank row is inserted.
SizingโฉRowsโฉandโฉColumnsโฉ
To change the size of a row or column, move your cursor over the top of the divider on the top
(for a column) or left side (for a row) of the spreadsheet. When the pointer turns into a cross with
arrows you can click and drag the divider to where you want it. You also can double-click on the
divider and it will automatically adjust to fit the data in the row or column.
Howโฉtoโฉsaveโฉaโฉfileโฉโฉ
โฉ
To save a workbook in Excel:
โข Click on the Office button and choose Save As.
โข Where it says Save as Type choose, Excel 97-03 Workbook from the list.
โข You will be asked to name the file and then choose a location for the file.
โข Note: You can save the document as an Excel 2007 file, but if you will be sharing files
with someone who still uses Office 2003, they will be unable to open your file. It is best
practice to save your files as Excel 97-03 documents.
โฉ
9โฉ
10. EnteringโฉFormulasโฉ
โฉ
The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the
CD expense for the month.
You can add these values in Excel by typing a simple formula into cell C6.
Excel formulas always begin with an equal sign (=). Here's the formula typed into cell C6 to add
12.99 and 16.99:
=12.99+16.99
The plus sign (+) is a math operator that tells Excel to add the values.
If you wonder later on how you got this result, the formula is visible in the formula bar Formula
bar near the top of the worksheet whenever you click in cell C6 again.
โฉ
Howโฉtoโฉuseโฉmathโฉoperatorsโฉ
โฉ
Mathโฉoperatorsโฉ
Addโฉ(+)โฉ =10+5โฉ
Subtractโฉ(โ)โฉ =10โ5โฉ
Multiplyโฉ(*)โฉ =10*5โฉ
Divideโฉ(/)โฉ =10/5โฉ
โฉ
โข Excel uses familiar signs to build formulas.
โข To do more than add, use other math operators as you type formulas into worksheet cells.
โข Remember to always start each formula with an equal sign.
โฉ
10โฉ
11. Totalโฉallโฉtheโฉvaluesโฉinโฉaโฉcolumnโฉ
โฉ
โฉ
โฉ
To add up the total of expenses for January, you don't have to type all those values again.
Instead, you can use a prewritten formula, called a function.
You can get the January total in cell B7 by highlighting the cells you want to add together, then
clicking Sum in the Editing group on the Home tab. This enters the SUM function, which
adds up all the values in a range of cells. To save time, use this function whenever you have
more than a few values to add up, so that you don't have to type the formula.
Pressing ENTER displays the SUM function result 95.94 in cell B7. The formula
=SUM(B3:B6) appears in the formula bar whenever you click in cell B7.
B3:B6 is the information, called the argument, which tells the SUM function what to add. By
using a cell reference (B3:B6) instead of the values in those cells, Excel can automatically update
results if values change later on. The colon (:) in B3:B6 indicates a cell range in column B, rows
3 through 6. The parentheses are required to separate the argument from the function.
Copyโฉaโฉformulaโฉ
โฉ
Sometimes it's easier to copy formulas than to create new ones. In this example, you'll see how to
copy the formula you used to get the January total and use it to add up the February expenses.
โฉ
11โฉ
12. 1. Drag the black cross from the cell containing the formula to the cell where the formula
will be copied, and then release the fill handle.
2. Auto Fill Options button appears but requires no actions.
Cellโฉreferencesโฉ
โฉ
Cellโฉreferencesโฉ Referโฉtoโฉvaluesโฉinโฉ
A10โฉ theโฉcellโฉinโฉcolumnโฉAโฉandโฉrowโฉ10โฉ
A10,A20โฉ cellโฉA10โฉandโฉcellโฉA20โฉ
A10:A20โฉ theโฉrangeโฉofโฉcellsโฉinโฉcolumnโฉAโฉandโฉrowsโฉ10โฉthroughโฉ20โฉ
B15:E15โฉ theโฉrangeโฉofโฉcellsโฉinโฉrowโฉ15โฉandโฉcolumnsโฉBโฉthroughโฉEโฉ
A10:E20โฉ theโฉrangeโฉofโฉcellsโฉinโฉcolumnsโฉAโฉthroughโฉEโฉandโฉrowsโฉ10โฉthroughโฉ20โฉ
โฉ
Cell references can indicate particular cells or cell ranges in columns and rows.
โฉ
12โฉ
13. You can type cell references directly into cells, or you can enter cell references by clicking cells,
which avoids typing errors.
In the first lesson you saw how to use the SUM function to add all the values in a column. You
could also use the SUM function to add just a few values in a column, by selecting the cell
references to include.
Imagine that you want to know the combined cost for video rentals and CDs in February. You
don't need to store the total, so you could enter the formula in an empty cell and delete it later.
The example uses cell C9.
The example shows you how to enter the formula. You would click the cells you want to include
in the formula instead of typing the cell references. A color marquee surrounds each cell as it is
selected and disappears when you press ENTER to display the result 45.94. The formula
=SUM(C4,C6) appears in the formula bar near the top of the worksheet whenever cell C9 is
selected.
The arguments C4 and C6 tell the SUM function what values to calculate with. The parentheses
are required to separate the arguments from the function. The comma, which is also required,
separates the arguments.
Simplifyโฉusingโฉformulasโฉwithโฉfunctionsโฉ
โฉ
Functionโฉnameโฉ Calculatesโฉ
AVERAGEโฉ Anโฉaverageโฉ
MAXโฉ Theโฉmaximumโฉnumberโฉ
MINโฉ Theโฉminimumโฉnumberโฉ
โฉ
โฉ
13โฉ
14. SUM is just one of the many Excel functions. These prewritten formulas simplify the process of
entering calculations. Using functions, you can easily and quickly create formulas that might be
difficult to build.โฉ
โฉ
โฉ
โฉ
To find the average of a range, click in cell D7, and then:โฉ
โฉ
1. On the Home tab, in the Editing group, click the arrow on the Sum button , and
then click Average in the list.โฉ
2. Press ENTER to display the result in cell D7.โฉ
โฉ
โฉ
โฉ
โฉ
14โฉ
15. To find the largest value in a range, click in cell F7 and then:โฉ
โฉ
1. On the Home tab, in the Editing group, click the arrow on the Sum button, and then
click Max in the list.โฉ
2. Press ENTER to display the result in cell F7.โฉ
โฉ
Printโฉformulasโฉ
โฉ
You can print formulas and put them up on your bulletin board to remind you how to create
them.
To print formulas, you need to display formulas on the worksheet:
โข Click the Formulas tab, and in the Formula Auditing group, clicking Show Formulas
Button image.
โข Then click the Microsoft Office Button in the upper left, and click Print.
โฉ
Tips:โฉ
โข Hide the formulas on the worksheet by repeating the step to display them.โฉ
โข You can also press CTRL+` (the ` key is next to the 1 key on most keyboards) to display
and hide formulas.โฉ
โข Displaying formulas can also help you spot errors.โฉ
โฉ
โฉ
โฉ
โฉ
15โฉ