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
Correct Answer :
B. Double clicking the cell to edit it in-place
Related Questions
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
The spelling dialog box can be involved by choosing spelling from ________ menu.
insert
file
tools
view
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Which of the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
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
You cannot link excel worksheet data to a word document
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
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
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
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
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
Which key do you press to check spelling?
F3
F5
F7
F9
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
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
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
An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts
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
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