Font size
WorksheetsDATA ANALYSIS 101 (Formulas / Functions)
Total questions: 11
Worksheet time: 9mins
A Data Model Is:
A database which uses Model Scenarios to add data.
A Financial, or Scientific model that uses Spreadsheets.
A document to model "What if" Scenarios.
Tick all key elements a Spreadsheet has.
Rows
Tools
Menus
Columns
Cells
The highlighted section in the picture covers a range from:
Columns A through B
Cells From 1A to 8B
Cells from A1 to B8
Rows 1 through 8
In order to center the title shown in the picture along the highlighted cells, we must
use the Merge (Combine) tool.
use the Wrap Text tool.
use the Center Align tool.
use the Middle Align tool.
In terms of use of formatting options, the following table contains:
Borders, number formatting, fill color.
Borders, number formatting, no fill.
No borders, currency formatting, fill color.
Borders, currency formatting, fill color.
To start using Formulas/Functions within Data Models. The Operator we must place first must be:
*
/
=
>
According to the picture, the formula you must use to return the result in cell E11 might be:
(a)
According to the picture, the formula/function you must use in cell I8 to return the average result might be:
AVERAGE(I4:I7)
=AVERAGE(I4:I7)
=AVERAGE(I4+I5+I6+I7)
=(I4+I5+I6+I7)/4
According to the picture, the functions you must use to return the most/least units sold in cells M8/M9 might be:
AVERAGE/MEAN
MOST/LEAST
COUNT/COUNTIF
MAX/MIN
Type the most appropriate function to round the average result obtained in cell M10 to one (1) decimal place.
(a)
How you feel during this Data Analysis Quiz?
Awesome! I have all/most of the questions correct!
That was a nice Activity!; I think I learned some new stuff!
I can't score high; nevertheless, I got some correct answers!
That was a though activity; I'm exhausted!
