Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
B. Linked
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Xls
Xlw
Wk1
123
WINDOWS
DOS
UNIX
OS/2
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Add
Subtract
Divide
SQRT
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Dialog box
Worksheet
Clipboard
Toolbar
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
standard formulas
array formula
complex formulas
smart formula
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
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
Pmt
Average
Max
Sum
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Formula Bar
Status Bar
Tool Bar
None of above
$
*
%
&
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Media player
Sound Recorder
Calculator
Macro Recorder
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
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
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
Press the Alt key
Press Tab
Press Enter
None of above
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
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