Parts of microsoft excel 2016 and its function ppt free download.www.TestsTestsTests.com
Recently Used.Functions and formulas of ms excel
If you are new to Excel, it is highly recommended that you familiarize yourself with the layout and terminology for all the parts of the Excel screen. The Microsoft Excel Ribbon is where you will find all the functions, options and settings to use Excel efficiently. The Ribbon in Excel contains options fubction everything: from making your Excel worksheet look good and setting out how your worksheets print, to building complex financial or programmatic formulas and functions.
Before you can explore the rest of the MS Excel screen, understanding how the Ribbon and menu items are organized, is essential. Study the image of the Excel screen below. The Ribbon has been outlined in yellow:. Tabs – the Excel Ribbon will change, displaying different function buttons, depending on which tab is selected.
The function buttons that display on the Ribbon relate to страница Tab that is selected. In the example below, the Home tab is selected and the functions which display relate to essential Excel functions such as cutting and pasting, formatting text and setting cell alignment. The function buttons on the Ribbon in Excel is divided into groups of parts of microsoft excel 2016 and its function ppt free download function buttons. Parts of microsoft excel 2016 and its function ppt free download example, the Font group contains function buttons pertaining to changing the font type, size and color.
This makes it easy to find functions on the Ribbon in the Excel screen. The dialog downlooad launcher opens a box that has additional and advanced options relating to a specific group on the Ribbon. Downloaf example, if you are looking for a font option that you cannot see within the Font group under the Home tab, click on the dialog box launcher to see additional options, like superscript and strikethrough. The dialog box launcher button is very small and easily missed — we have magnified it for you in the screenshot above.
Can you see the relationship of each tab to the groups and functions that appear when the tab is selected? Look at the groups and how they are organized. Do all funcfion have dialog box launchers? Resize your Excel window. What happens to the Ribbon? Does it stay the same or does it look different? What options do you have when you right-click on the Ribbon windows 10 pc amazon download The Excel Quick Access Toolbar is like a mini-Ribbon and very useful for option buttons you use frequently, saving you time in having to navigate through the Excel Ribbon and function groups to find a specific option.
Functions are displayed as icon buttons. It is easy to add additional microsoft net framework 4.5 for windows 7 ultimate free download free download options to the Quick Access Toolbar in Excel: either click on the More Options arrow labelled as 2 in the screenshot above OR right-click on any option on the Excel Ribbon, and select to add the option to the QAT.
It is worth making the effort to master the skill of adding and removing options to this mini-menu in Excel:. What happens when you hover your mouse cursor over the function shortcut icons in the QAT? Does it display the function name? The area of the Excel screen where you add text, numbers or graphical content, is like no other word processing or design program you may have experience with using. An Excel worksheet, also called a spreadsheet, is divided into multiple columns and rows 1, rows by 16, columns to be exact.
For downoad worksheet you create, you use only as many rows and columns as you need for your data and ignore the blank, unused rows and columns. You can also merge data across columns or rows and add separate lines of content within the same cell.
The area labelled as 1 contain the column labels. Columns are labelled alphabetically, with the first column being A. The area labelled as 2 contain the row labels. Rows are labelled numerically, with the first row being 1. Each block within an Excel worksheet is parts of microsoft excel 2016 and its function ppt free download a cell. Each cell has an address based on the column and row intersection they appear in.
In the image above, the cell labelled as 3, is located in Column I and Row 6. One of the reasons Excel works with a grid divided into cells, is to enable the content of each cell to be treated both individually and collectively with other cells rows and columns to be used in calculations in formulas and functions and for data analysis. Can you identify the column and row labels?
Is it easy to see the grid? Microosft you find the cell location for cell C9 on your sheet? Worksheets, also known as spreadsheets, within an Excel workbook, are the digital versions of the different tabbed sections you would find in a traditional paper folder. You may, for example, have an invoice folder, where you inserted tabs for each month of the year to separate and organize invoices into month sections.
In Microsoft Excel, these tab padts or dividers are called Worksheets. In the screenshot below is an pph of a workbook containing five visible worksheet tabs:. Depending on the workbook you are viewing, the worksheet labels will parts of microsoft excel 2016 and its function ppt free download different. In a blank new workbook, a worksheet label will be titled Sheet1. When you click on a worksheet tab label, that worksheet will open. When a workbook contains multiple worksheets, these may not all be visible at the same time due to space constraints.
In the area labelled 2 in the screenshot above, you will find arrows to navigate backwards and forwards through all the worksheets in an Excel workbook. The Lpt New Worksheet button is labelled as 3 in the screenshot above. /12739.txt add more worksheets to a downlaod, click the plus sign. Can you identify the worksheet tabs easily?
Add 15 new worksheets to the workbook. Are you able to navigate and view all the individual fo tabs in the workbook? The Name Box and Formula Bar, which are parts of microsoft excel 2016 and its function ppt free download in the area between the Ribbon and the worksheet grid, serve two purposes: they microsofg you with information about the cell or collection читать полностью cells you have selected and you can insert information into them to name and add content to selected cell s.
In the screenshot example below, the Name Box and Formula Bar are labelled as 1 and The Name Box contains the name of the cell which is selected within the worksheet. The Name Box therefore displays the cell address which is: B4. The Name Parts of microsoft excel 2016 and its function ppt free download can also contain customized names for cells or ranges of cells. The Excel Formula Bar reflects the contents of the cell which is selected.
In this Worksheet cell B4, which is selected, contains the word Norton. You can type directly into the formula bar to change the cell contents. The Formula Bar becomes really useful when a worksheet contains formulas or functions, where the worksheet cell will display the result of the calculation, the Formula Bar will display the actual formula or function.
When you look at a worksheet, can you identify:. Where the Name Box is? Where the Formula Bar is? Cover the Name Box with one hand /22463.txt selecting different cells in the worksheet. See if you can guess what the Name Box will display with each cell you select.
What happens when you click in the Formula Bar and type your name followed by pressing the Enter Key? You will find the QAT смотрите подробнее the top left-hand corner of your Excel screen: 1.
It is worth making the effort to master the skill of adding and removing options to this mini-menu in Excel: 1. To understand how this works, lets study the worksheet in the image below: 1. In the screenshot below is an example of a workbook containing five visible worksheet tabs: 1. In the screenshot example below, the Name Box and Formula Bar are labelled as 1 and 2: 1.
When you look at a worksheet, can you identify: 1. More Microsoft Excel 1. What is Anf Excel? What MS Excel Training is best for you? QUIZ 4. What version of Excel are you using? Free Excel Templates – get organized 1. TEST 2.
Parts of microsoft excel 2016 and its function ppt free download.Microsoft Excel Basics
A spreadsheet is an accounting program for the computer. Spreadsheets are primarily used to work with numbers and text. Spreadsheets can help organize information, such as alphabetizing a list of names or ordering records, and calculate and analyze information using mathematical formulas.
The menu bar displays all of the menus available for use in Excel XP. The contents of any menu can be displayed by left-clicking the menu name. Some commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the toolbar. Each Excel spreadsheet contains columns. Each column is named by a letter or combination of letters.
The formula bar isplays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar. A cell is an intersection of a column and row. Each cell has a unique cell address. In the picture above, the cell address of the selected cell is B3. The heavy border around the selected cell is called the cell pointer.
Navigation buttons allow you to move to another worksheet in an Excel workbook. They are used to display the first, previous, next, and last worksheets in the workbook.
Sheet tabs separate a workbook into specific worksheets. A workbook defaults to three worksheets. A workbook must contain at least one worksheet. A workbook automatically shows in the workspace when you open Microsoft Excel XP. Each workbook contains three worksheets. A worksheet is a grid of cells consisting of 65, rows by columns.
Spreadsheet information—text, numbers, or mathematical formulas—is entered into different cells. Column headings are referenced by alphabetic characters in the gray boxes that run across the Excel screen, beginning with column A and ending with column IV. Rows are referenced by numbers that appear on the left and then run down the Excel screen. The first row is named row 1, while the last row is named An Excel worksheet is made up of columns and rows.
Where these columns and rows intersect, they form little boxes called cells. The active cell—or the cell that can be acted upon—reveals a dark border. All other cells reveal a light gray border.
Each cell has a name. Its name is comprised of two parts: the column letter and the row number. In the following picture, the cell C3—formed by the intersection of column C and row 3—contains the dark border. It is the active cell. The vertical scroll bar located along the right edge of the screen is used to move up or down the spreadsheet.
The horizontal scroll bar located at the bottom of the screen is used to move left or right across the spreadsheet. The PageUp and PageDown keys on the keyboard are used to move the cursor up or down one screen at a time. As mentioned, each workbook defaults to three worksheets.
These worksheets are represented by tabs—named Sheet1, Sheet2 and Sheet3—that appear at the bottom of the Excel window. By the end of this lesson, you should be able to: Identify the parts of the Excel window Understand the differences between a workbook and a worksheet Understand a cell and its importance to Excel Move around a workbook.
Workbook Also called a spreadsheet, the workbook is a unique file created by Excel XP. Title bar The title bar displays both the name of the application and the name of the spreadsheet.
Menu bar The menu bar displays all of the menus available for use in Excel XP. Toolbar Some commands in the menus have pictures or icons associated with them. Column headings Each Excel spreadsheet contains columns. Row headings Each spreadsheet contains 65, rows. Each row is named by a number. Name box This shows the address of the current selection or active cell.
Formula bar The formula bar isplays information entered—or being entered as you type—in the current or active cell. Cell A cell is an intersection of a column and row. Navigation buttons and sheet tabs Navigation buttons allow you to move to another worksheet in an Excel workbook. Workbooks and worksheets A workbook automatically shows in the workspace when you open Microsoft Excel XP. Important terms A workbook is made up of three worksheets.
The worksheets are labeled Sheet1, Sheet2 , and Sheet3. Each Excel worksheet is made up of columns and rows. In order to access a worksheet , click the tab that says Sheet. The cell An Excel worksheet is made up of columns and rows. Important terms Each cell has a unique cell address composed of a cell’s column and row.
The active cell is the cell that receives the data or command you give it. A darkened border, called the cell pointer , identifies it. Moving around the worksheet You can move around the spreadsheet in several ways.
To move the cell pointer: To activate any cell, point to a cell with the mouse and click. To move the pointer one cell to the left, right, up, or down, use the keyboard arrow keys. To scroll through the worksheet: The vertical scroll bar located along the right edge of the screen is used to move up or down the spreadsheet. To move between worksheets: As mentioned, each workbook defaults to three worksheets. To move from one worksheet to another: Click the sheet tab—Sheet1, Sheet2 or Sheet 3—you want to display.
Display the contents of every menu in the menu bar, and note the icons associated with specific menu choices. Try to find the pictures or shortcuts on the Standard toolbar. Click each of the three worksheet tabs—Sheet1, Sheet2 and Sheet3—to become familiar moving from sheet to sheet in the workbook.
Use the horizontal and vertical scrollbars to practice scrolling up, down, left, and right in the worksheet. Next: Create, Open, and Save Workbooks.