Cell value
Formula
Both of above
None of above
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
256
1024
32000
65535
=10+50
10+50
=10+50
=B7+14
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
A type of chart
A cell reference
A collection of related data
A division of results
Formula Bar
Status Bar
Tool Bar
None of above
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Copy handle
Fill handle
Insert handle
Border
date ()
Today ()
now ()
time ()
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Data, Sort
Data, Form
Data, Table
Data Subtotals
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Add
Subtract
Divide
SQRT
Reference tabs
Position tabs
Location tabs
Sheet tabs
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Logical
Math & Trigonometry
Statistical
Financial
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
!A!1
$A$1
#a#1
A1
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
server
source
client
none
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
The Alt key
The Tab key
The Enter key
None of the 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
Xls
Xlw
Wk1
123
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
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
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
End key
Shift key
Ctrl key
Esc key
ROUND ( )
FACT ( )
MOD ( )
DIV ( )