Saraswati Education & Medical Trust

Shri R. A. Patel Gyanjyot English & Gujarati Medium School-Borsad

Std: X Sub: Computer Chapter:1 to 7

 Choose the correct alternatives from the following:

1. On the platform of the internet, a distributed information system exists, which is called ____________.
a. World Wide Web b. WWW c. Web d. All of these
2. The notion of web was conceived in __________________ by Tim Berners Lee by consulting at CERN in
Switzerland.
a. 1990 b. 1991 c. 1992 d. 1993
3. __________________ is needed to describe how a web page should be displayed by a web browser.
a. HTML b. HTM c. Both a & b d. None
4. The ___________________ is a documentation language to mark content of web page such as heading,
title, table, image, etc.
a. WWW b. HTML c. SGML d. None
5. _______________ is machine independent and all internet browser accept the content written using
HTML code.
a. WWW b. HTML c. SGML d. None
6. HTML was developed by ISO in _____________ to facilitate the sharing of machine- readable document.
a. 1984 b. 1985 c. 1986 d. 1987
7. A __________ is made up of letters, words & number enclosed between a left & right angular bracket.
a. Tag b. Element c. Code d. None
8. An HTML _______________ may be empty or can have some attributes to specify the additional
formatting & publishing instruction.
a. Tag b. Element c. Attribute d. None
9. The ________________ is a general purpose text editor for the GNOME desktop environment, Mac OS X
and Windows.
a. gedit b. nedit c. Notepad d. None
10. The ____________ section contains information about the page such as title & description of the page.
a. HTML b. Head c. Title d. Body
11. In HTML, the headings can be created in total _________________ inbuilt sizes.
a. 2 b. 4 c. 6 d. 8
12. The _______________ element does not have an opening and closing tags.
a. <p> b. <tt> c. <br> d. <b>
13. The advance versions like XHTML use __________________ tag as a line break.
a. <br> b. <br /> c. <\br> d. None
14. ________________ element is used to display text with multiple white spaces & in multiple lines without
wanting to be changed it by browser.
a. <p>…</p> b. <pre>…</pre> c. <br>…<br /> d. <b>…</b>
15. The content of a ____________ element is displayed with a strikethrough a thin line through the text.
a. <s></s> b. <strike></strike> c. Both a & b d. None
16. In HTML, ________________ is created using an <a> element.
a. Hyperlink b. Hypertext c. Both a & b d. None
17. When we provide hyperlink, __________ color text and underline will display on the browser screen.
a. Blue b. Indigo c. Violet d. Black
18. ________________ comes with complete source code and a license that permits use in any free project
& commercial product.
a. SciTe b. Gedit c. Nedit d. Notepad
19. __________________ is the latest version of the HTML and also becoming too popular.
a. HTML 4.0 b. HTML 5.0 c. HTML 6.0 d. None
20. __________________ is consider as an attribute of an anchor tag in HTML.
a. a href b. href c. Both a & b d. None
21. The _____________ section of the HTML document provides necessary information about the
HTML document.
a. Head b. Title c. Body d. None
22. ____________ will not be displayed as a content of the web page & it just display as a title of the browser
window.
a. Title b. Meta c. Base d. None
23. Most of the browser display ____________________ if a title is not specified in the HTML code.
a. URL b. File name c. Both a & b d. None
24. ___________ tag describes nature of the webpage precisely & make it easy for search engine to search
the webpage efficiently.
a. Head b. Title c. Meta d. Body
25. Most search engine will display the _______________ when they put the result of a search to the user.
a. Description b. Keywords c. Author d. None
26. _________________ provided in this tag will be used by the search engine.
a. Description b. Keywords c. Author d. None
27. ________________ tag is used to add/embed text of the comment inside the HTML code.
a. <!>. . . .</!> b. <!-- …--> c. Both a & b d. None
28. ________________ attribute of meta tag is used to refresh the content of the web page.
a. http-equiv b. content c. URL d. All of these
29. The HTML ___ element acts as a container of the items which have to be displayed within browser.
a. Head b. Title c. Body d. None
30. We can use _________________ attribute with body tag to present the content on decorative & colorful
background.
a. bgcolor b. background c. Both a & b d. None
31. _______________ attribute of body tag allows us to change the background color in the web page.
a. bgcolor b. background c. Both a & b d. None
32. The Colors in computer are coded as degree from 00 to FF in _____________________.
a. Binary b. Decimal c. Octal d. Hexa decimal
33. The combination of RGB value from 0 to 255 gives ________________ million different colors.
a. 14 b. 15 c. 16 d. 18
34. Using ____________________ attribute in body tag, we can provide color to the text.
a. text b. color c. text-color d. None
35. The ________________ attribute used to sets the colors for the active links within the document.
a. alink b. vlink c. both a & b d. None
36. The _____________ attribute is used to sets the color of hyperlinks within the document that have
already been visited.
a. alink b. vlink c. both a & b d. None
37. _____________ style tags indicate the formatting style & browser will follow the instruction strictly &
publishes the content in the said manner.
a. Physical b. Logical c. Both a & b d. None
38. ______ style tag mention the formatting instruction in the browser & just have to tell what we want.
a. Physical b. Logical c. Both a & b d. None
39. ________ mnemonic code is used to display the registered trademark with &ampersand sign.
a. reg b. regt c. erg d. None
40. Using _____________ sign we can display all the special character & symbol using ASCII value.
a. &# b. * c. # d. $
41. _______________ code is used to display the Registered Trademark symbol in the webpage.
a. &#174 b. &reg c. Both a & b d. None
42. Images are added to a web page using ____________________ tag in HTML.
a. <img> b. <image> c. <img src> d. None
43. The image tag with image content & attribute does not cause a line break, hence it is known as
_________________ element.
a. Image b. Inline c. Both a & b d. None
44. The _______________ attribute provide information about the location & source of the image.
a. src b. source c. alt d. None
45. The image file specified should have proper image format such as ___________________.
a. bmp b. tiff c. gif d. All of these
46. Using _________________ tag, we need not have to provide any content, but the source of image with its
attribute.
a. body b. image c. Both a & b d. None
47. The ________________ attribute along with an image tag describe the source image & always advisable
to define it.
a. src b. alt c. alternate d. None
48. The ___________________ attribute specifies how tall & wide the image should appear on the page.
a. height & width b. length & breadth c. resize & crop d. Both a & b
49. The value of height & width attribute can be specified using number of ____________________.
a. points b. percentage c. pixels d. None
50. _____________ value of align attribute display image in such a way that the middle of the image appear
at the current text.
a. Center b. Middle c. Both a & b d. None
51. ________________ attribute will be helpful when the image is inline with the text leaving no gap.
a. vspace b. hspace c. Both a & b d. None
52. The image format _________________ are good for continuously toned images such as photograph.
a. jpg b. jpeg c. Both a & b d. None
53. ________________ file format use the lossless compression technology.
a. gif b. png c. both a & b d. None
54. When we apply a link on the image, it is identified as a ___________________.
a. Hot link b.Hot spot c. Hot text d. hyperlink
55. The ________________ of a hot spot is mentioned using x & y co ordinates measured from the top left
hand corner of the image.
a. location b. position c. area d. None
56. _________________ tags are used along with a usemap attribute into its image tag.
a. <map> b. <area> c. Both a & b d. None
57. Within ______________ tags, the hotspot co-ordinates & their corresponding links are to be specified.
a. <area></area> b.<map></map> c. Both a & b d. None
58. In HTML, the _______________ tag must mention the shape of a hot spot.
a. map b.area c. name d. None
59. ________________ is/are the valid possible shape used in the shape attribute of the area tag .
a. circle b. rectangle c. Polygon d.All of these
60. A __________________ file can be integrated into HTML document using an anchor tag.
a. video b. audio c. Both a & b d. None
61. To create an unordered list in HTML, the pair of _________________ tag is used.
a. <ul></ul> b. <ol></ol> c. <dl></dl> d. <li></li>
62. In ordered and unordered list, the items of the list are enclosed within the _____________ tag pair.
a. <ul></ul> b. <ol></ol> c. <dl></dl> d. <li></li>
63. If we want to change the bullets, we can use an attribute called ___________________.
a. type b. bullet c. Both a & b d. None
64. In unordered list, the type attribute has ___________________ values.
a. circle b. square c. disc d. All of these
65. To create an ordered list in HTML, the _________________ tag pair is used.
a. <ul></ul> b. <ol></ol> c. <dl></dl> d. <li></li>
66. In HTML, generally the ordered list always starts with number __________________.
a. 1 b. i c. I d. All of these
67. ______________ contains information separated in form of grids & information can be present in form
of rows & columns.
a. Nested List b. Table c. Both a & b d. None
68. _______________ attribute of table tag is used to specified the background of the table.
a. bgcolor b. background c. color d. None
69. ________________ attribute leaves specified gap between edges of the cell & their content.
a. Cell spacing b.Cell padding c. Both a & b d. None
70. ________________ attribute manage the space between each cell of the table.
a. Cell spacing b. Cell padding c. Both a & b d. None
71. In table tag, if we use the border attribute with value ________________, no border will be visible.
a. 0 b. 1 c. 2 d. None
72. To set background color of table then ________________value can be provided using bgcolor attribute.
a. Color name b. 6 digit hexadecimal code c. Both a & b d. None
73. The value of _______________ attribute of table tag can be specified either in pixels or in percentage.
a. Cell padding b. Cell spacing c. Width d.All of these
74. _________________ attribute specifies the vertical alignment of the content of each cell in a row.
a. align b. valign c. halign d. None
75. By default, the content of a ______________ tag is usually displayed in a bold font, horizontally aligned
in the center of the cell.
a. <tr> b. <th> c. <td> d. None
76. ______________ attribute is used to indicate number of columns & rows that the cell spans across.
a. colspan b. rowspan c. both a & b d. none
77. _______________ attribute stop text from automatically wrapping into a new line within the cell.
a. wrap b. nowrap c. both a & b d. none
78. The _______________ defines the division of the browser windows & each frame is represented by a
pair of frame tag.
a. Frames b. Frameset c. noframe d. None
79. Within frameset, we may use ________________ element which provide an alternate message for user
when browser does not support frames.
a. <frames> b. <frameset> c. <noframe> d. None
80. ________________ is a long sheet of rows & columns on the computer screen to do data analysis
and calculation.
a. Spreadsheet b. Worksheet c. Both a & b d. None
81. _______ is a grid which interactively manages & organizes data in rows &columns.
a. Sheet b. Worksheet c. Spreadsheet d. All of these
82. ____________ Calc, which closely resembles the Calc is also free and open source spreadsheet package.
a. LibreOffice b. OpenOffice c. Both a & b d. None
83. By default, a new spreadsheet contains ________________ worksheet, but number of worksheet can be
added as per requirement.
a. 1 b. 2 c. 3 d. 4
84. There are maximum _______ worksheets per Calc spreadsheet document.
a. 234 b. 256 c. 278 d. 290
85. The default file name of Calc spreadsheet is ____________.
a. untitled b. Untitled 1 c. Untitle 1 d. Sheet1
86. In Calc, if additional information is required to follow user’s instructions, a dialog box appear
indicated by _________ sign.
a. (..) b. (.) c. (:) d. (+)
87. A __________ as a whole can be selected by clicking on the corresponding letter on the spreadsheet.
a. Rows b. Columns c. Both a & b d. None
88. ________ is an intersection of rows & column & can be identified by its column letter & row number.
a. Cell b. Cell address c. Both a & b d. None
89. In Calc, the __________ box appears is an indicator of an active cell.
a. square b. rectangle c. Both a & b d. None
90. The corner of the active cell is highlighted with filled small rectangle which is known as __________.
a. Autofill b.Autofill handle c. Fill series d. None
 91. In Open Office Calc, there are total __________________ columns & rows respectively.
a. 1024&1,048,576 b. 1045 & 1,048,567 c. 1064 & 1,056,665 d. None
92. ________ is the basic elements of a spreadsheet in which we can enter data, formulas, text, numbers.
a. Row b. Column c. Cell d. None
93. The ________________ shows the cell, which is currently selected on its left.
a. Menubar b.Formula bar c. Status bar d. None
94. The box indicated by ___________ on the right provides an area in which we can enter data or formula
into the cell.
a. f(x) b. p(x) c. Function d. None
95. The current worksheet tab name has _________________ background & the other sheets have the grey
background.
a. White b. Off white c. Cream d. yellow
96. In Calc, by doing right click on the sheet tab, we can perform ________________ operations.
a. Rename b. Move or Copy c. Insert or delete d. All of these
97. In spreadsheets, a cell range is denoted by the address of the first cell & last cell and it is separated
with a _______________ sign.
a. Colon(:) b. Semicolon(;) c. Dot(.) d. None
98. By default, the Calc saves the spreadsheet in the file format with extension __________________.
a. ods b. ots c. csv d. xls
99. __________________ file extension is Calc spreadsheet template format.
a. ods b. ots c. csv d. xls
100. _________________SheetRename allow us to rename the worksheet in Calc.
a. Edit b. Format c. Tools d. None
101. To change the tab color of a worksheet, right click & select ______________ option from the menu.
a. color b. Tab color c. background d. None
102. Using __________ sheet Delete option, we can able to delete the worksheet in Open Office Calc.
a. Edit b. Format c. Tools d. Data
103. In Open Office Calc, by default the values of column width & row height are in ________________.
a. mm b. cm c. inch d. None
104. ______________ option from Edit menu allows us to delete a row or a column in Open Office Calc.
a. Delete b. Delete Rows c. Delete columns d. Delete Cells
105. To select the entire column, click on _________________, it will be highlighted.
a. Column header b. Column c. Cell d. None
106. __________________ menu allow us to freeze a selected row or column to make it visible.
a. Edit b. View c. Tools d. Window
107. If cells are not physically adjacent to each other, we need to hold down the _____________ key.
a. Ctrl b. Shift c. Alt d. None
108. To edit the content of a cell, select the cell & ______________ click with mouse & edit the content.
a. left b. right c. single d. Double
109. ______________ option allow as to paste only text, only number, date & time, formulas, object only.
a. Paste Special b. Paste c. Both a & b d. None
110. To automatically fill data into the cells, the ___________________ tool is used.
a. Fill data b. Fill series c. Auto fill d. Auto series
111. When a ____________ address is copied from one cell to another, it will be automatically changed.
a. Absolute b. Relative c. Both a & b d. None
112. The ________________ address does not changed the formula is copied or moved.
a. Absolute b. Relative c. Both a & b d. None
113. _______ sign added before the row and/or column to make the fix address called absolute address.
a. $ b. # c. % d. &
114. The _______________ format can be applied to a single cell, multiple selected cells & range of cells.
a. Number b. Date & time c. Currency d. All of these
115. Using ____________  sort option, we can bale to sort the data in ascending or descending order.
a. Edit b. Format c. Tools d. Data
116. _________ help us to filter out unnecessary data & present only those which we want to see.
a. Data Filtering b. Data Sorting c. Both a & b d. None
117. To avoid errors in entering data we need to use _________________ facility of Open Office Calc.
a. Error Remover b. Data Validation c. Both a & b d. None
118. When we select _____________ from the delete content windows, then the validity options we have
set will be removed.
a. Format b. Delete All c. Both a & b d. None
119. The ________ areas in Calc are divided in three areas each called left area, centre area & right area.
a. Header b. Footer c. Both a & b d. None
120. Open Office Calc provides built-in functions for ____________ calculation on number or text.
a. Mathematical b. Statistical c. Logical d. All of these
121. A ____________ like an expression generally begins with an equal sign, followed by a function name.
a. Formula b. Function c. Both a & b d. None
122. _________ sign can be used in the functions to find different calculation .
a. Comma(,) b. Semicolon(;) c. Colon(:) d. All of these
123. ________________ shortcut key is used to open Function Wizard dialog box to insert a function.
a. Ctrl + F1 b. Ctrl + F2 c. Ctrl + F3 d. Ctrl + F4
124. _______ function removes the minus sign from the negative number & makes the number positive.
a. ABS() b. Positive() c. Round() d. None
125. ________ function does not make any kind of changes to Zero or Positive numbers.
a. ex() b. exp() c. Both a & b d. None
126. The ________________ function returns the values of the factorial for the given number.
a. Fact() b. Factorial() c. Both a & b d. None
127. The ____________ function returns the value of the natural logarithm for the given positive number.
a. LN() b. NL() c. Log() d. Log10()
128. The ____________ function returns the value of the logarithm base 10 for the given positive number.
a. LN() b. NL() c. Log() d. LOG10()
129. The ______________ function multiplies the number up to 30 arguments.
a. Multiply() b. Power() c. Product() d. All of these
130. The _________________ function rounds the given number down to the nearest integer.
a. ABS() b. Int() c. Round() d. None
131. The ___________________ functions rounds the given number to the specified places.
a. ABS() b. Int() c. Round() d. None
132. _______________ takes two arguments, first is a number & second is number of digits to be cut down
from the number from its fractional part
a. Truncate() b. TRUNC() c. Concatenate() d. Both a & b
133. The _______________ function returns the geometric mean of number given to it.
a. MEAN b. GEOMEAN c. HARMEAN d. All of these
134. The _____________ is defined as middle number of the group when they are ranked in order.
a. Mean b. Median c. Mode d. None
135. _____________ function returns the most common value in a data set which can be single value or
ranges of cells
a. Mean b. Median c. Mode d. None
136. ________________ function can use up to 30 arguments which can be single value or ranges of cells.
a. Mean b. Median c. Mode d. All of these
137. The prominent of all conditional functions used in the Calc is ________________.
a. If b. Else If c. Nested If d. None
138. Calc calculates ______________ expression and if result is true, it return value indicated by True part;
else False part.
a. Logical b. Relational c. Test d. None
139. ______________ sign is used to combine two strings instead of Concatenate function.
a. $[Dollar] b. &[and] c. +[plus] d. None
140. _____________ function turns first letter of all words into uppercase & remaining alphabets in
lowercase letters.
a. UPPER b. SENTENCE c. PROPER d. Both b & c
141. In Calc, the Roman numerals can only represent number from ______ & must be within this range.
a. 0 to 2999 b. 0 to 3999 c. 0 to 4999 d. 0 to 5999
142. The ___ function is reverse of the roman function & considers argument as a roman number only.
a. ARABIC b. LATIN c. Both a & b d. None
143. _________________ function allow us to removes the extra spaces from the strings.
a. TRIM b. TRUNC c. NOSPACE d. None
144. ______ function compares two strings and return 1 if they are exactly the same or 0 if they are not.
a. COMPARE b. EXACT c. SAME d. None
145. ______________ function returns values for the today’s or current date stored in the computer.
a. DATE() b. TODAY() c. DAY() d. Both a & b
146. The ______________ functions returns the valid date for the given number for year, month & day.
a. DATE() b. TODAY() c. DAY() d. Both a & b
147. The ________________ function is used to convert a date given in any recognizable format into days of
the month.
a. DATE() b. TODAY() c. DAY() d. WEEKDAYS()
148. The ________________ function is used to convert a valid date given into a day of week.
a. DATE() b. TODAY() c. DAY() d. WEEKDAY()
149. In Weekday function, days are numbered from __________________ [Sunday to Saturday].
a. 0 to 6 b. 1 to 6 c. Both a & b d. None
150. ____ function returns the number of days in the year presented by given date within the function.
a. YEAR() b. DAYSINYEAR() c. DAYS() d. NOW()
151. The _______________ function calculates the number of days between two dates.
a. DATE() b. DAY() c. WEEKDAYS() d. DAYS()
152. ________ function uses two DATE functions to converts the arguments given into valid date format
a. DAYS() b. WEEKS() c. YEARS() d. All of these
153. The _______________ functions calculates the number of years between two valid dates either in
yearly interval or calendar year
a. YEAR() b. YEARS() c. Both a & b d. None
154. ________________ option is used to insert chart in open office calc.
a. Insertchart b. Formatchart c. Drawchart d. None
155. The charts in calc may have ______________ axis.
a. two b. three c. two or three d. four
156. Which of the following is used to enter 3D text in calc?
a. WordArt b. Fontwork c. Artwork d. Graphwork
157. Which of the following is used to provide a link to the chart in calc?
a. activelink b. link c. hyperlink d. None
158. Which of the following shows us the preview of the chart?
a. Print preview b. Page preview c. Both a & b d. None
159. In FileExport, ___________ option given to export file in another format.
a. XHTML b. PDF c. Both a & b d. None
160. In Calc, _______________ is the rectangular area in which the chart is embedded.
a. Chart area b. Data area c. Chart floor d. Chart wall