Search Previous Year Questions

Find real questions from previous competitive exam papers with answers and solutions.

Leave the keyword blank to browse saved questions for your selected exam, newest papers first. Add a keyword, year or topic to narrow the results.

Browse complete papers
Showing 10 question(s)
Clear

Question 21

UPPCL Technician 2021• Computer Knowledge (CCC Level)

A set of rules that governs data communication is called:

  1. AOption (a)

    Standard

  2. BOption (b)

    Topology

  3. COption (c)

    Networking

  4. DOption (d)

    Protocol

View answer & explanation

Correct answer

Answer: (d)D.

Protocol

Why this answer is correct

The correct option is (4)

Protocol

Concept:-

A set of rules that governs data communication is called a protocol.

Key Points

  • A set of guidelines called a protocol governs communication. A sender, a receiver, and a method by which the message is sent from the sender to the receiver are the fundamental elements of communication.
  • A "blueprint of methods, properties, and other requirements that suit a given task or piece of functionality" is defined by protocols.
  • A protocol is a set of instructions for formatting and processing data in networking. Computers have a common language known as network protocols.
  • Even if the software and hardware used by the computers in a network may be very dissimilar, the usage of protocols allows them to communicate with one another.

Additional Information Networking:- Networking is the informal social exchange of knowledge and ideas among those who share a profession or a particular interest. A single area of agreement is frequently the starting point for networking.

Standard:- Standards are a set of guidelines for data transmission that are required for the exchange of data between devices.

Topology:- The physical and logical configuration of a network's nodes and connections is known as its topology. Devices like switches, routers, and software with switch and router features are typically included in nodes.

Question 22

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What is MFLOPS?

  1. AOption (a)

    It is used to measure the state of the CPU.

  2. BOption (b)

    It is used to measure the speed of CPU.

  3. COption (c)

    It is a memory unit.

  4. DOption (d)

    It is used to measure memory access time.

View answer & explanation

Correct answer

Answer: (b)B.

It is used to measure the speed of CPU.

Why this answer is correct

The correct option is (2)

It is used to measure the speed of the CPU.

Key Points

  • MFLOPs, an abbreviation for mega floating-point operations per second, is a commonly used indicator of how quickly computers can do floating-point computations.
  • MIPS (million instructions per second), which measures integer performance, is another widely used metric of computer speed and power.
  • MFLOPs are a commonly used metric for gauging how quickly floating-point calculations are processed by microprocessors.
  • The term FLOP, or floating point operations per second, refers to how quickly a computer can perform calculations.
  • A Giga FLOP is merely a GFLOP. So having GPU with 2 times higher GFLOP value is very likely to speed up the training process.
  • A central processing unit, also known as a CPU, is a piece of electronic equipment that executes commands from software, enabling a computer or other device to carry out its functions.

Question 23

UPPCL Technician 2021• Computer Knowledge (CCC Level)

URL means:

  1. AOption (a)

    Unique Resource Label

  2. BOption (b)

    Uniform Resource Locator

  3. COption (c)

    Unique Reference Label

  4. DOption (d)

    Uniform Reference Locator

View answer & explanation

Correct answer

Answer: (b)B.

Uniform Resource Locator

Why this answer is correct

The correct option is (2)

Uniform Resource Locator

Key Points

  • Uniform Resource Locator, or URL, is an Internet resource address and a reference to that resource.
  • Websites have individual addresses to make it easier for users to find them, just like residences and structures have street addresses. These are known as URLs on the Internet (Uniform Resource Locators).
  • A website's name is its domain, its location is its URL, and its content is what visitors see and use when they arrive.
  • In other words, purchasing a domain only gets you the name of your website; the actual website itself still needs to be built.
  • The text or image that you want to appear as a hyperlink should be selected. Input Ctrl+K. You can also choose a Link from the shortcut menu by right-clicking the text or image and selecting it. Type or paste your link into the Address box of the Insert Hyperlink box.

Question 24

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What does macro mean in the context of Microsoft Word?

  1. AOption (a)

    A macro is a command used to automatically send email.

  2. BOption (b)

    The macro command automatically creates multiple documents with similar content.

  3. COption (c)

    A macro is a series of commands and instructions that you put together as a single command to automatically accomplish a task.

  4. DOption (d)

    The Macro command helps to create multiple mails with different contents.

View answer & explanation

Correct answer

Answer: (c)C.

A macro is a series of commands and instructions that you put together as a single command to automatically accomplish a task.

Why this answer is correct

The correct option is (3)

A macro is a series of commands and instructions that you put together as a single command to accomplish a task automatically.

Key Points

  • By creating and using macros in Word, you may automate routine operations. A macro is a collection of instructions and commands that you can use as a single command to carry out a task automatically.
  • Updated versions of Office 2007 Word used online. Combine the procedures into a macro to save time on routine chores.
  • A macro is a section of code that a program replaces with its value. The #define directive defines a macro.
  • When the compiler comes across a macro name, it substitutes the name with the macro definition. A semicolon is not required to end macro definitions (;).
  • You may automate frequently used formatting options in Microsoft Word using macros, a little-utilized feature.
  • When you frequently find yourself changing the same formatting settings across many documents**, macros** can be very helpful.

Question 25

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which of the following menu items is used in Microsoft PowerPoint 2016 to see different presentation view options?

  1. AOption (a)

    Review

  2. BOption (b)

    Home

  3. COption (c)

    View

  4. DOption (d)

    Design

View answer & explanation

Correct answer

Answer: (c)C.

View

Why this answer is correct

The correct option is (3)

View

Key Points

  • The View tab is where you'll discover the many PowerPoint view choices, as demonstrated below.
  • The PowerPoint window's bottom-right corner houses the slide view commands. Four primary slide views are available.
  • Five alternative views are available in PowerPoint for working with presentations: Slide. \sOutline. Sorting by slide Page of Notes. Show a Slide.
  • To see all of your slides listed in a column, choose Outline View. To view thumbnails of all your slides, use Slide Sorter.

Additional Information

  • The Review tab is the following tab in Ribbon. This includes resources that can be used to edit and proofread presentations. We start with the available languages: Spelling: run a spell check on your written work.
  • The Cut and Paste capabilities, Font and Paragraph settings, and tools you need to add and organize slides are all found on the Home page.
  • The overall look of your entire slide show can be selected here. A slide show can be easily designed using themes. Each presentation slide will be customized to match the theme's chosen backdrop, font, colors, and effects.

Question 26

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What is the absolute address of the first cell of a Microsoft Excel worksheet?

  1. AOption (a)

    1$A$

  2. BOption (b)

    $A1$

  3. COption (c)

    $1A$

  4. DOption (d)

    $A$1

View answer & explanation

Correct answer

Answer: (d)D.

$A$1

Why this answer is correct

The correct answer is $A$1.

Key Points

  • The cell reference or cell address in MS Excel helps to identify the cell. Now, when a cell reference gets fixed and cannot change due to copy, then it is referred to as an absolute cell reference in MS Excel.
  • In MS Excel, rows are named after numbers like 1, 2, 3, 4 etc. and the columns are named with capital letters A, B, C etc. Once it reaches the letter Z, the next column starts with 'AA'.
  • The cell reference of the very first cell of MS Excel is A1. To create an absolute cell reference, the user needs to add the '$' sign at the beginning of the name of the row and column.
  • For example, the absolute cell reference of A1 will be $A$1.

Thus the correct answer is $A$1.

Additional Information

  • MS Excel, a spreadsheet program, is widely used for different kinds of functions, as a result, the info is simple to avoid wasting time, and data is accessible and removed with zero discomforts and less labour. Given below area unit some necessary advantages of exploitation MS Excel:
  • Easy To Store Data: Since there's no limit to the number of data that may be saved in an exceeding program. MS Excel is widely accustomed to saving or analysing information. Filtering info in stand out is simple and convenient.
  • Easy To Recover Data: If the data is written on a bit of paper, finding it should take longer, however, this is often not the case with Excel spreadsheets. Finding convalescent information is simple.
  • Application of Mathematical Formulas: Doing calculations has become more accessible and less time-taking with the formulas possibility in MS Excel.
  • More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer; therefore, the chance of losing them is much lesser than information written in registers or pieces of paper.
  • Data at One Place: Earlier, information was to be unbroken in several files and registers once the work was done. Now, this has become convenient as over one worksheet is accessible in an exceedingly single MS Excel file.
  • Neater and Clearer Visibility of Information: Once the info is saved within the type of a table, analysing it becomes easier. Thus, info may be a program that's a lot of legible and comprehensible$.

Question 27

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What is the label of the first column of a Microsoft Excel worksheet?

  1. AOption (a)

    A

  2. BOption (b)

    AA

  3. COption (c)

    Z

  4. DOption (d)

    1

View answer & explanation

Correct answer

Answer: (a)A.

A

Why this answer is correct

The correct answer is A.

Key Points

  • The cell address in MS excel helps to identify the cell.
  • In MS Excel, rows are labelled after numbers like 1, 2, 3, 4 etc. and the columns are labelled with capital letters A, B, C etc. Once it reaches the letter Z, the next column starts with 'AA'.
  • The cell reference of the very first cell of MS Excel is A1 where the label of the first column is A and the label of the first row is 1.

Thus the correct answer is A.

 Additional Information

  • MS Excel, a spreadsheet program, is widely used for different kinds of functions, as a result, the info is simple to avoid wasting time, and data is accessible and removed with zero discomforts and less labour. Given below area unit some necessary advantages of exploitation MS Excel:
  • Easy To Store Data: Since there's no limit to the number of data that may be saved in an exceeding program. MS Excel is widely accustomed to saving or analysing information. Filtering info in stand out is simple and convenient.
  • Easy To Recover Data: If the data is written on a bit of paper, finding it should take longer, however, this is often not the case with Excel spreadsheets. Finding convalescent information is simple.
  • Application of Mathematical Formulas: Doing calculations has become more accessible and less time-taking with the formulas possibility in MS Excel.
  • More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer; therefore, the chance of losing them is much lesser than information written in registers or pieces of paper.
  • Data at One Place: Earlier, information was to be unbroken in several files and registers once the work was done. Now, this has become convenient as over one worksheet is accessible in an exceedingly single MS Excel file.
  • Neater and Clearer Visibility of Information: Once the info is saved within the type of a table, analysing it becomes easier. Thus, info may be a program that's a lot of legible and comprehensible.

Question 28

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What is the address of the cell containing the 4th row and 5th column in Microsoft Excel?

  1. AOption (a)

    E4

  2. BOption (b)

    4E

  3. COption (c)

    45

  4. DOption (d)

    54

View answer & explanation

Correct answer

Answer: (a)A.

E4

Why this answer is correct

The correct answer is E4.

Key Points

  • The cell address in MS excel helps to identify the cell.
  • In MS Excel, rows are labelled after numbers like 1, 2, 3, 4 etc. and the columns are labelled with capital letters A, B, C etc. Once it reaches the letter Z, the next column starts with 'AA'.
  • The cell reference of the very first cell of MS Excel is A1 where the label of the first column is A and the label of the first row is 1.
  • In this manner, the address of the cell containing the 4th row and 5th column in Microsoft Excel is E4.

Thus the correct answer is E4.

Additional Information

  • MS Excel, a spreadsheet program, is widely used for different kinds of functions, as a result, the info is simple to avoid wasting time, and data is accessible and removed with zero discomforts and less labour. Given below area unit some necessary advantages of exploitation MS Excel:
  • Easy To Store Data: Since there's no limit to the number of data that may be saved in an exceeding program. MS Excel is widely accustomed to saving or analysing information. Filtering info in stand out is simple and convenient.
  • Easy To Recover Data: If the data is written on a bit of paper, finding it should take longer, however, this is often not the case with Excel spreadsheets. Finding convalescent information is simple.
  • Application of Mathematical Formulas: Doing calculations has become more accessible and less time-taking with the formulas possibility in MS Excel.
  • More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer; therefore, the chance of losing them is much lesser than information written in registers or pieces of paper.
  • Data at One Place: Earlier, information was to be unbroken in several files and registers once the work was done. Now, this has become convenient as over one worksheet is accessible in an exceedingly single MS Excel file.
  • Neater and Clearer Visibility of Information: Once the info is saved within the type of a table, analysing it becomes easier. Thus, info may be a program that's a lot of legible and comprehensible.

Question 29

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which of the following characteristics of a computer makes it capable to carry out a job without any human intervention?

  1. AOption (a)

    Diligence

  2. BOption (b)

    Accuracy

  3. COption (c)

    Automatic

  4. DOption (d)

    Versatility

View answer & explanation

Correct answer

Answer: (c)C.

Automatic

Why this answer is correct

The correct answer is Automatic.

Key Points

  • Diligence: A computer is a machine and never gets tired or exhausted. It can work 24x7 hrs constantly, without making any mistakes.
  • Accuracy: A computer is a machine and never makes any mistakes. It produces always 100% accurate answers after performing the calculation.
  • Automatic: The automation mode allowed the computer to do its work automatically without human intervention.
  • Versatility: A computer is a machine that can perform several tasks at the same time without making mistakes.

Thus the correct answer is Automatic.

Additional Information

  • Charles Babbage is known as the father of the computer who invented the analytical engine in the year 1822. Abacus is known as the first calculating device.
  • The computer can perform any task faster than a human being.
  • Computer never forgets anything.

Question 30

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which keyboard shortcut is used to move the insertion point to the beginning of a Microsoft Word document?

  1. AOption (a)

    CTRL+End

  2. BOption (b)

    CTRL+Enter

  3. COption (c)

    CTRL+Home

  4. DOption (d)

    ALT+Home

View answer & explanation

Correct answer

Answer: (c)C.

CTRL+Home

Why this answer is correct

The correct answer is CTRL+Home.

Key Points

  • CTRL + End: This keyboard shortcut is used to move the insertion point to the end of a Microsoft Word document
  • CTRL + Enter: keyboard shortcut is used to insert a page break in a Microsoft Word document.
  • CTRL + Home: This keyboard shortcut is used to move the insertion point to the beginning of a Microsoft Word document.
  • Alt + Home: This keyboard shortcut is used to move the insertion point to the first cell of a table in a Microsoft Word document.

Thus the correct answer is CTRL+Home.

Additional Information

  • The leading creators of MS Word software are Charles Simonyi and Richard Brodie, launched in 1983 under Microsoft corporation.
  • Microsoft word is recognised as a word processor software which means that a user can rewrite, erase or modify a document as per the requirement.
  • The documents created in MS Word are very high in quality. MS Word creates reports, stories, letters, resumes, etc.
  • It allows users to edit or modify the new or existing document with colour or any other formats like bold, italic and underline.
  • In MS Word, the users can write the stories in paragraph format.
  • The file extension used in MS Word is .doc or .docx.