Microsoft word Mcq questions and Answers (51-75)

INFORMATION TECHNOLOGY FOR OFFICE

MULTIPLE CHOICE QUESTIONS

51.Comments put in cells are called …..

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

Correct Answer: B

52.Which menu option can be used to split windows into two?

A. Format -> Window

B. View -> Window-> Split

C. Window -> Split

D. View –> Split

Correct Answer: C

53.You can activate a cell by

a. Pressing the Tab key

b. Clicking the cell

c. Pressing an arrow key

d. All of above

Correct Answer: D

54.When you use the fill effects in the format data series dialog box, you can not

a. rotate text on the chart

b. select a fore ground color

c. select a pattern

d. select a background color

Correct Answer: A

55.To insert three columns between columns D and E you would

a. Select column D

b. Select column E

c. Select columns E, F and G

d. Select columns D, E, and F.

Correct Answer: B

56.Hyperlinks cannot be

a. Special shapes like stars and banners

b. Drawing objects like rectangles ovals

c. Pictures

d. All can be hyperlinks

Correct Answer: D

57.You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.

a. Standard

b. Formatting

c. Drawing

d. Picture

Correct Answer: D

58.To drag a selected range of data to another worksheet in the same workbook, use the

a. Tab key

b. Alt key

c. Shift key

d. Ctrl key

Correct Answer: D

59.When you print preview a worksheet

a. the entire worksheet is displayed

b. the selected range is displayed

c. the active portion of the worksheet is displayed

d. a, b and c

Correct Answer: D

60.You can open the Sort dialog box by choosing Sort from the ….. menu

a. View

b. Format

c. Tools

d. Data

Correct Answer: D

61.When working in the page break preview, you can

a. view exactly where each page break occurs

b. add or remove page breaks

c. change the print area

d. all of above

Correct Answer: D

62.Which of the following is not a valid Zoom percentage in Excel? 

A) 10 

B) 100 

C) 300

 D) 500

 Correct Answer: D

63.The spelling tool is placed on ______ toolbar

 A) Standard

 B) Formatting 

C) Drawing

 D) Reviewing

Correct Answer: A

64.Formatting a cell in Currency, you can specify

 A) Decimal Places

 B) Currency Symbol

 C) Both of above

D) None of above 

Correct Answer: C

64.Formatting a cell in Number format you can’t set

 A) Decimal Places 

B) Use 1000 separator

 C) Negative numbers

 D) Currency Symbol

Correct Answer: D

65.What is entered by the function =today() 

A) The date value for the day according to system clock 

B) The time value according to system clock 

C) Today’s date as Text format 

D) All of above 

Correct Answer: A

66.Which function will you use to enter current time in a woksheet cell?

 A) =today() 

B) =now() 

C) =time() 

D) =currentTime()

Correct Answer: B

67.Merge cells option can be applied from 

A) Format Cells dialog box Alignment Tab 

B) Formatting toolbar 

C) Both of above

 D) None of above

 Correct Answer: A

68.Which of the following format you can decide to apply or not in AutoFormat dialog box? 

A) Number format 

B) Border format 

C) Font format

 D) All of above 

Correct Answer: D

69.How can you remove borders applied in cells? 

A) Choose None on Border tab of Format cells 

B) Open the list on Border tool in Formatting toolbar then choose first tool (no border) 

C) Both of above 

D) None of above

Correct Answer: C

70.You can set Page Border in Excel from 

A) From Border tab in Format Cells dialog box 

B) From Border tool in Formatting toolbar 

C) From Line Style tool in Drawing toolbar 

D) You can not set page border in Excel 

Correct Answer: D

71.You can check the conditions against __________ when applying conditional formatting 

A) Cell value 

B) Formula

C) Both of above 

D) None of above 

Correct Answer: C

72.When a range is selected, how can you activate the previous cell? 

A) Press the Alt key 

B) Press Tab 

C) Press Enter 

D) None of above

Correct Answer: D

73.Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? 

A) work sheet 

B) chart sheet 

C) module sheet 

D) data sheet 

Correct Answer: D

74.Which of the following Excel screen components can NOT be turned on or off? 

A) Formula Bar

 B) Status Bar 

C) Tool Bar

 D) None of above 

Correct Answer: D

75.Which of the following option is not available in Paste Special dialog box?

A) Add 

B) Subtract 

C) Divide 

D) SQRT

Correct Answer: D