Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
B. Create and edit formulas containing functions
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
Efficiency
Aditibility
Description
Clarity
Contents
Objects
Scenarios
All of above
128
256
512
1024
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
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, Chart
Insert, Chart
Tools, Chart
Format, Chart
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
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
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
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Press the Alt key
Press Tab
Press Enter
None of above
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
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
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
work sheet
chart sheet
module sheet
data sheet
Smart tip
Cell tip
Web tip
Soft tip
Media player
Sound Recorder
Calculator
Macro Recorder
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Format > window
View > window > split
Window > split
View > split
Page Break Preview
Page Orientation
Margins
Headers and Footers
Contents
Objects
Scenarios
All of the above
COUNTA ()
function do?counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells