wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

IT Term-1 Sample Quiz (Edition 2)

Total questions: 33

Worksheet time: 17mins

Name
Class
Date
1.

A communication ___________ is an obstacle that prevents the receiver from receiving and understanding the message sent by the sender.

a)

jam

b)

method

c)

barrier

d)

medium

2.

_________________ of these is not a form of non-verbal communication?

a)

body movements

b)

facial expressions

c)

gestures

d)

written words

3.

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 _______.

a)

Panic

b)

Fight or flight response

c)

Stress Management

d)

Stress inducer

4.

Being aware of your personality including your strengths and weaknesses is called _______________.

a)

Self-awareness

b)

Under-confidence

c)

Self-criticism

d)

Self-confidence

5.

Which of these is not a function of an operating system?

a)

Memory management

b)

Designing images

c)

File management

d)

Processor management

6.

Identify the signs of a possible virus attack:

a)

Display of unusual messages

b)

Frequent hanging of system

c)

Deletion or damage of files

d)

All of these

7.

_________ text means surrounding an image or a drawing object within the text.

a)

Wrapping

b)

Cropping

c)

Styling

d)

Editing

8.

___________ in a spreadsheet is used to set a goal to find the optimum value for one or more target variables with the certain conditions.

a)

Goal seek

b)

Target seek

c)

Variable setting

d)

Value seek

9.

In a document, _______________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.

a)

Arrangement

b)

Anchoring

c)

Alignment

d)

Text Wrapping

10.

_______________ helps us to manage, analyse, and extract specific information from the rows of related data.

a)

Summary Total

b)

Goal seek

c)

Subtotals

d)

Data

11.

The _________________ styles are used to control all the aspects of a paragraph's appearance.

a)

Cell

b)

Paragraph

c)

Formatting

d)

Character

12.

Removing the unwanted areas from an image is called _____________.

a)

Cropping

b)

Rotating

c)

Cutting

d)

Skewing

13.

If you want to calculate the effect of different interest rates on an investment, you can use the _________ manager of a spreadsheet.

a)

Information

b)

Worksheet

c)

Data

d)

Scenario

14.

______________ is particularly useful when creating a watermark or when wrapping the image in the background in a document.

a)

Transparency

b)

Fill

c)

Filters

d)

Crop

15.

____________ tools of Excel allow you to use different sets of values in one or more formulas to explore all the various results.

a)

If-else Analysis

b)

If-then Analysis

c)

Why-when Analysis

d)

What-If’ Analysis

16.

____________ are small programs that record your actions as you perform a task in a spreadsheet.

a)

Apps

b)

Macros

c)

Filters

d)

Micros

17.

A scenario is a ________ that you enter in a worksheet to perform calculations.

a)

Reference

b)

Subtotal

c)

Set of values

d)

Address

18.

The Table of Contents consists of ________ and ________ of chapters of a book.

a)

Footer and author name

b)

Summary, Keywords

c)

Headings, Sub-headings

d)

None of these

19.

Linking spreadsheets _________.

a)

Saves time

b)

Reduces errors

c)

Improves data integrity

d)

All of these

20.

A spreadsheet link can be created to ___________.

a)

a. a worksheet in the same workbook

b)

b. a worksheet in another workbook

c)

c. both a and b

d)

d. neither a nor b

21.

A ___________ is a collection of data, which is stored in a systematic manner in the form of tables.

a)

Document

b)

Database

c)

Presentation

d)

Model

22.

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.

a)

Record, Field

b)

Table, Record

c)

Table, Column

d)

Form, Report

23.

The _______ is a computerised record keeping system or a software that enables you to create, store, modify, and extract information from a database.

a)

Document Management System

b)

Database Management System

c)

Spreadsheet Management System

d)

Computer Management System

24.

Data ___________ occurs when the same piece of data is duplicated unnecessarily multiple times in a database.

a)

Redundancy

b)

Destruction

c)

Consolidation

d)

Interpretation

25.

The absolute cell reference in a spreadsheet for cell range B2 to F15 is _____________.

a)

$B2:$F15

b)

B2:F15

c)

B2:$F$15

d)

$B$2:$F$15

26.

Database servers are based on the ____________ architecture.

a)

Brick-mortar

b)

Von-Neuman

c)

Client-server

d)

None of these

27.

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?

a)

Mail Merge

b)

E-Mail

c)

Templates

d)

Data Source

28.

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?

a)

Styles

b)

Templates

c)

Wrap text

d)

Paragraph

29.

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?

a)

Clip art

b)

Cut

c)

Crop

d)

Contrast

30.

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?

a)

Macro

b)

Link Workbook

c)

Change Worksheet

d)

Track Changes

31.

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?

a)

Macro

b)

Goal Seek

c)

Scenario

d)

Track Changes

32.

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?

a)

Sum

b)

Sub-total

c)

What-if

d)

Formatting

33.

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?

a)

Digital Documentation

b)

Electronic Spreadsheet

c)

Database Management System

d)

None of these