Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
D. Any of the above
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
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
Contents
Objects
Scenarios
All of above
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Cell value
Formula
Both of above
None of above
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
The edit formula button
The cancel button
The enter button
All of the above
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
Number format
Border format
Font format
All of above
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Title bar
Menu bar
Formula bar
Standard toolbar
Linear
Growth
Autofill
Time
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
sheet3!A10
sheet1!A10
Sheet3.A10
A10
auto formatting
applying styles
changing fonts
all of above
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
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
Number
Character
Label
Date/time
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Validation
Formats
Formulas
All of above
Server
Destination
Client
Both b and c
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
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
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
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
=
+
(
@
Copy cell contents
Move cell contents
Add cell contents
a and b
$
*
%
&