Spread sheet Modelling Quiz 1
Quiz by Jamal Haider Naqvi
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
All of the following are rules that are common to good spreadsheet design, EXCEPT:
Create an area specifically for the variables (inputs) in the model
Enter a number directly into a formula, especially when you know it will change
Your model should be well-organized and nicely formatted
If your formulas are long or use complex logic, make sure to document them
60s - Q2
Which of the following fix the column reference to cell B6?
#B#6
$B6
B$6
$B4
60s - Q3
The_______ must precede all formulas in Excel, otherwise it will treat the formula as text and will not calculate the result
=
$
#
'
60s - Q4
What formula in cell H7 will allow you to calculate Total Current Assets/Total Current Liabilities?
=H1+H2+H3/H4
=(H1+H2+H3+H4)/H3
=SUM(H1:H4)/H4
=SUM(H1:H4)/H6
60s - Q5
Which of the following is the correct formula for cell B9 to calculate the net income?
=B2-B3-B4-B5-B6-B7+B8
=B2-SUM(B2:B8)
=B2-SUM(B3:B8)
=B2-(B3-B4-B5-B6)-B7-B8
60s - Q6
A common size income statement is constituted by dividing the income statement items to
Sales
gross profit
operating profit
Cost of goods sold
60s - Q7
which one is correct when you want to show a formula as text:
The cell in automatically text until you change the type numerical
Changing type as text and write in cell ='Sum(A1:A6)
'=sum(A1:A6)
='Sum(A1:A6)
60s
