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
B. Apply Conditional Formatting command on Format menu
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
WINDOWS
DOS
UNIX
OS/2
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
256
1024
32000
65535
DOC
XLS
123
WK1
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
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
Efficiency
Aditibility
Description
Clarity
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
The autosum button
The Formula button
The quicktotal button
The total button
XY Chart
Line Chart
Pie Chart
Column Chart
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Word
Smart cell
Excel
Lotus 1-2-3
Pmt
Average
Max
Sum
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
Contents
Objects
Scenarios
All of the above
Linear
Growth
Autofill
Time
F8
F9
F10
F11
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
Area
Line
Pie
All of the above
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style