Menu Dan Icon Pada Microsoft Excel
2007
·
Office Button
v New
v Open
v Save
v Save As : Excel WorkBook, Excel Macro – Enabled
Work, Excel Binary WorkBook, Excel 97 – 2003 Workbook, Findaddins for other
file formats, other formats
v Print : Print, Quick Print, Print Preview
v Prepare : Propertis, Inspect Document, Encrypt
Document, Restrict Permission, Add a Digital Singature, Mark As Final, Run
Compatibility Checker
v Send : E – Mail, Internet Fax
v Publish : Excel Service, Document Management
Server, Create Document Workspace
v Close
v Excel Options
v Recent Document
·
Quick Access Toolbar
v New, Open, Save, Email,
Quick Print, Print Preview, Spelling, Undo, Redo
·
Ribbon
v Home
o Clipboard : Paste, Format
Printer, Copy, Cut
o Font : Font, Font Size, Bold, Italic,
Underline, Increase Font Size, Decrease font size, Bottom Border, Fill color,
Font Color
o Aligment : Top Align, Middle Align, , Bottom Align,
Orientation, Align text Left, Align text Right, Center, Decrease Indent,
Increase Indent, Warp text, Marge & Center
o Number : Number Format, Accounting Number Format,
Percent Style, Increase Decimal, Decrease Decimal
o Style : Conditional Formatting, Formats As
Table, Cell Style
o Cell : Insert Cell, Delete Cell, Format
v Insert
o Table : Insert Pivot Table, Table
o Illustrations : Insert Picture, Clip Art, Shapes,
Insert Smart Art Graphic
o Charts : Columm, Line, Pie, Bar,
Area, Scatter, Other Charts
o Links : Insert Hyperlink
o Text : Text Box, Header &
Footer, Word Art, Singature Line, Insetobject, Symbol
v Page Layout
o Themes : Themes, Theme Colors, Theme
Fonts, Theme Effect
o Page Stupe : Margins, Page Orientations, Page
Size, Print Area, Breaks, Background, Print Tiles
o Scale to Fill : Widht, Height, Scale
o Sheet Options : Gridlines, Heading
o Arrange : Bring to Font, Send to Back,
Selection Pane, Align, Group, Rotate
v Formulas
o Function Library : Insert Function, Sum, Recently Used,
Financial, Logical, Text, Date & Time, Lookup & Reference, Math &
Trig, Stastical, Ergineering, Cube, Information
o Defines Names : Name Manager, Define Name, Use Informula,
Create From Seletion
o Formuls Auditing : Trace
Precedents, Trace Dependents, Remove Arraw, Show Formulas, Error Cheking,
Evaluate, Formula, Watch Window
o Calculation : Calculation Options, Calculate Now,
Calculate Sheet
v Data
o Get External Data : From
Access, From Web, From Text, From Other Sources, Existing Connections
o Connections : Refresh All, Connections, Propertis,
Edit Links
o Sort & Filter : Sort A to Z, Sort Z to A, Sort,
Filter, Clean, Reaaply, Advanced
o DataTools : Text to
Colums, Remove Duplicates, Data Validation, Consolidate, What – If Analysis
o Outline : Group, Ungroup, Subtotal,
Showdetail, Hide Detail
v Review
o Proofing : Spelling, Research, Teasaurus,
Translate
o Comments : New Comment, Delete Previous, Next, Show
All Comment, Show Link
o Changes : Protect Sheet, Protect Workbook,
Share Workbook, Protect and Share Workbook, Allow User to Edit Ranges, Track
Changes
v View
o Workbook Views : Normal, Page Layout, Page Break
Preview, Custom Views, Fullsreen
o Show/ Hide : Ruler, Gridlines, Message
Bar, Formula Bar, Headings
o Zoom : Zoom 100%, Zoom to
Selection
o Window : New Window, Arrange All,
Freeze Panes, Splint, Hide, Unhide, View Side by Side, Synchronous Scraling,
Rase Window Position, Save Workshop, Switch Windows
o Macros : Macros
Tidak ada komentar:
Posting Komentar