FINAL EXAM OF 2014S1

melbourne uni, spreadsheeting, fnce90045, 2014S1, final考试题目,不是pass paper.

Excel

Vba part 35

1,true false uncertain

Debugging tab in vba

Is it useless?

2. true false uncertain

Is function and sub procedure interchangeable

3. bsput prices, you need to write the function whole yourself, including the dim

4. taxable income function, use select case

5.geometric brownie motion, do not need the dim, use the for next

Excel part 35

1. true false uncertain

the #n/a name error occurs when the users type in the wrong name to login in

2. true false uncertain

formula group auditing could be error free?

Npv function, (给你一个截图,左边一竖条是period,右边一竖条是cf.然后从t=0开始.让你不要用数值,用命名的name来写公式.需要修改npv function来改变cf0.可用offset,index function) Tbillpricing function,给你一个截图,让你填日期,(个人觉得应该用date function?)

Csv file是什么.

How to produce a trading day list from 1900-1-1 to 2014-12-31, with non-trading days table in excel.

Assignment1, use advanced filter, auto fill in series, date ,step -1, weekday.

User want to produce a summary worksheet from csv files of several companies, with columns of trading days, volume and price. 这里用vlookup function.用上一题写好的trading day 作为lookup value.

User want to produce a statistic summary of the price and volume, which function should the user use. Give the max function as example.

可以用min,stdev,var,correl,covar,skew,mode,average

选择题:

1Counta function 是用来干嘛的

2在vba里,range的引用.Sales, sales,A1:B7,[]

3Sum function of two array,需要两个竖条array的乘积的和.用sum 和sumproduct function来选择

4Vba里,哪些function是不available的, normsinv, sum, rand, ln,sqrt

5Button = Msgbox “”,vbyesnocancel,”” 问你如果选了cancel,之后的return value是什么 6=if(6>average(1,2,3,4),”6 is greater than average(1,2,3,4)”) 出来的结果是什么

7Vba, private sub before-close,用在哪个module

8=”the money is:” & text(123.456,”$0.00#.##”) 出来的结果是什么

9哪几种方式是可以给一个range 来命名的, name manager-new, define name-new …. 10哪几个等式是得到一个同样的值的,有rand(),normsdist(),normsdist(rand()),log,ln 11Which of the following is not a valid name for VBA variable

Sub, function, …

12Which of the following is not a valid range name for excel

melbourne uni, spreadsheeting, fnce90045, 2014S1, final考试题目,不是pass paper.

C2, COSTS, C:C, C_C, AVERAGECOSTS

本文来源：https://www.bwwdw.com/article/1o2j.html