A large number of formulas make an active use of the functions that are present in the worksheet. These functions will enhance the power of the formulas and makes them perform some of the …
Cell References in Formulas Most of the formulas created by the user in MS Excel 2010 include the references to the cells or ranges. These references allow the formulas to work in the dynamic …
Copying formulas is among the most common task performed by the users in the worksheet. Most of the formulas doesn’t use constant values rather the cell references and Excel is smart at copying the …
In order to create a formula in MS Excel 2010, you are simply required to the type in the formula bar. It should be noted that formula always begins with ‘=’ sign. While writing …
MS Excel is a highly popular spreadsheet application which comes bundled in the Microsoft Office software. It is widely used across the globe for managing various data in a smart and efficient manner. Microsoft …
MS Excel offers a Conditional Formatting feature that allows user to format a range of values. Simply choose Home Tab, followed by Style Group and select Conditional Formatting dropdown. Different conditional formatting options Highlight …
When a user adds rows or column headings in the worksheet, it is not visible while scrolling up and down the worksheet. MS Excel offers a smart solution for this with freezing panes. Freezing …
If you wish to see background images in your printouts, you will be at loss to know it can’t be done. The settings such Page Layout, followed by Page Setup and Background does allow …
A header is a set of information that appears at the top of each printed page while footer appears at the bottom of each print page. In MS Excel by default, the worksheet does …
Page orientation refers to how the data or output will be printed on a page. If user makes any change in the orientation, the onscreen page breaks adjusts automatically as per new page orientation. …