什麼是絕對細胞參考(ACR)?

這是一個推薦產品對話框
熱門建議
起價
查看全部 >
語言
French
English
ไทย
German
繁體中文
國家/地區
All
登入/建立帳戶
language Selector,${0} is Selected
註冊並於Lenovo Pro 商務採購商店購物
於Lenovo教育商店註冊

專業等級福利

• 在 Think 每日價格上節省高達額外 3%
• 消費滿HK$78,000,晉升至 Plus 等級,享有更多福利

Plus 等級福利

• 在 Think 每日價格上節省高達額外 5%
• 消費滿HK$120,000,免費升級至擁有更多福利的菁英等級
等菁英級福利
• 在Think日常價格上節省高達額外8%
經銷商福利
• 可獲得Lenovo全系列產品的使用權
• 配置和購買價格優於Lenovo.com
查看所有詳情 >
再多達到
PRO Plus
PRO 菁英
恭喜,您已達到菁英地位!
Pro for Business
Delete icon Remove icon Add icon Reload icon
即將上市
已停產
暫時無法使用
Cooming Soon!
. Additional units will be charged at the non-eCoupon price. Purchase additional now
We're sorry, the maximum quantity you are able to buy at this amazing eCoupon price is
登入或建立帳戶以儲存您的購物車!
登錄或創建帳戶以加入獎勵計劃
檢視購物車
Wow, your cart is empty!
移除
item(s) in cart
Fill it in with great deals
Some items in your cart are no longer available. Please visit cart for more details.
has been deleted
Please review your cart as items have changed.
/
Contains Add-ons
繼續進行結帳
是的
Popular Searches
今天您想找什麼?
Trending
Recent Searches
Hamburger Menu
{"arrowColor":"#ffffff","backgroundColor":"#285d50","divideColor":"","sideMsg":"","data":[{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Pageb7f2e1ff-3557-49a5-94a2-7c82c8dee25b","language":{"zh_hk":"%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3ELenovo%20Pro%20%E4%BC%81%E6%A5%AD%E5%B0%88%E4%BA%AB%E9%AB%98%E9%81%94%208%20%E6%8A%98%E8%B3%BC%E7%89%A9%E5%84%AA%E6%83%A0%3C%2Fstrong%3E%26nbsp%3B%7C%20%E7%99%BB%E8%A8%98%E5%8D%B3%E7%8D%B2%E9%AB%98%E9%81%94%246%2C000%E8%BF%8E%E6%96%B0%E6%8A%98%E6%89%A3%20%2B%20%E5%85%8D%E8%B2%BB%E7%A6%AE%E7%89%A9%EF%BC%81%3C%2Fspan%3E%3C%2Fp%3E%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%E8%87%B4%E9%9B%BB%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3E2593%200388%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%26nbsp%3B%E8%A7%A3%E9%8E%96%E5%84%AA%E6%83%A0%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fbusiness%2Fbenefits%2F%3FipromoID%3Dhellobar_01_lpro_learn%22%20target%3D%22_blank%22%20textvalue%3D%22%E7%9E%AD%E8%A7%A3%E6%9B%B4%E5%A4%9A%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3E%E7%9E%AD%E8%A7%A3%E6%9B%B4%E5%A4%9A%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%3Cbr%2F%3E%3C%2Fp%3E","en":"","en_hk":"%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cstrong%3ELenovo%20Pro%20Business%20Offer%2020%25%20OFF%3C%2Fstrong%3E%26nbsp%3B%7C%20Join%20us%20to%20get%20up%20to%20%246%2C000%20Welcome%20Discount%20%2B%20Free%20Gift!%26nbsp%3B%3C%2Fspan%3E%3C%2Fp%3E%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3ECall%202593%200388%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3Cspan%20style%3D%22font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cstrong%3E%3Cspan%20style%3D%22font-family%3A%20Montserrat%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2Fspan%3E%3C%2Fstrong%3E%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fbusiness%2Fbenefits%2F%3FipromoID%3Dhellobar_01_lpro_learn%22%20target%3D%22_blank%22%20textvalue%3D%22Learn%20More%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3ELearn%20More%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%3Cbr%2F%3E%3C%2Fp%3E","zh":""},"id":"Pageb7f2e1ff-3557-49a5-94a2-7c82c8dee25b"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Pagecfa8504b-eb77-4339-9085-bcf23eb1a764","language":{"zh_hk":"%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3ELenovo%20%E6%95%99%E8%82%B2%E5%84%AA%E6%83%A02023%26nbsp%3B%7C%20%E5%AD%B8%E7%94%9F%E5%8F%8A%E6%95%99%E8%81%B7%E5%93%A1%E5%8F%AF%E4%BA%AB%E4%BD%8E%E8%87%B36%E6%8A%98%E5%84%AA%E6%83%A0%2C%20%E4%BD%BF%E7%94%A8%20SheerID%E5%BF%AB%E9%80%9F%E8%AA%8D%E8%A8%BC%26nbsp%3B%3C%2Fspan%3E%3C%2Fp%3E%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%E8%87%B4%E9%9B%BB%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3E2593%200388%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%26nbsp%3B%E8%A7%A3%E9%8E%96%E5%84%AA%E6%83%A0%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fd%2Fschool-from-home%2F%3FipromoID%3Dhellobar_02_edu%22%20target%3D%22_blank%22%20textvalue%3D%22%E7%AB%8B%E5%8D%B3%E8%B3%BC%E8%B2%B7%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3E%E7%AB%8B%E5%8D%B3%E8%B3%BC%E8%B2%B7%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%3Cbr%2F%3E%3C%2Fp%3E","en":"","en_hk":"%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20Montserrat%3B%22%3E%3Cstrong%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3C%2Fspan%3EBack%20to%20School%3C%2Fstrong%3E%26nbsp%3B%7C%20Join%20Lenovo%20Education%20to%20enjoy%20up%20to%2040%25%20Discount%20for%20students%20%26amp%3B%20teachers.%20SheerID%20is%20applicable.%3C%2Fspan%3E%3C%2Fp%3E%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%20font-family%3A%20Montserrat%3B%22%3E%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cstrong%3ECall%202593%200388%3C%2Fstrong%3E%3C%2Fa%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fd%2Fschool-from-home%2F%3FipromoID%3Dhellobar_02_edu%22%20target%3D%22_self%22%20textvalue%3D%22Shop%20now%22%20style%3D%22text-decoration%3A%20underline%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20Montserrat%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20Montserrat%3B%22%3E%3Cstrong%3EShop%20now%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E","zh":""},"id":"Pagecfa8504b-eb77-4339-9085-bcf23eb1a764"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Pagef53f1aa2-3b1d-4357-a57e-850230463f26","language":{"zh_hk":"%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3EPC%E4%BD%8E%E8%87%B37%E6%8A%98%3C%2Fstrong%3E%26nbsp%3B%7C%20%E7%B2%BE%E9%81%B8%E5%9E%8B%E8%99%9F%E7%8F%BE%E8%B2%A8%E7%99%BC%E5%94%AE%2C%20%E6%9C%80%E5%BF%AB3%E6%97%A5%E9%80%81%E8%B2%A8%EF%BC%81%E6%89%80%E6%9C%89%E8%A8%82%E5%96%AE%E5%9D%87%E4%BA%AB%E5%85%8D%E9%81%8B%E8%B2%BB%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3C%2Fp%3E%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%E8%87%B4%E9%9B%BB%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3E2593%200388%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%26nbsp%3B%E8%A7%A3%E9%8E%96%E5%84%AA%E6%83%A0%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fd%2Fdeals%2Fexpress%2F%3FipromoID%3Dhellobar_03_quickship%22%20target%3D%22_blank%22%20textvalue%3D%22%E7%AB%8B%E5%8D%B3%E8%B3%BC%E8%B2%B7%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3E%E7%AB%8B%E5%8D%B3%E8%B3%BC%E8%B2%B7%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%3Cbr%2F%3E%3C%2Fp%3E","en":"","en_hk":"%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cstrong%3EPC%20Up%20to%2030%25%20off%3C%2Fstrong%3E%26nbsp%3B%7C%20Selected%20models%20are%20on%20sale%20in%20stock%2C%20and%20the%20fastest%20delivery%20is%203%20days!%20Free%20shipping%20site-wide%2C%20no%20minimum%20spend.%3C%2Fspan%3E%3C%2Fp%3E%3Cp%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22font-family%3A%20Montserrat%3B%20color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3ECall%202593%200388%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fd%2Fdeals%2Fexpress%2F%3FipromoID%3Dhellobar_03_quickship%22%20target%3D%22_blank%22%20textvalue%3D%22Shop%20now%22%20style%3D%22text-decoration%3A%20underline%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cstrong%3EShop%20now%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%3Cbr%2F%3E%3C%2Fp%3E","zh":""},"id":"Pagef53f1aa2-3b1d-4357-a57e-850230463f26"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page40a4db87-5fc2-477e-aa8e-51281582d62c","language":{"zh_hk":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%E6%9C%89%E7%96%91%E5%95%8F%E5%97%8E%EF%BC%9F%20%E5%A6%82%E9%9C%80%E6%88%91%E5%80%91%E7%9A%84%E5%B0%88%E5%AE%B6%E5%BB%BA%E8%AD%B0%EF%BC%8C%E8%AB%8B%E8%87%B4%E9%9B%BB%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3E2593%200388%3C%2Fstrong%3E%3C%2Fspan%3E%3Cstrong%3E%E6%88%96%E9%BB%9E%E6%93%8A%E3%80%8C%E8%81%8A%E5%A4%A9%E3%80%8D%EF%BC%81%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fspan%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20class%3D%22live_chat_daily%22%20style%3D%22text-wrap%3A%20wrap%3B%20text-decoration-line%3A%20underline%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cstrong%3E%E8%81%AF%E7%B5%A1%E6%88%91%E5%80%91%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fp%3E","en":"","en_hk":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3ENeed%20Help%3F%26nbsp%3B%26nbsp%3B%3Ca%20href%3D%22tel%3A25930388%22%20style%3D%22color%3A%20rgb(255%2C%20192%2C%200)%3B%22%3E%3Cstrong%3ECall%202593%200388%3C%2Fstrong%3E%3C%2Fa%3E%26nbsp%3B%26nbsp%3Bor%20Chat%20with%20us%20now!%3C%2Fspan%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20class%3D%22live_chat_daily%22%20style%3D%22text-wrap%3A%20wrap%3B%20text-decoration-line%3A%20underline%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%20font-family%3A%20arial%2C%20helvetica%2C%20sans-serif%3B%22%3E%3Cstrong%3EContact%20Us%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fp%3E","zh":""},"id":"Page40a4db87-5fc2-477e-aa8e-51281582d62c"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page4daeae9a-96ce-41de-bb12-39e5cc32e16a","language":{"zh_hk":"%3Cp%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%E5%B9%B4%E5%BA%A6%E6%9C%80%E5%BC%B711.11%E5%84%AA%E6%83%A0%20%7C%20%E6%89%8B%E6%8F%90%E9%9B%BB%E8%85%A6%E6%BF%80%E6%B8%9B%E8%87%B3%20%241%2C798!%20%E8%B3%BC%E7%89%A9%E9%80%81%24400%E8%B6%85%E5%B8%82%E7%A6%AE%E5%88%B8!%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fd%2Fdeals%2Fspecial-offer%2F%22%20target%3D%22_self%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3E11.11%E7%B2%BE%E9%81%B8%E5%9E%8B%E8%99%9F%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E","en":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3EMega%20Clearance%20Sale%20%7C%20Laptops%20starts%20at%20%241%2C998%26nbsp%3B%20%26nbsp%3B%20Up%20to%2040%25%20off%20for%20Gaming%20PCs%2FYoga%20PCs%26nbsp%3B%20%26nbsp%3B%20Free%20shipping%20on%20any%20orders%2C%20as%20fast%20as%202%20days%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22https%3A%2F%2Fadmin.lenovo.com%2Fd%2Fdeals%2Fspecial-offer%2F%3FipromoID%3Dhellobar_05%22%20target%3D%22_blank%22%20title%3D%22Mega%20Clearance%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3EMega%20Clearance%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fp%3E","en_hk":"%3Cp%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E11.11%20Crazy%20Deals%20%7C%20Laptop%20Starting%20at%20%241798!%20Get%20%24400%20supermarket%20vouchers!%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fd%2Fdeals%2Fspecial-offer%2F%22%20target%3D%22_self%22%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3E11.11%20Deals%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E","zh":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%E7%A7%8B%E5%AD%A3%E9%96%8B%E5%80%89%E5%A4%A7%E6%BF%80%E8%B3%9E%7C%20%E9%9B%BB%E8%85%A6%E4%BD%8E%E8%87%B3%241%2C998%E8%B5%B7%26nbsp%3B%20%E9%9B%BB%E7%AB%B6%E9%9B%BB%E8%85%A6%2FYoga%E9%9B%BB%E8%85%A6%E4%BD%8E%E8%87%B36%E6%8A%98%20%E4%BB%BB%E4%BD%95%E8%A8%82%E5%96%AE%E5%85%8D%E8%B2%BB%E9%80%81%E8%B2%A8%20%E6%9C%80%E5%BF%AB2%E6%97%A5%E9%80%81%E5%88%B0%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22https%3A%2F%2Fadmin.lenovo.com%2Fd%2Fnotebook-recommendation%2F%3FipromoID%3Dhellobar_05%22%20target%3D%22_blank%22%20title%3D%22%E5%8D%B3%E6%90%B6%E7%A7%8B%E5%AD%A3%E9%96%8B%E5%80%89%E5%84%AA%E6%83%A0%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(255%2C%20255%2C%20255)%3B%22%3E%3Cstrong%3E%E5%8D%B3%E6%90%B6%E7%A7%8B%E5%AD%A3%E9%96%8B%E5%80%89%E5%84%AA%E6%83%A0%3C%2Fstrong%3E%3C%2Fa%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3C%2Fspan%3E%3C%2Fp%3E"},"id":"Page4daeae9a-96ce-41de-bb12-39e5cc32e16a"},"gInfo":""}],"autoRun":true,"isShowDivide":true}
11.11 最強折扣反應熱烈!
優惠延長一週!最後倒數,立即行動!
天數
小時
分鐘
秒數
11.11 最強折扣反應熱烈!
優惠延長一週!最後倒數,立即行動!
天數
小時
分鐘
秒數


什麼是絕對細胞參考(ACR)?

ACR 是一種指定電子表格程式(例如 Microsoft Excel 或 Google Sheets)中儲存格位置的方法。當使用 ACR 引用單元格時,其位置是固定的,並且當引用該單元格的公式或函數被複製或移動到另一個單元格時不會更改。這可確保無論公式或函數放置在何處,計算中始終使用相同的儲存格。 ACR 透過在公式或函數中引用單元格的列座標和行座標之前使用美元符號 ($) 來表示。

為什麼我需要使用 ACR?

當您想要引用公式中的固定儲存格或儲存格範圍時,無論公式複製或移動到何處,都可以使用 ACR。

如何在 Microsoft Excel 中使用 ACR?

在 Excel 中,您可以透過在要鎖定的儲存格的列字母和/或行號之前新增美元符號 ($) 來建立 ACR。例如,如果要鎖定對儲存格 A1 的引用,則將其寫為 $A$1。

ACR 中的美元符號 ($) 代表什麼?

ACR 中的美元符號表示引用是固定的,並且在複製或移動公式時不會更改。它充當錨點,保持參考不變。

我何時使用 ACR 的範例是什麼?

假設您有一個包含銷售資料的電子表格,並且您想要計算每種產品的總銷售額。 B 欄包含產品價格,C 欄包含銷售數量。透過使用 ACR,您可以在複製公式計算其他產品的總銷售額時鎖定價格和數量列的參考。

如何為數量列建立 ACR?

要為數量列建立 ACR,您需要選擇公式中的儲存格參考並在列字母前面新增美元符號。例如,如果數量位於 C 列中,則 ACR 將為 $C。

如何為價格列建立 ACR?

若要為價格列建立 ACR,您需要選擇公式中的儲存格參考並在列字母前面新增美元符號。如果價格在 B 列中,則 ACR 將為 $B。

如果我想將儲存格 C2 中的數量乘以儲存格 B2 中的價格,使用 ACR 的公式會是什麼樣子?

公式類似 =$B$2 * $C$2。透過使用 ACR,您可以確保在複製此公式來計算其他產品的總銷售額時,對價格和數量儲存格的參考保持固定。

如果我不使用 ACR 並複製公式來計算其他產品的總銷售額,會發生什麼情況?

如果您不使用 ACR 並複製公式,參考將相對於新位置進行調整。例如,如果將具有相對引用的公式從儲存格 D2 複製到 D3,則公式將自動調整為 =$B$3 * $C$3。這可能不會給您想要的結果,因為您想要將每種產品的價格和數量相乘。

有沒有在Excel中應用ACR的捷徑?

是的,有一個在 Excel 中應用 ACR 的捷徑。在公式中選擇儲存格參考後,您可以按鍵盤上的 F4 鍵循環選擇可用的參考類型(例如,絕對列和行、僅絕對列、僅絕對行、相對引用)。這使得在絕對引用和相對引用之間切換更快。

除了 Excel 之外,我可以在其他電子表格軟體中使用 ACR 嗎?

是的,ACR 的概念也存在於其他電子表格軟體中。雖然創建 ACR 的具體方法可能略有不同,但目的和功能保持不變。

ACR僅用於計算嗎?

不,ACR 還可用於計算以外的各種用途。當引用固定值(例如稅率、換算係數或其他需要在整個電子表格中保持不變的常數)時,它們非常方便。

ACR 和相關細胞參考有什麼不同?

當您將公式複製或移動到不同的儲存格時,相對儲存格參考會變更其位置。另一方面,無論公式的新位置如何,ACR 都保持固定並且不會改變。

我可以在一個公式中混合絕對和相對單元格引用嗎?

是的,您可以在公式中混合絕對和相對單元格引用。當您想要保持某些引用固定,同時允許其他引用根據公式的新位置進行調整時,這會很有用。

有沒有辦法只鎖定儲存格引用中的行或列?

是的,您可以鎖定儲存格參考中的行或列。若要僅鎖定該行,您可以在行號前面新增一個美元符號(例如,$A1)。若要僅鎖定該列,您可以在列字母前面新增一個美元符號(例如,A$1)。

我可以從配方中刪除 ACR 嗎?

是的,您可以透過編輯公式並從引用中刪除美元符號來從公式中刪除 ACR。這會將引用轉換為相對引用。

如果我刪除或移動 ACR 引用的儲存格,會發生什麼情況?

如果刪除或移動 ACR 引用的儲存格,則該參考仍將指向原始儲存格位置。這可能會導致公式錯誤或計算不正確。因此,在操作 ACR 引用的儲存格時務必小心謹慎。

我可以使用 ACR 引用不同工作表或工作簿中的儲存格嗎?

是的,您可以使用 ACR 來引用不同工作表或工作簿中的儲存格。引用其他工作表中的儲存格時,您可以在儲存格引用之前新增工作表名稱,後面跟著感嘆號 (!)。引用其他工作簿中的儲存格時,您還需要包含工作簿名稱以及工作表名稱和儲存格參考。

{"pageComponentDataId":"537198bf07954-401a-b47a-087e257f1d72","isAssociatedRelease":"true","pageComponentDataLangCode":"en_hk","configData":{"jumpType":"currentTab","headlineColor":"black","displayNumber":"","styleMode":"vertical","miniCardHoMode":"2","headline":"","products":[{"number":{"t_id":"len101t0102","language":{"zh_hk":"len101t0102","en":"","en_hk":"len101t0102","zh":""},"id":"Page497e178f-e4db-4b5b-b1a5-ec4687329efb"}},{"number":{"t_id":"len101t0104","language":{"zh_hk":"len101t0104","en":"","en_hk":"len101t0104","zh":""},"id":"Page9145835b-830f-4dee-9765-5a8ed87b670f"}},{"number":{"t_id":"len101t0081","language":{"zh_hk":"len101t0081","en":"","en_hk":"len101t0081","zh":""},"id":"Pagebb4de9bf-4262-41eb-9982-04bc0777035c"}},{"number":{"t_id":"len101g0036","language":{"zh_hk":"len101g0036","en":"","en_hk":"len101g0036","zh":""},"id":"Paged7259f59-5586-49c9-8b68-20a93f7b4c51"}}]},"urlPrefix":"AAAAAAALAAAG","needGetLatestTransDataKey":"needGetLatestTransDataValue","title":"glossary-right-blue-boxes-fragment","pageId":"82171833-6325-4d09-947e-5979c9876a90","urlEdit":0,"uri":"/FragmentDirectory/glossary/glossary-right-blue-boxes-fragment.frag","pageComponentId":"537198bf07954-401a-b47a-087e257f1d72","tplId":"c7389f9a-59c0-4c34-a9e1-f1c090c6ab86","pageComponentUuid":"537198bf07954-401a-b47a-087e257f1d72","targetUser":"0"}
即將上市
起價
建議售價
原價
網上售價:
建議售價
預估價值 (Estimated Value)
定價是Lenovo根據產業數據對產品價值的估算,包括第一方和第三方零售商和電商提供或估值相同或相似產品的價格。第三方經銷商數據可能不是基於實際銷售。
預估價值是Lenovo根據行業數據對產品價值的估算,包括Lenovo和/或第三方零售商和電子零售商提供或估值相同或相似產品的價格。第三方數據可能不是基於實際銷售。
了解更多
See More
See Less
查看 {0} 型號
查看 {0} 款型
shipping.options.for.{0}
產品編號
功能
查看更多
查看較少
比較
已加入!
好選擇!
您可以在每個產品類別(筆記本電腦、桌上型電腦等)中比較最多 4 項產品。請取消選擇一項才能新增另一項。
檢視您的比較
加入購物車
加入購物車
我們很抱歉,
產品暫時無法使用。
繼續購物
了解更多
即將上市
精選產品
精選產品
哎呀!未找到任何結果。請瀏覽上方的類別以尋找您的產品。
儲存
open in new tab
© 2024 Lenovo. 保留所有權利。
© {year} Lenovo. All rights reserved.
比較  ()
x