Curious about mechanical keyboards but put off by the loud noise that makes them impractical in a quiet office or bedroom? Let me walk you through various keyboard options so that you can enjoy the benefits without the disruptive click-clack.

Excel's AVERAGEIF and AVERAGEIF functions let you find the average of a set of data. However, where they differ from the more straightforward AVERAGE function is in their ability to include or discount certain values within the calculation.