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
C. Double clicking on column right border on column header
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
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
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
Smart tip
Cell tip
Web tip
Soft tip
128
256
512
1024
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
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
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
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
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Server
Destination
Client
Both b and c
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
There is no way to copy and apply formatting in Excel You have to do it manually
The Format Painter button on the standard toolbar
insert
file
tools
view
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Excel 2000
Excel 2002
Excel ME
Excel XP
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
Accessing
Referencing
Updating
Functioning
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
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
The entire worksheet
Rows
Columns
All of the above
DOC
XLS
123
WK1
Input cells
Constraints
Target cell
Changing cells
Solver
Goal seek
Scenario Manager
All of above
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
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