teleren/devto huggingface dataset:
How to Use Excel SQRT Function in Office 365? – {with Examples}
Tags: excelfunctions, excelsqrtfunctionino
Published: 2020-08-27 11:01:21

---
title: How to Use Excel SQRT Function in Office 365? – {with Examples}
published: true
date: 2020-08-26 12:33:52 UTC
tags: ExcelFunctions,ExcelSQRTFunctioninO
canonical_url: https://geekexcel.com/how-to-use-excel-sqrt-function-in-office-365-with-examples/
---

## Excel SQRT Function:

![SQRT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/SQRT-Function.png)<figcaption id="caption-attachment-12645">SQRT Function</figcaption>

In this article, we are going to learn how to use **Excel SQRT Function in Office 365** with its syntax, description, and examples. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)


## **SQRT Function – Description:**

- This function **returns the square root of a positive integer**.
- If the number is negative, it will show an error.
- For example, **SQRT(25)** returns the value **5**.

## **Syntax:**

**=SQRT(number)**

### Argument Explanation:

**Number** – The input number for which you want the square root value.

### **Note:**

- If the input is a negative number and then it will show **#NUM!** Error.
- If the argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

## **Examples:**

Let’s see some examples to make it clear.

### Example 1:

- The following image has shown the input numbers in **Column A** and its square root values in **Column B**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-78.png)<figcaption id="caption-attachment-12642">Example 1</figcaption>

### Example 2:

- If the input is a negative number and then it will show **#NUM!** Error.
- If the argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.
- Refer to the below screenshot.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-63.png)<figcaption id="caption-attachment-12643">Example 2</figcaption>

## **Summary:**

In this article, you will understand the usage of **Excel SQRT Function in Office 365** with its syntax, description, and examples. Give your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use Excel ODD Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-odd-function-in-office-365-with-examples/)
- [How to Use Excel MOD Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)
What is hashing and why hashing is required?
Tags: hashing
Published: 2020-08-26 11:57:54

Hashing is a crucial arrangement which is meant to use a special function called the Hash function which is employed to map a given value with a specific key for faster access of elements. The mapping’s efficiency depends of the efficiency of the hash function used.

It is a really useful concept that regularly comes up in System Design Interviews. you would possibly got to apply the concept while designing the backend of a system to alleviate bottlenecks . you’ll even be directly asked to style and implement a uniform [Hashing](https://technicalsand.com).

The process of re-calculating the hashcode of already stored entries (Key-Value pairs) and to move these to another bigger size hashmap when the threshold is crossed/reached, is known as Rehashing
Rehashing of a hash map is completed when the amount of elements within the map reaches the utmost threshold value. Java specification suggests that the great ratio value is .75 and therefore the default initial capacity of HashMap is 16. Once the amount of elements reaches or crosses 0.75 times the capacity, the complexity increases, So to beat this the dimensions of the array is increased by double and every one the values are hashed again and stored within the new array of double size. this is often done to scale back the complexity and maintain low ratio . during this case, when the amount of elements is 12, rehashing occurs. (0.75 * 16 = 12).

Why Rehashing is required?
Rehashing is required because whenever a brand new key value pair is inserted into map, the load factor increases and because of which complexity also increases. And if complexity increases our hashMap won’t have constant O(1) time complexity. Hence rehashing is required to distribute the things across the hashmap as to reduce both load factor and complexity, So that the methods, get() and put() have constant time complexity of O(1). After rehashing is completed existing items may fall within the same bucket or different bucket.
Hashing is involved when our goal is to style a database storage system such that:
- We should be ready to distribute the incoming queries uniformly among the set of “n” database servers
- We should be ready to dynamically add or remove a database server
- When we add/remove a database server, we’d like to maneuver the minimal amount of knowledge between the servers
To handle all above questions we need to understand the concepts of hashing in details. You need to learn and find the answers of following questions.
- What is hashing?
- What is hash table?
- How to build distributed hash tables?
- What is rehashing and why we need this?
- What is consistent hashing?
- What is hash ring?
I have written a detailed article on each one of above concepts, you can find all details here on <a href="https://technicalsand.com/hashing-in-data-structure/">Hashing in datastructure</a>
How to Use Excel QUOTIENT Function in Office 365? – {with Examples}
Tags: excelfunctions, excelquotientfunctio
Published: 2020-08-27 11:01:02

---
title: How to Use Excel QUOTIENT Function in Office 365? – {with Examples}
published: true
date: 2020-08-26 12:26:12 UTC
tags: ExcelFunctions,ExcelQUOTIENTFunctio
canonical_url: https://geekexcel.com/how-to-use-excel-quotient-function-in-office-365-with-examples/
---

## Excel QUOTIENT Function:

![QUOTIENT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/QUOTIENT-Function.png)<figcaption id="caption-attachment-12632">QUOTIENT Function</figcaption>

In this tutorial, we will guide you to know the usage of **Excel QUOTIENT Function in Office 365** with its syntax, explanation, and examples. Let’s see them below!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **QUOTIENT Function – Explanation:**

- This function **returns the integer portion of a division without the remainder**.
- For example, **QUOTIENT(7/2)** will return the output as **3**.

## **Syntax:**

**=QUOTIENT(numerator, denominator)**

### Argument Explanation:

**Numerator ** – The number that needs to be divided.

**Denominator ** – The divisor.

### Note:

- If any argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

## **Examples:**

Let’s see some examples below.

### Example 1:

- Refer to the below screenshot.
- The input values numerator (dividend) and denominator (divisor) are given in **Column A** , **B**. The output values (Quotient) are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-76.png)<figcaption id="caption-attachment-12627">Example 1</figcaption>

### Example 2:

- If any argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-61.png)<figcaption id="caption-attachment-12628">Example 2</figcaption>

## **Bottom-Line:**

In the above article, you can clearly understand how to use the **Excel QUOTIENT Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use Excel FLOOR Function in Office 365? – (With Examples)](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/)
- [How to Use IMPOWER Function in Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-impower-function-in-excel-365-with-examples/)
How to Use “Excel SIGN Function” in Office 365? – {with Examples}
Tags: excelfunctions, excelsignfunctionino
Published: 2020-08-27 11:00:50

---
title: How to Use “Excel SIGN Function” in Office 365? – {with Examples}
published: true
date: 2020-08-26 12:24:26 UTC
tags: ExcelFunctions,ExcelSIGNFunctioninO
canonical_url: https://geekexcel.com/how-to-use-excel-sign-function-in-office-365-with-examples/
---

## Excel SIGN Function:

![SIGN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/SIGN-Function.png)<figcaption id="caption-attachment-12638">SIGN Function</figcaption>

In this post, you will learn the usage of **Excel SIGN Function in Office 365** with its syntax, description, and examples. Let’s see them below!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **SIGN Function – Description:**

- This function **returns the sign of the given number**.
- If the number is **positive** ( **0 to ∞** ) and then it returns **1**.
-  This function will return **-1** if the input number is **negative** ( **-∞ to 0** ),
- If the number is **zero** , the SIGN function will return **0**.

## **Syntax:**

**=SIGN(number)**

### Parameter Description:

**Number** – The input number to get the sign.

### Note:

- If the argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

## **Examples:**

Kindly, see the below examples for your reference.

### Example 1:

- In the following image, you can see the input numbers in **Column A** , and its output values are listed in **Column B**.
- The **cell A3** contains an input value **18** ( **a positive integer** ), then the SIGN function returns **1** in the **cell B3**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-77.png)<figcaption id="caption-attachment-12635">Example 1</figcaption>

### Example 2:

- If the argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-62.png)<figcaption id="caption-attachment-12636">Example 2</figcaption>

## **End of the Article:**

In the above article, you can clearly understand the usage of **Excel SIGN Function in Office 365** with its syntax, description, and examples. Kindly, leave your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use DELTA Function in Microsoft Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-delta-function-in-microsoft-excel-365-with-examples/)
- [How to Use “Excel LOG10 Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-log10-function-in-office-365-with-examples/)
How to Use Excel TRUNC Function in Office 365? – (with Examples)
Tags: excelfunctions, exceltruncfunctionin
Published: 2020-08-27 11:00:33

---
title: How to Use Excel TRUNC Function in Office 365? – (with Examples)
published: true
date: 2020-08-26 12:22:21 UTC
tags: ExcelFunctions,ExcelTRUNCFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-trunc-function-in-office-365-with-examples/
---

## Excel TRUNC Function:

![TRUNC Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/TRUNC-Function.png)<figcaption id="caption-attachment-12662">TRUNC Function</figcaption>

In this article, you will learn the usage of **Excel TRUNC Function in Office 365** with its syntax, description, and examples. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)



## **TRUNC Function – Description:**

- This function **returns a truncated number of a given value**.
- It can truncate a number by removing the fractional part of a number.
- For example, **TRUNC(4.5)** returns the output as **5**.

## **Syntax:**

**=TRUNC(number, [num\_digits])**

### Argument Explanation:

**Number** – The input number that needs to be truncated.

**Num\_digits** – It is optional. The precision of the truncation. The **default value of num\_digits is 0**. If the value is given, it will print the corresponding floating value. For example, **TRUNC(9.876, 2) it will print 9.87**.

## **Examples:**

Let’s see an example to make it clear.

### Example 1:

- The following screenshot, shown the input numbers and digits in **Column A** , and **B**. The truncated output values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-80.png)<figcaption id="caption-attachment-12659">Example 1</figcaption>

### Example 2:

- If any argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-65.png)<figcaption id="caption-attachment-12660">Example 2</figcaption>

## **Closure:**

In this article, you can understand the usage of **Excel TRUNC Function in Office 365** with its syntax, description, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel EXP Function in Office 365? – [With Examples]](https://geekexcel.com/how-to-use-excel-exp-function-in-office-365-with-examples/)
- [How to Use Excel MUNIT Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-munit-function-in-office-365-with-examples/)
Async and Await Quick Guide
Tags: javascript, async, await
Published: 2020-08-26 12:21:07

Async and Await were introduced as ways to reduce headaches around nested callbacks. Async/Await is another way for you to wait for a result to return before continuing. At a basic level they are a keyword put before a function and then another keyword put before a promise that forces JavaScript to wait for that promise to return it's results.

```
async function functionName(){
  let value = await functionReturningPromise();
}

// arrow syntax
let functionName = async () => {
   let value = await functionReturningPromise();
}
```

Currently, awaits are limited in being used from inside of an async function, however there is an update coming to allow for awaits to be used at the top level of your code. This will remove the need for await to be inside of an async function.

Async/Await can also be used inside of a class by putting async on the method similar to how you would a function.

```
class ClassName{
  async methodName(){
    let value = await functionReturningPromise();
  }
}
```

On common thing people forget to do with the new syntax is to catch your errors. This is simple, simply wrap the await inside of a try..catch

```
async function functionName(){
  try{
    let value = await functionReturningPromise();
  } catch(err) {
    // handle err here
    console.log('error: ' , err);
  }
}
```

Also you can have multiple awaits inside the same function. The 2nd await will not run until the 1st await finishes.

```
async function functionName(){
  try{
    let value = await functionReturningPromise();
    let finalResult = await functionReturningPromiseTwo(value);
  } catch(err) {
    // handle err here
    console.log('error: ' , err);
  }
}
```

Async/Await is nothing to be afraid of, in fact it will simplify your code by reducing nested callbacks.
Let's talk about Streams
Tags: javascript, beginners
Published: 2020-08-26 12:06:43

This article is by no means a reference in streams concept.
It's a simple discussion between friends :-)

If I had to explain the streams to a non developper, I would simply say that, at the basic, streams concept is the port of Excel SpreadSheet concept to programming language.

In a spreadsheet when you enter in a cell [C1] : **[C1] = [A1] + [B1]**, your clearly establish a **relation** between those three cells.

In doing so, you are clearly stating : "the content of the cell [C1] is the result of the sum of the content of the cells [A] and [B]

And because you established a relation and not a simple affectation, you expect that, whenever A1 or B1 are modified C1 is modified automatically, whithout any action from you.

Thank you for reading.

To follow....
Hide your api keys from your android manifest file with Flutter using local.properties
Tags: flutter, dart, android, security
Published: 2020-08-26 12:06:03


A common problem we face is the protection of out private data such as API keys.
When working with Flutter, you may need to integrate a third party service which requires you to add your API key to your manifest file.

You wouldn't want to check-in your API keys to the source code. Instead, you would like to embed them into an internal file ignored by your source control and use  them through your app. For Android there's already a standard file that's used for this purpose called local.properties.

The AndroidManifest.xml is an xml file thus  we cannot write scripts there. Instead, we can write a small script in build.gradle file, read api key from the local.properties file and assign it to a variable. AndroidManifest will be able to read that variable.

Let's dive into the code!

Assuming we want to integrate segment, we would need to add the write key toe our AndroidManifest.xml file, instead of writing the clear API key, we would write :
```xml
<meta-data android:name="com.claimsforce.segment.WRITE_KEY" android:value="${segmentWriteKey}" />
```

And then register the API Key in the `local.properties` file under the variable named "segment.writeKey" like: 

```groovy
sdk.dir=
flutter.sdk=
flutter.buildMode=debug
flutter.versionName=1.0.0
flutter.versionCode=1
segment.writeKey=<SEGMENT API KEY GOES HERE> # We've added this line
```

`segmentWriteKey` is the name of the variable we are going to create in the module level build.gradle (android/app/build.gradle).

Add these lines before android{}  :

```groovy
Properties properties = new Properties()
properties.load(project.rootProject.file('local.properties').newDataInputStream())
def segmentWriteKey = properties.getProperty('segment.writeKey') // Notice we get the property we the exact same name we wrote in the local.properties file
```
This should look like :

```groovy
Properties properties = new Properties()
properties.load(project.rootProject.file('local.properties').newDataInputStream()) 
def segmentWriteKey = properties.getProperty('segment.writeKey')

android {
    compileSdkVersion 28
    ...
}
```

Under the android section, in the defaultConfig, add this line to the end:
```groovy
manifestPlaceholders = [segmentWriteKey: segmentWriteKey]
```

Now everything should look like: 

```groovy
Properties properties = new Properties()
properties.load(project.rootProject.file('local.properties').newDataInputStream())
def segmentWriteKey = properties.getProperty('segment.writeKey')

android {
    ...
    defaultConfig {
        ...
        manifestPlaceholders = [segmentWriteKey: segmentWriteKey]
    }
    ...
}
```

Note that the local.properties file is ignore by the source control by default so you will not have to do it yourself (but prevention is better than cure ;) ).

Well, we are done.
Hope this article helped you and see you on another one.
Thanks for reading.
Becoming a coder #002 - Mentoring my non-coder friend in his programming journey
Tags: beginners, motivation, mentoring, react
Published: 2020-08-26 12:05:53

Sam has been learning coding since December 2019, we talk every two weeks about his progress. We record our calls thinking that maybe some other beginners would find some of what we discuss useful.

https://www.youtube.com/watch?v=ub2yXllPqRY
{% youtube ub2yXllPqRY%}

This call was recorded in mid June 2020, where we discuss approaching difficult challenges efficiently, go over his second app built in React - the Coaching Question Generator, Git branching, managing React States, understanding Twitter share button and iframes, and many more. We also discuss edabit and javascript30 platforms to enhance his core JavaScript knowledge.

Hope some of you may find it useful.
My Experience with AWS Elastic Beanstalk and python
Tags: aws, python, elasticbeanstalk, elb
Published: 2020-08-26 12:01:50

I’m not from programming but wanted to start my learning with Python ! I recently purchased a Udemy course for Python for my personal learning and that had a project to build Web based portfolio. It also showed on how to host your Web portfolio using pythonanywhere.com. ( For those of you who do not what is Pythonanywhere.com, it is place to host your python application , you can actually host one application for free !!! That’s what I did on my Web portfolio ).

It was all fine and happy !!! Check the link below for Web portfolio:

http://durga533.pythonanywhere.com/

I’m avid lover of AWS and like the range of offerings it has .. So, I wanted to have my Web portfolio hosted on AWS to enhance my learning with Python and AWS. The straight option for me was to use AWS Beanstalk. This is a managed service which provides Platform as Service and you can run your code on small to medium work loads without worrying about the underlying Infrastructure.

Launching sample applications on beanstalk was very straight forward and the results are almost instantaneous ! But there are certain twists on actual code implementation. My code was getting uploading without any issue and application was showing healthy yet my end point URL was not reachable.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/11ztjvqysshyoaixoozx.png)


I got internal 505 errors, after a lot search on Web ( thanks Google and stackoverflow ) it was due to my application code.

There are two things that I did to keep this working.

First , Elastic beanstalk expects a file called “ application” on the top level of the your directory. If it does not finds one it would throw error like what I got. This is what I did. I renamed my previous server.py to application.py

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/7sau85wojq1bg0np821r.PNG)

Secondly, the story does not end here, I tried after renaming but still saw the error. I had to my variable for Flask from app to application.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/013dp16orxglb90cnrjq.PNG)


These two changes helped me to finally launch the my Website on AWS. Tadaaa !!!!!!! Happy me !!!!

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/9zkbbtlt4tr9ir4eqk4k.PNG)


My Learning and conclusion:

Not every code that we see can be implemented as-is, every platform has its own dependencies that we should satisfy to host. Launching a sample application for learning gives us confidence but launching something in real world throws lot of challenges and great learning !!!!!