Questions · Page 1 of 2

MCQ . (1 Marks)

🎯

Test yourself on this topic

50 questions · timed · auto-graded

MCQ 11 Mark
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
  • All of the given
Answer
Correct option: D.
All of the given
d
View full question & answer
MCQ 21 Mark
Which of the following is the extension of a worksheet created in Cale ?
  • ods
  • B
    odd
  • C
    xls
  • D
    obj
Answer
Correct option: A.
ods
a
View full question & answer
MCQ 31 Mark
Which of the following applications are not suitable for Calc ?
  • A
    Balance sheet preparation
  • B
    Result analysts
  • Presenting an idea about a product
  • D
    All of the given
Answer
Correct option: C.
Presenting an idea about a product
c
View full question & answer
MCQ 41 Mark
Which of the following type of package does Calc refer to ?
  • Spreadsheet
  • B
    Multi-sheet
  • C
    Double sheet
  • D
    Cannot be determined
Answer
Correct option: A.
Spreadsheet
a
View full question & answer
MCQ 51 Mark
_________ is an electronic spreadsheet package from the OpenOffice suits.
  • Calc 
  • B
    Writer 
  • C
    Excel 
  • D
    Lotus 123
Answer
Correct option: A.
Calc 
A
View full question & answer
MCQ 61 Mark
Which of the following will be inserted in a worksheet if =starcalcteam( )is inserted in a Calc cell ? 
  • A
    Stars
  • Photograph of Calc developer
  • C
    Calc licence Information
  • D
    Cale version Information 
Answer
Correct option: B.
Photograph of Calc developer
B
View full question & answer
MCQ 71 Mark
 _________ sign on the sheet tab takes you to the very first worksheet ? 
  • A
  • B
  • C
    ►I
  • I◄
Answer
Correct option: D.
I◄
D
View full question & answer
MCQ 81 Mark
Which of the following works as a navigation tool in a worksheet ? 
  • A
    statusbar 
  • B
    scroll bar 
  • sheet tab 
  • D
    zoom tool
Answer
Correct option: C.
sheet tab 
C
View full question & answer
MCQ 91 Mark
 _________  presents facilities for entering and editing formula within a cell.
  • Formulatoolbar
  • B
    Formatting toolbar
  • C
    Standard toolbar
  • D
    All of the given
Answer
Correct option: A.
Formulatoolbar
A
View full question & answer
MCQ 101 Mark
The tab other than the current worksheet tab has _________ background by default. 
  • A
    black 
  • grey 
  • C
    white 
  • D
    pink
Answer
Correct option: B.
grey 
B
View full question & answer
MCQ 111 Mark
The current worksheet tab has _________ background by default.
  • A
    black
  • B
    grey
  • white 
  • D
    pink
Answer
Correct option: C.
white 
C
View full question & answer
MCQ 121 Mark
The empty grid of cells forms _________ .
  • A
    cellrange 
  • workspace 
  • C
    function wizard 
  • D
    chart wizard
Answer
Correct option: B.
workspace 
B
View full question & answer
MCQ 131 Mark
The zoom tool is used to_________ a worksheet. 
  • A
    zoomin 
  • B
    zoom out 
  • both A and B 
  • D
    activate
Answer
Correct option: C.
both A and B 
C
View full question & answer
MCQ 141 Mark
The right corner of the active cell is highlighted with _________ when cell pointer is placed on it..
  • AutoFillhandle
  • B
    cell handle 
  • C
    AutoSum handle
  • D
    none of the given
Answer
Correct option: A.
AutoFillhandle
A
View full question & answer
MCQ 151 Mark
In spreadsheets, a cell range is denoted by the address of the first cell and the address of the last cell, separated by a _______ .
  • A
    ;
  • C
  • D
    !
Answer
Correct option: B.
B
View full question & answer
MCQ 161 Mark
When we use cell reference  _________ .
  • A
    weneednothavetomanuallyperformarithmeticoperation. 
  • B
    result of the formula will automatically be changed when there is a change in values of a cell.
  • C
    the reference in the formula will automatically be changed when data block is moved.
  • all of the given
Answer
Correct option: D.
all of the given
D
View full question & answer
MCQ 171 Mark
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 ?
  • Thecellrowandcolumnsarechangedatdestination.
  • B
    The cell row numbers are changed at destination. 
  • C
    The cell column numbers are changed at destination.
  • D
    Nothing will be changed. 
Answer
Correct option: A.
Thecellrowandcolumnsarechangedatdestination.
A
View full question & answer
MCQ 181 Mark
Which of the following menu is used to save and close Cale document and open an existing Calc document ? 
  • File 
  • B
    Window
  • C
    Data 
  • D
    View
Answer
Correct option: A.
File 
A
View full question & answer
MCQ 191 Mark
Which of the following menu is used to save and close Calic document and ope an extating Calc document ?
  • file
  • B
    Window
  • C
    Data
  • D
    View
Answer
Correct option: A.
file
a
View full question & answer
MCQ 201 Mark
Which of the following is seen on the status bar ?
  • A
    A Present status
  • B
    Page style
  • C
    Selection mode & unsaved changes
  • All of the given
Answer
Correct option: D.
All of the given
d
View full question & answer
MCQ 211 Mark
Which menu and options are used to turn off/on the toolbars ?
  • View Toolbars
  • B
    Insert Toolbars
  • C
    Tools Toolbars
  • D
    Help Toolbars
Answer
Correct option: A.
View Toolbars
a
View full question & answer
MCQ 221 Mark
Which of the following icons are there on standard toolbar ?
  • A
    Creating new Cale document, opening an existing document
  • B
    Checking spelling within the document
  • C
    Cutting and pasting content, printing document
  • All of the given
Answer
Correct option: D.
All of the given
d
View full question & answer
MCQ 241 Mark
Which mem is used in change the name of the sheet ?
  • A
    Edi
  • Format
  • C
    View
  • D
    Tools
Answer
Correct option: B.
Format
b
View full question & answer
MCQ 251 Mark
are stored in the right side of the cell in Cale.
  • Numbers
  • B
    Formulas
  • C
    Letters
  • D
    All of the given
Answer
Correct option: A.
Numbers
a
View full question & answer
MCQ 261 Mark
_______are stored in the left side of the cell in Calc.
  • A
    Numbers
  • B
    Formulas
  • Letters
  • D
    All of the given
Answer
Correct option: C.
Letters
c
View full question & answer
MCQ 271 Mark
41. The width of the column can be increased or decreased with
  • A
    +
  • B
  • D
Answer
Correct option: C.
c
View full question & answer
MCQ 281 Mark
The height of the cow can be increased or decreased with sign
  • A
    +
  • C
  • D
Answer
Correct option: B.
b
View full question & answer
MCQ 291 Mark
The headers with alphabets are called in Cale.
  • column header
  • B
    row header
  • C
    workbook
  • D
    name bax
Answer
Correct option: A.
column header
a
View full question & answer
MCQ 301 Mark
The headers which are numbered are called in ______Cale.
  • A
    column header
  • row header
  • C
    workbook
  • D
    name box
Answer
Correct option: B.
row header
b
View full question & answer
MCQ 311 Mark
There are maximum_______ worksheets per Cale spreadsheet document.
  • A
    255
  • 256
  • C
    250
  • D
    265
Answer
Correct option: B.
256
b
View full question & answer
MCQ 321 Mark
In Calc. displays the name of an active cell.
  • A
    formula bar
  • name box
  • C
    column header
  • D
    row header
Answer
Correct option: B.
name box
b
View full question & answer
MCQ 341 Mark
The contents of an active cell is displayed in
  • A
    that cell only
  • B
    formula bar
  • both A and B
  • D
    name bax
Answer
Correct option: C.
both A and B
c
View full question & answer
MCQ 351 Mark
The cell whose border is thick and dark black is known as
  • A
    A dark cell
  • active cell
  • C
    formula cell
  • D
    none of the given
Answer
Correct option: B.
active cell
b
View full question & answer
MCQ 361 Mark
32. Which of the following can be entered in a cell"
  • A
    A Text
  • B
    Numbers
  • C
    Formulas
  • All of the given
Answer
Correct option: D.
All of the given
D
View full question & answer
MCQ 391 Mark
A ________ is the basic element of a spreadsheet.
  • A
    name box
  • cell
  • C
    formula bar
  • D
    worksheet
Answer
Correct option: B.
cell
b
View full question & answer
MCQ 401 Mark
Which toolbar contains f(x) tool button and Σ button in Calc ?
  • A
    Standard toolbar
  • B
    Menu bar
  • C
    Formatting toolbar
  • Formula bar
Answer
Correct option: D.
Formula bar
d
View full question & answer
MCQ 411 Mark
Which of the following display content of an active cell ?
  • A
    Title bar
  • B
    Status bar
  • C
    Menu bar
  • Formula bar
Answer
Correct option: D.
Formula bar
d
View full question & answer
MCQ 421 Mark
________ display the address of the active cell.
  • Name box (Address box)
  • B
    Formula bar
  • C
    Status bar
  • D
    All of the given
Answer
Correct option: A.
Name box (Address box)
a
View full question & answer
MCQ 431 Mark
The ______ toolbar contains frequently used commands for formatting content of a cell.
  • A
    standard toolbar
  • B
    title bar
  • formatting toolbar
  • D
    formula bar
Answer
Correct option: C.
formatting toolbar
c
View full question & answer
MCQ 441 Mark
Which toolbar contains most frequently used standard commands from the File and Edit menus ?
  • Standard toolbar
  • B
    Formatting toolbar
  • C
    Status har
  • D
    Formula har
Answer
Correct option: A.
Standard toolbar
a
View full question & answer
MCQ 451 Mark
When any option of submenu contains shape, that means there are more suboptions available with the option.
  • B
  • C
    >
  • D
    <
Answer
Correct option: A.
a
View full question & answer
MCQ 461 Mark
Operations related to window such as opening a new window, freezing cells, displaying list of OpenOffice Org documents, etc. are done by ______ menu.
  • A
    Edit
  • B
    Tools
  • Window
  • D
    Data menu
Answer
Correct option: C.
Window
c
View full question & answer
MCQ 471 Mark
Operations such as data processing, data sorting, data filtering, etc. are performed by _____ menu.
  • A
    Edit
  • B
    Tools
  • C
    Window
  • Data
Answer
Correct option: D.
Data
d
View full question & answer
MCQ 481 Mark
Which of the following can be done using Format menu?
  • A
    Cell formatting
  • B
    Grouping of elements
  • C
    Sorting, Conditional formatting
  • All of the given
Answer
Correct option: D.
All of the given
d
View full question & answer
MCQ 491 Mark
Which of the following can be added in Calc worksheet with the help of Insert menu ?
  • A
    Row, Column
  • B
    Worksheet
  • C
    Elements. Objects
  • All of the given
Answer
Correct option: D.
All of the given
d
View full question & answer
MCQ 501 Mark
Which of the following menu contains additional tools such as spellchecking document protection formulas error correction, etc.?
  • A
    Edit
  • B
    Insert
  • Tools
  • D
    Data
Answer
Correct option: C.
Tools
c
View full question & answer
MCQ . (1 Marks) - Computer STD 10 Questions - Vidyadip