extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
D. none of the above
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
Contents
Objects
Scenarios
All of the 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
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Goal seek
Solver
Scenario manager
Auto Outline
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
WINDOWS
DOS
UNIX
OS/2
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Pmt
Average
Max
Sum
256
1024
32000
65535
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
VisiCalc
Lotus 1-2-3
Excel
StarCalc
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
Accessing
Referencing
Updating
Functioning
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Workbooks
Worksheets
Charts
Worksheets and charts
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
Number
Character
Label
Date/time
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
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
Xls
Xlw
Wk1
123
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
Dialog box
Worksheet
Clipboard
Toolbar