=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
A. =SUM(Sales)-A3
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
WINDOWS
DOS
UNIX
OS/2
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
Title bar
Menu bar
Formula bar
Standard toolbar
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
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
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
work sheet
chart sheet
module sheet
data sheet
Xls
Xlw
Wk1
123
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
Paper
Margin
Layout
Orientation
Validation
Formats
Formulas
All of above
256
1024
32000
65535
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
Linear
Growth
Autofill
Time
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
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
Contents tab
Answer Wizard tab
Index tab
all of the above
Workbooks
Worksheets
Charts
Worksheets and Charts
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Square
Percentage
Goal Seek
Divide
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
Contents
Objects
Scenarios
All of the above
Area
Line
Pie
All of the above
Pmt
Average
Max
Sum