什么是相对单元格引用?

這是一個推薦產品對話框
熱門建議
起價
查看全部 >
語言
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 最強折扣反應熱烈!
優惠延長一週!最後倒數,立即行動!
天數
小時
分鐘
秒數


什么是相对单元格引用?

相对单元格引用是电子表格应用程序(如 Microsoft Excel 或 Google Sheets)中的一个术语,用于描述一种单元格引用方式,当公式被复制或移动到不同单元格时,引用方式会发生变化。使用相对单元格引用时,引用是基于单元格的相对位置,而不是绝对位置。这样就可以创建动态公式,轻松应用于多个单元格,而无需手动调整。

相对单元格引用是如何工作的?

在公式中使用相对单元格引用时,它会根据公式相对于引用单元格的位置进行调整。例如,如果在单元格 B2 中有一个引用单元格 A1 的公式,然后将公式复制到单元格 B3,则引用将自动更改为单元格 A2。这种调整是根据公式的相对位置递增或递减行和(或)列引用。

为什么相对单元格引用有用?

相对单元格引用非常有用,因为它可以让你在电子表格中创建灵活且可重复使用的公式。通过使用相对引用,您可以将公式快速应用到多个单元格,而无需手动调整每个引用。在处理大型数据集或复杂计算时,这可以节省时间并降低出错的风险。

如何使公式中的引用为绝对引用而非相对引用?

要使公式中的引用绝对化,可以在列字母和/或行号前使用美元符号 ($)。例如,如果想在复制公式时保持对单元格 A1 的绝对引用,则将其写成 $A$1。 如果只想固定列,则使用 $A1,如果只想固定行,则使用 A$1。 通过使用绝对引用,无论复制或移动时单元格的位置如何,公式都将始终引用同一单元格。

能否在一个公式中混合使用相对引用和绝对引用?

是的,您可以在公式中混合使用相对引用和绝对引用。当您想锁定引用的某些部分,同时允许其他部分进行调整时,这可能会很有用。例如,如果您有一个计算两个值之间百分比变化的公式,您可以对初始值使用绝对引用,对当前值使用相对引用。这样,当你将公式复制到其他单元格时,初始值就会保持固定,而当前值则会相应调整。

是否有使用相对单元格引用的快捷方式或技巧?

是的,有一些快捷键和技巧可以帮助你更有效地使用相对单元格引用。其中一个方便的快捷键是使用 F4 键(Windows)在公式中的绝对引用和相对引用之间切换。另一个技巧是使用填充柄,它是位于选定单元格右下角的一个小方块。你可以拖动填充柄将公式复制到相邻的单元格中,相对引用会自动调整。

除了 Excel 和 Google Sheets 之外,相对单元格引用还适用于其他电子表格应用程序吗?

是的,相对单元格引用这一概念适用于大多数电子表格应用程序,包括 Excel 和 Google Sheets 的常用替代软件,如 Numbers 和 LibreOffice Calc。虽然不同软件创建相对引用的具体步骤可能略有不同,但基本思想是相同的。通过了解相对单元格引用的概念,你可以将其应用到各种电子表格应用程序中,提高工作效率。

如何在 Excel 中切换相对和绝对单元格引用?

在 Excel 中,使用键盘快捷键可以在相对单元格引用和绝对单元格引用之间轻松切换。编辑公式时,只需将光标放在要更改的单元格引用上,然后按 F4 键(Windows 系统)即可。每次按快捷键时,Excel 都会循环显示不同的引用类型:绝对行和列 ($A$1)、仅绝对列 (A$1)、仅绝对行 ($A1) 和相对引用 (A1)。

在编程中使用相对单元格引用有什么好处?

相对单元格引用不仅限于电子表格应用,还可用于编程。在编写涉及数组或矩阵数据操作的代码时,相对引用可以简化计算。通过使用相对索引而不是硬编码特定的单元格位置,你可以创建更灵活和可重复使用的代码,以适应数据大小或结构的变化。

相对单元格引用是否适用于数据库查询?

在数据库查询中,通常不使用相对单元格引用。相反,数据库查询依赖于不同的机制,如结构化查询语言(SQL),来检索和操作数据。SQL 查询使用明确的列名、表连接和其他筛选条件从数据库中提取相关信息。虽然相对单元格引用并不直接适用于这种情况,但根据数据关系动态调整引用的概念仍然非常重要。

如何在结构化查询语言 (SQL) 查询中创建绝对或相对引用?

在 SQL 查询中,可以通过明确指定列名和表关系来创建绝对或相对引用。例如,如果有两个表,即客户表和订单表,要根据客户 ID 连接这两个表,可以写道

SELECT customers.name, orders.order_number

从客户

在 customers.id = orders.customer_id 上连接 orders

在这里,对列(name、order_number)的引用是绝对的,因为它们明确指定了所需列。但是,对表(客户、订单)的引用在表之间建立了关系,允许根据相应的 ID 动态检索数据。

是否有任何工具或软件可以帮助管理相对单元格引用?

是的,有各种工具和软件可以帮助管理电子表格中的相对单元格引用。例如,Microsoft Excel 和 Google Sheets 提供了填充柄等功能,让您可以轻松地将带有相对引用的公式复制到相邻的单元格中。此外,一些电子表格插件还提供了高级功能,可用于处理复杂的数据集,并在处理大量数据时保持一致的相对引用。

除了 Python 之外,我还能在其他编程语言中使用相对单元格引用吗?

是的,相对单元格引用是一个可以应用于各种编程语言的概念,而不仅仅是 Python。不同语言的具体语法可能有所不同,但基本原理是相同的。无论您使用的是 JavaScript、Java、C++ 还是其他语言,您都可以利用相对引用来创建动态和可调整的代码,以适应数据或输入的变化。

{"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