Computer Basic Knowledge PDF Gujarati

Questions

    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:

    Computer Basic Knowledge PDF Gujarati for Students

    Quick Quiz

    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

    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:

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

    Leave a Comment

    Floating ChatBot
    Ask

    Doubt?, Ask me Anything



    Sticky Bottom Popup