How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
Correct Answer :
D. Format, cells, alignment
Related Questions
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
5430
5436.80
5436.8
6.8
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
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
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
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
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
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
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
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
To create a formula, you can use:
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
A typical worksheet has …. Number of columns
128
256
512
1024
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
How can you remove borders applied in cells?ACC
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
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 of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
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
Which of the following is the latest version of Excel
Excel 2000
Excel 2002
Excel ME
Excel XP
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
How can you find specific information in a list?
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
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F