简答题:打开考生Excel文件夹中的某公司费用工作表,如下表所示: 公司历年费用支出情况表(万元)年度房租水电人员工资2011年

  • 题目分类:会计电算化
  • 题目类型:简答题
  • 查看权限:VIP
题目内容:
打开考生Excel文件夹中的某公司费用工作表,如下表所示:
公司历年费用支出情况表(万元)

年度
房租 水电 人员工资
2011年 18.35 14.23 31.65
2012年 21.56 17.24 43.78
2013年 27.65 21.56 56.89
总计



按要求对此工作表完成如下操作:
利用SUM函数分别计算3年来“房租”、“水电”、“人员工资”的支出总额,在B7、C7、D7单元格分别用MAX函数求出3年来“房租”、“水电”、“人员工资”的最大支出额的数值
参考答案:
答案解析:

阅读材料,回答题。It was a beautiful summer day and I was taking a w

阅读材料,回答题。It was a beautiful summer day and I was taking a walk in the downtown

查看答案

The story was said to have been based on the information fr

The story was said to have been based on the information from a reliable ______

查看答案

A season ticket __________ the holder to make as many journ

A season ticket __________ the holder to make as many journeys as he wished wit

查看答案

According to the American federal government, residents of

According to the American federal government, residents of Hawaii have the long

查看答案

A person who gets the basic necessities must __________ acc

A person who gets the basic necessities must __________ according to the writer

查看答案