Looking for:
- Microsoft office 2010 tutorial pdf in hindi free |
Microsoft office tutorial pdf free download - Australian Examples Step-by-step Guidelines.MS Word tutorial notes PDF download in Hindi | Microsoft Office Course
WinRAR bit. VLC Media Player. MacX YouTube Downloader. Microsoft Office YTD Video Downloader. Adobe Photoshop CC. VirtualDJ Avast Free Security. WhatsApp Messenger. Talking Tom Cat. Clash of Clans. Subway Surfers. TubeMate 3. Google Play. Windows Windows. Most Popular. New Releases. Desktop Enhancements. Networking Software. Software Coupons. To cancel a moving border, press ESC. Select the cells that you want to move or copy. On the Home tab, in the Clipboard group, do one of the following: a.
To move cells, click Cut. To copy cells, click Copy. Click in the center of the cell you would like to Paste the information too. On the Home tab, in the Clipboard group, click Paste. When you copy cells, cell references are automatically adjusted. If the selected copy or paste area includes hidden cells, Excel also copies the hidden cells. You may need to temporarily unhide cells that you don't want to include when you copy information. Select the cells or a range of cells that you want to move or copy.
To move a cell or range of cells, point to the border of the selection. When the pointer becomes a move pointer , drag the cell or range of cells to another location.
Column Width and Row Height On a worksheet, you can specify a column width of 0 to and a row height of 0 to This value represents the number of characters that can be displayed in a cell that is formatted with the standard font. The default column width is 8. Select the column s or row s that you want to change. On the Home tab, in the Cells group, click Format. A Column Width or Row Height box will appear.
In the Column Width or Row Height box, type the value that you want your column or row to be. Click the Select All button 2. This can occur when the cell contains a number or a date that exceeds the width of the cell so it cannot display all the characters that its format requires.
To see the entire contents of the cell with its current format, you must increase the width of the column. Place you cursor on the line between two rows or columns. A symbol that looks like a lower case t with arrows on the horizontal line will appear 3. Select the column s or row s that you want to change 2.
Merge or Split Cells When you merge two or more adjacent horizontal or vertical cells the cells become one larger cell that is displayed across multiple columns or rows. When you merge multiple cells, the contents of only one cell appear in the merged cell. Merge and Center Cells 1. Select two or more adjacent cells that you want to merge. On the Home tab, in the Alignment group, click Merge and Center. The cells will be merged in a row or column, and the cell contents will be centered in the merged cell.
Split Cells 1. Select the merged cell you want to split 2. To split the merged cell, click Merge and Center. The cells will split and the contents of the merged cell will appear in the upper-left cell of the range of split cells. Automatically Fill Data To quickly fill in several types of data series, you can select cells and drag the fill handle. To use the fill handle, you select the cells that you want to use as a basis for filling additional cells, and then drag the fill handle across or down the cells that you want to fill.
Select the cell that contains the formula that you want to be brought to other cells. Move your curser to the small black square in the lower-right corner of a selected cell also know as the fill handle. Your pointer will change to a small black cross. Click and hold your mouse then drag the fill handle across the cells, horizontally to the right or vertically down, that you want to fill. The cells you want filled will have a gray looking border around them.
Once you fill all of the cells let go of your mouse and your cells will be populated. Spreadsheets can become professional documents used for company meetings or can even be published.
Wrap Text You can display multiple lines of text inside a cell by wrapping the text. Wrapping text in a cell does not affect other cells. Click the cell in which you want to wrap the text. On the Home tab, in the Alignment group, click Wrap Text.
The text in your cell will be wrapped. NOTE: If the text is a long word, the characters won't wrap the word won't be split ; instead, you can widen the column or decrease the font size to see all the text. If all the text is not visible after you wrap the text, you might have to adjust the height of the row.
This display difference can have a significant effect when the data is numeric. For example, numbers in cells will default as rounded numbers, date and time may not appear as anticipated. After you type numbers in a cell, you can change the format in which they are displayed to ensure the numbers in your spreadsheet are displayed as you intended. Click the cell s that contains the numbers that you want to format. On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click the format that you want.
If you are unable to format numbers in the detail you would like that you can click on the More Number Formats at the bottom of the Number Format drop down list.
In the Category list, click the format that you want to use, and then adjust settings to the right of the Format Cells dialog box. If predefined cell borders do not meet your needs, you can create a custom border. NOTE: Cell borders that you apply appear on printed pages.
If you do not use cell borders but want worksheet gridline borders for all cells to be visible on printed pages, you can display the gridlines. Apply Cell Borders 1. On a worksheet, select the cell or range of cells that you want to add a border to, change the border style on, or remove a border from. Go to the Home tab, in the Font group 3.
Click the arrow next to Borders 4. Click on the border style you would like 5. In the Format Cells dialog box, on the Border tab, under Line and Color, click the line style and color that you want.
Remove Cell Borders 1. Go to the Home tab, in the Font group 2. Click the arrow next to Borders 3. Click No Border. You can click the Borders button not the arrow to apply that style. Cell Styles You can create a cell style that includes a custom border, colors and accounting formatting. On the Home tab, in the Styles group, click Cell Styles. Select the different cell style option you would like applied to your spreadsheet. NOTE: If you would like to apply a cell fill and a cell border, select the cell fill color first the ensure both formats are applied.
Cell Fill 1. Select the cells that you want to apply or remove a fill color from. Go to the Home tab, in the Font group and select one of the following options: a. To fill cells with a solid color, click the arrow next to Fill Color , and then under Theme Colors or Standard Colors, click the color that you want.
To fill cells with a custom color, click the arrow next to Fill Color , click More Colors, and then in the Colors dialog box select the color that you want. To apply the most recently selected color, click Fill Color.
To quickly apply one of these colors, click the arrow next to Fill Color , and then click the color that you want under Recent Colors. Remove Cell Fill 1. Select the cells that contain a fill color or fill pattern.
Text Color 1. Select the cell, range of cells, text, or characters that you want to format with a different text color. On the Home tab, in the Font group and select one of the following options: a. To apply the most recently selected text color, click Font Color. To change the text color, click the arrow next to Font Color , and then under Theme Colors or Standard Colors, click the color that you want to use. Bold, Underline and Italics Text 1.
Select the cell, range of cells, or text. The selected command will be applied. Customize Worksheet Tab 1. On the Sheet tab bar, right-click the sheet tab that you want to customize 2. Click Rename to rename the sheet or Tab Color to select a tab color.
Type in the name or select a color you would like for your spreadsheet. The information will be added to the tab at the bottom of the spreadsheet. Microsoft Office Excel follows the standard order of mathematical operations. You can also create a formula by using a function which is a prewritten formula that takes a value, performs an operation and returns a value. Depending on the type of formula that you create, a formula can contain any or all of the following parts.
Cell references You can refer to data in worksheet cells by including cell references in the formula. For example, the cell reference A2 returns the value of that cell or uses that value in the calculation. Constants You can also enter constants, such as numbers such as 2 or text values, directly into a formula. Operators Operators are the symbols that are used to specify the type of calculation that you want the formula to perform.
Click the cell in which you want to enter the formula. The second cell reference is C3, the color is green, and the cell range has a green border with square corners. To create your formula: 1. Click on the 1 cell you want in the formula.
Click on the next cell you want in the formula. Click Insert Function on the formula bar. Select the function that you want to use. NOTE: If you're not sure which function to use, type a question that describes what you want to do in the Search for a function box for example, "add numbers" returns the SUM function , or browse from the categories in the Or Select a category box.
Enter the arguments. Select the cell where you would like your formulas solution to appear. Go to the Home tab, in the Editing group, 3. Click AutoSum, to sum your numbers or click the arrow next to AutoSum to select a function that you want to apply. Delete a Formula When you delete a formula, the resulting values of the formula is also deleted.
However, you can instead remove the formula only and leave the resulting value of the formula displayed in the cell. To delete formulas along with their resulting values, do the following: 1. Select the cell or range of cells that contains the formula. To delete formulas without removing their resulting values, do the following: 1. On the Home tab, in the Clipboard group, click Copy. When you create a parentheses formula, Excel displays parentheses in color as they are entered.
Use a colon to indicate a When you refer to a range of cells, use a colon : to separate the reference to range the first cell in the range and the reference to the last cell in the range. For example, A1:A5. Enter all required Some functions have required arguments. Also, make sure that you have not arguments entered too many arguments. Nest no more than 64 You can enter, or nest, no more than 64 levels of functions within a function.
Enter numbers without Do not format numbers as you enter them in formulas. Charts in Excel Microsoft Excel no longer provides the chart wizard. Instead, you can create a basic chart by clicking the chart type that you want on the Insert tab in the Charts group. Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.
To create a chart in Excel, you start by entering the numeric data for the chart on a worksheet. Then you can plot that data into a chart by selecting the chart type that you want to use on the Insert tab, in the Charts group. Worksheet data Chart created from worksheet data Getting to know the elements of a chart A chart has many elements. Some of these elements are displayed by default, others can be added as needed.
You can change the display of the chart elements by moving them to other locations in the chart, resizing them, or by changing the format. You can also remove chart elements that you do not want to display. Create a Chart 1. On the worksheet, arrange the data that you want to plot in a chart.
The data can be arranged in rows or columns — Excel automatically determines the best way to plot the data in the chart. Select the cells that contain the data that you want to use for the chart. NOTE: If the cells that you want to plot in a chart are not in a continuous range, you can select nonadjacent cells or ranges as long as the selection forms a rectangle.
You can also hide the rows or columns that you do not want to plot in the chart. Go to the Insert tab, in the Charts 4. Click the chart type, and then click a chart subtype from the drop menu that will appear.
Click anywhere in the embedded chart to activate it. When you click on the chart, Chart Tools will be displayed which includes the Design, Layout, and Format tabs. The chart will automatically be embedded in the worksheet. A chart name will automatically be assigned. Move Chart to New Sheet 1.
On the Design tab, in the Location group, click Move Chart. Under Choose where you want the chart to be placed, click on the New sheet bubble 3. Type a chart name in the New sheet box.
Change Chart Name 1. Click the chart. On the Layout tab, in the Properties group, click the Chart Name text box. Type a new chart name. Change Chart Layout 1. Click anywhere in the chart. Go to the Chart Tools, the Design group 3. In the Chart Layouts, click the chart layout that you want to use. To see all available layouts, click More. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
To see all predefined chart styles, click More. Chart or Axis Titles To make a chart easier to understand, you can add titles, such as chart and axis titles.
To add a chart title: 1. On the Layout tab, in the Labels group, click Chart Title. In the Chart Title text box that appears in the chart, type the text that you want. To remove a chart title, click Chart Title, and then click None. To format the whole title, you can right-click it, click Format Chart Title, and then select the formatting options that you want. To add axis titles: 1. On the Layout tab, in the Labels group, click Axis Titles.
Do one or more of the following: a. To add a title to a primary horizontal category axis, click Primary Horizontal Axis Title, and then click the option that you want. To add a title to primary vertical value axis, click Primary Vertical Axis Title, and then click the option that you want.
In the Axis Title text box that appears in the chart, type the text that you want. To remove an axis title, click Axis Title, click the type of axis title to remove, and then click None.
- Download free tutorials and courses on ms word hindi - Documents PDF
Microsoft Word Part 2: Intermediate. Word Getting Started. Description : This tutorial booklet, recommended for intermediate-level Macintosh users, has been developed to help you get started with Word , a PDF file. Word Quick Start Guide. Description : Microsoft Word looks different from previous versions, so we created this guide to help you minimize the learning curve. Introduction to Word Description : Download free an introduction to Microsoft word , course tutorial training, a PDF file by Montclaire state univesity.
Word Collaboration. Word - Accessibility. Microsoft Word Basics for Mac. Word Accessibility. Advanced Word Size : 2. Word Training. Microsoft Word An introduction to Word Description : Download free course material and training on an introduction to Word PDF file 64 pages Size : An Introduction to Word Description : This course includes an introduction to the Microsoft Office interface, and covers the various aspects of creating, formatting, editing, saving, and printing a document in Word Description : PDF tutorial It includes an introduction to the Microsoft Office interface, and covers the various aspects of creating, formatting, editing, saving, and printing a document in Word Word Formatting your Document.
Word —Tips and Tricks. Word Reviewing your Document. Description : Download free Microsoft office word reviewing your document, course tutorial training. Go to Insert section, Click on Tables, Choose the number of row and column of tables. The process of inserting templates in MS Word -. Click on File menu, Click on New option, If you are using ms word or then you will see many templates on this windows. If you are using MS word , then you have to download MS word templates style from online internet.
Answer: 6 categories of shapes are there in MS Word All 6 categories of shapes are given below -. Answer: MS word mein document print karne ke liye File menu par click karen fir Print option par click karen. Answer: To embed a virus in a Word document, you need to add additional plugin which is made by viruses, in MS word Add-on section. Answer: MS word mein resume edit karne ke liye resume file ko ms word mein open karna hoga fir file ke kisi bhi test jaha edit karna chahte hai, par click karna hoga.
Agar resume locked hai ya security password laga hua hai to use unlock karke edit kar sakte hain. Tags Computer study materials. LinkList ul li ul'. ResizeIfy - LazyIfy on Scroll by blogshinepro v1.
No comments:
Post a Comment