Microsoft Excel 2019 15 basic formulas

 

Here are 15 basic formulas in Excel 2019:

1.   SUM: This formula is used to add up a range of numbers.

Syntax: =SUM(number1,number2,...)

Example: =SUM(A1:A10)

 

2.   AVERAGE: This formula is used to calculate the average of a range of numbers.

Syntax: =AVERAGE(number1,number2,...)

Example: =AVERAGE(A1:A10)

 

3.   MAX: This formula is used to find the largest number in a range.

Syntax: =MAX(number1,number2,...)

Example: =MAX(A1:A10)

 

4.   MIN: This formula is used to find the smallest number in a range.

Syntax: =MIN(number1,number2,...)

Example: =MIN(A1:A10)

 

5.   COUNT: This formula is used to count the number of cells that contain numbers in a range.

Syntax: =COUNT(number1,number2,...)

Example: =COUNT(A1:A10)

 

6.   COUNTA: This formula is used to count the number of cells that contain any type of data (numbers, text, formulas, etc.) in a range.

Syntax: =COUNTA(value1,value2,...)

Example: =COUNTA(A1:A10)

 

7.   ROUND: This formula is used to round a number to a specified number of decimal places.

Syntax: =ROUND(number,num_digits)

Example: =ROUND(A1,2)

 

8.   IF: This formula is used to test a condition and return one value if the condition is true and another value if the condition is false.

Syntax: =IF(condition,value_if_true,value_if_false)

Example: =IF(A1>10,"Yes","No")

 

9.   SUMIF: This formula is used to add up values in a range that meet a specified criterion.

Syntax: =SUMIF(range,criteria,sum_range)

Example: =SUMIF(A1:A10,">10",B1:B10)

 

10.         AVERAGEIF: This formula is used to calculate the average of values in a range that meet a specified criterion.

Syntax: =AVERAGEIF(range,criteria,average_range)

Example: =AVERAGEIF(A1:A10,"Apples",B1:B10)

 

11.         TRIM: This formula is used to remove extra spaces from text.

Syntax: =TRIM(text)

Example: =TRIM(" Apple ")

 

12.         LEFT: This formula is used to extract a specified number of characters from the beginning of a text string.

Syntax: =LEFT(text,num_chars)

Example: =LEFT("Apple",3)

 

13.         RIGHT: This formula is used to extract a specified number of characters from the end of a text string.

Syntax: =RIGHT(text,num_chars)

Example: =RIGHT("Apple",2)

 

14.         LEN: This formula is used to count the number of characters in a text string.

Syntax: =LEN(text)

Example: =LEN("Apple")

 

15.         CONCATENATE: This formula is used to join two or more text strings into one.

Syntax: =CONCATENATE(text1, text2, ...)

Example: =CONCATENATE("John ","Doe")

Microsoft Office 2019 related 15 Theory (MCQ) Question and Answer

 

MCQ Question and Answer :-

1.   What is Microsoft Office 2019?

A. A web browser

B. An operating system

C. A productivity suite

D. An antivirus program

 

Answer: C. A productivity suite

 

2.   Which of the following applications is included in Microsoft Office 2019?

A. Photoshop

B. Illustrator

C. Excel

D. Adobe Reader

 

Answer: C. Excel

 

3.   Which of the following applications is used for creating presentations in Microsoft Office 2019?

A. Word

B. Excel

C. PowerPoint

D. Outlook

 

Answer: C. PowerPoint

 

4.   Which of the following applications is used for creating and editing documents in Microsoft Office 2019?

A. Word

B. Excel

C. PowerPoint

D. Outlook

 

Answer: A. Word

 

5.   Which of the following applications is used for managing emails in Microsoft Office 2019?

A. Word

B. Excel

C. PowerPoint

D. Outlook

 

Answer: D. Outlook

 

6.   What is the cloud-based version of Microsoft Office 2019 called?

A. Office 365

B. Office Online

C. Office Web Apps

D. Microsoft 365

 

Answer: A. Office 365

 

7.   Which of the following is not a feature of Microsoft Office 2019?

A. Dark mode

B. Real-time collaboration

C. Artificial intelligence

D. Virtual reality

 

Answer: D. Virtual reality

 

8.   Which of the following is a spreadsheet program in Microsoft Office 2019?

A. Excel

B. Word

C. PowerPoint

D. Outlook

 

Answer: A. Excel

 

9.   Which of the following is a word processing program in Microsoft Office 2019?

A. Excel

B. Word

C. PowerPoint

D. Outlook

 

Answer: B. Word

 

10.                     Which of the following is a presentation program in Microsoft Office 2019?

A. Excel

B. Word

C. PowerPoint

D. Outlook

 

Answer: C. PowerPoint

 

11.                     Which of the following is a communication program in Microsoft Office 2019?

A.   Excel

B. Word

C. PowerPoint

D. Outlook

 

Answer: D. Outlook

 

12.                     Which of the following is a diagramming program in Microsoft Office 2019?

A. Excel

B. Word

C. PowerPoint

D. Visio

 

Answer: D. Visio

 

13.                     What is the function of the Ribbon in Microsoft Office 2019 applications?

A. To provide access to frequently used commands and functions

B. To display the document or spreadsheet

C. To save the file

D. To close the application

 

Answer: A. To provide access to frequently used commands and functions

 

14.                     Which of the following is not a file format supported by Microsoft Office 2019?

A. DOCX

B. XLSX

C. PPTX

D. PDF

 

Answer: D. PDF

 

15.                     What is the function of the Quick Access Toolbar in Microsoft Office 2019 applications?

A. To provide access to frequently used commands and functions

B. To display the document or spreadsheet

C. To save the file

D. To close the application

 

Answer: A. To provide access to frequently used commands and functions

 

Network and Internet related longfrom (fullform)

 

• LAN: Local Area Network

• WAN: Wide Area Network

• MAN: Metropolitan Area Network

• WLAN: Wireless Local Area Network

• VPN: Virtual Private Network

• DNS: Domain Name System

• IP: Internet Protocol

• TCP: Transmission Control Protocol

• UDP: User Datagram Protocol

• FTP: File Transfer Protocol

• HTTP: Hypertext Transfer Protocol

• HTTPS: Hypertext Transfer Protocol Secure

• SSL: Secure Sockets Layer

• TLS: Transport Layer Security

• POP: Post Office Protocol

• SMTP: Simple Mail Transfer Protocol

• IMAP: Internet Message Access Protocol

• VoIP: Voice over Internet Protocol

• IoT: Internet of Things

• HTML: Hypertext Markup Language

• CSS: Cascading Style Sheets

• JavaScript: a programming language used for creating interactive web applications

• API: Application Programming Interface

• URI: Uniform Resource Identifier

• URL: Uniform Resource Locator

• MAC: Media Access Control

• SSID: Service Set Identifier

• IEEE: Institute of Electrical and Electronics Engineers

• ISP: Internet Service Provider

• BGP: Border Gateway Protocol.

What is LAN network?

    LAN stands for Local Area Network. It refers to a network that is designed to connect devices within a relatively small area, such as a building, a campus, or a small geographic area.

    A LAN typically consists of a group of computers, servers, printers, and other network devices that are connected together using a variety of technologies, including Ethernet cables, wireless access points, and switches.

    LANs are commonly used in homes, small businesses, schools, and other organizations to allow devices to share resources, such as files, printers, and Internet access. LANs are also often used to facilitate communication and collaboration between different users and devices within a local area.

One of the advantages of LANs is that they are typically faster and more reliable than WANs because they have a smaller geographic area to cover and can use higher-speed technologies, such as Ethernet cables. Additionally, LANs can be more secure than WANs because they are easier to monitor and control.

LAN network example

An example of a LAN network is a home network, where devices such as computers, laptops, smartphones, printers, and other devices are connected to a common router or switch. The router is used to share the internet connection among the devices, while the switch is used to connect devices within the network.

Another example of a LAN network is a small business network, where computers, servers, printers, and other devices are connected to a local switch or router. This allows employees to share files, printers, and other resources, and collaborate more efficiently.

LANs are also commonly used in schools, libraries, hospitals, and other institutions to enable communication and data sharing between devices within a small geographic area.

Another example of a LAN is a data center, where servers and other computing devices are interconnected to support data storage, processing, and delivery. These networks often use high-speed Ethernet or fiber-optic cables to enable fast data transfer between devices.

What is WAN network?

    WAN stands for Wide Area Network. It refers to a network that covers a large geographical area, such as a city, a country, or even the entire world. WANs are used to connect devices and networks that are far apart from each other, such as different offices or data centers.

    WANs typically use a variety of technologies to connect different locations, including leased lines, satellite links, and fiber-optic cables. They also often use routing protocols to determine the best path for data to travel between different locations.

    One of the most common examples of a WAN is the Internet, which is a global network of networks that allows devices and users to communicate and exchange information from anywhere in the world. Other examples of WANs include private networks used by businesses, government agencies, and educational institutions to connect their offices and facilities in different locations.

WAN network example

    An example of a WAN network is the Internet, which is a global network that connects millions of devices and networks across the world. The Internet is the largest and most well-known example of a WAN, and it uses a variety of technologies and protocols, such as TCP/IP, DNS, and routing protocols, to enable communication and data exchange between devices and networks across different geographic locations.

    Another example of a WAN network is a private network used by a large corporation with multiple offices located in different cities or countries. In such a network, the company may use leased lines, MPLS (Multiprotocol Label Switching), or other technologies to connect its offices and facilities, enabling employees to share resources and collaborate seamlessly regardless of their physical location.

Other examples of WAN networks include government networks that connect different agencies and facilities across a country, academic networks that connect universities and research institutions across the world, and cloud-based networks that allow organizations to store and access data and applications from remote servers.

How to install Debian Server on computer in easy step by step

 

I can provide you with detailed step-by-step instructions for installing Debian Server on a computer.

1.   Download the Debian Server ISO file from the official Debian website :- https://www.debian.org/distrib/

2.   Burn the ISO file to a USB drive or DVD. You can use a program like Rufus or Etcher to create a bootable USB drive or DVD from the ISO file.

3.   Insert the USB drive or DVD into the computer that you want to install Debian Server on.

4.   Boot the computer from the USB drive or DVD. This may require you to change the boot order in the BIOS or UEFI settings of your computer.

5.   Choose the "Graphical install" option from the Debian boot menu.

6.   Choose your preferred language, location, and keyboard layout.

7.   Enter a hostname for your server and click "Continue".

8.   Set a password for the root user and click "Continue".

9.   Partition the disk according to your needs. You can choose to use the entire disk, create separate partitions for /home or /var, or use LVM (Logical Volume Manager) for more flexibility.

10.                     Choose the software that you want to install. You can choose to install only the basic system utilities or select additional packages such as a web server, a database server, or an SSH server.

11.                     Configure the network settings. You can choose to use DHCP or set a static IP address.

12.                     Install the GRUB bootloader to the MBR (Master Boot Record) of the disk.

13.                     Finish the installation process and reboot the computer.

14.                     Log in as the root user with the password you set during the installation.

15.                     Configure any additional settings, such as firewall rules or user accounts.

Note that these steps are a general overview of the Debian Server installation process and may vary depending on your specific hardware and software configuration. It is recommended to refer to the official Debian documentation for more detailed instructions.

Keyboard Navigation keys information

 

Keyboard navigation keys are used to navigate a computer interface without using a mouse.

Here are some commonly used keyboard navigation keys :-

1.   Tab key :- Moves the focus to the next control or element in a form or dialog box.

2.   Arrow keys :- Moves the focus to adjacent controls or elements, or scrolls the document up/down or left/right.

3.   Enter key :- Activates the default action for the current control or element, such as clicking a button or submitting a form.

4.   Spacebar :- Activates the current control or element, such as selecting a checkbox or radio button.

5.   Escape key :- Cancels the current operation or closes a dialog box.

6.   Alt key :- Activates the menu bar, allowing you to access menus using keyboard shortcuts.

7.   Ctrl key :- Used in combination with other keys to perform actions such as copying, pasting, or undoing.

8.   Home and End keys :- Move the cursor to the beginning or end of a line or document.

9.   Page Up and Page Down keys :- Scroll the document up or down by one screenful.

10.                     F1-F12 keys :- Perform specific functions depending on the software being used, such as opening help files or executing macros.

What is Supercomputer?

      A supercomputer is a type of computer that is designed to handle very large and complex computational tasks at very high speeds. It is a high-performance computing system that is capable of performing millions or even billions of calculations per second.

    Supercomputers are typically made up of thousands or even millions of processors that work together in parallel to solve a single problem or set of problems. They are used for a variety of applications such as scientific research, weather forecasting, quantum mechanics, fluid dynamics, and many more.

Some of the characteristics of a supercomputer include :-

1.   High processing power: Supercomputers are designed to perform complex calculations at very high speeds. They can perform billions of calculations per second.

2.   Massive memory capacity: Supercomputers have a very large amount of memory, which allows them to process and store massive amounts of data.

3.   Parallel processing: Supercomputers use a technique called parallel processing, which means that they divide a complex problem into smaller parts that can be solved simultaneously by different processors.

4.   Specialized hardware: Supercomputers are designed with specialized hardware such as graphics processing units (GPUs) and field-programmable gate arrays (FPGAs) that can perform specific tasks very quickly.

5.   Cost: Supercomputers are very expensive to build and maintain, with costs ranging from tens of millions to hundreds of millions of dollars.

    Supercomputers are essential for many fields of scientific research and engineering, and they play a critical role in advancing technology and innovation.