An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts
Correct Answer :
D. Worksheets and Charts
Related Questions
Which of the following is not true about Find and Replace in Excel
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
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 you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
Which of the cell pointer indicate that you can move the content to other cell?
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 valid data type in Excel?
Number
Character
Label
Date/Time
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
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
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
To view a cell comment
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
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
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
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c