The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Correct Answer :
B. Formula bar
Related Questions
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
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
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
The spelling dialog box can be involved by choosing spelling from ________ menu.
insert
file
tools
view
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
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
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
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
5430
5436.80
5436.8
6.8
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
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
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
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 Chart can be created in Excel?
Area
Line
Pie
All of the above
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
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete