Font size
WorksheetsreFocus Friday
Total questions: 27
Worksheet time: 4mins
This board is being used during Practice and QA, Outro and Goal-setting live sessions
(a)
Any lesson-related concerns, especially technical ones, should be directed to the...
Classmates
Community Managers
Mentors
Sales Managers
Module 2 Excel: Which of the following is the correct way to write the IF function?
=IF(condition, condition if false, condition if true)
=IF(condition:condition if true:condition if false)
=IF(condition, condition if true, condition if false)
None of these
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Jose Mari Chan
CM Dave
CM Menjie
CM Earl
What is the use of Pivot Table?
An interactive way to quickly summarize large amounts of data
To create visuals
So you can add individual values, cell references or ranges or a mix of all three.
none of these
The #VALUE! error appears when....
The value is too big
The values is in decimals
A value is not the expected type
None of these
When I get a rejected/approved status of my Home Assignment, I can find the feedback of the mentor in...
Thinkific
Discord
No feedback is being sent
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Ira
CM Dee
CM Kath
CM Angela
This is a technique that transforms available data into a story. It combines data visualization formats (such as graphs, charts, animated maps, and so on) with narrative elements. The goal is to use a somewhat complex amount of data to tell a story in a simple, concise way.
(a)
This is used to communicate with a database. It is a standard language for storing, manipulating and retrieving data in databases.
Data Storytelling
Excel
SQL
Pivot
How do I calculate the number of days, months, or years between dates in Excel?
(a)
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Angela
CM Nerma
CM Rosette
CM Tin
What type of chart is useful for comparing values over categories ?
Pie Chart
Column Chart
Line Chart
Dot Graph
Which function in Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
CHKNUM
Functions in MS Excel must begin with (a)
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Tin
CM Angela
CM Zie
CM Dee
In Excel, Columns are labelled as...
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
What type of chart is useful for showing trends or changes over time ?
Pie Chart
Column Chart
Line Chart
Dot Graph
What function displays row data in a column or column data in a row?
Hyperlink
Index
Transpose
Rows
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Dee
CM Tin
CM Ira
CM Kath
Which function will you use to enter current time in a worksheet cell?
=today()
=now()
=time()
=currentTime()
What to do with errors = #N/A ?
Check the spelling
Column width is not enough
Excel cant perform the formula
All of the these
Which type of visualization should never be used in a business setting?
Pie Chart
100% Stacked Bar Chart
100% Stacked Area Chart
3D Chart
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Dave
CM Eril
CM Ghio
CM Lois
When should we use a table instead of a chart?
When the data is very complex
When there are no real patterns in the data
When we are interested in looking up specific values in the data set
When the data is very simple
What is an appropriate gap width between the bars in a bar chart?
20%
30%
50%
100%
Know your Community Managers
Bonus Question: Who is this Community Manager?
CM Eril
CM Earl
CM Dave
CM Menjie
