M1_Lab_Manual_Basic_excel.pptx

Lab Manual

Basic Excel

Objectives of this Lab Manual This lab manual is designed to provide practical knowledge to learners to solve a real-time work related assignment You will be given a problem and it’s descriptions. You are supposed to write down the steps to resolve the problem and submit the answer on a Google Sheet. A model answer will be provided at the end.

Problem What will you do? Copy a data from one worksheet to another

Model Answer WWhhaatt sshhoouulldd yyoouu ddoo?? • Right-click on the sheet tab that you want to copy. • The toolbar window will appear. Click on the 'Move or Copy' option. • The 'Move or Copy' dialog box will be displayed. In the Before Sheet section, select the 'move to end' option and make sure to check in the 'create a copy'. • Click OK. Your data will be copied to the new worksheet

What have 01 Copying data from one worksheet to another we learned…

Problem What will you do? Create table of existing worksheet data

Model Answer WWhhaatt sshhoouulldd yyoouu ddoo?? • Select the cell or the range in the data. • Select Home > Format as Table. • Pick a table style. • In the Format as Table dialog box, select the checkbox next to My table as headers if you want the first row of the range to be the header row, • and then click OK.

What have 01 Creating table in existing worksheet we learned…

Problem What will you do? Format Date into Numbers in excel

Model Answer WWhhaatt sshhoouulldd yyoouu ddoo?? • Select a cell or a cell range of date column in worksheet • On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells… , and select Number. ... • Select the number format. • Click on ok

What have 01 Formatting date type into number type we learned…

Problem What will you do? Save Excel file using different Format & Extension

Model Answer WWhhaatt sshhoouulldd yyoouu ddoo?? • Open the workbook for which you want to change the format. Go to the FILE tab. • It will open a left pane window. There are a lot of options available in this pane. • Click on Save As option as shown below. • It will open a dialog box select location and click on save type the drop-down • Select the format and click on OK.

What have 01 Save Excel file using different Format & Extension we learned…

Problem What will you do? Print a Table in Excel

Model Answer WWhhaatt sshhoouulldd yyoouu ddoo?? • Click a cell within the table to enable the table. • Click File, and then click Print. • Under Settings, click the arrow next to Print Active Sheets and select Print Selected Table. • Click Print.

What have 01 Print a Table in Excel we learned…

Problem What will you do? Add commands to the Ribbon

Model Answer WWhhaatt sshhoouulldd yyoouu ddoo?? • Use the Choose Command From drop-down list on the left to display various groups of commands. • Select the command in the list box on the left. • Use the Customize the Ribbon drop-down list on the right to choose a group of tabs. Main Tabs refers to the tabs that are always visible; Tool Tabs refers to the contextual tabs that appear when a particular object is selected. • In the list box on the right, select the tab and the group where you want to put the command. You'll need to click the plus-sign control to expand the tab name so that it displays its group names. • Click the Add button to add the selected command from the left to the selected group on the right. To rearrange the order of tabs, groups, or commands, select the item and use the Move Up and Move Down buttons on the right.

What have 01 Adding commands to the Ribbon we learned…

Thank You!