Efficiency
Aditibility
Description
Clarity
C. Description
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
3
8
255
none of above
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
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
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
The Alt key
The Tab key
The Enter key
None of the 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
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
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
Paper
Margin
Layout
Orientation
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
XY Chart
Line Chart
Pie Chart
Column Chart
Delete contents
Delete notes
Delete cells
Delete formats
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
Visual Basic
C
Visual C++
Java
256
1024
32000
65535
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Excel 2000
Excel 2002
Excel ME
Excel XP
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
Pmt
Average
Max
Sum