1. Sử dụng công thức để tính toán

– Các phép toán cơ bản được sử dụng trong trang tính là:

  • +: Kí hiệu phép cộng
  • -: Kí hiệu phép trừ
  • /: Kí hiệu phép chia
  • *: Kí hiệu phép nhân
  • ^: Kí hiệu phép lấy luỹ thừa
  • %: Kí hiệu phép lấy phần trăm

– Thứ tự thực hiện phép toán giống như trong toán học

2. Nhập công thức

– Dấu = là dấu đầu tiên cần gõ khi nhập công thức vào một ô

– Các bước thực hiện lần lược là:

  1. Chọn ô cần nhập công thức
  2. Gõ dấu =
  3. Nhập công thức hay địa chỉ ô
  4. Nhấn Enter

3. Sử dụng địa chỉ trong công thức

– Trong các công thức tính toán với dữ liệu có trong các ô, dữ liệu đó thường được cho thông qua địa chỉ của các ô 9hoặc hàng, cột hay khối)

– Nội dung của ô kết quả sẽ được tự động cập nhật mỗi khi nội dung trong các ô dữ liệu thay đổi.


  1. Amazing! This blog looks exactly like my old one! It’s
    on a totally different subject but it has pretty much the same layout and design.
    Great choice of colors!

  2. Aw, this was a really nice post. Finding the time and actual effort to create a top notch article… but what can I say… I
    hesitate a whole lot and never manage to get nearly anything done.

  3. Terrific work! That is the type of info that are supposed to be shared across the net.

    Shame on Google for not positioning this put up higher!
    Come on over and seek advice from my website .
    Thanks =)

  4. I would like to express my passion for your kind-heartedness
    in support oof those people who should have assistance with that question. Your
    personal commitment to passing the message all through ended up being extraordinarily important and have regularly allowed associates like me to attain their endeavors.

    This helpful help and advice means this much a person like mee and far more to my peers.
    Many thanks; from all of us.

  5. Outstanding post however , I was wanting to know if you could write a
    litte more on this subject? I’d be very thankful if you could elaborate a little bit more.
    Appreciate it!

  6. Thx for your post. I’d like to say that the cost of car insurance will vary
    from one insurance plan to another, due to tthe fact there are so many
    different facets which bring about the overall cost. As an example,
    the model and make of the car or truck will have a tremendous bearing on tthe price.
    A reliable old family automobile wilol have a lower priced premium thzn the usual flashy performance car.

  7. Normally I do not learn article on blogs, but I wish to say that this write-up very compelled me to try and
    do it! Your writing style has been amazed me.
    Thanks, very great post.

  8. I’m truly enjoying the design and layout of your website. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and
    visit more often. Did you hire out a developer to create your theme?
    Great work!

  9. Just desire to say your article is as surprising. The clarity in your post is simply
    excellent and that i can suppose you’re an expert
    in this subject. Well together with your permission let me to seize your feed to keep updated with coming near near post.
    Thank you 1,000,000 and please keep up the gratifying work.

  10. We’re a group of volunteers and opening a new scheme in our community.
    Your web site provided us with valuable info
    to work on. You have done a formidable job
    and our whole community will be thankful to you.

  11. I’m no longer sure where you’re getting your info, butt good topic.
    I needs to spend a while studying much more or understanding more.
    Thank you for fantastic info I was in search of this info for
    my mission.


Please enter your comment!
Please enter your name here