Cach tinh hang cot cua bang trong Word 2013

Thứ ba, 25 Tháng sáu 2013, 10:03 GMT+7

Neu dang lam viec trong Word va can tinh tong gia tri trong mot bang, ban co the lam nhu vay ma khong can nhap du lieu vao Excel, sau do sao chep va dan tro lai Word. Word co the lam cac phep tinh don gian nhu cong, nhan, tinh trung binh.

Neu dang lam viec trong Word va can tinh tong gia tri trong mot bang, ban co the lam nhu vay ma khong can nhap du lieu vao Excel, sau do sao chep va dan tro lai Word. Word co the lam cac phep tinh don gian nhu cong, nhan, tinh trung binh.

Cach tinh hang cot cua bang trong Word 2013
Chu y: Khi ban them hang hoac cot gia tri moi vao bang trong Word, cac cong thuc se khong tu dong cap nhat. De cap nhat cong thuc, hay nhap chuot phai vao cong thuc va tu menu hien ra > chon Update Field.
De nhap cong thuc vao mot o trong bang, dat con tro vao o va nhap tab Layout duoi Table Tools.

Cach tinh hang cot cua bang trong Word 2013
Nhap vao Formula trong phan Data cua tab Layout.

Cach tinh hang cot cua bang trong Word 2013
Trong vi du sau, chung ta se nhan cot Units voi Unit Cost, sau do dua ket qua vao Total. De lam dieu nay, chung ta nhap =PRODUCT(LEFT) vao hop text-box duoi nhan Formula trong hop thoai Formula de nhan hai so ben trai cua o hien hanh.
Hay chon mot tuy chon cho Number format (dinh dang so) tu danh sach tha xuong de xac dinh dinh dang cho ket qua cua cong thuc.
Chu y: De biet them thong tin ve cac cong thuc co san va lam the nao de su dung chung, hay truy cap website Office cua Microsoft.

Cach tinh hang cot cua bang trong Word 2013
Nhan OK de chap nhan cac thiet lap va chen cong thuc vao trong o.

Cach tinh hang cot cua bang trong Word 2013
Ket qua cua cong thuc hien thi trong o.
Chu y: Neu ban nhap chuot phai vao o chua cong thuc va chon Toggle Field Codes tu menu pop-up, cong thuc thuc su se hien thi trong o (nhu trong hinh minh hoa dau tien o dau bai viet nay). Nhap chuot phai va chon Toggle Field Codes mot lan nua de hien thi ket qua.

Cach tinh hang cot cua bang trong Word 2013
Hay lap lai viec nhan cot Units voi Unit Cost, sau do dua ket qua vao Total trong moi hang khac.

Cach tinh hang cot cua bang trong Word 2013
Bay gio, hay chac chan rang o duoi cung cua bang da co them mot hang de chung ta co the tinh tong chi phi. Dat con tro vao o trong o duoi cung cua cot Total. Nhap vao Formula trong phan Data cua tab Layout mot lan nua de truy cap vao hop thoai Formula. Nhap cong thuc =SUM(ABOVE) vao hop text-box duoi nhan Formula.
Hay chon mot tuy chon cho Number format > nhan OK.

Cach tinh hang cot cua bang trong Word 2013
Tong cua cot Total se hien thi trong o.

Cach tinh hang cot cua bang trong Word 2013

Vietbao.vn (Theo XHTT)

http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/images/vn888/hot/v2012/2131540748-8-599theodongtintuc.png
5 ung dung Android giup pin smartphone tho lau hon My ap toi gian diep cho Edward Snowden SourceForge bi loi dung de phat tan ma doc
5 ung dung Android giup pin smartphone tho lau hon My ap toi gian diep cho Edward Snowden SourceForge bi loi dung de phat tan ma doc
http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/http://a8.vietbao.vn/images/vn888/hot/v2012/2131540748-12-938dangchuy.png
15 tien ich khong can thiet phai cai dat trong Windows 8 Pico ke toi Webtretho chua chap thong tin vo can cu Instagram dat 5 trieu video tai len trong 24 gio dau tien
15 tien ich khong can thiet phai cai dat trong Windows 8 Pico "ke toi" Webtretho chua chap thong tin vo can cu Instagram dat 5 trieu video tai len trong 24 gio dau tien

Cac bai viet khac:

Tiep theo >>


^ Lên đầu trang ^


Copyright © 2006-2012 by VietBao.vn
Viet Bao Viet Nam - All Rights Reserved.