Virtual Institute

Learning To Be

Excel – Filter

Bagaimana caranya jika anda ingin menampilkan data penerbangan yang tarip nya berkisar antara 200.000 sampai dengan 300.000 ?

A. Dari menu bar pilih Filter -> Auto Filter -> Custom -> is Less than 2000000 and greater than 3000000

B. Dari menu bar pilih Filter -> Auto Filter -> Custom -> is Greater than 200000 and less than 300000

C. Dari menu bar pilih Filter -> Auto Filter -> Custom -> is greater than 200000 or less than 300000

D. Dari menu bar pilih Filter -> Auto Filter -> Custom -> Begins with 200000 and Ends with 300000

E. Dari menu bar pilih Filter -> Auto Filter -> Custom -> is less than 200000 or greater than 300000

Filed under: Ms. Excel , , ,