Questions

M.C.Q[1M] [Subject Skills]

🎯

Test yourself on this topic

24 questions · timed · auto-graded

MCQ 11 Mark
Two other toolbars can be opened from the Picture Toolbar: the __________ and __________
  • A
    Edit picture, Color picture
  • Format, drawing
  • C
    Graphic Filter toolbar, Color toolbar
  • D
    Floating toolbar, Color toolbar
Answer
Correct option: B.
Format, drawing
Format, drawing
View full question & answer
MCQ 21 Mark
Suraj wants to know the sequence of steps used to open the Templates dialog. Answer to his query.
  • A
    File → New → ext Document
  • File → New → Templates
  • C
    Format → Group → Group
  • D
    None of the above
Answer
Correct option: B.
File → New → Templates
 File → New → Templates
View full question & answer
MCQ 31 Mark
__________ is used to define the structure of your tables and other objects in the database.
  • DDL
  • B
    DML
  • C
    DCL
  • D
    None of these
Answer
Correct option: A.
DDL
 DDL
View full question & answer
MCQ 41 Mark
Rajiv has created an employee table and made Emp_No, the primary key so that it can accept unique values for each record. At the same time, he wants to have one more field that can behave like a primary key. Which of the following types of key can serve the purpose?
  • A
    Foreign key
  • Composite key
  • C
    Unique key
  • D
    None of these
Answer
Correct option: B.
Composite key
Composite key
View full question & answer
MCQ 51 Mark
URL is the __________ for a website or a web page.
  • web address
  • B
    website
  • C
    web page
  • D
    Both (a) and (c)
Answer
Correct option: A.
web address
web address
View full question & answer
MCQ 61 Mark
A __________ refers to a cell or a range of cells on a Worksheet and can be used to find the values or data that you want the formula to calculate.
  • cell reference
  • B
    block
  • C
    sheet reference
  • D
    autofill
Answer
Correct option: A.
cell reference
 cell reference
View full question & answer
MCQ 71 Mark
Which of the following allows you to display the specific data?
  • A
    Arranging
  • Filtering
  • C
    Scenario
  • D
    Custom sorting
Answer
Correct option: B.
Filtering
Filtering
View full question & answer
MCQ 81 Mark
This is a type of hyperlink available in the Hyperlink dialog box, which creates a new worksheet.
  • New document
  • B
    New file
  • C
    New worksheet
  • D
    New data
Answer
Correct option: A.
New document
New document
View full question & answer
MCQ 91 Mark
In packet-based networks, the message gets broken into small __________
  • data packets
  • B
    data frame
  • C
    chunk
  • D
    None of these
Answer
Correct option: A.
data packets
 data packets
View full question & answer
MCQ 101 Mark
1 : 1, 1 : n, and n : 1 are examples of different types of __________
  • Relations
  • B
    Databases
  • C
    Data
  • D
    Query
Answer
Correct option: A.
Relations
Relations
View full question & answer
MCQ 111 Mark
A __________ is a document model that you use to create other documents.
  • A
    Anchoring
  • B
    Alignment
  • Template
  • D
    None of these
Answer
Correct option: C.
Template
Template
View full question & answer
MCQ 121 Mark
Which of the following is an application program that is stored on a remote server and delivered over the Internet?
  • Web application
  • B
    System application
  • C
    Internet application
  • D
    None of these
Answer
Correct option: A.
Web application
Web application
View full question & answer
MCQ 131 Mark
What is the name given to a combination of two cell references?
  • A
    Relative reference
  • B
    Absolute reference
  • Mixed reference
  • D
    None of the above
Answer
Correct option: C.
Mixed reference
Mixed reference
View full question & answer
MCQ 141 Mark
Key field is a unique identifier for each record. It is defined in the form of __________
  • A
    rows
  • columns
  • C
    tree
  • D
    query
Answer
Correct option: B.
columns
columns
View full question & answer
MCQ 151 Mark
Template includes a text space that is surrounded by brackets. It is called a __________
  • A
    margin
  • placeholder
  • C
    data source
  • D
    track changes
Answer
Correct option: B.
placeholder
placeholder
View full question & answer
MCQ 161 Mark
A __________ filters data traffic at a network boundary.
  • bridge
  • B
    switch
  • C
    gateway
  • D
    hub
Answer
Correct option: A.
bridge
bridge
View full question & answer
MCQ 171 Mark
DBMS is a program, that controls the creation, maintenance, and use of a database. Here, DBMS stands for
  • A
    Digital Base Management System
  • B
    Data Build Management System
  • Database Management System
  • D
    Database Management Service
Answer
Correct option: C.
Database Management System
Database Management System
View full question & answer
MCQ 181 Mark
Editing Custom Shapes feature allows __________ of small segments of a drawing.
  • A
    shaping
  • reshaping
  • C
    rehearse
  • D
    None of these
Answer
Correct option: B.
reshaping
 reshaping
View full question & answer
MCQ 191 Mark
Neeta is planning to take a car loan to buy a new car. But she is not sure about the payback time, i.e. whether to pay it back in 5 or 6 years considering that her monthly fuel cost will also increase. In such cases, which of the following features of the spreadsheet can she use to get an idea about it?
  • A
    Consolidation
  • B
    Macros
  • C
    Templates
  • What-if analysis
Answer
Correct option: D.
What-if analysis
What-if analysis
View full question & answer
MCQ 201 Mark
Which of the following is not an AutoShape?
  • A
    Line
  • B
    Circle
  • C
    Curve
  • ClipArt
Answer
Correct option: D.
ClipArt
 ClipArt
View full question & answer
MCQ 211 Mark
Which of the following allows you to reorder data?
  • Sorting
  • B
    Filtering
  • C
    Scenario
  • D
    Custom sorting
Answer
Correct option: A.
Sorting
 Sorting
View full question & answer
MCQ 221 Mark
The __________ SQL statement is used to make a query or retrieve data from a table in a database.
  • A
    INSERT
  • B
    UPDATE
  • SELECT
  • D
    REVIEW
Answer
Correct option: C.
SELECT
SELECT
View full question & answer
MCQ 231 Mark
The small area network created around a Bluetooth device is called __________
  • A
    LAN
  • PAN
  • C
    WAN
  • D
    MAN
Answer
Correct option: B.
PAN
PAN
View full question & answer
MCQ 241 Mark
A __________ is a temporary connection that uses the Public Switched Telephone Network (PSTN) to connect to the Internet.
  • A
    broadband connection
  • B
    wireless connection
  • dial-up connection
  • D
    None of the above
Answer
Correct option: C.
dial-up connection
 dial-up connection
View full question & answer
M.C.Q[1M] [Subject Skills] - Information Technology STD 10 Questions - Vidyadip