format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
B. create and edit formula containing functions
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
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
Page Break Preview
Page Orientation
Margins
Headers and Footers
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
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
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
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
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
XY Chart
Line Chart
Pie Chart
Column Chart
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
128
256
512
1024
0
1
5
10
insert
file
tools
view
Solver
Goal seek
Scenario Manager
All of above
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
work sheet
chart sheet
module sheet
data sheet
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Copy handle
Fill handle
Insert handle
Border
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Pmt
Average
Max
Sum
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above