Computer Science
Question Bank – Half Yearly Examination (Ch-1,3,4 & 5)
I. Convert the following Decimal Numbers into Binary Numbers and vice versa.
(i) 125
(ii) 224
II. Convert the following Binary Numbers into Decimal Numbers and vice versa.
(i) 10011100
(ii) 11110011
III. Solve the following Binary Arithmetic
(i) 11001010 (ii) 100011101
+ 100101 + 1001
______
______
IV. Very Short Answer type questions
Q1.) What is binary?
Q2.) What is octal number system?
Q3.) What is hexadecimal number system?
Q4.) What is concatenation?
Q5.) What is range?
Q6.) What is Autosum feature?
Q7.) What is Goal Seek?
Q8.) What is Data Series?
Q9.) What are legends?
Q10.) What is the use of Chart Title in a Chart?
V. Short Answer type questions
Q1.) Explain number system and its commonly used types.
Q2.) What are the rules to convert a Decimal number into Binary number?
Q3.) Differentiate between a basic formula and a compound formula with an example.
Q4.) What is the difference between CUT PASTE and COPY PASTE?
Q5.) What do you mean by Function? Name some of the functions.
Q6.) Write the steps to rename a sheet tab?
Q7.) Describe the term Database.
Q8.) Differentiate between a Field and a Record.
Q9.) What is Form? How it is useful?
Q10.) Differentiate between Filtering data and Advance Filter.
Q11.) What is the difference between Chart Area and Plot Area?
Q12.) What is the difference between Category Axis and Value Axis?
Q13.) Explain the utility of Pie Chart.
VI. Long Answer type Questions
Q1.) What are formulas? Briefly explain all its elements.
Q2.) What is cell reference? Explain all types of cell references with example.
Q3.) What are functions? Write all the rules to enter a function.
Q4.) Explain the purpose of the following functions:
· Average()· ODD()
· INT()
· Round() / · EXP()
· SQRT()
· Power()
· MOD() / · Today()
· MAX()
· MIN()
· SUM()
Q5.) Explain the utility of Sorting Feature and Filter Feature in Excel
Q6.) What is Chart? Explain any four components of a chart.
Q7.) State any three differences between Column Chart and Bar Chart.
Q8.) Explain any three common errors along with their possible reasons.