When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Correct Answer :
D. Both b and c
Related Questions
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
The autofill feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
The name box
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
To create a formula, you can use:
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
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
It is acceptable to let long text flow into adjacent cells on a worksheet when
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
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 menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the 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
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results