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
Correct Answer :
D. Click on Merge and Center tool on formatting toolbar
Related Questions
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
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
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
To center worksheet titles across a range of cells, you must
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
Each excel file is called a workbook because
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
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
Which is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
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
When you copy a formula
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
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
To copy formatting from one area in a worksheet and apply it to another area you would use:
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
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key