COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
D. counts non-empty cells
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
Reference tabs
Position tabs
Location tabs
Sheet tabs
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
Efficiency
Aditibility
Description
Clarity
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
Word
Smart cell
Excel
Lotus 1-2-3
256
1024
32000
65535
server
source
client
none
Delete contents
Delete notes
Delete cells
Delete formats
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
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
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
XY Chart
Line Chart
Pie Chart
Column Chart
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
Pie chart
Row chart
Line chart
Column chart
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
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
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
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
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
WINDOWS
DOS
UNIX
OS/2
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
Input cells
Constraints
Target cell
Changing cells