DATA ANALYSIS 101 (Formulas / Functions)

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:

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.