EX表格相乘公式怎么不能自动生成

颜白子2022-10-04 11:39:541条回答

EX表格相乘公式怎么不能自动生成
各位大神!谁能告诉我为什么EXcellent表格里相乘公式不能用,我相乘的二个数字也是公式比如:1+1=公式等于2 2+2等于4 我要设一个公式是2和4相乘,但怎么不能自动生成

已提交,审核后显示!提交回复

共1条回复
紫燕飞 共回答了20个问题 | 采纳率100%
第一个 生成后 摁住ctrl键 向下拉动 试试
1年前

相关推荐

英国法国美国德国政治制度比较表格
英国法国美国德国政治制度比较表格
历史必修一第三单元的内容
必要四国政治制度 结构 国家元首以及能力 有无内阁、议会、国会、最高法院及其组成只能 特别注意 等等
越全越好
病罂1年前1
987654567afg 共回答了12个问题 | 采纳率100%
表格不太好呈现,但愿能有点用吧~~~~~~~~~~~~~~~~~~~~~
英国 君主立宪制 议会权力至上,下院具有立法权,上院具有司法权.人数多的政党领袖被选为首相,掌握国家大权,对议会负责,君主统而不治
美国 总统共和制(受孟德斯鸠启蒙思想影响) 国会(立法权)、最高法院(司法权)、总统(行政权)三权分立相互制约,独立平等
法国 共和政体 议会拥有立法权,总统拥有行政大权
德国 君主立宪政体 皇帝掌握国家大权,宰相由皇帝任命,只对皇帝负责.议会是立法机构,但帝国议会通过的法案必须经过联邦议会和皇帝的批准才能生效
根据表格补全对话
janely19881年前1
妖精403 共回答了13个问题 | 采纳率84.6%
My favourite holiday is Dragon Boat Festival.
When is the holiday?
The people eat rice dumplings and dragon boat races.
It's Halloween.
The people dress up in costumes and make pumpkin lanterns.
看图表格.
看图表格.

mahaonan77881年前1
pgicl4 共回答了15个问题 | 采纳率100%
男生每格代表10,女生每格代表2
英语补全对话,根据表格
qwbd551年前1
ruanlzhou 共回答了8个问题 | 采纳率75%
Dragon Boat Festival
When
May or June
on
eat rice dumplings
watch dragon boat races
dress up in costumes make pumpkin lanterns
Christmas
give presents to each other
March April
Easter eggs
阅读理解,根据短文内容完成表格.
阅读理解,根据短文内容完成表格.
zhang yining,the famour chinese table tennis player,was born in beijing on October 5th,1982.she was interested in ping-pong when she a child.she started playing table tennis at the age of six.she joined the beijing table tennis team in 1991.
she joined the national table tennis team in 1993.she is 30 years old now.
in august 2008,zhnag yining took part in the 29th olympic games.she defeated wan nan,also a famous chinese table tennis single in the olympic game.
when what
october 5th 1982 was born
when she was a child (1)__________
(2)____________ started playing table tennis
(3)____________ joined the beijing table tennis team
1993 (4)__________________
in August 2008 (5)___________________
如果生命中没有你1年前1
Maisakura 共回答了16个问题 | 采纳率87.5%
1 was interested in ping-pong
2 at the age of six
3 in 1991
4 joined the national table tennis team
5 took part in the 29th olympic games
英语根据表格内容描述人物Name Age Country Nationality Phone NumberPhilip
英语根据表格内容描述人物
Name Age Country Nationality Phone Number
Philip 12 France French 66039816
Bill 13 America American 75220381
Alice 11 Australia Australian 85365401
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
kobeandIverson1年前1
皇后梦想 共回答了17个问题 | 采纳率88.2%
Philip is 12.He is from France He is French .His phone number is 66039816.
Bill is 13 .He is from America.He is American .His phone number is 75220381.
Alice is 11 .She is from Australia .She is Australian .Her phone number is 85365401
英语表格填写surnamegiven namemiddle initialsecondary school datapo
英语表格填写
surname
given name
middle initial
secondary school data
post-secondary school data
蒸发的雨点8881年前1
极品蚂蚁 共回答了15个问题 | 采纳率93.3%
surname姓名
given name姓
middle initial名
secondary school data高中入学数据
post-secondary school data大学入学数据
初二英语阅读短文完成表格
初二英语阅读短文完成表格



xtfl1年前1
十一点上床 共回答了20个问题 | 采纳率95%
16.Introduction
17.looks like
18.get hurt seriously
19.wet
20.swim
根据表格内容补全短文Ways to Learn English Students Successful OK Unsuc
根据表格内容补全短文
Ways to Learn English

Students Successful OK Unsuccessful


Lillian Lee read English novels learn English songs hate grammar
Wei Ming study grammar watch English movies talk with friends in English

Last week we asked some students about the ( 1 ) way to learn English. Some students had some suggestions. Lillian Lee. for example, said her best way to learn English was by( 2 ) . She also said learning English songs could help a little. But she ( 3 ).
Wei Ming feels differently. He thinks ( 4 ) is a great way to learn a language. He also thinks watching English movies isn’t a bad way because he can watch the actors say the words. But he never( 5 ) with his friends in English because he’s afraid they might laugh at him.
窗户窗户1年前1
工159 共回答了16个问题 | 采纳率87.5%
1、 Successful
2、 reading English novels
3、hates grammar
4、studying grammar
5、 talks with friends in English
怎样设计物理表格
风雨无阻3211年前1
ewqwetqwesdfsd 共回答了16个问题 | 采纳率81.3%
近几年各省中考物理试题出现了三个明显的趋向:一是着重考查对知识的理解以及运用所学知识解释现象、分析和解决问题,试题材料密切联系同学们的学习和实际生活;二是越来越重视探究能力的考查;三是综合性试题更常见,考查大家设计和实施实验能力的题目也更普遍.在新课程实验区的考试中,除考查知识与技能、过程与方法的试题外,物理表格的设计也是试题中一个不容忽视的知识点.一、物理表格设计的原则1.必须设计出实验所要测量的物理量和要控制的不变量.2.设计的物理量必须附有单位.二、物理表格的设计方法1.行:一般设计物理量2.列:一般设计实验次数例1根据生活经验,我们猜想物体温度升高吸收热量的多少可能与质量和物质的种类有关.为了验证猜想,我们制订了两个计划:A.让研究对象都升高相同的温度,然后比较它们吸收热量的多少.B.让研究对象都吸收相同的热量,然后比较它们提升的温度高低.(1)实验室准备了两个规格相同的电加热器、两个相同的酒精灯、两个相同的烧杯、两只温度计以及手表、铁架台、适量的水和煤油.为了完成实验,还需要一个仪器.
这个表格怎么完成
这个表格怎么完成

飘仙1年前4
flowerfish 共回答了16个问题 | 采纳率87.5%
第一排1,1
第二排9,18
第三排 8,8
第四排12,12
第五排20,20
第六排19,40
根据下面表格,完成下列作文There are many great invent
根据下面表格,完成下列作文

There are many great inventions in the world.Here is a short introduction
meemy1年前1
Oo夕阳oO 共回答了26个问题 | 采纳率100%
for example, camera which is being used to take photoes, is invented by Joseph N. in 1827; abacus which is used for counting, is invented by some Chinese people in around the sixth country; chips whic...
在线翻译英语完成下列表格 How can we keep safe on the streets?First We mu
在线翻译英语
完成下列表格
How can we keep safe on the streets?
First We must ( ) the street only when we see the ( ) “walk” sign.
Second Look ( ) ( )--- look left , look right and look left again before we cross the road.
Third We must ( ) ( ) on the street.
Last It’s good to ( ) children and old people ( ) the road.
山上客1年前1
garyfung 共回答了25个问题 | 采纳率88%
First We must (cross ) the street only when we see the (shining ) “walk” sign.
Second Look ( around ) ( carefully )--- look left , look right and look left again before we cross the road.
Third We must ( be ) ( careful ) on the street.
Last It’s good to ( help ) children and old people ( cross ) the road.
初二英语阅读短文完成表格
初二英语阅读短文完成表格



想做幸福的白羊1年前1
iill手 共回答了13个问题 | 采纳率92.3%
17.good advice 18.volunteer programs 19.get on well with others 20.An English summer camp
根据短文内容完成表格 根据短文内容完成表格. Hi,I'm Zhu H
根据短文内容完成表格
根据短文内容完成表格.
Hi,I'm Zhu Hua.I'm a junior high school student in Beijing.There are twenty-six boys and twenty-two
girls in my class.Half of the students come to school by bike.Five boys and four girls come to school on
foot.About a quarter of us come to school by bus.The rest come to school by subway.We're all from
China.We're good friends.
Students By bike By bus By subway On foot
Number 1._____ 2._____ 3._____ 4._____ 5._____
1.______ 2.______ 3.______ 4.______ 5.______
猪住房yy企yy1年前1
我哪知道 共回答了9个问题 | 采纳率66.7%
1.48 2.24 3.12 4.3 5.9
阅读短文完成表格
阅读短文完成表格

半酒瓶子醋1年前1
晚上请 共回答了16个问题 | 采纳率68.8%
1.69
2.A brown dress
3.30
4.1.82
5.A green suit
6.52
7.1.50
8.5
9.A red blouse and skirt
10.Jim
根据表格内容完成对话Carl:Do you like action movies?Tina:No,I __1___lik
根据表格内容完成对话
Carl:Do you like action movies?Tina:No,I __1___like them.Carl:What do you ___2___?Tina:I like comedies,but Iprefer _________3_________.Carl:Do you like horror movies?Tina:No,I hate them.What___4____you,Carl?Carl:Well,I like action movies and horror movies,but I don't like____5____or documentaries
童崽1年前1
鄙人布衣 共回答了17个问题 | 采纳率94.1%
1,don't2,like3,Documentaries4,are5,Comedies
表格=IF(J5="",(x+L5+M5+N5+O5+P5),(x+L5+M5+N5+O5+P5)*J5))
qhwr1年前1
飘零的蝴蝶 共回答了21个问题 | 采纳率85.7%
首先你需要知道的是J5表示一个单元格,列号是J,行号是5.
那么这个公式的意思是:
如果J5这个单元格是空的,那么本单元格(有公式的那个单元格)的值就等于
x+L5+M5+N5+O5+P5,否则(J5不为空)本单元格的值等于
(x+L5+M5+N5+O5+P5)*J5)
阅读短文,完成表格
阿JOE1年前2
柳月诚 共回答了10个问题 | 采纳率80%
1、Problem
2、school uniforms
3、Students'
4、beautiful
5、smart
6、Wear
7、Teachers'
8、Students
9、way
10、design
根据表格信息编写对话Wang Yan:Hi,Li Hong!Did you have a good holiday?Li
根据表格信息编写对话

Wang Yan:Hi,Li Hong!Did you have a good holiday?

Li Hong:Yes.
Wang Yan:________________________________
Li Hong:___________________________________
Wang Yan:________________________________
Li Hong:_________________________________
Wang Yan:________________________________
Li Hong:____________________________________
Wang Yan:________________________________
Li Hong:____________________________________
Wang Yan:___________________________________
woshinaibo1年前2
sunlirong1982 共回答了17个问题 | 采纳率82.4%
Wang Yan:Hi,Li Hong!Did you have a good holiday?
Li Hong:Yes.
Wang Yan:where have you visited?
Li Hong:I went to Hangzhou with my friends.what about you?
wang yan:I visited Harbin.
li hong:sounds like fun!how did you get there?
wang yan:by plane,I guess you must by train.
li hong:yes ,you know me!
wang yan:what did you do during your trip?
li hong :I visited west lake,ate a lot of good food and bought presents.what about you
wang yan:I went skiing and made a snowman and took pictures.
根据表格内容,完成下列句子.
crazyfrog5051年前1
透明的阳光 共回答了18个问题 | 采纳率94.4%
1name is 2 Ben is 3 lives in 4 There are 5 telephone number 6 hobbies playing 7 subjects Maths 8 Ben's e-mail
表格填空
表格填空


晓艳love1年前1
20cl 共回答了29个问题 | 采纳率86.2%
由第一横行可知各横行与竖列的四个数之和是-10
所以,表格中的数字应该如下
Accident Report Form(表格)
Accident Report Form(表格)
Accident: A car crashed(冲撞) into a tree.
Some people were trapped (困)in the car.
Weather: There was a heavy rain.
Date of call: June 3,2006
Time of call: 9:30 p.m.
Name of caller: Mrs Green
Place: Zhongshan Road, Nanjing
Conditions of victims(受害者): Mr Green hurt his head.
Mrs Green hurt her left leg.
Their daughter felt frightened.
Action: Policemen arrived at 9:40 p.m. and sent the victims to Gulou Hospital at 9:45 p.m.
小题1: What time did Mrs Green call the police?
A.At 9:30 a.m. B.At 9:30 p.m.
C.At 9:40 p.m. D.At 9:45 p.m.
小题2:How many people were trapped in the car?
A.One. B.Two C.Three D.Four
小题3:Whose left leg was hurt?
A.Mrs Green’s. B.Their daughter’s. C.Mr. Green’s D.Their friend’s.
小题4:What was the weather like that day?
A.It was sunny. B.It was snowy. C.It was cloudy. D.It was rainy.
小题5: Which of the following is TRUE?
A.The car crashed into a wall.
B.Their daughter hurt her leg and was sent to the hospital.
C.The car accident happened on Zhongshan Road in Nanjing.
D.The policemen arrived half an hour later and sent the victims to the hospital.
clydezhou1年前1
注册只为灌水 共回答了12个问题 | 采纳率91.7%
小题1:B
小题1:C
小题1:A
小题1:D
小题1:C


小题1:根据Time of call: 9:30 p.m.可知选B。
小题1:根据Conditions of victims(受害者): Mr Green hurt his head.
Mrs Green hurt her left leg.
Their daughter felt frightened.
可知车里面有三个人,故选C。
小题1:根据Mrs Green hurt her left leg.可知选A。
小题1:根据Weather: There was a heavy rain.可知选D。
小题1:根据Place: Zhongshan Road, Nanjing可知选项C,描述正确。
阅读理解,根据短文内容完成表格
阅读理解,根据短文内容完成表格


xncyq721年前1
wretd123 共回答了23个问题 | 采纳率87%
Beijing nice
Hangzhou Cloudy
Wuhan nice
Guangzhou Rain
Lhasa snow
根据表格,找出规律,然后回答问题
根据表格,找出规律,然后回答问题
1 3 5 7 9 .
2 6 10 14 18 .
4 12 20 28 36 .
8 24 40 56 72 .
16 48 90 112 144..
.....
(1)第一列的第十个数是?
(2)数42应在表格第几行?
(3)数88应在表格的第几行,第几列?
临门一脚差1年前1
boboshooter 共回答了26个问题 | 采纳率92.3%
1、是19
2、第2行
3、4行6列
高一必修一生物实验总结 表格
kd宝贝丫头1年前2
新月999 共回答了18个问题 | 采纳率94.4%
探究和资料分析没打,开始本来把实验步骤打上去了去了,但是后来不知怎么不见了,我打了很久的,重新打一遍不可能了,只能告诉你有什么实验了.
使用高倍显微镜观察几种细胞
检测生物组织中的糖类、脂肪和蛋白质
观察DNA和RNA在细胞中的分布
体验制备细胞膜的方法
用高倍显微镜观察叶绿体和线粒体
比较过氧化氢在不同条件下的分解
绿叶中色素的提取和分离
细胞大小与物质运输关系
观察根尖分生区组织细胞的有丝分裂
正在填写英文学历表格,Educational Qualification:-Number of Education De
正在填写英文学历表格,
Educational Qualification:-
Number of Education Details
Awarding Body/Inst./Univ.
Country
Namex05
Qualification
Faculty
Specializationx05
Mode of Study:Self-Study (我是自考所以填这个了,
Period of Study(DD/MM/YYYY)
bolt8888881年前1
天使般微笑 共回答了16个问题 | 采纳率93.8%
Educational Qualification:- 教育资质
Number of Education Details 一些接受教育的细节
Awarding Body/Inst./Univ.发证机构/学院/大学
Country 国家
Namex05 姓名
Qualification 资格证书
Faculty 学院
Specializationx05 专业
Mode of Study:Self-Study 学习方式:自学
Period of Study(DD/MM/YYYY) 学习时间:日 月 年
按照例句完成表格
nigoli1年前2
梦在潇潇暮雨 共回答了19个问题 | 采纳率89.5%
是这个表吗?
verb I feel...because...
excite I feel excited because the football match is exciting.
interest
relax
please
bore
worry
annoy
frighten
disappoint
白荷根据文章填写下面表格
寂静中等待1年前1
水无劫 共回答了18个问题 | 采纳率88.9%
大盘子是指白荷刚长出来的时候圆形状;小雨伞是指白荷叶长大后的样子;伞柄是指白荷的茎;大伞帽是指白荷的叶子2062时间           白荷生长情况                  作用 春末夏初  ...
阅读对话,完成表格Ben:It's my birthday next week.Jenny:Oh,really?When
阅读对话,完成表格
Ben:It's my birthday next week.
Jenny:Oh,really?When is it?
Ben:Friday,the nineteenth.
Jenny:I have a rock concert then.
Ben:That sounds fun.And there's the Art Festival on the seventeenth.
Jenny:Oh,yes,there is!See you there.
Ben:Yes.What about the school trip on the sixteenth?
Jenny:No,I can't go.I have an Engliah speech contest.
Ben:Too bad.
回答时请说出Ben和Jenny星期一到星期五都做了哪些事.
好的追!
tommy221521年前2
moonlightholder 共回答了18个问题 | 采纳率94.4%
星期
星期一:Mon.=Monday
星期二:Tues.=Tuesday
星期三:Wed.=Wednesday
星期四:Thur.=Thurday
星期五:Fri.=Friday
星期六:Sat.=Saturday
星期天:Sun.=Sunday
ben Tuesday the school trip
Jenny Tuesday have an Engliah speech contest
ben Jenny Wednesday the Art Festival
ben Friday birthday
Jenny Friday have a rock concert
需要中文解释吗?
英文表格 race 如何填写
oo的青春1年前3
hxfzj1998 共回答了15个问题 | 采纳率93.3%
民族
就写Han就OK呀
根据对话完成表格. 根据对话完成表格. John:How tall are you?      Wu:I'm 164cm
根据对话完成表格.
根据对话完成表格.
John:How tall are you?
Wu:I'm 164cm tall. How tall are you?
John:You're 4cm taller than me.
Wu:How old are you?
John:I'm 11 years old. How old are you?
Wu:I'm one year older than you.
John:I'm shorter than you.
Wu:And you're younger than me.
Name
Age
Height
Jone
eleven
1.
Wu
2.
164cm
1. 2.
teijin1年前1
zr521311 共回答了17个问题 | 采纳率82.4%
1. 160cm 2.twelve
根据表格内容完成短文初一英语
根据表格内容完成短文初一英语

灰尘迎面我呸1年前1
cottton 共回答了23个问题 | 采纳率69.6%
16 Friday
17 and
18 them
19 8:00
20 science
21 is
22、 10:00
23 、subject
24 math
25 lunch
More than 700 years ago,a17-year-old Italian boy根据短文内容完成表格
More than 700 years ago,a17-year-old Italian boy根据短文内容完成表格
短文
0ash21年前1
wangysupc 共回答了16个问题 | 采纳率100%
表格短文在哪儿?