GSEB Class 10 Introduction to Calc Computer Studies MCQs

(1) Which of the following type of package does Calc refer to ?

(A) Spreadsheet

(B) Multi sheet

(C) Double sheet

(D) Cannot be determined

Answer: (A) Spreadsheet

(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 these

Answer: (C) Presenting an idea about a product

(3) Which of the following is the extension of a worksheet created in Calc ?

(A) .ods

(B) .odd

(C) .xls

(D) .obj

Answer: (A) .ods

(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

Answer: (B) Photograph of Calc developer team

(5) How can one calculate total of values entered in a worksheet in a Calc document ?

(A) By manual entry

(B) By AutoSum

(C) By formula

(D) All of these

Answer: (D) All of these

(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 changed at destination.

(D) Nothing will be changed.

Answer: (A) The cell row and columns are changed at destination.

(7) Which option is use to open Calc program ?

(A) Applications -> Office -> Spreadsheet

(B) Applications -> OpenOffice -> Spreadsheet

(C) Start -> Office -> Spreadsheet

(D) Start -> OpenOffice -> Spreadsheet

Answer: (A) Applications -> Office -> Spreadsheet

(8) Which type of package is Calc ?

(A) Word processor

(B) Spreadsheet

(C) Database

(D) Presentation

Answer: (B) Spreadsheet

(9) In Calc, how many spreadsheets are there by default ?

(A) 2

(B) 3

(C) 4

(D) 5

Answer: (B) 3

(10) How many maximum worksheet in spreadsheet document ?

(A) 24

(B) 64

(C) 256

(D) 65536

Answer: (C) 256

(11) How many menu is available in Calc ?

(A) 6

(B) 7

(C) 8

(D) 9

Answer: (D) 9

(12) Which sign is available on bottom right side of the active cell ?

(A) +

(B) #

(C) –

(D) *

Answer: (A) +

(13) How many rows in Calc ?

(A) 65516

(B) 65526

(C) 1 to 65536

(D) 65546

Answer: (C) 1 to 65536

(14) How many columns in Calc ?

(A) 226

(B) 236

(C) 246

(D) 256

Answer: (D) 256

(15) Which is the basic element of a spreadsheet ?

(A) Cell

(B) Worksheet

(C) Workbook

(D) Row and Column

Answer: (A) Cell

(16) In which form scroll bar is seen in Calc ?

(A) Horizontal

(B) Vertical

(C) Both (A) and (B)

(D) None of these

Answer: (C) Both (A) and (B)

(17) Which background does current worksheet tab name have?

(A) Black

(B) White

(C) Red

(D) Green

Answer: (B) White

(18) To add or remove toolbar which option is used ?

(A) File -> Toolbars

(B) Insert -> Toolbars

(C) View -> Toolbars

(D) Format -> Toolbars

Answer: (C) View -> Toolbars

(19) Which menu – option is sued to rename a worksheet ?

(A) Format -> Sheet -> Rename

(B) Format -> Sheet -> Modify

(C) Edit -> Sheet -> Rename

(D) Edit -> Sheet -> Modify

Answer: (A) Format -> Sheet -> Rename

(20) Which menu – option is used in Calc to add new worksheet?

(A) File -> Sheet

(B) View -> Sheet

(C) Insert -> Sheet

(D) Tools -> Sheet

Answer: (C) Insert -> Sheet

(21) Which menu – option is used to save Worksheet in Calc ?

(A) File -> Save

(B) File -> Store

(C) File -> Add

(D) File -> Set

Answer: (A) File -> Save

(22) Which symbol is used for multiplication in Calc ?

(A) &

(B) *

(C) #

(D) @

Answer: (B) *

(23) Which symbol is necessary to write at the starting of formula ?

(A) =

(B) #

(C) @

(D) *

Answer: (A) =

(24) Which key is pressed to see the result after entering formula in Calc ?

(A) Insert key

(B) Ctrl key

(C) Enter key

(D) Shift key

Answer: (C) Enter key

(25) To show cell range in Calc which symbol is used to separate the first cell address and the last cell address ?

(A) .

(B) ,

(C) :

(D) ;

Answer: (C) :

(26) Which of the following option is used to add the values between cell A1 to A5 in Calc ?

(A) =A1+A2+A3+A4+A5

(B) =Sum(A1:A5)

(C) Σ button

(D) All of these

Answer: (D) All of these

(27) Which function is used to do sum in Calc ?

(A) Plus

(B) Sum

(C) Joint

(D) Add

Answer: (B) Sum

(28) In which form, the sum function appears in function bar ?

(A) Σ

(B) Δ

(C) Ψ

(D) Ш

Answer: (A) Σ

(29) On which bar Σ symbol does appear ?

(A) Title bar

(B) Formula bar

(C) Symbol bar

(D) Format bar

Answer: (B) Formula bar

(30) What is called to arrange data in order ?

(A) Filtering

(B) Inserting

(C) Sorting

(D) Deleting

Answer: (C) Sorting