Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
B. Type the equals sign (=) to tell Excel that youre about to enter a formula
The entire worksheet
Rows
Columns
All of the above
Visual Basic
C
Visual C++
Java
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
standard formulas
array formula
complex formulas
smart formula
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
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
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
256
1024
32000
65535
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
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
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
Formula bar
Status Bar
Name Box
Title Bar
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
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
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
VisiCalc
Lotus 1-2-3
Excel
StarCalc
auto formatting
applying styles
changing fonts
all of above
128
256
512
1024
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
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Press the Alt key
Press Tab
Press Enter
None of above
Workbooks
Worksheets
Charts
Worksheets and Charts
Formula Bar
Status Bar
Tool Bar
None of above
Add
Subtract
Divide
SQRT