standard formulas
array formula
complex formulas
smart formula
B. array formula
AA
A1
Aa
A0
3
8
255
none of above
date ()
Today ()
now ()
time ()
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
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
End key
Shift key
Ctrl key
Esc key
Edit > Comments
Insert > Comments
File > Comments
View > Comments
128
256
512
1024
Contents
Objects
Scenarios
All of above
Copy handle
Fill handle
Insert handle
Border
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
sheet3!A10
sheet1!A10
Sheet3.A10
A10
=10+50
10+50
=10+50
=B7+14
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
Data, Sort
Data, Form
Data, Table
Data Subtotals
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
350
May 10, 2001
0.57
Serial Number 50771
work sheet
chart sheet
module sheet
data sheet
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
Reference tabs
Position tabs
Location tabs
Sheet tabs
standard formulas
array formula
complex formulas
smart formula
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
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the 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
Smart Tip
Cell Tip
Web Tip
Soft Tip
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
!A!1
$A$1
#a#1
A1
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
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