It is acceptable to let long text flow into adjacent cells on a worksheet when
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
Correct Answer :
B. no data will be entered in the adjacent cells
Related Questions
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Which of the following is not true regarding Conditional Formatting?
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
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
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
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
The auto calculate feature
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
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Which of the following methods cannot be used to enter data in a cell
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
How many worksheets can a workbook have?
3
8
255
none of above
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
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
You can set Page Border in Excel from
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
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar