It is a customizable toolbar placed beside the quick access button and on top of the home tab. once you click the down arrow at the end of quick access toolbar it displays a lot of commands. You’ll be able to add any of those commands to quick access toolbar by a left click on … Read more

The office button is found within the upper-left corner of excel. When the office button is clicked, several of constant choices you’d see within the File menu, like New, Open, Save, Print, etc., is found. Listed below are the usually used choices found within the office button menu and their operate. New: to make a … Read more

There are various choices to move across the spreadsheet using mouse and keyboard. You can scroll the worksheet up or down by moving mouse wheel or using vertical scroll bar. In a alike way, you can use horizontal scroll bar to move the worksheet horizontally in the direction of left or right side.  

Select the data you desire to move, right click on it then choose the cut option then select the cell where you want to shift the data. Right click on the particular cell and select paste option. Cell Data will be moved to the desired location.  

In Microsoft Excel the mini toolbar is a minor version of the full toolbar found near the topmost of the application window. The mini toolbar seems when you right click a cell or additional objects like a shape or chart. It shows frequently used structuring commands like Bold, Italics, Font Size, Alignment, Font Type and … Read more

Select the cell where you want the symbol. Then click on the Insert tab and choose Symbol command, on the right end of the ribbon. It will show a number of symbols, pick the desired symbol and click on Insert button then close the box. Symbol will be added to the preferred cell. Special characters … Read more

Always type the values and text in distinct cells otherwise the formula will not work. See the example given below image: In case you want to add currency sign to values then use mini toolbar as shown in the image given below. Choose the series of cells then right click. Mini toolbar seems above the … Read more

There are several tabs present in Microsoft Excel: Home, Insert, Page Layout, Formula, Data, Review and think about. Each and every tab has totally different functions. The features of the Home tab are: The excel Home Tab is used to execute regular instructions like bold, underline, copy, and paste. It’s additionally used to apply formats … Read more

The SUMIF function is used to sum up the data of some precise cells of a column; the cells which fulfilled certain conditions. The syntax of SUMIF function is: =SUMIF(range,criteria, [sum_range]) So, the SUMIF function has three key parts: Range: It mentions to choice of cells that you need to calculate to choose the cells … Read more

Relative referencing tells that you don’t need to type the formula distinctly for every calculation in a column or a row. See the picture: Enter the formula in the first cell F5 and pressing Enter key to get the result, then use the fill handle. The formula will apply automatically in the respective cells and … Read more