Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
D. Ctrl+Space Bar
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Excel 2000
Excel 2002
Excel ME
Excel XP
Smart tip
Cell tip
Web tip
Soft tip
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
Pie chart
Row chart
Line chart
Column chart
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
Option buttons
List boxes
Text boxes
Combo boxes
Data, Sort
Data, Form
Data, Table
Data Subtotals
Media player
Sound Recorder
Calculator
Macro Recorder
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
256
1024
32000
65535
F8
F9
F10
F11
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
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
date ()
Today ()
now ()
time ()
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
The autosum button
The Formula button
The quicktotal button
The total button
!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
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
Copy handle
Fill handle
Insert handle
Border
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
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
$
*
%
&