quiz

Fundamental of Computer - Demo

1 / 50

Which of the following is a non-volatile memory chip?

निम्नलिखित में से कौन-सी नॉन-वोलेटाइल मेमोरी चिप है?

EEPROM

RAM

SRAM

DRAM

2 / 50

Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?

संख्यात्मक और सांख्यिकीय गणना करने के लिए निम्नलिखित में से कौन सा सॉफ़्टवेयर एप्लिकेशन सबसे उपयुक्त होगा?

Graphics package

Spreadsheet

Database

Document processor

3 / 50

Which of the following is twice the size of A4 paper?

निम्न में से कौन सा A4 पेपर के आकार का दोगुना है?

4 / 50

Which of the following languages computer understand?

निम्नलिखित में से कौन सी भाषा कंप्यूटर समझता है?

C language

JAVA language

Object language

Binary Language

5 / 50

What is the speed of computer measured in?

कंप्यूटर की गति किसमें मापी जाती है?

Nanoseconds

Megabytes

Gigahertz

Kilo-seconds

6 / 50

What is a single dot on a computer screen called?

कंप्यूटर स्क्रीन पर सिंगल डॉट क्या कहलाता है?

Screen dot

Pixel

Desktop

Color dot

7 / 50

Consider the following path C:\Device\Module\Module 1. What is name of the file in this path?

निम्न पथ पर विचार करें C:\Device\Module\Module 1. इस पथ में फ़ाइल का नाम क्या है?

Module 1

Device

Module

8 / 50

What is the full form of HLDA?

एचएलडीए का पूर्ण रूप क्या है?

Hold Link Data Application

High-Level Definition Application

High-Level Data Application

HOLD Acknowledge

9 / 50

What is five main components of a computer system?

कंप्यूटर सिस्टम के पांच मुख्य घटक क्या हैं?

CPU, CD-ROM, Mouse, Keyboard, Sound card

CPU, Memory, System bus, Input, Output

Modem, Keyboard, Word Processor, Printer, Screen

Memory, Video card, Monitor, Software, Hardware

10 / 50

What is the use of the computer port?

कंप्यूटर पोर्ट का उपयोग क्या है?

None of the these

To reduce the internet speed

Download the file via the internet

To connect with other devices

11 / 50

In which of the following, the second-generation computer was based?

निम्न में से किसमें दूसरी पीढ़ी का कंप्यूटर आधारित था?

Transistor

Electron tube

Vacuum tube

Electron ray

12 / 50

A hard disk drive can be directly connected to a PC via a _____.

एक हार्ड डिस्क ड्राइव को एक _____ के माध्यम से सीधे पीसी से जोड़ा जा सकता है।

USB interface

Parallel interface

WAN interface

SCSI interface

13 / 50

Which one of the following groups contains graphical file extensions?

निम्नलिखित में से किस समूह में ग्राफिकल फ़ाइल एक्सटेंशन हैं?

TCP, JPG, BMP

GIF, TCE, WMF

JPG, CPX, GCM

JPG, GIF, BMP

14 / 50

Which of the following statement is correct about the PCI?

पीसीआई के बारे में निम्नलिखित में से कौन सा कथन सही है?

PCI is software that is used to transfer the data.

PCI is an interface of the OS.

PCI is a hardware device.

All of the these

15 / 50

How many bytes does 4 kilobytes represent?

4 किलोबाइट कितने बाइट दर्शाता है?

4096

1024

8192

512

16 / 50

Which of the following commands cannot be used to work on a file?

फ़ाइल पर काम करने के लिए निम्न में से किस कमांड का उपयोग नहीं किया जा सकता है?

Ctrl + Z

None of the these

Ctrl + Y

Ctrl + I

17 / 50

Which one of the following printers is suitable for printing sprocket-fed carbon copies?

निम्नलिखित में से कौन सा प्रिंटर स्प्रोकेट-फेड कार्बन प्रतियों को प्रिंट करने के लिए उपयुक्त है?

Solid Ink printer

Business Inkjet printer

Dot-matrix printer

Normal printer

18 / 50

The term A: \ refers to ____.

शब्द A: \ का संदर्भ ____ से है।

Subdirectory

Filename

Hard disk

Root directory

19 / 50

Which of the following statement is correct about the virus?

निम्नलिखित में से कौन सा कथन वायरस के बारे में सही है?

None of the these

The virus is an operating system that controls the entire OS.

The virus is a small program that infects a large program in the user system.

The virus is a file of the hacker.

20 / 50

The use of the IC in a computer has ______.

कंप्यूटर में IC के उपयोग में ______ होता है।

Reduced the size and cost of computers

Increased the amount of heating

Reduced the performance capacity of the computer

Reduced the peripheral devices to be used

21 / 50

Which of the following device is used for gaming?

निम्नलिखित में से किस डिवाइस का उपयोग गेमिंग के लिए किया जाता है?

Speaker

Joystick

None of the these

Mouse

22 / 50

The speed of a modern printer is generally measured in __________.

एक आधुनिक प्रिंटर की गति आमतौर पर __________ में मापी जाती है।

PPS

PPM

DPI

LPS

23 / 50

What is the full form of SCSI?

एससीएसआई का पूर्ण रूप क्या है?

Small computer systems interface

Super computer systems interface

Standard computer systems interface

Small computer standard interface

24 / 50

A spreadsheet is the best application for ____________.

स्प्रेडशीट ____________ के लिए सबसे अच्छा एप्लीकेशन है।

Producing a grid-referenced map

Keeping an inventory of equipment used

Handling simple accounts

Writing an information

25 / 50

Which of the following is not considered hardware?

निम्नलिखित में से किसे हार्डवेयर नहीं माना जाता है?

Hard disk

Keyboard

CPU

Operating system

26 / 50

In which of the following computer-generation vacuum tubes were used?

निम्नलिखित में से किस कंप्यूटर जनरेशन में वैक्यूम ट्यूब का उपयोग किया गया था?

First-generation

Third-generation

Fourth-generation

Second-generation

27 / 50

Which of the following statement is correct regarding a template prepared by a word processing package?

वर्ड प्रोसेसिंग पैकेज द्वारा तैयार किए गए टेम्पलेट के बारे में निम्नलिखित में से कौन सा कथन सही है?

Any document can be saved as a template.

Many templates contain text that gives one advice on how to use the template.

Default settings are reflected by the normal document template and cannot be overwritten.

Default template is used when you create a new file.

28 / 50

What is the full form of DRAM?

डीआरएएम का पूर्ण रूप क्या है?

Dependent Remote Access Memory

Dynamic Random-Access Memory

Dependent Random-Access Memory

Dynamic Remote Access Memory

29 / 50

What is the decimal value for the octal value 1?

अष्टक मान 1 के लिए दशमलव मान क्या है?

100

30 / 50

Which of the following values is the correct value of this binary code 1011 and 1111?

निम्नलिखित में से कौन सा मान इस बाइनरी कोड 1011 और 1111 का सही मान है?

12 and 15

11 and 15

11 and 14

12 and 14

31 / 50

What is the full form of SRAM?

एसआरएएम का पूर्ण रूप क्या है?

Setup Remote-Access Memory

Static Remote-Access Memory

Setup Random-Access Memory

Static Random-Access Memory

32 / 50

Which of the following numbers is a binary number?

निम्नलिखित में से कौन सी संख्या एक बाइनरी संख्या है?

0 and 1

0 and 0.1

1 and 2

2 and 0

33 / 50

Which one of the following is not a form of data storage media?

निम्नलिखित में से कौन सा डेटा स्टोरेज मीडिया का एक रूप नहीं है?

Magnetic tape

A database

Optical disc

Magnetic disc

34 / 50

Which type of program acts as an intermediary between a user of a computer and the computer hardware?

किस प्रकार का प्रोग्राम कंप्यूटर के उपयोगकर्ता और कंप्यूटर हार्डवेयर के बीच मध्यस्थ के रूप में कार्य करता है?

User thread

Application program

Superuser thread

Operating system

35 / 50

Akshat has created a story of ten pages, but only wants to print the first two pages. Which printer command should he choose?

अक्षत ने दस पन्नों की एक कहानी बनाई है, लेकिन वह केवल पहले दो पन्नों को ही छापना चाहता है। उसे कौन सा प्रिंटर कमांड चुनना चाहिए?

Print all

Page setup

Print Preview

Print from 1 to 2

36 / 50

Which of the following is not one of the internal components of a CPU?

निम्नलिखित में से कौन सा सीपीयू के आंतरिक घटकों में से एक नहीं है?

M-D-R

M-A-R

Control sequencer

Floppy disk

37 / 50

Which of the following is exclusively a sequential access storage device?

निम्नलिखित में से कौन सा विशेष रूप से अनुक्रमिक एक्सेस स्टोरेज डिवाइस है?

Hard disk

DVD

Magnetic tape

Floppy disk

38 / 50

Which one of the following is the best fire extinguisher for IT equipment?

निम्नलिखित में से कौन सा आईटी उपकरण के लिए सबसे अच्छा अग्निशामक है?

CO2

Water

Bromo chloride

Dry powder

39 / 50

Which of the following would be the correct description for WORM virus?

निम्नलिखित में से कौन सा WORM वायरस के लिए सही विवरण होगा?

It alters the folder structure.

It has no effect in increasing the internet traffic.

It infects the boot sector.

It propagates through the internet and e-mail.

40 / 50

Which of the following is equal to a gigabyte?

निम्नलिखित में से कौन सा एक गीगाबाइट के बराबर है?

1024 bits

1024 megabytes

512 GB

1024 bytes

41 / 50

What is the full form of RAM?

रैम का फुल फॉर्म क्या होता है?

Remote Access Memory

Random Access Memory

Remote Access Memory

42 / 50

Which of the following command remove the paragraph formatting?

निम्नलिखित में से कौन सा कमांड पैराग्राफ फॉर्मेटिंग को हटाता है?

Ctrl + L

Copy

Ctrl + Q

Open

43 / 50

Which of the following memory cannot be directly accessed?

निम्नलिखित में से किस मेमोरी को सीधे एक्सेस नहीं किया जा सकता है?

RAM

Secondary memory

Primary memory

DRAM

44 / 50

Which of the following shortcut key shows the properties of a file?

निम्नलिखित में से कौन सी शॉर्टकट कुंजी फ़ाइल के गुणों को दर्शाती है?

Alt + F3

Alt + Ctrl

Alt + Enter

Alt + P

45 / 50

Which of the following processor has a fixed length of instructions?

निम्नलिखित में से किस प्रोसेसर में निर्देशों की निश्चित लंबाई होती है?

Dual Core

RISC

COM

Main processor

46 / 50

Which of the following language was used in first-generation computers?

पहली पीढ़ी के कंप्यूटरों में निम्नलिखित में से किस भाषा का प्रयोग किया गया था?

All of the these

Machine language

Java

Python

47 / 50

What is the full form of USB?

यूएसबी का फुल फॉर्म क्या होता है?

Universal System Bus

Universal System Board

Unshielded System Board

Unidentified System Bus

48 / 50

What kind of language can computer understand?

कंप्यूटर किस प्रकार की भाषा समझ सकता है?

Computer language

Normal language

Assembly language

High-level language

49 / 50

What is the full form of VDU?

वीडीयू का फुल फॉर्म क्या होता है?

Virtual Detection Unit

Virtual Development User

Visual Detection Unit

Visual Display Unit

50 / 50

What is the full form of the EEPROM?

ईईपीरोम का पूर्ण रूप क्या है?

Electrical Erase Program Read-Only Memory

Electron Erase Program Read-Only Memory

Electrically Erasable Process Read-Only Memory

Electrically Erasable Programmable Read-Only Memory

Your score is

LinkedIn Facebook Twitter VKontakte

Operating Sysytem - Demo

1 / 50

Which command is used to delete the directory that is empty ?

R D

Del

M D

Erase

2 / 50

Which file extension is used for binary files ?

.BAK

.BIN

.BAF

.BAT

3 / 50

I O controller keeps track of all the devices.

False

True

4 / 50

Icons are text.

False

True

5 / 50

GUI makes work easy.

False

True

6 / 50

JPEG stands for Joint Photographic Expert Gallery.

False

True

7 / 50

Main function of the operating system is to boot the system.

False

True

8 / 50

GUI is used as an interface between.

None of the above

Man and software

Software and user

hardware and software

9 / 50

Which command displays the disk consumption of a specific directory ?

10 / 50

Which command is used to create new directories ?

Nwdir

Rmdir

Chdsk

Mkdir

11 / 50

Which command is used in 'Linux' for character account ?

count

wcount

12 / 50

A file name has two parts.

False

True

13 / 50

Ctrl, Shift and alt are called :

Alphanumeric keys

Function keys

Modifier keys

Adjustment keys

14 / 50

Who is the founder of UBUNTU ?

Pavel durov

None of the above

Linux Torvalds

Mark Richard Shuttleworth

15 / 50

Folder contains files and folders.

True

False

16 / 50

Which of the following is a Windows feature that enables the computer to use a USB flash drive as a memory expansion device ?

EMD

SuperFetch

ReadyBoost

SmartResponse

17 / 50

Which command is used to change the file name ?

Ren

None of the above

Both as above

Rename

18 / 50

If umask is 002, what will be the new directory ?

664

777

775

774

19 / 50

Which one is better in Security ?

Windows

Linux

20 / 50

How do we check the Linux operating system version ?

OSname

None of the above

Uname

Sname

21 / 50

Which of the following comes under the category of a search engine ?

Vista

Unix

Altavista

Linux

22 / 50

Operating system acts as an interface between user and hardware.

True

False

23 / 50

Does Ubuntu requires an antivirus ?

Yes

None of the above

Not Sure

24 / 50

Linux is an application software.

True

False

25 / 50

Who is the founder of Ubuntu ?

Mark Richard Shuttleworth

None of the above

Robertnoic

Mark endarson

26 / 50

To close a terminal window which command is used ?

None of the above

end

exit

27 / 50

The Windows 10 Store app is linked to which of the following ?

The local computer account

The user's Microsoft account

The user's library account

The administrator account

28 / 50

What is the file name of Linux Operating system ?

Vmlinux

Linux

Vmlinux

None of the above

29 / 50

Who founded Linux ?

Ray Tomlinson

Bill gates

Linux Torvalds

Vint Cerf

30 / 50

Which command is used to print a file in UNIX ?

Ipr

31 / 50

What is the full form of PGA graphics card ?

Public Giga Array

Professional Graphics Array

Portal Graphic Array

Personal Graphics Array

32 / 50

Which among the following is a Linux command ?

curl

all

Chmod

33 / 50

Which among the following is a single user operating system ?

MS Dos

Linux

None of the above

Unix

34 / 50

To use computer, an OS is needed.

False

True

35 / 50

Real time operating systems are required for a quick response time.

False

True

36 / 50

What is Linux ?

Multi tasking, multi purpose

Single tasking, multi purpose

Multi tasking, single purpose

Single tasking, single purpose

37 / 50

Memory management is an important function of OS.

True

False

38 / 50

Which command is used in UNIX to print a file ?

39 / 50

Files and folders can't be restored from recycle bin.

False

True

40 / 50

An image is composed of

Pels

Pexels

All of these

Dots

41 / 50

The most popular computer operating system in use today is.

UNIX

Linux

Microsoft Windows

Macintosh

42 / 50

Latest OS of Windows Family is

Windows 11

Windows XP

Windows 15

Windows 10

43 / 50

What is a Kernel ?

Graphical interface of an operating

Important core of Linux and Unix

It is stored in a chip

All of the above

44 / 50

Which option is used to move folder from 'D' drive to 'E' drive ?

Find from D drive and paste to E drive

Cut from D drive and paste to E drive

Copy from D drive and paste to E drive

Delete from D drive and paste to E drive

45 / 50

First version of DOS...

DOS 0.1

DOS Xpert

DOS 1.0

46 / 50

The language that the computer can understand and execute is called :

None of the above

System program

Machine language

Application Software

47 / 50

Desktop background can be changed using MS-Paint.

True

False

48 / 50

Assessories are additional programs provided with Windows.

True

False

49 / 50

A new folder cannot be created on the desktop.

True

False

50 / 50

How can you find out which Shell you are using ?

echo $0

shell

eshell

Your score is

LinkedIn Facebook Twitter VKontakte

138

Word - Demo

1 / 50

A font with curved or extended edges is called_______

Serif

None of the Above

Sans Serif

Script

2 / 50

What does Ctrl + B shortcut accomplish in Ms-Word?

It adds a line break to the document

It converts selected text into the next larger size of the same font

It applies Italic formatting t the selected text.

It makes the selected text bold

3 / 50

In Microsoft Word system to copy something the following shortcut is used

CTRL+C

CTRL+X

None of these

CTRL+V

4 / 50

Which enables you to move directly to specific location In a document?

Outlines

Subdocuments

None of these

Bookmarks

Cross-references

5 / 50

By default, your document prints with:

1.25 inches left and right margins

1 inch top and bottom margins

all of the above

a portrait orientation

None of these

6 / 50

In Microsoft Word to delete the selected item permanently without placing the item in the Recycle Bin

Shortcut CTRL+SHIFT while dragging an item

Shortcut SHIFT+DELETE

None of these

Shortcut CTRL while dragging an item

7 / 50

Which of the following option in File pull down menu is used to close a MS Word document?

Exit

New

None of these

Quit

8 / 50

In Microsoft Word shortcut CTRL+A is to

Paste something

Highlight a block of text

Delete something

Select all

9 / 50

Which key is used to increase left indent?

Ctrl+ M

Ctrl+ L

Alt +L

F10

None of these

10 / 50

The minimum number of rows and columns in MS Word document is

3 and 3

2 and 2

2 and 1

1and1

None of these

11 / 50

In Microsoft Word shortcut key CTRL+R is used for

Open the Print dialog box

None of these

Update the current Web page

Close the current window

12 / 50

Pressing F8 key for three times select

Entire document

None of these

A paragraph

A sentence

A word

13 / 50

Graphics for word processor

Execute

Clip art

Highlight

Peripheral

14 / 50

What is the shortcut key to Close Active Document In Microsoft Word?

Shift + F

Ctrl + D

Ctrl + F4

Ctrl +Shift + F4

None of these

15 / 50

Which of the following is not valid version of MS Office?

Office Classic

Office Vista

Off ice XP

Office 2007

None of these

16 / 50

Before moving a subdocument to another location within a master document, you must switch to,

Print Layout View

Normal View

Web Layout View

None of these

Outline View

17 / 50

To open Columns dialog box quickly

double click the space between area on ruler

double click on the left margin area of ruler

None of these

All of above

double click the right margin in ruler

18 / 50

What is the default left margin in Word 2003 document?

1.25"

None of these

1.5"

19 / 50

In Word, the mailing list is known as the

Sheet

Source

Data source

None of these

Datasheet

20 / 50

The ability to combine name and addresses with a standard document is called

mail merge

form letters

document formatting

data base management

None of these

21 / 50

Which of the following is not a font style?

Bold

Regular

Italics

None of these

Superscript

22 / 50

If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should:

Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box.

Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect.

AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an Auto Correct entry.

None of these

Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK.

23 / 50

In Microsoft Word shortcut key CTRL+L is used for

Open the Open dialog box

Open the Favorites bar

Open the Open dialog box, the same as CTRL+L

Start another instance of the browser with the same Web address

24 / 50

In Microsoft Word shortcut key CTRL+E is used for

Open the Organize Favorites dialog box

Start the Find utility

Open the History bar

Open the Search bar

25 / 50

Which command Is used to establish a link between a source document and a destination document?

Tools, Link

Edit, Paste Special

Edit, Link

None of these

Tools, Link, Documents

26 / 50

In Microsoft Word shortcut key CTRL+O is used for

Open the Open dialog box, the same as CTRL+L

Open the Favorites bar

Start another instance of the browser with the same Web address

Open the Open dialog box

27 / 50

There can be many ways to insert page number in a document. Which of the following lets you insert page number

Page number from Insert menu

Page Setup from file menu

None of these

Footnote from Insert menu

Both a & c

28 / 50

In Microsoft Word move the insertion point to the beginning of the previous paragraph

CTRL+DOWN ARROW

CTRL+LEFT ARROW

None of these

CTRL+RIGHT ARROW

29 / 50

In Microsoft Word shortcut CTRL+C is used for

Cut

None of these

Paste

Copy

30 / 50

What is the purpose of inserting header and footer in document?

None of these

To mark the starting and ending of page

To make large document more readable To allow page headers and footers appear on document when printed

To enhance the overall appearance of the document

31 / 50

A font with straight edges is called ________

Serif

Sans Serif

None of the Above

Script

32 / 50

What is the default font used in MS Word document?

Times New Roman

Algerian

Preeti

Arial

None of these

33 / 50

The key F12 opens a

Close dialog box

Save dialog box

None of these

Save As dialog box

Open dialog box

34 / 50

In Microsoft Word shortcut DELETE is for

None of these

Undo something

Paste something

Delete something

35 / 50

Why are headers and footers used in document?

To make large document more readable

To allow page headers and footers to appear on document when it is printed

To enhance the overall appearance of the document

To mark the starting and ending of a page

36 / 50

If you need to change the typeface of a document, which menu will you choose?

View

Format

None of these

Tools

Edit

37 / 50

What does the Ctrl + I shortcut key accomplish in Ms-Word?

It adds a line break to the document

It makes the selected text bold

It applies Italic formatting t the selected text.

It converts selected text into the next larger size of the same font

38 / 50

In Microsoft Word move the insertion point to the beginning of the previous word

Shortcut CTRL+RIGHT ARROW

Shortcut CTRL+LEFT ARROW

None of these

Shortcut CTRL+DOWN ARROW

39 / 50

In Microsoft Word shortcut key CTRL+H is used for

Start the Find utility

Open the Organize Favorites dialog box

Open the History bar

Open the Search bar

40 / 50

If you need to double underline a word, how will you do that?

None of these

Select the text then choose Format > > Font and on Font tab open Underline Style and choose Double Underline

From Format menu choose Font option and then from Font tab open Underline Style and select Double Underline

Click double underline tool on formatting toolbar

Go to Format menu and then Font option. Open Underline Style and choose Double Underline

41 / 50

In Microsoft Word using CTRL+SHIFT with any of the arrow keys

None of these

Highlight a block of text

Delete something

Paste something

42 / 50

What is the shortcut key for "Find and Replace" dialog box?

None of these

Ctrl + F

Ctrl + H

Ctrl + R

Ctrl+ Shift + F

43 / 50

A bookmark is an item or location in document that you identify as a name for future reference. Which of the following task is accomplished by using bookmarks?

To add anchors in web page

To quickly jump to specific location in document

None of these

To mark the ending of a paragraph of document

To add hyperlinks in webpage

44 / 50

In Microsoft Word shortcut CTRL while dragging an item

Copy the selected item

Create a shortcut to the selected item

Delete the selected item permanently without placing the item in the Recycle Bin

Rename the selected item

45 / 50

In Microsoft Word to cut something the following shortcut is used

CTRL+V

CTRL+C

CTRL+X

None of these

46 / 50

Which simplifies the process of formatting text If the same formatting Is required In more than one location?

None of the above

Auto Text

None of these

Font dialog box,,

Format Painter

47 / 50

To autofit the width of column '

Double click the right border of column

All of above

Double click the left border of column

Double click the column header

None of these

48 / 50

Which of the following function key activates the speller?

None of these

Shift +F7

49 / 50

A master document contains.......... each of which contains a pointer to a file on a disk?

references

Placeholders

subdocuments

bookmarks

50 / 50

In Microsoft Word shortcut for copy is

CTRL+V

CTRL+X

CTRL+C

None of these

Your score is

LinkedIn Facebook Twitter VKontakte

288

Excel - Demo

1 / 49

Which of the following is not an example of a value?

निम्नलिखित में से कौन सा मूल्य का उदाहरण नहीं है?

350

May 10, 2001

Serial Number 50771

0.57

2 / 49

Which of following is Not one of Excel’s what-if function?

निम्न में से कौन एक्सेल के व्हाट-इफ फंक्शन में से एक नहीं है?

Goal seek

Solver

Scenario manager

Auto Outline

3 / 49

Data can be arranged in a worksheet in a easy to understand manner using

किसका प्रयोग कर डेटा को वर्कशीट में आसानी से समझने योग्य तरीके से व्यवस्थित किया जा सकता है?

All of above

Applying styles

Changing fonts

Auto formatting

4 / 49

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

एक्सेल वर्कशीट सेल विंडोज ग्राफिकल यूजर इंटरफेस के सामान्य तत्व के समान ही काम करते हैं

Option buttons

List boxes

Combo boxes

Text boxes

5 / 49

The Paste Special command lets you copy and paste:

पेस्ट स्पेशल कमांड आपको कॉपी और पेस्ट करने देता है:

Multiply the selection by a copied value

Formatting options

Cell comments

The resulting values of a formula instead of the actual formula

6 / 49

Which of the following is the latest version of Excel?

निम्नलिखित में से कौन सा एक्सेल का नवीनतम संस्करण है?

Excel 2000

Excel XP

Excel 2002

Excel ME

7 / 49

You can use the formula palette to

आप फॉर्मूला पैलेट का उपयोग करने के लिए कर सकते हैं

Enter assumptions data

Format cells containing numbers

Create and edit formulas containing functions

Copy a range of cells

8 / 49

Which of the following formulas will Excel Not be able to calculate?

निम्नलिखित में से कौन सा सूत्र एक्सेल गणना करने में सक्षम नहीं होगा?

=SUM(Sales)-A3

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)-10

=SUM(A1:A5)*.5

9 / 49

You can select a single range of cells by

आप द्वारा कक्षों की एकल श्रेणी का चयन कर सकते हैं

Pressing the Shift key and an arrow key

Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

Dragging over the desired cells

Pressing the Ctrl key while dragging over the desired cells

10 / 49

You can activate a cell by

आप द्वारा एक सेल को सक्रिय कर सकते हैं

Clicking the cell

All of the above

Pressing an arrow key

Pressing the Tab key

11 / 49

Which area in an excel window allows entering values and formulas

एक्सेल विंडो में कौन सा क्षेत्र मूल्यों और सूत्रों को दर्ज करने की अनुमति देता है

Formula bar

Menu bar

Standard toolbar

Title bar

12 / 49

Which of the following is a popular DOS based spreadsheet package?

निम्नलिखित में से कौन सा लोकप्रिय डॉस आधारित स्प्रेडशीट पैकेज है?

Excel

Smart cell

Lotus 1-2-3

Word

13 / 49

Which is used to perform what if analysis?

व्हाट इफ एनालिसिस करने के लिए किसका प्रयोग किया जाता है?

Goal seek

Solver

Scenario Manager

All of above

14 / 49

You cannot link excel worksheet data to a word document

आप एक्सेल वर्कशीट डेटा को वर्ड डॉक्यूमेंट से लिंक नहीं कर सकते हैं

With the copy and paste buttons on the standard toolbar

With the copy and paste special commands

With the right drag method

With a hyperlink

15 / 49

To copy cell contents using drag and drop press the

ड्रैग एंड ड्रॉप का उपयोग करके सेल सामग्री को कॉपी करने के लिए दबाएं

Esc key

End key

Shift key

Ctrl key

16 / 49

You can enter which types of data into worksheet cells?

आप वर्कशीट सेल में किस प्रकार के डेटा को एंटर कर सकते हैं?

Labels and values but not formulas

Labels, values and formulas

Formulas only

Values and formulas but not labels

17 / 49

A numeric value can be treated as a label value if it proceeds with

यदि यह आगे बढ़ता है तो एक संख्यात्मक मान को लेबल मान के रूप में माना जा सकता है

Ampersand (&

Exclamation (!)

Hash (#)

Apostrophe (&lsquo

18 / 49

How do you delete a column?

आप कॉलम कैसे हटाते हैं?

Right click the column heading you want to delete and select delete from the shortcut menu

Select the column heading you want to delete and select the Delete Row button on the standard toolbar

Select the column heading you want to delete and select Insert Delete from the menu

Select the row heading you want to delete and select Edit > Delete from the menu

19 / 49

Which of the following is not a basic step in creating a worksheet?

वर्कशीट बनाने में निम्नलिखित में से कौन सा बुनियादी कदम नहीं है?

Copy the worksheet

Modify the worksheet

Enter text and data

Save workbook

20 / 49

Which menu option can be sued to split windows into two?

विंडोज़ को दो में विभाजित करने के लिए किस मेनू विकल्प पर मुकदमा चलाया जा सकता है?

Format > window

View > window > split

View > split

Window > split

21 / 49

You can use drag-and-drop to embed excel worksheet data in a word document

एक्सेल वर्कशीट डेटा को वर्ड डॉक्यूमेंट में एम्बेड करने के लिए आप ड्रैग-एंड-ड्रॉप का उपयोग कर सकते हैं

By dragging a range of excel data to the word button on the taskbar while pressing Alt key

By dragging a range of excel data to the word button on the taskbar while pressing Shift key

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

None of above

22 / 49

In a worksheet you can select

वर्कशीट में आप चुन सकते हैं

Rows

All of the above

The entire worksheet

Columns

23 / 49

Which of the following is not a valid data type in excel

निम्नलिखित में से कौन सा एक्सेल में मान्य डेटा प्रकार नहीं है

Date/time

Character

Number

Label

24 / 49

Which elements of worksheet can be protected from accidental modification?

वर्कशीट के किन तत्वों को आकस्मिक संशोधन से बचाया जा सकता है?

Objects

Scenarios

Contents

All of above

25 / 49

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

माउस या तीर कुंजियों का उपयोग किए बिना, स्प्रैडशीट में सेल A1 पर जाने का सबसे तेज़ तरीका क्या है?

Press Alt + Home

Press Ctrl +Home

Press Shift + Home

Press Home

26 / 49

To create a formula, you can use:

सूत्र बनाने के लिए, आप इसका उपयोग कर सकते हैं:

Values but not cell references

Cell references but not values

Values or cell references although not both at the same time

Value and cell references

27 / 49

Which of the following is not a worksheet design criterion?

निम्नलिखित में से कौन सा वर्कशीट डिजाइन मानदंड नहीं है?

Clarity

Efficiency

Description

Aditibility

28 / 49

The chart wizard term data series refers to

चार्ट विज़ार्ड शब्द डेटा श्रृंखला संदर्भित करता है

A data label

A chart legend

A set of values you plot in a chart

A collection of chart data markers

29 / 49

To activate the previous cell in a pre-selected range, press

पूर्व-चयनित रेंज में पिछले सेल को सक्रिय करने के लिए, दबाएँ

The Alt key

The Enter key

None of the above

The Tab key

30 / 49

If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

अगर आप किसी सेल में एंट्री टाइप करना शुरू करते हैं और फिर महसूस करते हैं कि आप अपनी एंट्री को सेल में नहीं रखना चाहते हैं, तो आप:

Press the Edit Formula button

Press the Enter button

Press Esc

Press the Erase key

31 / 49

How can you delete a record?

आप एक रिकॉर्ड कैसे हटा सकते हैं?

Delete the column from the worksheet

Select Data > Delete Record from the menu

Click the Delete button on the Standard toolbar

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

32 / 49

When a label is too long to fit within a worksheet cell, you typically must

जब कोई लेबल वर्कशीट सेल में फिट होने के लिए बहुत लंबा होता है, तो आपको आमतौर पर ऐसा करना चाहिए

Adjust the row height

Increase the column width

Decrease the column width

Shorten the label

33 / 49

A circular reference is

एक परिपत्र संदर्भ है

Geometric modeling tool

Always erroneous

A formula that either directly or indirectly depends on itself

A cell that points to a drawing object

34 / 49

Files created with Lotus 1-2-3 have an extension

लोटस 1-2-3 के साथ बनाई गई फाइलों में एक एक्सटेंशन होता है

123

WK1

XLS

DOC

35 / 49

An excel workbook is a collection of

एक एक्सेल वर्कबुक एक संग्रह है

Worksheets and charts

Charts

Worksheets

Workbooks