The default Number format is General.
Why change number formats?
Examples of number formats:
Number formats can be changed by clicking the Number format dropdown, accessed in the Ribbon, found in the Numbers group.
You can format fonts in four different ways: color, font name, size and other characteristics.
The default color for fonts is black.
Colors are applied to fonts by using the "Font color" function.
How to apply colors to fonts
Excel has a set of themes and standard colors available for use. You select a color by clicking it:
The "More Colors" option allows you to select custom colors by entering a RGB or HEX code.
The format painter is a command which lets you copy formatting from one cell to another.
It is a great tool, which saves you lots of time!
The Format painter can be used to copy to single cells or ranges.
Format Painter is used by clicking on its button in the Ribbon, found in the Clipboard group.
Let's try some examples and copy formats with Colors and font Characteristics, such as bold, italic and underline:
Copy the red color from A1 to B1.
Step by step:
A1B1
Notice the dotted border around A1. This indicates that the format is copied and ready for pasting. Let's paste it to B1!
Great job!
Copy B2 to C2. That is right, let's try to paste to a range of two cells!
A2B2 and hold an drag to C2
That's the way! The format painter can be used for single cells and on ranges.
Last example. Copy the Font Characteristics from A4:A6 to B4:B6.
Step by step:
A4:A6B4:B6
Excel has many ways to format and style a spreadsheet.
Why format and style your spreadsheet?
Styling is about changing the looks of cells, such as changing colors, font, font sizes, borders, number formats, and so on.
The most used styling functions are:
Cells are selected by clicking them with the left mouse button or by navigating to them with the keyboard arrows.
It is easiest to use the mouse to select cells.
To select cell A1, click on it:
Language is a method of communication with the help of which we can speak, read and write. For example, we think, we make decisions, plans and more in natural language; precisely, in words. However, the big question that confronts us in this AI era is that can we communicate in a similar manner with computers. In other words, can human beings communicate with computers in their natural language? It is a challenge for us to develop NLP applications because computers need structured data, but human speech is unstructured and often ambiguous in nature.
In this sense, we can say that Natural Language Processing (NLP) is the sub-field of Computer Science especially Artificial Intelligence (AI) that is concerned about enabling computers to understand and process human language. Technically, the main task of NLP would be to program computers for analyzing and processing huge amount of natural language data.
In this chapter, we will learn about the linguistic resources in Natural Language Processing.
A corpus is a large and structured set of machine-readable texts that have been produced in a natural communicative setting. Its plural is corpora. They can be derived in different ways like text that was originally electronic, transcripts of spoken language and optical character recognition, etc.