When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
Pmt
Average
Max
Sum
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
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
Smart Tip
Cell Tip
Web Tip
Soft Tip
The edit formula button
The cancel button
The enter button
All of the above
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
=
+
(
@
AA
A1
Aa
A0
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
128
256
512
1024
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
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
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
256
1024
32000
65535
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
0
1
5
10
Add
Subtract
Divide
SQRT
The autosum button
The Formula button
The quicktotal button
The total button
WINDOWS
DOS
UNIX
OS/2
350
May 10, 2001
0.57
Serial Number 50771
insert
file
tools
view
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Delete contents
Delete notes
Delete cells
Delete formats