Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
A. Press the Alt key
Dialog box
Worksheet
Clipboard
Toolbar
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
Copy handle
Fill handle
Insert handle
Border
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
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
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
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
=
+
(
@
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Page Break Preview
Page Orientation
Margins
Headers and Footers
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
Square
Percentage
Goal Seek
Divide
Pie chart
Row chart
Line chart
Column chart
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Word
Smart cell
Excel
Lotus 1-2-3
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Text
Drawing objects
Pictures
All of above
Validation
Formats
Formulas
All 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
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
XY Chart
Line Chart
Pie Chart
Column Chart
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
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home