Workbooks
Worksheets
Charts
Worksheets and charts
D. Worksheets and charts
Linear
Growth
Autofill
Time
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
There is no way to copy and apply formatting in Excel You have to do it manually
The Format Painter button on the standard toolbar
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
=10+50
10+50
=10+50
=B7+14
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Excel 2000
Excel 2002
Excel ME
Excel XP
CTRL + C
CTRL + Arrow key
CTRL + S
None of the 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
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
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
0
1
5
10
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
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
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
Efficiency
Aditibility
Description
Clarity
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
AA
A1
Aa
A0
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
!A!1
$A$1
#a#1
A1
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
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
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
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Pmt
Average
Max
Sum
Validation
Formats
Formulas
All of above
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Input cells
Constraints
Target cell
Changing cells
Server
Destination
Client
Both b and c
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c