How to use Excel’s PICTURE function

If you have not installed the office package yet, install it and try it, it is very fast and easy to use. The Excel program is one of the tools most used by different companies and their workers.

It has different functions to use in different fields of work , for example accountants, engineers and businessmen, an easy way to keep your accounts in spreadsheets in an orderly way.

One of the Excel functions in the field of engineering is the calculation of IM.ANGLE , which returns the argument q, an angle in radians, taking into account the Innumber, which is the complex number whose argument you want to calculate.

To give your spreadsheet an attractive appearance, use the formatting possibilities that Excel offers you. You can modify the font size, borders, background, number format and many other attributes.

How to use Excel’s PICTURE function easily

Select your favorite cell where the desired result will be thrown, click on the box (fx), which is located in the menu or standard toolbar , the command to insert function will immediately appear on your screen. In the box to select the category you will look for the engineering option.

It is important to note that all the functions are arranged alphabetically to facilitate the search. In the option to select a function you will point to the IM.ANGLE function , this function returns the argument q, an angle expressed in radians.

Next, we press the accept button and a box will appear in the second function assistant window. In this window, you must enter the parameters of the function. Both these parameters and the cell references must be clear and precise so as not to throw any errors.

When you enter the values ​​to be calculated, you will press the accept button and the result will be obtained in the box previously selected. To finish the procedure, press the accept button and the calculated result will be immediately thrown in the chosen cell, = IM.ANGLE ().

How to correct errors when using the functions

It is common that errors are commented on in the information digitization processes. There are several ways to correct them as the case may be; here you will see some of them. For example, for the wrongly entered number, the cell where the error is found must be activated, type the correct value and press Enter.

Another way to edit the content of a cell is by selecting it and pressing the F2 key . In the case of deleting the information from a cell, you must activate the cell where the data to be deleted is located, then press the Del key to delete it.

To replace data in a string of characters , just click on the box that contains the information and select the data and then type the new ones. With the edit menu you can also correct some errors using the undo and redo options.

How to select ranges for the cells where you will get the value of the function

Normally when selecting a set of cells, the mouse pointer is dragged from the upper left cell to the lower right cell, which will make up the range; the selected region will appear in dark color, but it can also be marked by pressing the Shift key and moving with the keyboard arrows.

In the contiguous cell selection, position the cursor in the starting cell of the range, hold down the left mouse button and drag it to the end cell of the range . Whereas for the selection of non-contiguous cells. The pointer must be positioned in the first cell of the range.

Hold down the Ctrl key and click on the cell of your choice; without releasing the Ctrl key click another cell. It is important to know that it is a range, which is a selection of contiguous cells or not; it can be a whole row, column and whole sheet.

To select a complete column click on the column header; while to select a complete row click on the row header. If you want to select the entire sheet, click the select all button, located in the upper left corner of the sheet.

 

by Abdullah Sam
I’m a teacher, researcher and writer. I write about study subjects to improve the learning of college and university students. I write top Quality study notes Mostly, Tech, Games, Education, And Solutions/Tips and Tricks. I am a person who helps students to acquire knowledge, competence or virtue.

Leave a Comment