You can use drag-and-drop to embed excel worksheet data in a word document
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
Correct Answer :
A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
Related Questions
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
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
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
If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You 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
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 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 box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Which symbol must all formula begin with?
=
+
(
@
How can you remove borders applied in cells?ACC
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
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
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
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
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 a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
A numeric value can be treated as a label value if it precedes with
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&