2021 Financial Modeling Using Excel(Dongbei University of Finance & Economics)1465518477 最新满分章节测试答案

本答案对应课程为:点我自动跳转查看
本课程起止时间为:2021-09-27到2022-01-31
本篇答案更新状态:已完结

【作业】1. Excel Basics Excel Basics Course Data

1、 问题:Please finish all Excel contents. 
评分规则: 【 Completed all Excel contents
】

【作业】2. Corporate Finance Corporate Finance Course Data

1、 问题:Please finish the online course
评分规则: 【 Finish the exercise
】

【作业】3. Bond Bond Course Data

1、 问题:Finish the Excel online course
评分规则: 【 Finish the Excel online course
】

【作业】4. Option Option Course Data

1、 问题:Option online course
评分规则: 【 finish the course
】

【作业】5. Portfolio Management Portfolio Management Course Data

1、 问题:Please finish the course
评分规则: 【 Finish the course
】

【作业】6. Stock Valuation Stock Valuation Course Data

1、 问题:Stock valuation online course
评分规则: 【 finish the course
】

1. Excel Basics Test 1

1、 问题:If you want to find the number of product sale based on different salesman, how to fill the D12?INDEX(array, row_num,column_num)MATCH(lookup-value,lookup-array,match-type)
选项：
A:=INDEX(B3:F9,MATCH(B12,B4:B9,0),MATCH(C12,C3:F3,0))
B: =INDEX(B3:F9,MATCH(C12,C3:F3,0),MATCH(B12,B4:B9,0))
C: =INDEX(C4:F9,MATCH(B12,B4:B9,0),MATCH(C12,C3:F3,0))
D: =INDEX(C4:F9,MATCH(C12,C3:F3,0),MATCH(B12,B4:B9,0))
答案: 【 =INDEX(C4:F9,MATCH(B12,B4:B9,0),MATCH(C12,C3:F3,0))】

2、 问题:If you want to set up the drop-down menu in B12, How to do it? 
选项：
A:Data-Data Validation-Setting tab, Allow box select Any数据—数据有效性—有效性条件允许选择任何值
B:Data-Data Validation-Setting tab, Allow box select List数据—数据有效性—有效性条件允许选择序列
C:Data-What-If Analysis—Data Table数据—模拟分析—模拟运算表
D: Data-What-If Analysis—Goal Seek数据—模拟分析—单变量求解
答案: 【Data-Data Validation-Setting tab, Allow box select List数据—数据有效性—有效性条件允许选择序列】

3、 问题:In the following table, how to fill in D13 and how to do the arrow? RANK(number,ref)
选项：
A: =RANK(B13,B13:B19)     Conditional Formatting-Icon Set 图标集
B: =RANK($B$13,$B13:$B19)   Conditional Formatting-Color Sacles 色阶
C:=RANK(B13,$B$13:$B$19)    Conditional Formatting-Icon Set 图标集
D:=RANK($B$13,B$13:B$19)    Conditional Formatting-Color Sacles 色阶
答案: 【=RANK(B13,$B$13:$B$19)    Conditional Formatting-Icon Set 图标集】

4、 问题:If you want to freeze panes, fixed the first row and the first two column, how to do? 
选项：
A:Select C2, Freeze first row
B:Select C2, Freeze panes
C:Select B3, Freeze panes
D:Freeze top row then freeze first column
E:Select B2, Freeze first row
F:Select C2, Freeze first column
答案: 【Select C2, Freeze panes】

5、 问题:How to set up B20, and then drag to the right to fill in all the number? VLOOKUP(lookup_value, table_array,col_index_num,[range_lookup])range_lookup: FALSE(exact match), TRUE(approximate match)
选项：
A:=VLOOKUP($A20,$A$15:$G$18,COLUMN(A1),FALSE)
B:=VLOOKUP(A20,A15:G18,COLUMN(A1),FALSE)
C:=VLOOKUP($A20,A15:G18,COLUMN(B1),FALSE)
D:=VLOOKUP($A20,$A$15:$G$18,COLUMN(B1),FALSE)
E:=VLOOKUP($A20,$A$15:$G$18,COLUMN(B1),TRUE)
F:=VLOOKUP(A20,A15:G18,COLUMN(A1),TRUE)
G:=VLOOKUP(A$20,$A$15:$G$18,COLUMN(B1),FALSE)
答案: 【=VLOOKUP($A20,$A$15:$G$18,COLUMN(B1),FALSE)】

6、 问题:In the Excel, if you want to fix the cell A1, only fixed the row, how to do? What’s the fast button to fixed the cell?
选项：
A: $A$1  F4
B:$A1   F4
C:A$1   F4
D:$A$1  F2
E:A$1   F2
F:A$1   F5
答案: 【A$1   F4】

7、 问题:If in the following graph, how to draw the column D?
选项：
A:Conditional Formatting—Icon Set
B:Conditional Formatting—Data Bar
C:Conditional Formatting—Color Scale
D:Insert—Sparklines
答案: 【Conditional Formatting—Data Bar】

8、 问题:In Excel, the location for C4 means?
选项：
A:Row 3 and Column 4
B:Row 4 and Column 3
C:Row 3 and Column 3
D:Row 4 and Column 4
答案: 【Row 4 and Column 3】

9、 问题:In Excel, if you want to select not continuous columns,how to do?
选项：
A:Alt
B:Shift
C:Ctrl
D:Shift+Ctrl
E:Ctrl+Shift+Enter
答案: 【Ctrl】

10、 问题:what’s the keyboard shortcuts for copy and paste?
选项：
A:Ctrl+A
B:Ctrl+N
C:Ctrl+Z
D:Ctrl+C/Ctrl+V
答案: 【Ctrl+C/Ctrl+V】

11、 问题:If you want to open a new workbook, what’s the keyboard shortcuts?
选项：
A:Shift+N
B:Ctrl+N
C:Alt+N
D:Ctrl+Alt+N
答案: 【Ctrl+N】

12、 问题:If you want to put a line break in a cell, creating a multi-line cell, how to do?
选项：
A:Alt+Enter
B:Ctrl+Enter
C:Shift+ENter
D:Ctrl+Alt+Enter
答案: 【Alt+Enter】

13、 问题:what’s the result for Row(C5)?
选项：
A:2
B:3
C:4
D:5
答案: 【5】

14、 问题:What’s the result for Column(D2)?
选项：
A:2
B:3
C:4
D:5
答案: 【4】

15、 问题:In cell A2, you fill in 1.5, in cell A3 you put in 2, and the you select A2:A3 together and using the fill handle, what’s the number in A4?
选项：
A:2.5
B:3
C:1.5
D:2
答案: 【2.5】

16、 问题:If you only want to fixed column, how to do for A1?
选项：
A:A1
B:$A1
C:A$1
D:$A$1
答案: 【$A1】

17、 问题:If A1=68, A2=76, A3=85, A4=90, what’s the number should be =MATCH(A3,A1:A4,0)?MATCH(lookup-value,lookup-array,match-type)
选项：
A:1
B:2
C:3
D:4
答案: 【3】

18、 问题:If A1=68, A2=76, A3=85, A4=90, what’s the number should be =INDEX(A1:A4,3,1)?INDEX(array, row_num,column_num)
选项：