In this module, we will look at formatting cells in Excel in the following ways that allows one to decide how a sheet looks like Row Height Column Width Hiding/Unhiding Columns Hiding/Unhiding Rows Hiding/Unhiding Sheet Where to Find the ‘Format’ option? Click on the ‘Home’ menu and then you can find the ‘Format’ option in …
The fill command in Microsoft Excel helps you to fill data from an adjacent cell into the cell you want it to be in. This option has the following choices Up Down Right Left Series Justify Flash fill Where to Find the Fill Command? The ‘Fill’ command is present in the ‘Editing’ group in the …
Fill Command in Microsoft Excel- Up, Down, Right, Left, Justify, Series, Flash fill Read More »
Using Comments in MS Excel worksheet helps a user, who is not the one who created the sheet, in understanding the content by adding notes. This makes it easier to know what each cell is about and the user can add other relevant pieces of information as well. You can Adding a Comment Resizing a …
Using Comments in MS Excel – Adding, Deleting, Reshaping, Resizing and Formatting Read More »
Defining and managing names in Excel can make ur lives easier. One can use names to refer to a range of cells to make it more convenient for navigation and efficient. In this module we will learn about How to Define a Name for a Range of Cells How to Define a Name by Using …
Control Structure In Python – To process the inputs as per user’s requirement, there are some conditional statements available in Python like other languages. They are: if, else and elif block for loop while loop Boolean logic Operator precedence We will discuss the above points one by one. if, else and elif block These are one of …
else and elif Block – Control Structure In Python Read More »