Questions

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

🎯

Test yourself on this topic

24 questions · timed · auto-graded

MCQ 11 Mark
State True or False. (1)
“A custom style displays user-defined styles.”
  • TRUE
  • B
    FALSE
Answer
Correct option: A.
TRUE
TRUE
View full question & answer
MCQ 21 Mark
It 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.
  • A
    Row
  • B
    Column
  • C
    Autosum
  • Cell reference
Answer
Correct option: D.
Cell reference
Cell reference
View full question & answer
MCQ 31 Mark
Rishabh wants to make a professional resume. He tried many times but the result was not satisfactory as he did not know what all points should be there and that too in which order. Which one of the following writers would you suggest to him, so that his problem is solved?
  • Template
  • B
    Form
  • C
    Worksheet
  • D
    Format
Answer
Correct option: A.
Template
Template
View full question & answer
MCQ 41 Mark
Goal Seek is also called ________ is one of the What-if analysis tools that is available in Calc.
  • back-solving
  • B
    solver
  • C
    forward-solving
  • D
    result analysis
Answer
Correct option: A.
back-solving
back-solving
View full question & answer
MCQ 51 Mark
When a primary key constraint is applied on more than one column, then it is known as
  • A
    composite primary key
  • B
    foreign key
  • composite foreign key
  • D
    connecting key
Answer
Correct option: C.
composite foreign key
composite foreign key
View full question & answer
MCQ 61 Mark
If you have a safer and healthier workplace, there will be fewer days lost and it will have higher
  • A
    employee satisfaction
  • productivity
  • C
    stress levels
  • D
    None of the above
Answer
Correct option: B.
productivity
productivity
View full question & answer
MCQ 71 Mark
Which data type is the most appropriate for storing an employee’s short bio?
  • A
    Text
  • B
    String
  • Memo
  • D
    Large text
Answer
Correct option: C.
Memo
Memo
View full question & answer
MCQ 81 Mark
Manya has created a spreadsheet using Calc, to find the average of the values in a range of cells. She wants to use a function so that it is calculated automatically and she can copy the same formula for other ranges of cells. Which of these functions will give the correct result?
  • A
    AVG
  • Average
  • C
    Mean
  • D
    None of these
Answer
Correct option: B.
Average
Average
View full question & answer
MCQ 91 Mark
Anila works in a Multi National Company (MNC) and needs to work online from home also. She requires a fast Internet connection. Which type of Internet connection in your view would be best suited for her?
  • A
    Dialup
  • Broadband
  • C
    Both are suitable
  • D
    None of these
Answer
Correct option: B.
Broadband
Broadband
View full question & answer
MCQ 101 Mark
________ is an example of a text-based browser which provides access to the Internet in the text-only mode.
  • A
    Mozilla Firefox
  • Lynx
  • C
    Internet Explorer
  • D
    All of these
Answer
Correct option: B.
Lynx
Lynx
View full question & answer
MCQ 111 Mark
Reports are generally used to show the data in ________ form.
  • printed
  • B
    chart
  • C
    Both (a) and (b)
  • D
    None of these
Answer
Correct option: A.
printed
printed
View full question & answer
MCQ 121 Mark
The Show Changes dialog box has which of the following settings?
  • A
    Data
  • B
    Comment
  • C
    Views
  • All of these
Answer
Correct option: D.
All of these
All of these
View full question & answer
MCQ 131 Mark
What can you do with the Internet?
  • A
    Exchange information with friends and colleagues.
  • B
    Access pictures, sounds, video clips, and other media elements.
  • C
    Find diverse perspectives on issues from a global audience.
  • All of the above
Answer
Correct option: D.
All of the above
 All of the above
View full question & answer
MCQ 141 Mark
________ allows multiple users to view, edit and change in a spreadsheet.
  • A
    Opening
  • B
    Reviewing
  • Sharing
  • D
    Collaborating
Answer
Correct option: C.
Sharing
Sharing
View full question & answer
MCQ 151 Mark
According to OpenOffice Calc which of the following is not a What-if analysis tool?
  • Conditional formatting
  • B
    Goal seek
  • C
    Scenarios
  • D
    Solver
Answer
Correct option: A.
Conditional formatting
 Conditional formatting
View full question & answer
MCQ 161 Mark
Computer connected with LAN
  • A
    can work fast
  • B
    can go online
  • C
    can E-mail
  • can share information or peripheral devices
Answer
Correct option: D.
can share information or peripheral devices
can share information or peripheral devices
View full question & answer
MCQ 171 Mark
Aanya is making a table in a Database to store data of all the employees working in her organization. She has decided on the various information that she needs to store on that table. She also has to have a field in which unique data can be entered. Out of the given fields suggest the best field suitable that can be used as a primary key, so that it can accept unique data.
  • A
    Emp_name
  • B
    Emp_dept
  • Emp_number
  • D
    Emp_DOB
Answer
Correct option: C.
Emp_number
Emp_number
View full question & answer
MCQ 181 Mark
Grouping drawing object can be used for which of the following?
  • Combining drawing objects as one
  • B
    Resizing
  • C
    Adding more drawing objects
  • D
    None of these
Answer
Correct option: A.
Combining drawing objects as one
Combining drawing objects as one
View full question & answer
MCQ 191 Mark
Which of the following is not an object of a database?
  • A
    Report
  • B
    Forms
  • C
    Query
  • Functions
Answer
Correct option: D.
Functions
Functions
View full question & answer
MCQ 201 Mark
Template is a ________ document based on which one can create a new document.
  • blueprint
  • B
    printed
  • C
    suggested
  • D
    copied
Answer
Correct option: A.
blueprint
blueprint
View full question & answer
MCQ 211 Mark
Shalini is working in a school. She is the class teacher of VIII B. It is the time to enter the subject marks and grades of all students in her class in a worksheet. While entering the marks and grades, she has to scroll up again and again to the row where all subject names are entered, to avoid any mistakes in her entries. This process is consuming a lot of her time. Help her by letting her know about one such tool by which she can fix the field rows from the following and continue with her work without wasting much time.
  • A
    Fix row
  • B
    Fix column
  • Freeze panes
  • D
    Freeze all
Answer
Correct option: C.
Freeze panes
Freeze panes
View full question & answer
MCQ 221 Mark
The data in the data source is organized in
  • A
    text form
  • B
    image form
  • tabular form
  • D
    paragraph form
Answer
Correct option: C.
tabular form
tabular form
View full question & answer
MCQ 231 Mark
Which of the following is not a good choice as a field name for a database?
  • A
    Emp_Id
  • B
    Emp_dept
  • C
    Emp_name
  • Emp_set
Answer
Correct option: D.
Emp_set
 Emp_set
View full question & answer
MCQ 241 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 the above
Answer
Correct option: A.
Web application
Web application
View full question & answer
M.C.Q[1M] [Subject Skills] - Information Technology STD 10 Questions - Vidyadip