The autosum button
The Formula button
The quicktotal button
The total button
A. The autosum button
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
350
May 10, 2001
0.57
Serial Number 50771
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
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
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
Pie chart
Row chart
Line chart
Column chart
Word
Smart cell
Excel
Lotus 1-2-3
standard formulas
array formula
complex formulas
smart formula
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
DOC
XLS
123
WK1
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
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
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
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Text
Drawing objects
Pictures
All of above
The entire worksheet
Rows
Columns
All of the above
Formula bar
Status Bar
Name Box
Title Bar
Option buttons
List boxes
Text boxes
Combo boxes
Format > window
View > window > split
Window > split
View > split
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
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
work sheet
chart sheet
module sheet
data sheet
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Xls
Xlw
Wk1
123
256
1024
32000
65535
The autosum button
The Formula button
The quicktotal button
The total button
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series