Posts

Showing posts from April, 2021

Use conditional formatting rules in Google Sheets

Image
  Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. On your computer, open a spreadsheet in  Google Sheets . Select the cells you want to apply format rules to. Click  Format     Conditional formatting . A toolbar will open to the right. Create a rule. Single color : Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. Color scale : Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow  . Click  Done . Example A teacher can highlight test scores to see which students scored less than 80%. On your computer, open a spreadsheet in  Google Sheets . Select the test scores. Click  Format     Conditional...

How to disable notification in google chrome browser in PC?

Image
 How to disable notification in google chrome browser in PC? Go to Google chrome > then click 3 doth on the right hand side upper corner   which is customize and control google chrome > then Click settings > then type in the search settings "site settings" after that you can see that option   then click on the site settings >   then scroll down and see the Notifications option then click on the Notifications option > then click on the Sites can ask to send notifications > after that notifications disable has been success. I hope this information is helpful for you.

How To Highlight Maximum And Minimum Value In Excel

Image
  How To Highlight Maximum And Minimum Value In Excel   Highlight Maximum Value Think this that you have a list of data in range A1:F7, and you want to highlight   maximum values in Gross column. You need to use the conditional formatting for highlight maximum value. Just do the following steps_   1-   Select the range of cells that you want to highlight the maximum values in data,   2-  Go to  Home  tab, then click  Conditional Formatting under  Styles  group, then click  New Rule  from the drop down list,   3-  Select  Use a formula to determine which cells to format , then type the formula in the  Format values where this formula is true  text box, then click  Format  button, =F2=MAX($F$2:$F$7) 4-  Then click  Fill  tab, select background color as you need then click  Ok  button, 5-   Click ok maximum value has been...

What is MS Excel?

  What is Microsoft Excel? Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a cell. Each cell contains one point of data or one piece of information. By organizing the information in this way, you can make information easier to find, and automatically draw information from changing data. Features.. Microsoft Excel has the basic features of all spreadsheets, using a grid of  cells  arranged in numbered  rows  and letter-named  columns  to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors ...

FULL FORM

WHAT IS THE  POLICE FULL FORM ? POLICE KA FULL FORM KYA HAI? PROTECT OF LIFE IN CIVIL ESTABLISHMENT https://youtu.be/cfgt5XE_Tqs WHAT IS THE FULL FORM OF MBBS? MBBS KA FULL FORM KYA HAI? BACHELOR OF MEDICINE & BACHELOR OF SURJERY WHAT IS THE FULL FORM OF NDA? NDA KA FULL FORM KYA HAI? NATIONAL DEFENCE OF ACADMY WHAT IS THE FULL FORM OF ATM? ATM KA FULL FORM KYA HAI? ANY TIME MONEY AUTOMATIC TELLOR MACHINE https://youtu.be/m2T9Mpu3hss WHAT IS THE FULL FORM OF AM & PM? AM & PM KA FULL FORM KYA HOTA HAI? ANTI MERIDIEM & POST MERIDIEM WHAT IS THE FULL FORM OF HR? HUMAN RESOURCE

Shring to fitt in excel

 How to shring to fit in excel? Shring to fit in excel https://youtu.be/Qcv4vTIHzb0 https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal https://amzn.to/2Q2ssFb

Full form of police

Image
 What is the full form of police? Police ka full form kya hota hai? Protect of Life In Civil Establishment https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal

How to hide data in excel (hide trick)

Image
How to hide data in excel (hide trick).  Excel me cell ka data kaise chup. https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal https://youtu.be/zE-371wdQd8

How to insert currency symbol in excel ; Excel me rupee ka chinh kaise l...

Image
How to insert currency symbol in excel ;  Excel me rupee ka chinh kaise l... select the range then go to home tab > number drop down list> select currency. https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal https://youtu.be/2rL0QFrrJOc

Conditional Formatting in Excel

Image
 How to apply conditional formatting? https://youtu.be/PDADoKr5OHg Select the Criteria where you can apply conditional formatting> Go to home tab> then select conditional formatting. How to highlight grater than ( ) less than ( ) equals to ( ) How to apply conditional formatting? https://youtu.be/PDADoKr5OHg https://www.facebook.com/Full-Harkat-114089750775194/videos/?ref=page_internal

DATA FILTER IN EXCEL

Image
Filtering data F ilters  can be applied in different ways to improve the performance of your worksheet. You can filter text, dates, and numbers. You can even use more than one filter to further narrow your results. 1- Begin with a worksheet that identifies each column using a header row. 2- Select the  Data  tab, then locate the  Sort & Filter  group. 3- Click the  Filter  command. 4- Drop-down arrows will appear in the header of each column. 5- Click the  drop-down arrow  for the column you want to filter. In this example, we'll filter the Type column to view only certain types of equipment. 6- The  Filter  menu appears. 7- Uncheck  the boxes next to the data you don't want to view, or uncheck the box next to  Select All  to quickly uncheck all. 8- Check  the boxes next to the data you do want to view. In this example, we'll check Laptop and Projector to view only these types of equipment. 9- Click  OK ...