"电子表格练习一",,,,,

"序号","分组","列一","列二","列三","合计""1","A组","宋体字","红色字体","绿色背景","NULL""2","B组","隶书字","水平居中","黄字红背景","NULL""3","C组","国标楷体字","垂直居中","14号字体","NULL""4","D组","Arial体","双向居中","蓝色粗实边框","NULL""5","E组","随意选择","绿色双向居中","12号加粗","NULL""合并单元格",,"加粗字体","倾斜字体","垂中加下画线","左三项混合""注:","以上表格内容除未注明要求外,其它均应按要求体现原样!
""电子表格练习二",,,,"标题栏","列一","列二","列三","列四""行1","粗实线框","上下合并","左右合并并居中","行2","正常",,"四个格子合并并居中","行3","虚线框","上下合并并竖排",,"行4","右对齐",,"多个单元格合并,然后选择自动换行,最后选择水平方向与垂直双向居中!
!
!
","行5","美元符号$$$$",,,"行6","人民币符号$$$",,,"行7","百分比符号100%",,,"注:","1、以上表格边框颜色不同;","2、单元格合并后选择的不同对齐效果给人感觉也会有不一样!
""电子表格练习三""行号列位","列一","列二","列三","列四","列五","列六","列七","列八","列九""行1""行2""行3""行4",,,,"地心",,,,,"行5""行6""行7""行8""行9""注:","里外边框的套用效果!
""电子表格练习四""练习内容:","1、单元格大小,也即对列宽与行高的控制;,"2、练习特殊字符的输入表达样式.
"主题标题区域","本行高为23.
5个单位;,"本列宽23.
5个单位,高20个单位",,"本列宽为18个单位;,,"39102","-10010","以下均为1.
8个单位宽,共10列",,"-2500","右边每行高12个单位,共10行","1","2","3","4","5","6","7","8","9","0",,"0.
714285714285714",,"2",,"这才是文本型内容5/7",,"3",,,,"4",,,,"5",,,,"6",,,,"7",,,,"8",,,,"9",,,,"0""本单元格宽33.
5个单位,高45个单位,注意字体及效果!
"注:","表格的宽度与高度控制要精确.
""电子表格练习五""NO:填表日期:年月日""身份证号码""姓名",,,"性别",,,,"出生年月",,,,,,"照片",,"民族",,,"婚否",,,,"文化程度""专业",,,"户籍地""受教情况","就读时间",,,,"学校名称",,,,,,"学习方式",,"外语水平",,"电脑应用""工作经历","时间",,,,"工作单位及部门",,,,,,"职务",,"职责范围",,"求职意向",,,,"食宿要求",,,,"工作方式",,,,"月薪要求",,,"附加内容""特别说明""联系方式","QQ:89753025",,,,,,"E-MAIL:",,,"cfosea.
cn@sohu.
com",,,,,,"PERSONALHOMEPAGE:http://www.
cfosea.
cn/"说明:以上表格内容由sea自制,欲知进一步详情请与求职者本人联系.
"电子表格练习六""说明:","本次主要练习电子表格系统界面的设置及相关系统参数设置.

"本次练习的内容项目","1、在练习前同样需要制作完成本电子表格的制作工作;,"2、练习设置工具栏中的快捷图标的常用项显示情况,只显示"新建、打开、保存、打印、格式刷、求合、排序""字体、字号、加粗、倾斜、居中对齐、右对齐、合并居中、分隔号、背景色,字体色","3、显示/隐藏绘图工具栏操作;角度设置",,"4、练习将本行的内容分别以复制、剪切的方式粘贴到下一行;,"5、上一行操作完成后恢复本行内容;,"6、将""填充""向右填充三个单元格;",,,"填充",,,,,"7、在以下空格中向右填入一组序列号,起点值为1,步长值3;,,,,,,,,,"8、找出本表页中两处的文字"文本位置",并将说出其坐标位置;,"9、设置本表工作表的显示比例,分别为75%、25%并注意显示效果,然后还原;,"10、设置本表格打印时的页眉为"参数练习",页脚为"文档共#页,当前第#页","11、编辑本单元格的注释内容,输入"编辑完成"字样并设为红色字体!

,"12、在下面的表格图中插入一个单元格,形成一个"十"字形;,,,,,,,,,,,,,,,,,,,,,,,"注意本处不得超出边框!
",,,,,,,,,,,,,,,,,,,,,,,,,,"13、将本工作表的网格线设为蓝色,改变回车符回后光标的默认移动方向;,"14、设置本工作表的打印区域,将本表格的红虚线框架区域高为打印区域再取消;,"15、设定对本工作表的密码保护.
"特殊符号","今日气温37℃",,"因为所以符号∵∴",,"五星级",,,,,,,,,,,"注:","本练习要求先将表格制作完成,然后进行单项操作练习,并注意预览打印的效果.

,,,,,,,,文本位置""电子表格练习七""练习内容:","本练习主要练习如何美化文档,插入相关图片及内容的操作.

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"注:","本练习的相关操作除图片为外部插入外,其它主要从绘图工具栏选择插入,如艺术字!
""说明:"一、本练习资料由尘埃设计制作,允许任何人以任何方式进行复制或转载;"二、练习请按照练习一至练习七进行,以便练习由浅入深:"三、本练习资料主要应用于EXCEL学习的入门者及基础较薄弱者;"四、通过本练习,可完全适应一般办公环境下的常用工作需求(函数公式运用除外),,,,,,,"五、本练习的目标主要是试图通过练习操作,使用户了解如何在EXCEL中获取自己需要的操作功能,而并非仅仅教会如何操作.