=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Area
Line
Pie
All of the above
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
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
Option buttons
List boxes
Text boxes
Combo boxes
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
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative 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
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
3
8
255
none of above
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
Title bar
Formula bar
Menu bar
Sheet tabs
128
256
512
1024
Number format
Border format
Font format
All of above
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
standard formulas
array formula
complex formulas
smart formula
Accessing
Referencing
Updating
Functioning
Data, Sort
Data, Form
Data, Table
Data Subtotals
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
Title bar
Menu bar
Formula bar
Standard toolbar
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
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