1 |
Pre-made sheet formats like simple classic accounting colorful can be applied from. |
From format >> cells
From Table >> autoformat
From format >> autoformat
All of above
|
2 |
Merge cells option can be applied from. |
Format cells dialog box alignment tab.
Formatting toolbar
Both of above
None of above
|
3 |
Which function will you use to enter current time in a worksheet cell. |
= today()
=now()
= time()
= current time()
|
4 |
Formatting a cell in number format you can't set. |
Decimal places
Currency symbol
Both of above
None of above
|
5 |
Can you set 0.5 inch left indentation for a cell in Excel. |
Excel does not have indentation feature
You can specify indentation only if you turn the rulers on
Indentation can be set from format cells dialog box
The indentation can be specified only when printing
|
6 |
If you need a text to show vertically in a cell .how will you achieve this. |
Choose vertical on text alignment in format cells dialog box
Choose 90 degrees in orientation of format cells dialog box
Choose distributed from the vertical drop down list of format cells dialog box
Choose center Across selection from horizontal combo box in format cells dialog box
|
7 |
The spelling tool is placed on _____________ toobar. |
Standard
Formatting
Drawing
Reviewing
|
8 |
Which of the following is not a valid zoom percentage in Excel. |
10
100
500
300
|
9 |
Which of the following is not of the merge process. |
Sort the data source records
Format a main document
Edit a data soruce
Merge the two files to print or create a new document
|
10 |
You wished to justify text over the height of paper which option will you choose. |
Page setup from file menu
Paragraph from format menu
From formatting toolbar
Font from format menu
|
11 |
MS Office provides help in many ways which of these is one of them. |
What is this
Office assistant
Help menu
All of the above
|
12 |
Which of the following are word processing software. |
Word perfect
Easy word
MS word
All of above
|
13 |
Text boundary can be displayed on hidden from |
Auto text option from insert menu
Options from tools menu
Customize from tools menu
All of above
|
14 |
To move the cursor page to page of document. |
Ctrl + Pgon
Ctrl + Pg Up
Both of above
None
|
15 |
Which is the following command is not available in Tools menu. |
Auto text
Autocorrect
Auto summarize
Macro
|
16 |
To open columns dialog box quickly |
Double click on the left margin area of ruler
Double click the space between area on ruler
Double click the right margin in ruler
All of above
|
17 |
How much spave in minimum must be provided between columns. |
0"
0.5"
1.5"
1"
|
18 |
If the number of columns is selected 1 and the line between check box is marked. where is the line drawn. |
In the left margin
In the right margin
Both in left and right margin
None
|
19 |
What is the smallest width of a column. |
0"
0.5"
1.5"
1"
|
20 |
How can you break the current column and start a new column immediately. |
Press Ctrl + Shift + Enter
Press Alt + Enter
Press Ctrl + Enter
Press Alt + Shift + Enter
|
21 |
You can jump to the next column by |
Clicking with your muse on the next column
Press Alt+ Down arrow
Both of above
None
|
22 |
Columns dialog box can be opened from |
Format menu Columns submenu
Double click on column space in ruler
Press Alt +O+C
All of above
|
23 |
Which of the following is used to create newspaper style columns. |
Format tabs
Table insert table
Insert textbox
Format Columns
|
24 |
What is the maximum number of lines you can set for lines to drop box. |
3
5
10
15
|
25 |
How many different positions can you set for drop cap. |
1
2
4
6
|
26 |
To insert a drop cap in one of the paragraph you should sccess |
Insert Menu
Format
Tools
None
|
27 |
Which of the following option is not available in insert >> picture |
Chart
Word Art
Clip Art
Graph
|
28 |
What is the extension of Word files. |
FIL
DOT
DOC
TXT
|
29 |
Which operation you will perform if you need to move a block of text. |
Copy and paste
Cut and paste
Paste and Delete
Paste and cut
|
30 |
How can you remove tab stop markers from ruler. |
Double click the tab marker and choose clear all
Drag the tab stop marker out of the ruler
Right click the tab stop marker and choose remove
All of above
|