EXCEL
How to open excel: -
1. Press window + R > to open run dialog box > Type (excel) > Ok/enter > select workbook.
2. Press ctrl + shift + window + alt + X to open MS excel application.
3. MS excel stand: - Excel
4. Extension name: - .xlsx
5. Total row: - 1048576
6. Total column: - 16384
7. Total cells: - 17179869184
8. Row level name: - 1, 2, 3, 4, etc.
9. Columns level name: - A, B, C, D, E, etc.
[Link] row height: - 15 points
[Link] column width: - 8.43 points
[Link] font size: - 11
[Link] font style: - Calibri font
Excel used to manage client, custom or consumer, items, product, services, data to find,
filter, generate report and charts etc.
This application is part of MS office group known as excel or workbook.
This Application run command excel and extension name .xlsx.
Excel page known as spreadsheet, excel sheet and worksheet.
There is important menu given in excel menu bar: -
a) Home
b) Insert
c) Draw
d) Page layout
e) Formulas
f) Data
g) Review
h) View
-: HOME MENU: -
Home Menu: - This is the most common menu of MS Excel used to customize,
data, cells, formatting and clipboard in excel sheet. There are important tool boxes
available in-home menu given below.
Clipboard: - To copy, text, paste, matter and value of page as well as apply font
formatting of text.
Font: - To customize text style, size, effects and color.
Alignment: - To align cells data.
Number: - To change cell format.
Styles: - To apply designing at range.
Cells: - To add, remove, update size of cells.
Editing: - To find, replace, start data of sheet.
-: INSERT MENU: -
Insert Menu: - This menu used to insert objects in spreadsheet. There is
important menu available in insert menu bar.
Tables: - There are two types of tables in excel. First one is pivot table which is
used to filter column and second one is table which is used to filter rows of
spreadsheet. To create table, press ctrl + T.
Illustrations: - To insert objects in spreadsheet such as picture, icons, smart art,
screenshot, etc.
Add-ins: - To install apps related data calculation and data management.
Charts: - To design different styles of graphs related data ranges.
Tours: - To create online 3D maps related address range data.
Sparkline: - To create line, column and win/loss chart of numeric value range
data.
Filters: - To filter columns a pivot table in dowable window by filter tool and filter
columns a pivot table according data range by timeline tool.
Links: - To create hyperlinks at text, matter objects.
Text: - To define and customize column text over spreadsheet.
Symbols: - To insert communicative characters by using wingding as welding
symbol font styles.
-: PAGE LAYOUT MENU: -
Page layout menu: - This menu used to setup page size, margins, prints
and manage objects over spreadsheet. There are five toolboxes in page layout
menu.
Themes: - This toolbox used to apply group in text, styles, effects, color
themes over range in spreadsheet.
Page setup: - This toolbox used to customize margins, rotation, size print
area, page break, and background of spreadsheet.
Scale of FPT: - This toolbox used to customize multiple pages in single page
layout.
Sheet options: - This toolbox used to show/hide headings and gridlines of
view and print page of sheet.
Arrange: - This toolbox used to manage objects to sends background or
brings forward rotate, alignment and group.
-: FORMULA MENU :-
Formula Menu: - This menu contains formula functions using spreadsheet.
There is main eight category of function in and sheet known as basic function,
reference’s function, conditional function, date and time function, lookup function,
Table (pivot Table) or normal table, Logical function, financial function. There are
four toolboxes available in this menu.
Function Library: - This toolbox used to access all function and formulas to
be used tin excel data calculation.
Define names: - This toolbox used to define or changes name of cell, rows,
columns and range.
Formula Auditing: - This toolbox used to chow/hide formula in cells,
checking error in formula show steps in formula calculation. Using evaluate
formula show ranges using in formulas by arrows.
-: DATA MENU:-
Data menu: - This menu used to manage multiple workbooks through
remote access by others monitors. Create connections with multiple workbooks,
short and filter data and group/ungroup rows and columns. There are six
toolboxes contain in this menu.
Get and Transform Data: - This toolbox used to access and merge
others monitors workbook in single monitor system.
Queries And Connections: - This toolbox used to merge center,
edit, refresh, connections of multiple workbooks.
Sort and Filter: - This toolbox used to arrange data in ascending and
descending order. Sort and filter data by rows- wise through filter.
Data tools: - This toolbox used to convert matter into columns, Merge
multiple columns data in single columns, create data validation merge multiple
sheets data into single sheet, remove duplicated data of selected area.
Forecast: - This toolbox used to create charts of numeric value of any
range.
Outline: - This toolbox used to group/ungroup selected rows and also.
-: REVIEW MENU: -
Protect: - To restrict row, column, sheet by unintentional editing or
opening.
-: VIEW MENU: -
Workbook Views: - To display spreadsheet in normal page break,
preview page layout and custom view, normal view is default view of excel
sheet.
Zoom: - To zoom in and zoom out spreadsheet from 10% to 400%.
Macros: - To create ultimately recorder progress from spreadsheet.