Page 141 - TP_V5.1_C7_fb
P. 141

Half-Yearly Examination

                                                      Sample Paper





                                                   (Chapters 1, 2, 3 and 4)


                 Max. Time: 2 Hours                                                                  Max. Marks: 40


                 1.  Fill in the blanks.                                                                           5×1=5
                    a. A computer represents all kinds of data and information like text, numbers, audio and video
                       in ........................ form.
                    b. The hexadecimal  number system  uses  digits from 0 to  9 and letters  from  ........................
                       to ........................ .

                    c. The feature that  allows you  to  see  only the data  that  meets  specific  criteria  is
                       called ........................ .

                    d. To style an element with a circle bullet, you can use the CSS property list-style-........................ .

                    e. To arrange data in ascending order, you use the ........................ option in Excel.
                 2.  Application-based questions.                                                                   4×1=4
                    a. You need to find out which students have attended more than 40 classes. What feature in
                       Excel will help you filter this information?
                    b. You  are  working  on  a  project  that  involves  converting  binary  numbers  to  decimals.
                       You receive the binary number 1011. Convert this binary number to its decimal equivalent.

                    c. Your friend wants to  know how  many items  he has in a list of products.  He should use
                       the ........................ function to count the number of entries.
                    d. You have scores for 5 subjects: 88, 92, 79, 85, and 90. Which Excel function will you use to
                       find the average score?
                 3.  Define the following terms:                                                                 4×1.5=6

                    a. LEN() function in Excel
                    b. Conditional Formatting

                    c. Rowspan attribute in an HTML table
                    d. Decimal number system

                 4.  Short answer type questions.                                                                  3×2=6
                    a. Difference between Least Significant Digit and Most Significant Digit.
                    b. Explain the difference between the <ol> and <ul> tags in HTML.

                    c. Describe how to use the ROUND() function in Excel and provide an example.
                 5.  Long answer type questions.                                                                   3×3=9

                    a. Explain the difference between container tags and empty tags in HTML, with examples.
                    b. Describe a scenario where you would use conditional formatting to improve the readability of
                       a data table. Explain how you would set it up.
                    c. What is the difference between the LEFT() and RIGHT() functions? Provide examples of both.


                                                                                Half-Yearly Examination Sample Paper  139
   136   137   138   139   140   141   142   143   144   145   146