Computer Basic Knowledge PDF Gujarati

5/5 - (2 votes)

Computer Basic Knowledge PDF Gujarati. We covered all the Computer Basic Knowledge PDF Gujarati MCQs in this post for free so that you can practice well for the exam.

Select your language and change this post to your favorite language.

Install our MCQTUBE Android app from the Google Play Store and prepare for any competitive government exams for free.

Join Telegram Group and Get FREE Alerts! Join Now

Join WhatsApp Group For FREE Alerts! Join Now

These types of competitive MCQs appear in exams like SSC, Railway, Bank, Delhi Police, UPSSSC, UPSC (Pre), State PCS, CDS, NDA, Assistant Commandant, and other Competitive Examinations, etc.

We created all the competitive exam MCQs into several small posts on our website for your convenience.

You will get their respective links in the related posts section provided below.

Related Posts:

Questions hide

Computer Basic Knowledge PDF Gujarati for Students

In an MS Excel 2010 sheet, a cell with a text overflow problem can be dealt with

a) Text Bumping

b) Text Aligning

c) Text Merging

d) Text Wrapping

Option d - Text Wrapping

Which of the following keyboard shortcuts is used to move through each of the open tabs going to the right in Chrome browser?

a) Ctrl + N

b) Alt + N

c) Alt + Tab

d) Ctrl + Tab

Option d - Ctrl + Tab

Which of the following keyboard shortcut keys can be used to insert a hyperlink in an MS Word 2010 document?

a) Ctrl + K

b) Alt + L

c) Ctrl + L

d) Alt + K

Option a - Ctrl + K

Facebook is a / an

a) Social network site

b) Browser

c) Search engine

d) Internet service provider

Option a - Social network site

Choose the wrong option with respect to MS- Excel 2010.

a) In MS Excel 2010, we can save the file by using F 12.

b) In MS-Excel 2010, we can insert a table from the insert tab.

c) In MS-Excel 2010, we can insert a comment to a cell.

d) In MS Excel 2010, to open a new blank file Ctrl+0 is used.

Option d - In MS Excel 2010, to open a new blank file Ctrl+0 is used

....... tab in MS-Excel 2010 ribbon bar contains the most frequently used commands such as copying & pasting, sorting, and filtering, formatting, etc.

a) HOME

b) REVIEW

c) FORMULA

d) FILE

Option a - HOME

Consider a formula A3 + B4 is typed in cell A5 is copied and pasted into cell E9, then what will be the formula in cell E9?

a) = E7+F8

b) = E8+ F7

c) = A3+B4

d) = B4+ C5

Option a - = E7+F8

Which of the following is not a webmail provider?

a) Outlook

b) Gmail

c) Yahoo

d) Baidu

Option d - Baidu

Which of the following is the slowest type of Internet service?

a) 3G and 4G

b) Digital subscriber line

c) Satellite

d) Dial-up

Option d - Dial-up

The deleted emails can be found in the folder.

a) Trash

b) Draft

c) Sent

d) Inbox

Option a - Trash

A …… is a telecommunication technology, which permits two or more people in different locations to interact via mutual video or audio transmission simultaneously.

a) Payment gateway

b) Blog

c) Email

d) Videoconferencing

Option d - Videoconferencing

What will the function given below return in MS- Excel 2010? = EXACT ("Word", "word")

a) 0

b) False

c) 1

d) True

Option b - False

What is the default font face in an MS Word 2010 document?

a) Times New Roman

b) Italic

c) Calibri

d) Arial

Option c - Calibri

The ……. refers to the topmost area of the application that contains menu items and toolbars available in MS Excel 2010.

a) Ruler Bar

b) Ribbon

c) Task Bar

d) Title Bar

Option d - Title Bar

In ........ MS Word 2010, all the lines other than the first line are indented

a) right indent

b) hanging indent

c) hanging indent

d) left indent

Option b - hanging indent

.......... refers to the topmost area of the application that contains menu items and toolbars available in MS Excel 2010.

a) Ruler Bar

b) Ribbon

c) Task Bar

d) Title Bar

Option b - Ribbon

In paragraph formatting of MS Word 2010, the keyboard shortcut Ctrl + Q is used for which of the following purposes?

a) Change the paragraph spacing to double line

b) Remove paragraph formatting from the highlighted paragraph

c) Open the Apply Style task pane

d) Remove paragraph indentation

Option b - Remove paragraph formatting from the highlighted paragraph

A …… is a tool used in MS Excel 2010 to calculate, summarize & analyze data & lets you see comparisons, patterns & trends in your data.

a) Pivot table

b) Conditional table

c) Reference table

d) Lookup table

Option a - Pivot table

Every computer connected to the Internet needs an IP address. What is the full form of IP?

a) Internal Protocol

b) Internet Protocol

c) International Partner

d) Internet Partner

Option b - Internet Protocol

What is the default name of the first worksheet in an MS Excel 2010 workbook?

a) WSheet 1

b) Spreadsheet 1

c) Sheet 1

d) Worksheet 1

Option c - Sheet 1

What will happen when you select a cell from an MS Excel 2010 worksheet & press the F2 key?

a) The cell will switch to editing mode so that its content can be modified

b) The content of the cell will be deleted

c) The font color of the content of the cell will be changed

d) The background color of the cell will be changed

Option a - The cell will switch to editing mode so that its content can be modified

The button fx in MS Excel 2010 represents an operation.

a) Format

b) Cancel

c) Insert function

d) Accept/ Enter

Option c - Insert function

When you open a new workbook in MS Excel 2010, then which of the following appears at the topmost position of the screen?

a) Vertical Scroll bar

b) Horizontal scroll bar

c) Status bar

d) Title bar

Option d - Title bar

The first part of the email address is

Join Telegram Group and Get FREE Alerts! Join Now

Join WhatsApp Group For FREE Alerts! Join Now

a) domain name

b) system name

c) mail server

d) username

Option d - username

A sales clerk at a checkout counter scanning a tag on an item rather than keying it into the system is using

(a) Input automation

(b) Item data automation

(c) Scanning automation

(d) Source data automation

Option c - Scanning automation

If you open a menu & then decide you don't want to select an option after all, click the menu to close the menu. Press the ...... key to close the menu

(a) Shift

(b) Tab

(c) F1

(d) ESC

Option d - ESC

A key that will erase information from the computer's memory & characters on the screen ........

(a) Edit

(b) Delete key

(c) Dummy out

(d) Trust key

Option b - Delete key

A ........ is often used to select or highlight.

(a) Icon

(b) Keyboard

(c) Hard disk

(d) Mouse

Option d - Mouse

What are the speakers attached to your computer used for?

(a) Displaying images

(b) Sending messages

(c) Storing messages

(d) Handling sound & music

Option d - Handling sound & music

The mouse ....... usually appears in the shape of an arrow.

(a) Indicator

(b) Maker

(c) Meter

(d) Pointer

Option d - Pointer

The most common storage device for the personal computer is the

(a) Floppy disk

(b) USB thumb drive

(c) Zip disk

(d) Hard disk drive

Option a - Floppy disk

Which of the following could be digital input devices for computers?

(a) Digital camcorder

(b) Microphone

(c) Scanner

(d) All of the above

Option d - All of the above

CPU retrieves its data & instructions from .........

(a) Secondary Memory

(b) Auxiliary Memory

(c) Main Memory

(d) All of these

Option c - Main Memory

Computer memory is used for storing programs & data currently being processed by the CPU .........

(a) Mass Memory

(b) Internal Memory

(c) Non-volatile

(d) PROM

Option b - Internal Memory

The I/O processor has direct access to .......... & contains a number of independent data channels.

(a) Main Memory

(b) Secondary Memory

(c) Cache

(d) Flash

Option a - Main Memory

The word 'computer' usually refers to the central processing unit plus ........

(a) External Memory

(b) Internal Memory

(c) Input Device

(d) Output Devices

Option b - Internal Memory

........... connects components inside the motherboard like CPU & system memory.

(a) Data Bus

(b) Address Bus

(c) Internal Bus

(d) External Bus

Option c - Internal Bus

The main purpose of time-sharing techniques used in computers is to make the best use of the ........

(a) CPU

(b) Peripherals

(c) Secondary

(d) Storage

Option a - CPU

The microprocessor of a computer .............

(a) done not understand machine language

(b) Understands machine language & high-level language

(c) Understands only machine language

(d) Understands only high-level languages.

Option c - Understands only machine language

The memory unit that communicates directly with the CPU is called the

(a) Main Memory

(b) Secondary Memory

(c) Auxiliary Memory

(d) Register

Option a - Main Memory

Which of the following formulas when executed will give an error in Microsoft Excel 2016?

a) SUM (A9 : A15) - B4/10

b) SUM (A1 : A15) * 10 =

c) SUM (L9 : L12)* SUM (K9 : K 12)/(10-9)

d) SUM (A9 : A15)* SUM (K9 : K15)

Option a - SUM (A9 : A15) - B4/10

A service that allows us to send messages in electronic mode over the internet with a unique address. It offers an efficient, inexpensive & real-time means of distributing information among people.

a) VLOG

b) Videoconferencing

c) BLOG

d) EMAIL

Option d - EMAIL

Which of the following is the component where email is received & managed?

a) Drafts

b) Trash

c) Inbox

d) Sent mail

Option c - Inbox

Choose the wrong option related to the cell of MS-Excel 2010 :

a) Cell address is denoted as 1, 2, 3

b) Cells can contain text, such as letters, numbers, & dates.

c) Intersection of a Row & column is known as the cell

d) Cell address is denoted as A1, A2, A3

Option a - Cell address is denoted as 1, 2, 3

Function in MS-Excel 2010 rounds a number to the nearest integer or to the nearest multiple of significance.

a) IF

b) CEILING

c) COUNTIF

d) FLOOR

Option b - CEILING

What is the minimum zoom in MS-Excel 2010 application?

a) 50%

b) 0%

c) 10%

d) 20%

Option c - 10%

The data validation option is present in the _ tab in the MS-Excel 2010 ribbon bar.

a) Insert

b) File

c) View

d) Data

Option d - Data

The keyboard shortcut key to close the MS Word 2010 document is

a) Ctrl + Y

b) CTRL+Z

c) CTRL+W

d) CTRL+X

Option c - CTRL+W

What will be the result if TOGGLE CASE is applied to the word 'Examination' in MS Word 2007?

a) examination

b) Examination

c) EXAMINATION

d) EXAMINATION

Option d - EXAMINATION

Google Chrome is a web browsing software developed in the year

a) 2010

b) 2007

c) 2008

d) 2009

Option c - 2008

Consider a formula "-B2+4" in cell Al of MS- Excel 2010. If cell Al is copied & pasted into D4, then what will be the formula in D4?

a) =B4+7

b) =D4+4

c) =B2+4

d) = E5+4

Option d - = E5+4

The rules governing the sending, traveling & receiving of information within the Internet are called

a) Protocols

b) Algorithms

c) Programs

d) Procedure

Option b - Algorithms

The distance between the written text & the edge of a paper in MS Word 2010 is called

a) Margin

b) Indent Stop

c) Ruler Line

d) Alignment

Option a - Margin

The shortcut key is used in MS Excel 2010 to start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell.

a) Ctrl + Space

b) Ctrl + Enter

c) Alt + Enter

d) Alt + Space

Option c - Alt + Enter

Which of the following keyboard shortcuts is used to save an MS Word 2010 document?

a) Ctrl + C

b) Ctrl + A

c) Ctrl + S

d) Ctrl + B

Option c - Ctrl + S

The function key is used to close a workbook in MS Excel 2010.

a) Ctrl + F2

b) Ctrl + F3

c) Ctrl + Fl

d) Ctrl + F4

Option d - Ctrl + F4

Choose the wrong option with respect to MS- Excel 2010:

a) In MS Excel 2010, Ctrl + 9 is used in hiding the rows within the sheet.

b) In MS Excel 2010, Alt +0 is used in hiding the columns within the sheet.

c) In MS Excel 2010, Ctrl+0 is used in hiding the columns within the sheet.

d) In MS Excel 2010, the Home Tab in the ribbon bar contains the most frequently used commands such as copying & pasting, sorting & filtering, formatting, etc.

Option b - In MS Excel 2010, Alt +0 is used in hiding the columns within the sheet

In MS-Excel 2010 year corresponds to a date. function returns the

a) YEAR

b) CURRENT

c) NOW

d) TODAY

Option a - YEAR

Several computers linked to a server to share programs and storage space are known as:

a. Grouping

b. Integrated system

c. Network

d. Library

Option c - Network

What characteristic of read-only memory (ROM) makes it useful?

a. ROM chips are easily swapped between different brands of computers

b. ROM information can be easily updated

c. Data in ROM is non-volatile, that is, it remains there even without electrical power

d. ROM provides very large amounts of inexpensive data storage

Option c - Data in ROM is non-volatile, that is, it remains there even without electrical power

A Web page is viewed using a:

a. Browser

b. Digital device

c. Link

d. Host

Option a - Browser

The term designates equipment that might be added to a computer system to enhance its functionality:

a. Digital device

b. Peripheral Device

c. Disk pack

d. System add-on

Option b - Peripheral Device

Every HTML file is a:

a. Audio

b. Image

c. Text

d. Video

Option c - Text

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

a. Document Processor

b. Database

c. Spreadsheet

d. Graphic Package

Option c - Spreadsheet

By default, your documents print in:

a. Portrait

b. Landscape

c. Print View

d. Page Setup

Option a - Portrait

A ....... is approximately one billion bytes

a. Terabyte

b. None of these

c. Megabyte

d. Gigabyte

Option d - Gigabyte

In MICR, C stands for:

a. Code

b. Computer

c. Character

d. Color

Option c - Character

A computer cannot "boot" if it does not have the:

a. Loader

b. Compiler

c. Operating System

d. Assembler

Option c - Operating System

Which file starts MS Word?

a. mswords.exe

b. winword.exe

c. word.exe

d. word2003.exe

Option b - winword.exe

Verification of log-in name and password is for:

a. Authenticating the user

b. Completing the formality of login

c. Providing formal access to the user

d. Re-confirming the user

Option a - Authenticating the user

We covered all the computer mcqs above in this post for free so that you can practice well for the exam.

Check out the latest MCQ content by visiting our mcqtube website homepage.

Also, check out:

Join Telegram Group and Get FREE Alerts! Join Now

Join WhatsApp Group For FREE Alerts! Join Now

Hello, I am the admin of mcqtube.com website. I am a blogger and app developer. Thanks.

Leave a Comment