You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
Correct Answer :
C. client
Related Questions
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Which of the following is the latest version of Excel
Excel 2000
Excel 2002
Excel ME
Excel XP
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Which of the following is invalid statement?
Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
Which key do you press to check spelling?
F3
F5
F7
F9
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which of the cell pointer indicates that you can fill series?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Which would you choose to create a bar diagram?
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip