WorksheetsIT Term-1 Sample Quiz (Edition 2)
Total questions: 33
Worksheet time: 17mins
A communication ___________ is an obstacle that prevents the receiver from receiving and understanding the message sent by the sender.
jam
method
barrier
medium
_________________ of these is not a form of non-verbal communication?
body movements
facial expressions
gestures
written words
Deepika has been under a lot of pressure lately trying to balance between work and home life. She starts taking nature walks since the soft breeze and beauty of natural surroundings have a calming effect on her mind. This is called _______.
Panic
Fight or flight response
Stress Management
Stress inducer
Being aware of your personality including your strengths and weaknesses is called _______________.
Self-awareness
Under-confidence
Self-criticism
Self-confidence
Which of these is not a function of an operating system?
Memory management
Designing images
File management
Processor management
Identify the signs of a possible virus attack:
Display of unusual messages
Frequent hanging of system
Deletion or damage of files
All of these
_________ text means surrounding an image or a drawing object within the text.
Wrapping
Cropping
Styling
Editing
___________ in a spreadsheet is used to set a goal to find the optimum value for one or more target variables with the certain conditions.
Goal seek
Target seek
Variable setting
Value seek
In a document, _______________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.
Arrangement
Anchoring
Alignment
Text Wrapping
_______________ helps us to manage, analyse, and extract specific information from the rows of related data.
Summary Total
Goal seek
Subtotals
Data
The _________________ styles are used to control all the aspects of a paragraph's appearance.
Cell
Paragraph
Formatting
Character
Removing the unwanted areas from an image is called _____________.
Cropping
Rotating
Cutting
Skewing
If you want to calculate the effect of different interest rates on an investment, you can use the _________ manager of a spreadsheet.
Information
Worksheet
Data
Scenario
______________ is particularly useful when creating a watermark or when wrapping the image in the background in a document.
Transparency
Fill
Filters
Crop
____________ tools of Excel allow you to use different sets of values in one or more formulas to explore all the various results.
If-else Analysis
If-then Analysis
Why-when Analysis
What-If’ Analysis
____________ are small programs that record your actions as you perform a task in a spreadsheet.
Apps
Macros
Filters
Micros
A scenario is a ________ that you enter in a worksheet to perform calculations.
Reference
Subtotal
Set of values
Address
The Table of Contents consists of ________ and ________ of chapters of a book.
Footer and author name
Summary, Keywords
Headings, Sub-headings
None of these
Linking spreadsheets _________.
Saves time
Reduces errors
Improves data integrity
All of these
A spreadsheet link can be created to ___________.
a. a worksheet in the same workbook
b. a worksheet in another workbook
c. both a and b
d. neither a nor b
A ___________ is a collection of data, which is stored in a systematic manner in the form of tables.
Document
Database
Presentation
Model
In a table, a _______is a set of related information that belongs to a particular object and a _______ describes a specific property of a row.
Record, Field
Table, Record
Table, Column
Form, Report
The _______ is a computerised record keeping system or a software that enables you to create, store, modify, and extract information from a database.
Document Management System
Database Management System
Spreadsheet Management System
Computer Management System
Data ___________ occurs when the same piece of data is duplicated unnecessarily multiple times in a database.
Redundancy
Destruction
Consolidation
Interpretation
The absolute cell reference in a spreadsheet for cell range B2 to F15 is _____________.
$B2:$F15
B2:F15
B2:$F$15
$B$2:$F$15
Database servers are based on the ____________ architecture.
Brick-mortar
Von-Neuman
Client-server
None of these
The headmistress Kumud wants to ask all teachers to type question papers for the final exam. She wants to ensure that all the teachers use the same predefined layout with the same themes, colours, font styles. Which feature of a Word Processor will be suitable for this requirement?
Mail Merge
Templates
Data Source
Sonali has created a document for the annual school report and to enhance the report she inserted some images in the document. She wants to surround the text around the border of the images. Which word processor feature should she use?
Styles
Templates
Wrap text
Paragraph
Gaurav has inserted an image in a document. He wants to remove the unwanted area of the image. Which option of the word processor he will use to complete the task?
Clip art
Cut
Crop
Contrast
Hema is a computer teacher. She has entered the subject-wise marks of 80 students in a worksheet and sent the file to Kritika (another fellow teacher of the school) to verify the information. Which feature should be activated by Kritika before reviewing the data in the worksheet so that any changes made by her can easily be identified by Hema?
Macro
Link Workbook
Change Worksheet
Track Changes
Madhavi records meteorological (weather-related) information every day in a spreadsheet. She calculates the averages of different regions every day and applies some formatting weekly. Suggest a feature of Excel that she can use to complete the task quickly rather than by repeating all the steps every time?
Macro
Goal Seek
Scenario
Track Changes
Vinod is reviewing a sales report of the sales executive to find the total number of orders of every executive. Which feature of Excel should he use to perform this task?
Sum
Sub-total
What-if
Formatting
Alena wants to use an application to store, update and maintain the data of a huge organisation such that the integrity of data is maintained and there is no redundancy in the data. Which application would you suggest she uses to achieve her goal?
Digital Documentation
Electronic Spreadsheet
Database Management System
None of these
