Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
D. Group of Workbooks
Page Break Preview
Page Orientation
Margins
Headers and Footers
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
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
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
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
Accessing
Referencing
Updating
Functioning
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
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
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
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
=
+
(
@
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
Number
Character
Label
Date/time
Contents tab
Answer Wizard tab
Index tab
all of the above
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
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
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
128
256
512
1024
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Logical
Math & Trigonometry
Statistical
Financial
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
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
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
Excel 2000
Excel 2002
Excel ME
Excel XP
Copy cell contents
Move cell contents
Add cell contents
a and b
Area
Line
Pie
All of the above