When you want to insert a blank imbedded excel object in a word document you can
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
Correct Answer :
A. Click the object command on the insert menu
Related Questions
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
You can edit a cell by
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
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
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Right clicking something in Excel:
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
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
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
The short cut key Ctrl + R is used in Excel to
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
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
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
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
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
Excel files have a default extension of
Xls
Xlw
Wk1
123
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
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
When you copy a formula
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
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
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results