Formatting Worksheets. Format Command ?
Cells group ? Data Tools group ? 12. The name does not begin with a letter or an underscore • Space or other invalid characters are not allowed in name • The name conflicts with an Excel built-in name or the name of another object in the workbook View Tab ? It will launch a Data table dialog box.
Macro Settings ?
SecondDate: This is the more recent of the two dates. View Tab ? Changes Group ? Simply download the included sample file and start practicing your Excel skills today! Data tab ? Microsoft Excel is a spreadsheet program. 3. select Option a. OK File ? To sort the records Employee name wise steps are- Select any Employee name Sort A to Z.
Or Select the range and go to Formulae Tab ? We use it to create reports that need calculations and charts. Manager (it will launch a dialog box) Note: (i) To view the different result use show command from scenario manager dialog box (ii) If required you can insert a summary of recorded scenario by using Summary command from the same dialog box.
Home Tab ? Microsoft Excel practice for basic, intermediate and advanced students. Alignment group ?
it will launch Advance filter dialog box. Editing group ? Home tab? To set paper size, orientation and margins you can use page setup window as shown in above figure of Point no. Define name. 2.
new sheet or new cell in the same sheet), then go to Paste Special ? Editing group ? a) To repeat row / column in sheets for printing go to Page Layout Tab ? Cells group ? To protect entire workbook go to Review Tab ? Editing group ? Prepare the table Party Outstanding Reports as given in exercise and format it accordingly. Data validation ? Protect and Share workbook ? Creates a chart (on a chart sheet) using the highlighted range Switches between the worksheet, Zoom controls, task pane, and Ribbon Enables the user to add a nonadjacent cell or range to a selection of cells by using the arrow keys Displays the (Shortcut) menu for the selected item Performs the Move window command when the window is not maximized Performs the Size window command when the window is not maximized Maximizes or restores the selected workbook window Creates a chart (on a chart sheet) using the highlighted range Closes all the workbooks (saving first) and exits Excel Toggles between the Visual Basic Editor window (in which one can create a macro using VBA) and the Excel window Displays the Create Names from Selection dialog box Toggles the strikethrough of text on the current selection Alternates between hiding objects, displaying objects, and displaying place- holders for objects Copies the contents and format of the first cell in the selection downwards Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks Copies the contents and format of the leftmost cell in the selection to the right Pastes the contents of the clipboard at the insertion point Inserts argument names and parentheses when the insertion point is to the right of a function name in a formula Opens the Format Cells dialog box with the Font tab selected Enters the contents of the active cell and moves to the cell below Enters the contents of the active cell and moves to the cell above Enters the contents of the active cell and moves one cell (unlocked in a protected worksheet) to the right Enters the contents of the active cell and moves one cell (unlocked in a protected worksheet) to the left Enters the euro symbol (€) (using Number keypad) Enters the cent symbol (¢) (using Number keypad) Enters the pound sign symbol (£) (using Number keypad) Enters a new line (or carriage return) into a cell Enters the formula from the cell directly above into the active cell Enters the contents of the active cell to the selected cell range Displays a drop-down list of the values in the current column of a range row Move by one block of data within a row or column Moves to the beginning (cell ?A1?) Enter the labels and values in the exact cells locations as desired. select the location ? f) To insert multiple cells, select the cells and press To insert multiple rows/columns select multiple row/column and press g) To insert an object in worksheet go to Insert Tab ?