logo

Crowdly

Browser

Add to Chrome

Questions Bank (1550646 total)

What term is used to describe brief, generally small, visuals that fit within one cell in Excel that visually depicts what happened in the cells next to it?

❌
❌
✅
❌
View this question

Based on Lab 2.1 Excel: Identify and Work with Different Data Types, and the exhibit below, which of the following measures would appear in the status bar (marked with the number 2 in the screenshot) when selecting the collection of product descriptions marked with the number 1?

A table shows an excel sheet with 7 columns and 7 rows. The headings of columns 1 to 7 are as follows: sales_order_ID; sales_order_date; sales_employee_ID; customer_ID; sales_order_quantity_sold; product_description; product_sales_price. The row entries are as follows: row 2 - 20001; 11 / 1 / 2024; 1006; 2056; 10; pale ale; blank. Row 3 - 20005; 11 / 1 / 2024; 1006; 2012; 8; pale ale; blank. Row 4 - 20017; 11 / 7 / 2024; 1006; 2043; 1; pale ale; blank. Row 5 - 20080; 11 / 29 / 2024; 1007; 2021; 11; pale ale; blank. Row 6 - 20140; 12 / 20 / 2024; 1006; 2002; 5; pale ale; blank. Row 7 - 20183; 1 / 1 / 2025; 1006; 2034; 7; pale ale; blank. Rows 2 and 3 of column 6 are marked 1 and the bottom right of the status bar is marked 2.

✅
❌
❌
❌
View this question
Confirmatory business analytics includes:
❌
❌
❌
✅
View this question

Diagnostic analysis includes all of the possible types of analytics except for which of the following?

✅
❌
❌
❌
View this question

What is being graphed in the chart?

The line chart shows the sales revenue with sales order month on the x axis and sales in amount of dollars in the y axis. The x axis ranges from May 2017 to November 2020 in increments of 6 months. The y axis ranges from $0 to $120,000 in increments of $10,000. The line passes by the following point at (May 2017, $30,000) and fluctuates and goes up and to the right and ends on the to right of the first quadrant at (November 2020, $90,000). All values are estimated.

0%
0%
0%
0%
View this question

Which of the following would be considered an example of structured data?

❌
✅
❌
❌
View this question
Which data type would financial statement data generally be considered to be?
0%
❌
0%
0%
View this question

According to the SOAR model, the analyst should know the question they are trying to address before considering and accessing available data.

0%
0%
View this question

Which type of analytics will provide insight on whether the company should rent or own its headquarters?

❌
✅
❌
❌
View this question

Based on the box plot created in Lab 3.2 Excel, Using the Excel Analysis ToolPak to Calculate Descriptive Statistics to Gain Insight About the Distribution of a Sales Data Set, what is the median for in-person sales?

The figure shows a box plot for in-person sales. The vertical axis ranges from 0 to 120 in increments of 20 units. The lower whisker has a value of 2.87. The first quartile has a value of 12.52. The median or the second quartile has a value of 26.97. Inside the box the mean value is X33.64156863. The third quartile has a value of 52.52. The upper whisker has a value of 98.42.

0%
0%
0%
0%
View this question