1. Which of the following refers to a list of instructions in a proper order to solve a problem called? 
a. Algorithm
b. Flowchart
c. Sequence
d. Roadmap 

2. Which of the following symbol is used to test conditions in a flowchart?
a. Diamond
b. Circle
c. Arrow
d. Square

3. Which of the following symbol is used to represent output in a flowchart?
a. Square
b. Circle
c. Parallelogram
d. Triangle

4. Which of the following is the standard terminal symbol for a flowchart?
a. Circle
b. Diamond
c. Rounded Rectangle
d. Square

5. Which of the following refers to the purpose of Algorithm and Flowchart?
a. Know the memory capacity
b. Identify the base of the number system
c. Direct the output to the printer
d. Specify the problem completely and clearly

6. Which of the following is not a problem solving technique?
a. Pseudo code
b. Flowchart
c. Algorithm
d. Sequence

7. Which of the following is a pictorial representation of a problem solving technique?
a. Pseudo code
b. Flowchart
c. Algorithm
d. Computer program

8. An arrow symbol in flowchart is sued to show
a. The flow of an action
b. The sequence of action
c. The start of actions
d. The completion of an action

9. Which of the following refers to the core part of any solution?
a. Input
b. Output
c. Process
d. Algorithm

10. Which of the following symbol represents a Process?
a. Rectangle
b. Square
c. Circle
d. Diamond

11. Which of the following is used to distinguish different connector pairs in flowchart?
a. Arrows are used
b. Alphabets or other characters are used
c. Circles are used
d. Diamonds are used

(Note: A circle symbol is used to represent a connector but to distinguish different connector, different characters are used with a same alphabet in a pair.)

1. Which of the following option is used to print a chart?
a. Insert -- Chart
b. File -- View
c. File -- Print
d. View -- Chart

2. The charts in Calc may have how many of the following axis?
a. Two
b. Three
c. Two or Three
d. Four

3. Which of the following is used to enter 3D text in Calc?
a. Fontwork
b. Artwork
c. Drawing work
d. Graphwork

4. Which of the following shows us the preview of the chart?
a. Save as XHTML
b. Page preview
c. Export chart
d. All of the above

5. Which of the following is used to provide a link to the chart?
a. Activelink
b. Hyperlink
c. Drawinglink
d. Connectionlink

6. To fix the column or row in a data range – to make it absolute, which symbol is used?
a. #
b. $
c. &
d. %

7. To which of the entity can a Calc chart be linked?
a. To an existing document
b. To a new document
c. Web page
d. All of the above

1. In which of the following ways we can enter a function in Calc?
a. Directly typing function name in a cell
b. Function wizard or selecting from tool bar
c. Both A and B
d. Depends on function

2. A function can start with which of the following options?
a. ‘=’ sign
b. Alphabets
c. Numbers
d. Any of the above

3. Which of the following is not a logical function?
a. OR
b. AND
c. NOT
d. PROPER

4. Which date and time function of Calc you will use to find out whether the given year is leap year or not?
a. DAYSINYEAR()
b. DAYS()
c. Both (A) and (B)
d. DATE()

5. Which is the possible mechanism to enter a function in Calc cell?
a. Through function wizard
b. By manually entering
c. Both (A) and (B)
d. Depends on function

6. How many arguments one can use with a Calc function?
a. One
b. Two
c. Three
d. Depends on the function

7. What can be a function argument?
a. Value
b. Text
c. Other function
d. All of the above

1. Which of the following technique arranges the data set in a particular order such as ascending and descending?
a. Data formatting
b. Data validators
c. Data filtering
d. Data sorting

2. Which of the following technique can be used to allow only date values in a cell?
a. Data formatting
b. Data validators
c. Data filtering
d. Data sorting

3. Which of the following options when selected deletes all data validation?
a. Delete formatting
b. Delete all
c. Delete formula
d. Delete me

4. We can replace multiple occurrence of a word using which of the following facility of Calc?
a. Find and replace
b. By replace only
c. By cope command
d. By preview command

5. Page preview will also allow you to do which of the following settings?
a. Borders
b. Margins
c. Column and row heading
d. All of the above

6. Which of the following function key is used to check spelling in Calc?
a. F1
b. F3
c. F5
d. F7

7. Which of the following function key is used to get help in Calc?
a. F1
b. F3
c. F5
d. F7

8. What is the name of mechanism to arranging the data in a particular order?
a. Sorting
b. Searching
c. Filtering
d. Validating

9. What is the name of mechanism to filter out unnecessary data?
a. Sorting
b. Searching
c. Filtering
d. Validating

10. What is the name of mechanism to allow only valid data?
a. Sorting
b. Searching
c. Filtering
d. Validating

1. Which of the following type or package does Calc refer to?

2. Which of the following applications are not suitable for Calc?
a. Balance sheet preparation
b. Result analysis
c. Presenting an idea about a product
d. All of the above

3. Which of the following is the extension of a worksheet created in Calc?
a. .ods
b. .odd
c. .xls
d. .obj

4. Which of the following will be inserted in a worksheet if=starcalcteam() is inserted in a Calc cell?
a. Stars
b. Photograph of Calc developer team
c. Calc license information
d. Calc version information

5. How can one calculate total of value entered in a worksheet in a Calc document?
a. By manual entry
b. By autosum
c. By formula
d. All of the above

6. If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in formula?
a. The cell row and columns are changed at destination
b. The cell row numbers are changed at destination
c. The cell column numbers are change at destination
d. Nothing will be changed