Title bar
Menu bar
Formula bar
Standard toolbar
C. Formula bar
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
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
128
256
512
1024
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Validation
Formats
Formulas
All of above
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Goal seek
Solver
Scenario manager
Auto Outline
Media player
Sound Recorder
Calculator
Macro Recorder
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
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
=
+
(
@
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
256
1024
32000
65535
WINDOWS
DOS
UNIX
OS/2
3
8
255
none 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
Visual Basic
C
Visual C++
Java