microsoft excel. become familiar with the ribbon in microsoft excel © 2014, john wiley & sons,...
TRANSCRIPT
![Page 1: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/1.jpg)
SpreadsheetsMicrosoft Excel
![Page 2: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/2.jpg)
Ribbon Become familiar with the Ribbon in Microsoft Excel
© 2014, John Wiley & Sons, Inc.
Microsoft Official Academic Course, Microsoft Word 2013 2
![Page 3: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/3.jpg)
RibbonHOME Tab
© 2014, John Wiley & Sons, Inc.
Microsoft Official Academic Course, Microsoft Word 2013 3
![Page 4: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/4.jpg)
Ribbon
INSERT Tab
© 2014, John Wiley & Sons, Inc.
Microsoft Official Academic Course, Microsoft Word 2013 4
![Page 5: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/5.jpg)
Same as MS Word:◦ Save/Save As◦ Open◦ Print functions◦ Font functions◦ Alignment functions
◦ Clipboard functions◦ Clip Art functions◦ Page Setup functions◦ Proofing functions◦ Zoom functions◦ Window functions
Common Functions
![Page 6: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/6.jpg)
ColumnCells that run from top to bottom in a worksheet and are identified by letters.
![Page 7: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/7.jpg)
Columns are identified by letters of the
alphabet
![Page 8: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/8.jpg)
RowA line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
![Page 9: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/9.jpg)
Rows are identified by numbers
![Page 10: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/10.jpg)
CellA box on the grid identified by the intersection of a column and a row..
![Page 11: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/11.jpg)
CellsCells first name begins with the column letter
Cells last name is the row number
Example:C5
![Page 12: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/12.jpg)
active cellA cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
![Page 13: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/13.jpg)
Active cell
Identified by a black line around it
![Page 14: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/14.jpg)
Command groupTask-specific groups divided among the command tabs appropriate to the work a user currently performs.
![Page 15: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/15.jpg)
Command tabTask-oriented tabs that are organized on the ribbon.
![Page 16: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/16.jpg)
Dialog box launcherAn arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
![Page 17: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/17.jpg)
Help systemA system in Excel that is rich in information, illustrations, and tips that can help you complete any task as you create worksheets and workbooks.
![Page 18: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/18.jpg)
Key tipSmall “badges” displaying keyboard shortcuts for specific tabs and commands on the ribbon and Quick Access Toolbar. Also referred to as hotkeys.
![Page 19: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/19.jpg)
Name boxLocated below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
![Page 20: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/20.jpg)
Quick access toolbarA toolbar that gives you fast and easy access to the tools you use most often in Excel.
![Page 21: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/21.jpg)
RibbonA broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
![Page 22: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/22.jpg)
Screen tipsA small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
![Page 23: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/23.jpg)
WorkbookA collection of worksheets in a single file.
![Page 24: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/24.jpg)
WorksheetA page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
![Page 25: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/25.jpg)
So many CURSORSWhat does it all mean?
Used for selecting cells
The I-beam - indicates that you may type text in this area.
The fill handle - used for copying formula or extending a data series.
Used to select a whole row/column when positioned on the row number or column letter.
Appears at the border of the column letters. Drag to widen or narrow the width of a column.
Appears at the border between the row numbers. Drag to increase or decrease the height
of a row.
![Page 26: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/26.jpg)
CursorWiden or shrink columns
![Page 27: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/27.jpg)
CursorWiden or shrink row
![Page 28: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/28.jpg)
WorkbookA workbook is the same thing as a “file.”.
![Page 29: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/29.jpg)
Worksh
eets
Worksheets are the same as “pages.”
![Page 30: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/30.jpg)
Fill Handle
Position cursor over the break in the box
You will see the fill handle
Click and drag – left, right, up, or down
Break in th
e box
![Page 31: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/31.jpg)
Right click on row name to insert a row
Rows always insert above the cursor.
![Page 32: Microsoft Excel. Become familiar with the Ribbon in Microsoft Excel © 2014, John Wiley & Sons, Inc. Microsoft Official Academic Course, Microsoft Word](https://reader035.vdocuments.us/reader035/viewer/2022062322/5697bfbf1a28abf838ca339c/html5/thumbnails/32.jpg)
Right click on column name to INSERT a column
Columns always insert to the left of the cursor