Tic Port3 Act2

No. of Evidence: S3AC2 Name of evidence: S3AC2
Objective:

Instructions: Read in detail until a complete understanding the topic ¨ Graphical Environment Of Microsoft Excel ¨and ¨Elaborating of Workbooks¨ from the textbook Information and Communication Technology 1, DENMS, UANL, obtaining from them the most important ideas and concepts.

a) Different ways to start a session inMicrosoft Excel 2010.
From the Start button
1.- Click on the Start button
2.- Select All programs
3.- Select Microsoft Office
4.- Click on Microsoft Excel 2010

From the short cut
1.- Double click to the short cut that is on the desktop.

b) Main parts of the Microsoft Excel 2010 screen and its graphical environment of operation.
1.- File menu: It shows, from the Backstage view, thebasic commands as New, Open , Save, Save as, Print and Close, among others.
2.- Quick Access Toolbar: It is the area where you can personalize the most used command buttons in Excel. You can add or remove command buttons, clicking on the arrow of the right side and selecting in the dialog box the buttons that you want to add or remove, also how to determinate the location of the Toolbar, above orbelow the ribbon.
3.- Ribbon: It contains the different tabs that have groups, and they have command buttons used in Excel, it is divided in: Start, Insert, Layout, Formulas, Data, Review and View.
4.- Spreadsheet: It is divided in cells, composed by columns(16, 384), labeled with letter and rows (1, 048, 576), labeled by numbers. The name that each cell of the spreadsheet receives is called CellReference, which is formed by the letter of the column and the number of the row. This reference is used to refer to the content of the cells in the functions and formulas.
5.- Name box: It is where it is observed mainly the Cell Reference where the cursor is located. It is also used to assign a name to a range or to change the name to a cell.
6.- Formula Bar: It is where it is observed thecontent of the cell; Text, Numbers and Formulas.
7.- Active cell: It is the cell that is selected in the spreadsheet, it is visualized by a bold box that forms it and also its Filling control.
8.- Label sheets: They are used to identify the sheets, besides to give or to change their name.
9.- Navigate buttons: They are buttons used to move to different sheets that contain the book when the space tovisualize them is not enough to observe them.
10.- Status Bar: In this bar are observed the operations performed in the spreadsheets, besides the different View buttons and the Zoom button.

c) Procedure to open a new book.
1.- Click on File menu, option New
2.- In this window choose Blank book or the template that you want to open
3.- Click on Create

d) Procedure to save a workbook.1.- Click on File menu, select: Save as…
2.- Choose the folder where you want to store the file.
3.- Type the name of the file.
4.- Choose the type of file, the version of Excel in which you want to save the file, in order that you can open it in other versions of Excel or if you want to store it as PDF file( only reading), etc.
5.- Click on Save.
e) Procedure to open an existing workbook.Procedure to open an existing workbook:
1.- Click on File menu, select: Open.
2.- Choose the folder where it is stored the file.
3.- Select the file and click on Open.

Procedure to pen a recent file:
1.- Click on File menu, select Recent.
2.- Click on the file you want to open

f) Display in the screen many opened books.
1.- Click on View tab.
2.- Select from the group Window the buttonSwitch Windows.
3.- Select with a click the file you want to display.

g) Procedure to insert a spreadsheet.
1.- Click on Home tab.
2.- Select from the group Cells the button Insert.
3.- Choose the last option Insert sheet.

h) Procedure to eliminate a spreadsheet.
1.-Click on Home tab.
2.- Select the button Delete from the group Cells.
3.- Choose the last option Delete Sheet.

i)...