date ()
Today ()
now ()
time ()
B. Today ()
DOC
XLS
123
WK1
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
Number format
Border format
Font format
All of above
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
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
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
The autosum button
The Formula button
The quicktotal button
The total button
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 Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
Dialog box
Worksheet
Clipboard
Toolbar
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
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
Accessing
Referencing
Updating
Functioning
Square
Percentage
Goal Seek
Divide
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Contents
Objects
Scenarios
All of above
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Option buttons
List boxes
Text boxes
Combo boxes
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
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
Text
Drawing objects
Pictures
All of above
Edit > Comments
Insert > Comments
File > Comments
View > Comments
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Title bar
Menu bar
Formula bar
Standard toolbar