Ms Office Excel
For Ms- Office Online Videos Tutorial
Please click Here Link:-
 |
| Ms Excel |
 |
| Ms Excel |
Q.:- What is Ms-office?
Ans.:- Microsoft Office. Suite of products developed by Microsoft Corporation that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, and Outlook. Office contained Microsoft Word, Microsoft Excel and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Microsoft Visual Basic for Applications scripting language.
Q.:- What is Ms- EXCEL?
Ans.:- Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions.
Q.:- How to start Ms- Office Excel?
Ans.:- Three Are Some Steps Of Start & Open Ms- office Excel………..
1. Start (Windows key Press) → All Programs → Microsoft Office → Microsoft Office Excel → Ok.
2. Start (Windows key +R Press) → Run Dialog Box Open → Write “Excel” → Ok.
Q.:- What are interfaces Of Microsoft Office Excel?
Ans.:- there are interfaces Of Microsoft Office excel.
1. Title Bar
2. Menu Bar
3. Sub Menus Bar (Commands Bar)
4. Ribbon Bar (Quick Access Tools Bar)
5. Formula Bar
6. Column Area (Define Alphabetically)
7. Row Area (Define Numerically)
8. Sheet Area
9. Horizontal & Vertical Ruler Bar
10. Status bar
11. Task bar
Q.:- How many Types of Microsoft Office Excel Menus please write?
Ans.:- there are Seven Types of Menus in Microsoft Office Excel.
1. Home
2. Insert
3. Page layout
4. formulas
5. Data
6. Review
7. View
Q.:- Please Define The Descriptions Of Menus And Sub Menus.
Ans.:- There is Define the Descriptions of Menus and Sub Menus.
1. Home _________________________________
(CLIPBOARD)
Paste- Paste The Contents Of The Clipboard.
Cut- Cut The Selection Form The Document And Put It On The Clipboard.
Copy- Copy The Selection Form The Document And Put It On The Clipboard.
Format Painter- Copy Formatting On One Place And Apply It On To Another.
(FONT)
Font- Change The Font Face.
Font Size- Change The Font Size.
Grow Font- Increase The Font Size.
Shrink Font- Decrease The Font Size.
Bold- Make The Selected Text Bold.
Italic- Italicize The Selected Text.
Underline- Underline The Selected Text.
Border- You Can Affect And Set The Border Style In Present Selected Text Area.
Text Highlight Color- Make Text Look Like It Was Marked With The Highlighter Pen.
Font Color- Change The Text Font Color.
(ALIGNMENT)
Top Align- Align Text To The Top Of The Cell.
Middle Align- Align Text So That It Is Centered Between The Top And Bottom Of The Cell.
Bottom Align- Align Text To The Bottom Of The Cell.
Orientation- Rotate Text To A Diagonal Angle Or Vertical Orientation.
Align Text Left- Selected Text Areas Align Text To Left Side.
Align Text Center- Selected Text Areas Align Text To Center Side.
Align Text Right- Selected Text Areas Align Text To Right Side.
Decrease Indent- Decrease The Indent Level Of The Paragraph Area.
Increase Indent- Increase The Indent Level Of The Paragraph Area.
Wrap Text- Make All Content Visible Within A Cell By Displaying It On Multiple Lines.
Merge & Center- Join The Selected Cells Into One Larger Cell And Centers The Contents In The New Cell.
(NUMBER)
General- Choose How The Values In A Cell Are Displayed.
Number Format- Choose An Alternate Currency Format For The Selected Cell.
Percent Style- Display The Value Of The Cell As A Percentage.
Comma Style- Display The Value Of The Cell With A Thousands Separator.
Increase Decimal- Show More Precise Value By Showing More Decimal Place.
Decrease Decimal- Show Less Precise Value By Showing Fewer Decimal Place.
(STYLES)
Conditional Formatting- Highlight Interesting Cells,
(CELLS)
Insert- Insert Cells, Rows Or Columns Into The Sheet Or Table.
Delete- Delete The Rows Or Columns From The Sheet Or Table.
Format- Change The Row Height Or Column Width, Organize Sheets, Or Protected Or Hide Cells.
(EDITING)
Auto Sum- Display The Sum Of The Selected Cells Directly After The Selected Cells.
Fill- You Can Fill Cells In Any Direction And Into Any Range Of Adjacent Cells.
Clear- Delete Everything From The Cell Or Selectively Remove The Formatting.
Short & Filter- You Can Short The Selected Data In Ascending Or Descending Order Or Filter Specific Values.
Find- Find Any Text & Keywords In Your Documents.
Go To- Navigate To A Specific Place In The Documents.
Replace- Replace Any Text & Keywords In Your Documents.
Select- Select Text Or Objects In The Documents.
2. Insert _________________________________
(TABLES)
Pivot Table- Summarize The Data Using A Pivot Table.
Table- Create A Table To Manage And Analyze Related Data.
(ILLUSTRATIONS)
Picture- Insert A Picture From A File.
Clip Art- Insert Clip-art Into A Document, Including Drawings, Movies, Sounds, Or Stocks Photography To Illustrate A Specific Concept.
Shapes- Insert Ready-Made Shape, Such As Rectangles And Circles, Arrows, Lines, Flowchart Symbols And Call-outs.
Smart Art- Insert A Smart Art Graphic To Visually Communicate Information. Smart Art Graphics Range From Graphical List And Process Diagrams To Complex Graphics.
(CHARTS)
Charts- Insert A Chart To Illustrate And Compare Data. Bar, Pie, Line, Area And Surface Are Some Of The Available Types.
(LINKS)
Hyperlink- Create A Link To A Web Page, A Picture, An E-Mail Address Or A Program.
(TEXT)
Text Box- Insert Reformatted Text Boxes.
Header & Footer- Edit The Header Of The Document. The Content In The Header Will Appear At The Top Of Each Printed Page. Edit The Footer Of The Document. The Content In The Footer Will Appear At The Top Of Each Printed Page.
Word Art- Insert Decorative Text In Your Document.
Signature Line- Insert A Signature Line That Specifies The Individual Who Must Sign.
Object- Insert Embedded Object Content In Software’s Command Projects.
Symbol- Insert Symbol That Are Not On Your Keyboard, Such As Copy Right Symbols, Trademark Symbols, Paragraph, Marks And Unicode Characters.
No comments:
Post a Comment