d

Show the popup text box on cell in Excel 2013

Show the popup text box in cell when you select the cell.


Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com


Select the cell you want to appear popup tex box.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

Goto Data tab and click the Data Validation.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

 After the select the Data Validation the drop down tab appear on screen click the Data Validation...

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

When you click the Data Validation a new dialog box show in screen. In settings tab select the Validation Criteria In Allow drop down box select the Any value.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com
 After the selecting of Any value (Don't click the OK button)
Select the second tab (Input Message) get the check in Show Input message when cell is selected.

and Type the Title of the massage and type your massage in Input Massage box and then click OK.

Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com



Show the popup text box on cell in Excel 2013
raj-excel.blogspot.com

Tips of the Day: Microsoft Excel 2013 Short Cut Keys: Alt + HAF



Microsoft Excel 2013 Short Cut Keys: Alt + H+A+F
Hit the Alt key. Then type HAF (one key at a time).


Open the drop down box for Left-to-Right Text Direction. Set the text direction

Excel 2013 Short Cut Keys: Alt + HAF
raj-excel.blogspot.com

Tips of the Day: Microsoft Excel 2013 Short Cut Keys: Alt + HAC



Microsoft Excel 2013 Short Cut Keys: Alt + H+A+C
Hit the Alt key. Then type HAC (one key at a time).

Align your content to the Center.


Excel Short Cut Keys: Alt + HAC
raj-excel.blogspot.com

Tips of the Day: Microsoft Excel Short Cut Keys: Alt + HAB


Microsoft Excel Short Cut Keys: Alt + H+A+B
Hit the Alt key. Then type HAB (one key at a time).


Align text to bottom.

Microsoft Excel Short Cut Keys: Alt + HAB
raj-excel.blogspot.com

Tips of the Day: Microsoft Excel Short Cut Keys: Alt + H+6


Microsoft Excel Short Cut Keys: Alt + H+6
Hit the Alt key. Then type H6one key at a time).


Move your content farther away from the cell border.

Activity log Tracker Excel 2013 Online Template















Description:
Track your duration and calories burned through your various activities with this log template.

Daily task list Excel 2013 Online Template












Description:

Stay organized with this template list of daily tasks. Important events, special occasions, holidays and have your own list, and every day tasks to do to stay on track. Enter a date in the yellow box to highlight the tasks for that day.


How to make text or data Italic in Excel 2013


First select your text/data you need to Italic


How to make text or data Italic in Excel 2013
raj-excel.blogspot.com


Go to Home Tab>
In the Font group click the Italic icon look like this (for example see the picture below)
Or
Keyboard short: Hit the or  

Italic Icon

How to make text or data Italic in Excel 2013
raj-excel.blogspot.com


and you will see the all the selected text convert to normal font to Italic. (for example see the picture below)






How to make text or data Italic in Excel 2013
raj-excel.blogspot.com



Value


A value can be virtually any type of data of a given type of data, such as a string, a digit, a single letter.
The numerical values ​​represent an amount of some kind: amounts of sales, number of employees, atomic weights, test results, and so on. Values ​​may also be date (as in February-26-2013) or the time (eg, 3:24 a.m.).
To Boolean or logical data, the value refers to the state of the data - whether true or false
For text data, the value refers to a word or string of entry into the spreadsheet
The value can also be used to mean a condition or parameter that must be fulfilled for certain results in a worksheet occur.

For example, to filter data, the value is the condition that the data must meet in order to remain in the data table and not filtered.

Worksheet


spreadsheet is an object in a spreadsheet program that is mainly composed of a grid of cells arranged in rows and columns, which are held spreadsheets and information.
There are three default file sheets in 2010 or earlier versions, but in 2013 only one sheet by default, but you can create many sheet if necessary.
A file stored in a spreadsheet program may consist of many worksheets.

Excel sheet view in 2003
Excel sheet view in 2003
raj-excel.blogspot.com

Excel sheet view in 2010
Excel sheet view in 2010
raj-excel.blogspot.com

Excel sheet view in 2013
Excel sheet view in 2013
raj-excel.blogspot.com

Range



A group of cells is called a range. To designate an address range specifying the address of the top left cell and address of the bottom right cell, separated by colons.

For example see the pictures below:


Range
raj-excel.blogspot.com


Range
raj-excel.blogspot.com


Range

Range
raj-excel.blogspot.com

Range
raj-excel.blogspot.com

Range
raj-excel.blogspot.com

Range
raj-excel.blogspot.com


Cell


A cell is a single item in a spreadsheet can contain a value, a text or formula. A cell is identified by its address, which is its column letter and row number. For example (see the picture below), cell E12 is the cell in the fifth column and the twelfth row. Cell name is appear in Name Box. Cell can be thought of as a box for storing data. Generally rows, representing the dependent variables, referred to in decimal notation from 1 whereas the columns represent the independent variables used 26-adic target numbering using the letters AZ as numbers.
In most implementations, many worksheets can be located within a single spreadsheet. A spreadsheet is simply a subset of the spreadsheet divided for the sake of clarity.

Cell
raj-excel.blogspot.com

Understanding Workbooks and Worksheets



The work you do in Excel is done in a workbook file. You can have as many open books as needed, and each appears in its own window. By default, Excel workbooks use a file extension. xlsx.
Each book contains one or more worksheets, and each worksheet is composed of individual cells. Each cell can contain a value, a formula, or text. A worksheet also has an invisible drainage layer, which has charts, pictures and diagrams. Each worksheet in a workbook can be accessed by clicking on the tab at the bottom of the workbook window. In addition, a book can store chart sheets, a sheet of graph shows a single card and can also be accessed by clicking on a tab.

Newcomers to Excel often feel intimidated by the different elements that appear within the Excel window. After you become familiar with the various parts, it all starts to make sense, and you will feel at home.

Formulas


The formulas are what make a spreadsheet a spreadsheet. Excel allows you to introduce flexible used values ​​(or text) in cells to calculate the result. When you enter a formula in a cell, the result of the formula appears in the cell. If you change any of the cells used by a formula, the formula recalculates and displays the new result.
Formulas can be simple mathematical expressions, or can use some powerful functions that are built into Excel. In Picture shows an Excel spreadsheet set up to calculate the monthly loan payment. The worksheet contains the values, text and formulas. The cells in column B contain text. Column C contains four values ​​and two formulas. The formulas are in cells C7 and 11. Column E, as a reference, shows the actual content of the cells in column C.

Formulas
raj-excel.blogspot.com


Function



A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.

Spreadsheet



spreadsheet is an interactive computer application program for organization and analysis of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that can contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
The user of the spreadsheet can make changes in any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without tedious manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.
In addition to the fundamental operations of arithmetic and mathematical functions, modern spreadsheets provide built-in functions for common financial and statistical operations. Such calculations as net present value or standard deviation can be applied to tabular data with a pre-programmed function in a formula. Spreadsheet programs also provide conditional expressions, functions to convert between text and numbers, and functions that operate on strings of text.
Spreadsheets have now replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared.
Visicalc was the first electronic spreadsheet on a microcomputer, and it helped turn the Apple II computer into a popular and widely used system. Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Excel now has the largest market share on the Windows and Macintosh platforms. A spreadsheet program is a standard feature of an office productivity suite; since the advent of web apps, office suites now also exist in web app form.



How to make text or data Bold in Excel 2013




 First select your text/data you need to bold

How to make text or data Bold in Excel 2013
raj-excel.blogspot.com




Go to Home Tab>
In the Font group click the Bold icon look like this (for example see the picture below)

Or
Keyboard short: Hit the or  

How to make text or data Bold in Excel 2013
raj-excel.blogspot.com


and you will see the all the selected text convert to normal font to bold. (for example see the picture below)

How to make text or data Bold in Excel 2013
raj-excel.blogspot.com


Italic


Italic Justification:

In typography, italic type is a cursive typeface based on a stylized form of calligraphic handwriting. Owing to the influence from calligraphy, such typefaces often slant slightly to the right. Different glyph shapes from roman type are also usually used—another influence from calligraphy. True italics are therefore distinct from oblique type, in which the font is merely distorted into a slanted orientation. However, uppercase letters are often oblique type or swash capitals rather than true italics.
This style is called "italic" for historical reasons. Calligraphic typefaces started to be designed in Italy, for chancery purposes. Ludovico Arrighi and Aldus Manutius (both between the 15th and 16th centuries) were the main type designers involved in this process at the time.

"Italics are the print equivalent of underlining" and typewriter users underlined words that would normally appear as italics in professionally printed works. source

Number




A number is a mathematical object used to count, label, and measure. In mathematics, the definition of number has been extended over the years to include such numbers as 0, negative numbers, rational numbers, irrational numbers, and complex numbers.
Mathematical operations are certain procedures that take one or more numbers as input and produce a number as output. Unary operations take a single input number and produce a single output number. For example, the successor operation adds 1 to an integer, thus the successor of 4 is 5. Binary operations take two input numbers and produce a single output number. Examples of binary operations include addition, subtraction, multiplication, division, and exponentiation. The study of numerical operations is called arithmetic.
A notational symbol that represents a number is called a numeral. In addition to their use in counting and measuring, numerals are often used for labels (telephone numbers), for ordering (serial numbers), and for codes (e.g., ISBNs).

In common usage, the word number can mean the abstract object, the symbol, or the word for the number. Source

Data


For data in computer science, see Data (computing). For other uses, see Data (disambiguation).
Data (/ˈdeɪtə/ day-tə, /ˈdætə/ da-tə, or /ˈdɑːtə/ dah-tə) are values of qualitative or quantitative variables, belonging to a set of items. Data in computing (or data processing) are represented in a structure, often tabular (represented by rows and columns), a tree (a set of nodes with parent-children relationship) or a graph structure (a set of interconnected nodes). Data are typically the results of measurements and can be visualised using graphs or images. Data as an abstract concept can be viewed as the lowest level of abstraction from which information and then knowledge are derived. Raw data, i.e., unprocessed data, refers to a collection of numbers, characters and is a relative term; data processing commonly occurs by stages, and the "processed data" from one stage may be considered the "raw data" of the next. Field data refers to raw data collected in an uncontrolled in situ environment. Experimental data refers to data generated within the context of a scientific investigation by observation and recording.
The word data is the plural of datum, neuter past participle of the Latin dare, "to give", hence "something given". In discussions of problems in geometry, mathematics, engineering, and so on, the terms givens and data are used interchangeably. Such usage is the origin of data as a concept in computer science or data processing: data are numbers, words, images, etc., accepted as they stand.
Though data is also increasingly used in humanities (particularly in the growing digital humanities), it has been suggested that the highly interpretive nature of humanities might be at odds with the ethos of data as "given". Peter Checkland introduced the term capta (from the Latin capere, “to take”) to distinguish between an immense number of possible data and a sub-set of them, to which attention is oriented.[1] Johanna Drucker has argued that since the humanities affirm knowledge production as “situated, partial, and constitutive,” using data may introduce assumptions that are counterproductive, for example that phenomena are discreet or are observer-independent.[2] The term capta, which emphasizes the act of observation as constitutive, is offered as an alternative todata for visual representations in the humanities.


Font


"Fount" redirects here. For the original meaning, see fountain.
This article is about the traditional meaning of "font". For the electronic data file, see Computer font. For other uses, see Font (disambiguation).
Font nowadays is frequently used synonymously with the term "typeface", although before the advent of digital typography and desktop publishing, "font" referred to a single size and "typeface" referred to a set of otherwise identical fonts of different sizes.
Beginning in the 1980s, with the introduction of computer fonts, a broader definition for the term "font" evolved. Different sizes of a single style separate fonts in metal type are now generated from a single computer font, because vector shapes can be scaled freely. "Bulmer", the typeface, may include the fonts "Bulmer roman", "Bulmer italic", "Bulmer bold" and "Bulmer extended", but there is no separate font for "9-point Bulmer italic" as opposed to "10-point Bulmer italic". source

Text



In literary theory, a text is any object that can be "read," whether this object is a work of literature, a street sign, an arrangement of buildings on a city block, or styles of clothing. It is a coherent set of signs that transmits some kind of informative message. This set of symbols is considered in terms of the informative message's content, rather than in terms of its physical form or the medium in which it is represented.
Within the field of literary criticism, "text" also refers to the original information content of a particular piece of writing; that is, the "text" of a work is that primal symbolic arrangement of letters as originally composed, apart from later alterations, deterioration, commentary, translations, paratext, etc. Therefore, when literary criticism is concerned with the determination of a "text," it is concerned with the distinguishing of the original information content from whatever has been added to or subtracted from that content as it appears in a given textual document (that is, a physical representation of text).
Since the history of writing predates the concept of the "text", most texts were not written with this concept in mind. Most written works fall within a narrow range of the types described by text theory. The concept of "text" becomes relevant if/when a "coherent written message is completed and needs to be referred to independently of the circumstances in which it was created."



Bold



Bold Justification:

The human eye is very receptive to differences in brightness within a body of text. Therefore, you can differentiate between types of emphasis depending on whether the emphasis changes the "darkness" of text.

By contrast, the weight makes text bold darker than the surrounding text. With this technique, the highlighted text is strongly out from the rest, so it should be used to highlight certain keywords that are relevant to the topic of the text for easy visual scanning text. For example, printed dictionaries often use boldface for their keywords, and the names of the inputs can be conventionally marked in bold.


Why use;
The most common methods in Western typography fall under the general technique of care through a change or modification of the font:

for see the example how to apply click here

Recommended for You

LinkWithin

Related Posts Plugin for WordPress, Blogger...