DATA ANALYSIS 101 (Formulas / Functions)
Authored by SEBASTIAN POVEDA
Computers, Instructional Technology, Other
8th - 9th Grade
Used 31+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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.
2.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Tick all key elements a Spreadsheet has.
Rows
Tools
Menus
Columns
Cells
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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.
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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.
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
To start using Formulas/Functions within Data Models. The Operator we must place first must be:
*
/
=
>
7.
FILL IN THE BLANK QUESTION
45 sec • 1 pt
According to the picture, the formula you must use to return the result in cell E11 might be:
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
