Also Read Similar Questions Below : 17+59 ⇒ Which tool you will use to join some cells and place the content at the middle of joined cell?From Format Cells dialog box click on Merge Cells check boxFrom Format Cells dialog box select the Centered alignmentFrom Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar ⇒ In MS-Excel you can copy cell formats from one cell to another by using theBsckspace keyDefault fontFormat painter None of these ⇒ In MS-Excel you can use the drag and drop method toCopy cell contentsMove cell contentsAdd cell contents (A) and (B) ⇒ Which of the following is not the correct method of editing the cell content?Press the Alt keyPress the F2 keyClick the formula bar Double click the cell ⇒ In MS-Excel how do you delete a column?Select the column heading you want to delete and select the Delete Row button on the standard toolbarSelect the column heading you want to delete and select Insert Delete from the menuSelect the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu ⇒ Which command will you choose to convert a column of data into row?Cut and PasteEdit >> Paste Special >> TransposeBoth of above None of above ⇒ In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?AutoFillAuto correctAuto sum Auto format ⇒ To select an entire column in MS-EXCEL, press?CTRL + CCTRL + Arrow keyCTRL + S None of the above ⇒ What is the shortcut to change the font?Ctrl + FAlt + Ctrl + FShift + Alt + F Ctrl + Shift + F ⇒ The Name box on to the left of formula barshows the name of workbook currently working onshows the name of worksheet currently working onshows the name of cell or range currently working on None of above ⇒ In MS-Excel all worksheet formulaManipulate valuesManipulate labelsReturn a formula result Both (a) & (b) ⇒ Which of the following Excel screen components can NOT be turned on or off?Formula BarStatus BarTool Bar None of above ⇒ Which area in an Excel window allows entering values and formulas?Title BarMenu BarFormula Bar Standard Tool Bar ⇒ Which Chart can be created in Excel?AreaLinePie All of the above ⇒ In MS-Excel Text formulasReplace cell referencesReturn ASCII values of charactersConcatenate and manipulate text None of these ⇒ In MS-Excel how do you insert a row?Right-click the row heading where you want to insert the new row and select insert from the shortcut menuSelect the row heading where you want to insert the new row and select Edit >Row from the menuSelect the row heading where you want to insert the new row and click the insert Row button on the standard toolbar All of the above ⇒ By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?Right click on Sheet Tab of third sheet and choose Delete from the context menuClick on Sheet 3 and from Edit menu choose Delete Both of above None of above ⇒ What happens when you press Ctrl + X after selecting some cells in Excel?The cell content of selected cells disappear from cell and stored in clipboardThe cells selected are marked for cuttingThe selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up ⇒ In MS-Excel which of the following formulas will not be calculated?=SUM(Sales)-A3=SUM(A1:A5)*.5+SUM(A1:A5)/(10-10) Both (a) & (c) ⇒ When all the numbers between 0 and 100 in a range should be displayed in Red Color, applyUse =if() function to format the required numbers redApply Conditional Formatting command on Format menuSelect the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above ⇒ What is the short cut key to open the Open dialog box?Shift+ F12Ctrl + F12F12 Alt + F12 ⇒ Which of the following is not true regarding Conditional Formatting?You can add more than one condition to checkYou can set condition to look for Bold and apply Italics on themYou can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried ⇒ Ctrl + D shortcut key in Excel willOpen the font dialog boxApply double underline for the active cellFill down in the selection None of above ⇒ In MS-Excel you can create only a horizontal page break by first selecting>page breakA cell in row 1A cell in column A (A) and (C) ⇒ What does Ctrl + = key effect?All CapsShadowSuperscript Subscript ⇒ You can link MS-Excel worksheet data to a Word documentWith the right drag methodWith a hyperlinkWith the copy and paste buttons on the standard toolbar None of these ⇒ In MS-Excel the drag and drop method of copying or movingCan be used between a worksheet but not workbooksCan be used between both workbooks an worksheetsCan be used between workbooks but not worksheets None of these ⇒ Where can you set the shading color for a range of cells in Excel?Choose required color form Patterns tab of Format Cells dialog boxChoose required color on Fill Color tool in Formatting toolbarChoose required color on Fill Color tool in Drawing toolbar All of above ⇒ Which of the following format you can decide to apply or not in AutoFormat dialog box?Number formatBorder formatFont format All of above
If you don't have a data source yet, choose Type a New List, and then use the form that opens to create your list. The list is saved as a database (.mdb) file that you can reuse. For details about creating a new list, see Set up a new mail merge list with Word. An existing list might be an Excel spreadsheet, Access database, or some other type of database. To use it as your data source, choose Use an Existing List.
Important: No matter what type of file you use as a data source, be sure to save it on your local computer or a file share; saving at an HTTP location isn't supported for mail merge.
You can retrieve contact information directly from your Outlook contact list in Word. To use this as your data source, choose Choose from Outlook Contacts. For more information, see Use Outlook contacts as a data source for a mail merge. If you don't have a data source yet, choose Create a New List, and then use the dialogs that open to create your list. The list is saved as a document file that you can reuse. For details about creating a new list, see Set up a new mail merge list with Word. Here are few examples of data sources you can use for mail merge in Word. Excel spreadsheet An Excel spreadsheet works well as a data source for mail merge. Data should be on one sheet and well formatted so that it can be read well with Word. For more information, see Prepare your Excel data source for mail merge. Outlook Contact List You can retrieve contact information directly from your Outlook Contact List on to Word. See Export Outlook items. Apple Contacts List You can export Apple contacts into an Excel spreadsheet and use it as your mailing list for mail merge. Text files You can use any text file that has data fields separated (or delimited) by tab characters or commas and data records separated by paragraph marks. • Create a new list In the Edit List Fields dialog box, Word automatically creates fields for some basic information, such as first name, last name, and address. If you want to add a new field—for example, a message field—add it now, so you can fill in the field when you type the entry. Under New field name, type the name of the field you want to add and then click + (plus sign). Tip: To change the order of the fields, choose the field you want to move, and then use the up or down arrows to move the field. When all fields are set up as you want, choose Create to make a new list. • Use an Existing List Browse to the file you want to use and choose Open. In the Open Workbook dialog box, select the sheet you want to use, and then do one of the following: Leave Cell Range blank to use the entire worksheet. or Enter a cell range for the data you want to use. Choose OK. • Choose from Outlook Contacts Choose Filter Recipients to select the recipients you want to include. In the Query Options dialog box, next to List mail merge recipients by, choose Complete record. In the list of contacts, select the contacts you want to include in the mail merge, and then choose OK. • Apple Contacts Choose Filter Recipients to select the recipients you want to include. In the Query Options dialog box, under Apple Group Contacts, choose the group you want to include in the mail merge, and then choose OK. • File Maker Pro Browse to the file you want to use and choose Open. In the Header Record Delimiters dialog box, choose a field delimiter to separate each data field and a record delimiter to separate each data record, and then choose OK.
Here are few examples of data sources you can use for mail merge in Word.
|
You can merge the main document with data source in Excel in mail merge operation, word is usually
Pos Terkait
Copyright © 2024 ketiadaan Inc.
