Descriptive statistics - Analyze data

Which of the following is used to aggregate data in excel

• Average

• STDEV

• MAX

• SUM

The IF function returns

• One of two possible outcomes

• One outcome

• Two outcomes

• One of many possible outcomes

One of the following is not a valid logical operator

• =

• >

• <

• !

A data analyst needs to count the the number of large sales in the sales data. Large sales are sales above 200,000. How can he achieve this?

• Copy large sale to a new sheet then count using the pivot table

• Filter for large sales then count using the filter function

• Count all sales then determine large sales using count all function

• Checks for large sales and then count them using the count and if functions

Which of these is more accurate?

• The named range makes the reference to a cell static

• The named range changes the name of a range of cells for easy identification

• There is nothing as named range

• Named range makes a cell dynamic and easier to work with

Consider this string:

I Am A Data Analyst.

How can this case be obtained in excel functions?

• Upper

• Lower

• Case

• Proper

Which of these can be used as a delimiter when splitting a cell

• Tab

• Comma

• Space

• Hyphen

Using a delimiter, what function splits strings in one cell into multiple cells

• Text to field

• Split all

• Multi-cell

• Text to column

Data can be filtered in the pivot table

• Yes

• No

• Not in google sheets

The formulatext function

• Allows you to view the formula used in a cell

• Allows you to make use of formula with a function

• Allows spreadsheet to know the the data in the cell is a formula and should be treated as such

• There's no such thing