大理学院数学与计算机学院上机实践报告

一、实验目的

         

                                                             

                                                                  

                                                                   

二、实验内容

                                                                      

                                                                      

                                                                      

                                                                     

                                                                              

三、实验环境

                                                                 

                                                                  

                                                                 、四、实验过程

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                             

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

                                                                 

五、实验总结

                                                                 

                                                                 

                                                                 

                                                                  

                                                                 

                                                                 

六、附录

 

第二篇：大学计算机基础实验二实验报告

实   验   报   告

程名称

课  大学计算机基础     实验名称     Excel图标的创建与编辑             

姓  名__ __   寸利芳   __ ___学  号_ 201107010125     __     专业班级_计1101              

实验日期___2011_ _ 年10_月_27_日   成绩_____        __     指导教师___杨文阳__      

一、实验目的。

1、学习图标的制作方法。

2、掌握图标的制作、编辑、修饰等基本操作。

二、实验内容。

按样例创建表格，然后按下面的操作建立图标，保存在D盘，文件名为Excel2.xls。

1.选定含有需要绘制数据的区域，嵌入柱形图。

2、为柱形图加入标题：“西安德华公司20##年销售统计表”。

3、对创建的图标修饰。

放大该图表。

将“类型合计”删除。

为“季度合计”增加以直显示的数据标记。

图表标题设置为方正姚体、18磅，选用圆角边框。

横坐标变为“386型”、“486型”、“586型”、“季度合计”。

将图标类型改为折线图。

三、操作过程。

①选择“插入”菜单下的“图表”命令,打开图表向导对话框 创建嵌入式柱形图。

②选择所创建的图标，选择图标下的图表选项命令，利用标题选项卡加入图表标题。

对图表操作。

①      选择图标，选族图标周围的某一手柄，按住鼠标键调整图表的大小。

②      选择图标，单击右键，选择源数据，在此对话框中重新定义图表所使用的区域。

③      选中季度合计的数据系列，单击右键，选择数据系列格式命令，在此对话框中，选择数据标志选项卡，选中值。

④      选中图表标题设置为方正姚体、18磅；单击右键，选择图标区格式命令，在图案选项卡中选择圆角。

⑤      选择一个数据系列，单击右键，选择数据系列格式，在此对话框中选择系列次序，选定486型，并向下移。

⑥      选族图标，单击右键，选择图标类型命令，选择折线图。