XLS《练习一》

"电子表格练习一",,

,,

, "序号","分组","列一","列二","列三","合计" "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:",,

,"[email protected]",,

,,

, ,"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中获取自己需要的操作功能,而并非仅仅教会如何操作. ,,

,,

,,

, "网名:","尘埃" "性别:","先生" "QQ:","89753025" "E_Mail:","[email protected]" "个人网站:","http://www.cfosea.cn" "个人简介:","想了解的可以加本人QQ,不想了解的说了也没用!"