Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

MS EXCEL 2007
MS-Excel: - MS-Excel is an electronic spread sheet package that can be use to create
sales report, budget or other calculation types works
...

o Cell: - Cell is the inter section of row and the column
...

o Work Sheet: - Work Sheet is the collect the icon is the collection of 255 work
sheets in which 3 work sheets are shown by default
...


Office Button:
1
...

2
...
Its shortcut is Ctrl + O
...
Save: - This command is use to save a work book with another name
...

4
...
Its shortcut is F12
...
Print preview: - This command is use to view your work book before printing
...

6
...
Its shortcut is Ctrl + P
...
Prepare/ Property: - This command is use to give every detail of the saved work
book
...
Close: - This command is use to close the work book
...


Home Menu:
1
...
Its shortcut is Ctrl + X
...
Copy: - This command is use to create a duplicate of the active cell to the selected
cell
...

3
...
Its
shortcut is Ctrl + V
...
Format Painter: - This command is use to copy the formatting style of the active
cell to another cell
...

5
...
Its shortcut is Ctrl + Shift + F
...
Size: - This command is use to change the size of the text within the active cell
...

7
...
Its
increase up to 72 only
...

8
...
It
decreases up to 8 only
...

9
...
Its shortcut is Ctrl + B
...
Italic: - This command is use to give your text slash effect
...

11
...
Its shortcut is single
underline is Ctrl + U and for double underline is Ctrl + Shift + D
...
Border: - This command is use to apply a border around the table
...
Fill color: - This command is use to apply a background color to the selected cells
...
Text color: - This command is use to change the color of the text of active cell
...

Middle: - This command is use to adjust your text to the mid position in the active
cell
...

Left: - This command is use to the left position in the active cell
...

15
...

16
...

17
...

18
...


19
...

20
...

21
...

22
...

23
...

24
...

25
...

26
...

27
...
Hide and unhide and make a duplicate of the sheets also
change the tab color of the sheet
...
Auto Sum: - This command is use to find out the sum of the selected values
...
Fill: - This command is use to fill the data within selection
...
Clear Formatting: - This command is use to clear the various formatting over the
cell
...
Sort: - This command is use to sort your data according to the ascending and
descending order
...
Filter: - This command is use to check only the desire the data
...
Find and Select: - This command is use to open the find, go to, replace and select
all option in the worksheets
...
Picture: - This command is use to insert the picture from computer with in the
worksheet
...
Clip Art: - This command is use to insert the picture in the work sheet from excel
gallery
...
Shapes: - This command is use to insert the shapes in the work sheet
...
Smart Art: - This command is use to insert the diagrams in the work sheet
...
Charts: - This command is use to insert the charts in the work sheet chart is the
graphical presentation of the data
...

6
...
Its shortcut is
Ctrl + K
...
Text Box: - This command is use to create space far text writing in the excel sheet
...
Header and Footer: - This command is use to apply heading over the top and
bottom of the worksheet
...
Work Art: - This command is use to insert the colorful text
...
Signature: - This command is use to insert a space far signature of higher authority
in the work sheet
...
Symbol: - This command is use to insert the symbol in the sheets
...
Margin: - This command is use to set the margin of the work sheet
...
Orientation: - This command is use to change the orientation of the page into
portrait and landscape
...
Size: - This command is use to change the size of the work sheet
...
Print Area: - This command is use to print the selected area
...
Break: - This command is use to break the page on to the active cell position
...
Background: - This command is use to insert back ground over the work sheet
...
Print Tiles: - This command is use to allow the heading gridlines and break and
while point of work sheet
...
Width and Height: - This command is use to increase or decrease the width and
height of the row and column of the work sheet
...
Scale: - This command is use to increase or decrease the resolution of the work
sheet
...
From Access: - This command is use to import the data from Ms Access
...
From Web: - This command is use to import the data from internet page
...
From Text: - This command is use to import the data from text file
...
Sort: - This command is use to sort the data by ascending or descending order
...
Filter: - This command is use to apply the filter over the table filter allows you to
view only the selective data only
...
Remove Duplications: - This command is use to give a condition to editing the
data
...
Data Validation: - This command is use to give a condition to editing the data
...
Consolidate: - This command is use to out the total of number of sheets to the last
one sheet
...
What if analysis: - This command is use to implement the two main option in the
worksheet
...

b) Scenario: - This command is use to compare the table data
...
Group and in Group: - This command is use to make the grouping of the rows and
columns and also group them
...
Spelling: - This command is use to check the spelling mistake
...
Research: - This command is use to search the particular meaning of the selected
text
...
The sources: - This command is use to search the particular meaning of the
selected text
...
Translate: - This command is use to translate selected cell into another language
...
Comment: - This command is use to insert a suggestion over the active cell
...

6
...

7
...


View:
1
...

2
...

3
...

4
...

5
...

6
...

7
...

8
...

9
...

10
...
Its shortcut is Ctrl + Mouse roller
...
Freeze pane: - This command is use to freeze the selected data of the work sheet
...
Macro: - This command is use to record the data table with shortcut key

---