OFFICE FOR INFORMATION TECHNOLOGY
MULTIPLE-CHOICE QUESTIONS (MCQ)
51. Comments put in cells are known as …..
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Correct Answer: B
52. Which menu alternative can be used to cut up home windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View –> Split
Correct Answer: C
53. You can set off the mobile 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 outcomes in the structure statistics sequence dialog box, you can not
a. rotate textual content on chart
b. pick out a foreground color
c. pick a pattern
d. pick a heritage 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 can't 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 a picture 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 chosen variety of statistics to any other worksheet in the equal 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 complete worksheet is displayed
b. the chosen vary is displayed
c. the lively element of the worksheet is displayed
d. a, b and c
Correct Answer: D
60. You can open the Sort dialog field via selecting Sort from the ….. menu
a. View
b. Format
c. Tools
d. Data
Correct Answer: D
61. When working in the web page destroy preview, you can
a. view precisely the place every web page wreck occurs
b. add or eliminate web page breaks
c. alternate the print area
d. all of above
Correct Answer: D
62. Which of the following is now not a legitimate Zoom proportion in Excel?
A) 10
B) a hundred
C) 300
D) 500
Correct Answer: D
63. The spelling device is positioned on ______ toolbar
A) Standard
B) Formatting
C) Drawing
D) Reviewing
Correct Answer: A
64. Formatting a mobile 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 mobile phone in Number layout you can’t set
A) Decimal Places
B) Use one thousand separator
C) Negative numbers
D) Currency Symbol
Correct Answer: D
65. What is entered with the aid of the feature =today()
A) The date price for the day in accordance to the gadget clock
B) The time fee in accordance to the machine clock
C) Today’s date as Text structure
D) All of above
Correct Answer: A
66.Which characteristic will you use to enter present day time in a woksheet cell?
A) =today()
B) =now()
C) =time()
D) =currentTime()
Correct Answer: B
67. Merge cells alternative can be utilized from
A) Format Cells dialog field Alignment Tab
B) Formatting toolbar
C) Both of above
D) None of above
Correct Answer: A
68. Which of the following structure you can figure out to observe or no longer in the AutoFormat dialog box?
A) Number layout
B) Border layout
C) Font format
D) All of above
Correct Answer: D
69. How can you take away borders utilized in cells?
A) Choose None on the Border tab of Format cells
B) Open the listing on the Border device in the Formatting toolbar then select the first device (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 field
B) From the Border device in the Formatting toolbar
C) From the Line Style device in the Drawing toolbar
D) You can now not set web page border in Excel
Correct Answer: D
71. You can take a look at the prerequisites in opposition to __________ when making use of conditional formatting
A) Cell cost
B) Formula
C) Both of above
D) None of above
Correct Answer: C
72. When a variable is selected, how can you prompt the preceding 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 includes distinctive sheets. Which of the following can now not be a sheet in the workbook?
A) worksheet
B) chart sheet
C) module sheet
D) datasheet
Correct Answer: D
74. Which of the following Excel display elements can NOT become on or off?
A) Formula Bar
B) Status Bar
C) Tool Bar
D) None of above
Correct Answer: D
75. Which of the following alternative is now not reachable in the Paste Special dialog box?
A) Add
B) Subtract
C) Divide
D) SQRT
Correct Answer: D
0 মন্তব্যসমূহ