To rename the Sheet follow “Day 1” point no.
To apply cell format as Currency follow point no. To apply cell format as Date follow point no. To change Date format (like Location, Currency), go to Control Panel ? Region and Language Settingsġ1. Note : Make sure that the system date format is dd-mm-yyyy, otherwise enter the date values in system date format only. Step 2: Then prepare a data sheet as given (Employee Table). Step 1: To insert a new sheet press Shift+F11 or right click on sheet tab ?Insert command. ? Click on OK to apply the selected format (Refer the figure).ġ0. It will display Sample of selected category. To change or apply cell formatting select the cells ?Home tab ? Cells group ? Format ? Format Cells or press Ctrl+1 ? (it will launch a dialog box) select Category and related things. To merge the cells, select cell range ? Home tab ? Alignment Group ? Merge & Centerĩ. To auto fit for Columns select the columns ? Home tab? Cells group ? Auto Fit ColumnĨ. Step 2: To navigate between Sheets you can directly click on sheet name or use keyboard shortcuts-ħ. Step 1: To open a file press CTRL +O or CTRL + F12 or File Tab ? Open ? specify file name ? Open Step 2: Now come to Excel and go to File tab ? Save ? select Location ? type the file name as given (Excel Practice) ?Save.Ħ. Use New Folder command to create a folder and provide folder name Start ? Computer ? D drive ? STUDENTS ? press CTRL+Shift+N to create a folder and type folder name Step 1: To create a folder in D:\STUDENTS location steps are. Right click on Sheet name ? Rename ? type name as you want orĭouble Click on Sheet name ? enter the name as you desired.ĥ. To prepare the given data sheet ( Student report) follow the above steps of point no. * For Bold select the cells or cells values ? press CTRL +B or CTRL+2 or Home Tab ? Font groupģ. * To set the Row height or Column width, select row/column ? Home tab ? Cells group ? Format Command ? Row Height / Column Width ? provide value in points as required. * To merge cells select the cell range ? Home Tab ? Alignment group ? Merge & Centre To prepare the given data sheet ( Sales report) enters the values in respective cells ? apply formatting as required. (e) In name box type A1 ? press Enter Key or press CTRL+Home Key.Ģ. (d) Type the Cell name in Name Box and press Enter Key.
(c) Press F5 or Ctrl + G for go to command or go to Home tab ? Editing Group ? Find ? Go to ? (it will launch a dialog box), enter the cell name in reference field ? press Enter Key or Clickon OK. We can pin in Taskbar / Start Menu and we can start from there by clicking.ġ. We can assign and use short-cut key to Open Excel Application Or Press window key form keyboard and type Excel then press Enter key. If Desktop Shortcut is available, then double click on Excel icon Press Window +R for Run Command and type Excel then click on OK or press Enter key To start Excel 2010 go to Start ? All Programs ? Microsoft Office ? Microsoft Excel 2010
0 kommentar(er)
