開始使用免費開始

How the 104% live

Sometimes numbers are more easily comprehended as a percentage. To convert a number to a percent, you call TO_PERCENT() passing a cell address.

This exercise requires the use of absolute cell addresses that don't change when you copy a formula. Recall that you can write an absolute address by prefixing it with dollar signs. For example, $Z$100 is the absolute equivalent of Z100.

本練習屬於課程

Google Sheets 中級

檢視課程

練習說明

  • In H2, calculate the time for this record (A2) divided by the fastest time (A20); the latter written in absolute form.
  • Copy the formula down to row 20.
  • In column I, convert the ratios to percentages using TO_PERCENT().

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習