Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
Correct Answer :
A. Wrap Text in Format >> Cells
Related Questions
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
The autofill feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
The short cut key Ctrl + R is used in Excel to
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
Which symbol must all formula begin with?
=
+
(
@
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
You can move a sheet from one workbook into new book by
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
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
Excel files have a default extension of
Xls
Xlw
Wk1
123
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
XY Chart
Line Chart
Pie Chart
Column Chart
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
You can select a single range of cells by
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
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3