The Millennium School, Bathinda
Half-Yearly Exam (2024-25)
SUB- Computer Science Class: VI___
Time Allowed: Name: ________________ Max Marks: 30
Q1. Choose the correct answer. (4)
1. In ______________ chart, data is displayed in the form of an area.
a. Line b. Area
c. Pie d. Column
2. To make a reference absolute, add a ________ sign in front of both column letter and the row?
a. # b&
b. = d$
3. ___________ identifies the location of a cell in a group of cells in the worksheet.
a. Filtering b. cell reference
c. Sorting d. conditional formatting
4. _____________ is the equation that performs calculation.
a. function b. NOT
c. Formula d. None of these
Q2. Fill in the blanks. (5)
1. _____________ Function is to find the average of the specified data.
2. ____________ Function is used to round the decimal values.
3. A ___________ chart is used to show the progress across certain stages.
4. ___________formatting allows to apply formats depending on the values of the cell.
5. ____________ is a tool to get the desired result in a cell by changing a value in another cell.
Q3. State whether the statements are TRUE/FALSE. (5)
1. A chart is the textual representation of the data.
2. To insert a picture in a worksheet, click on the insert tab and then on picture group.
3. The Max function is use to find the large value from range of values.
4. ‘<’ operator is used to find the smallest value out of two.
5.OR return true if any of the given condition is true.
Q4. Define the following. (4)
1. Formula__________________________________________________________________
_________________________________________________________________________________
2. AND operator
___________________________________________________________________________
_________________________________________________________________________________
3. Sorting ___________________________________________________________________
_________________________________________________________________________________
4. Conditional formatting
__________________________________________________________________________
_________________________________________________________________________________
Q5. Match the terms in Column A with the statements in Column B. (5)
Column A Column B
1. Change the case of all in upper a) SUM
letters
2. A tool used to create visual b) Conditional Formatting
representations of data
3. Automatically highlights cells that
c) Upper
meet certain criteria
4. Calculates the total of a range of d) Charts
numbers
5. Allows you to display only rows e) Filtering
that meet specific criteria
Q6. Answer the following questions.
1. What is the difference between bar chart and pie chart? (2)
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
2. Define the Relative cell reference and absolute cell reference.. (2)
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
3. write all number of comparison operators in excel? (3)
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
_______________________________________________________________________________________
