在Excel中 跨工作表单元格引用的格式正确的是( )。A.工作表名!数据源所在单元格地址B.[工作
在Excel中,跨工作表单元格引用的格式正确的是( )。
A.工作表名!数据源所在单元格地址
B.[工作簿名]!工作表名!数据源所在单元格地址
C.[工作簿名]工作表名!数据源所在单元格地址
D.工作表名!数据源所在单元格地址l
请帮忙给出正确答案和分析,谢谢!
参考解答
正确答案:A
跨工作表单元格引用是指引用同一工作簿里其他工作表中的单元格,又称为三维引用,需要按照以下格式进行跨表引用:“工作表名!数据源所在单元格地址”。
相似问题
Consumers should do __________than simply complain
Consumers should do __________than simply complain about the poor quality of goods A much lessB some moreC far lessD far more请帮忙给出正确答案和分析,谢谢!
Many a delegate was in favor of his proposal that
Many a delegate was in favor of his proposal that a special committee __________ to investigate the incident A were set upB was set upC be set upD set up请帮忙给出正确答案和分析,谢谢!
' Good-bye Mr. Wang. I‘ m pleased________you. 'A.
" Good-bye, Mr Wang I‘ m pleased________you "A to meetB meetingC to have been meetingD to be met请帮忙给出正确答案和分析,谢谢!
阅读材料 回答题。Harriet Beecher Stowe had poured her hear
阅读材料,回答题。Harriet Beecher Stowe had poured her heart into her anti-slavery book,&quo阅读材料,回答题。Harriet Beecher Stow
Harriet Beecher Stowe was able to describe the evi
Harriet Beecher Stowe was able to describe the evils of slavery because __________ 查看材料A she had lived for 18 years in
