Quiz Facts 1. Business - Office Technologies

Structured data extracts information from data and uses it to predict future trends and identify behavioral patterns.

Business analytics use techniques that describe past performance and history.

Predictive analytics use techniques that create models indicating the best decision to make or course of action to take.

4

Reports for each sales person, product, and part are examples of information granularities.

5

Business intelligence is both a core and extended ERP component.

6

Big data is a view of data at a particular moment in time.

7

Prescriptive analytics use techniques that create models indicating the best decision to make or course of action to take.

8

Top managers use predictive analytics to define the future of the business, analyzing markets, industries, and economies to determine the strategic direction the company must follow to remain profitable. Tony will set the strategic direction for his firm, which might include introducing new flavors of potato chips or sports drinks as new product lines or schools and hospitals as new market segments.

9

Predictive analytics use techniques that extract information from data and use it to predict future trends and identify behavioral patterns.

10

A dynamic report can include updating daily stock market prices or the calculation of available inventory.

11

A snapshot is a view of data at a particular moment in time.

12

The Internet of Things (IoT) refers to devices that connect directly to other devices.

13

Big data is a collection of large complex data sets, including structured and unstructured, which cannot be analyzed using traditional database methods and tools.

14

A worksheet, created by a company making toothbrushes, contains the following information within specified cells (given in brackets): Number of toothbrushes sold (K10), Sale price * number of toothbrushes sold (K11), transportation cost per toothbrush * number of toothbrushes sold (K12), the fixed cost (K13) involved in manufacturing the toothbrushes, and the net profit (K14). If the company wants to find the number of toothbrushes they have to sell to make a profit of $5,000, what must they enter in the "To value" field in the Goal Seek Dialog box?

15

Machine to machine (M2M) refers to devices that connect directly to other devices.

16

Technology provides countless business opportunities, but can also lead to pitfalls and traps for a business.

17

A variable is a business intelligence characteristic that stands for a value that cannot change over time.

18

Which of the following would not be considered part of the consistent characteristic of high-quality information?

19

_____ is an Excel function that works backward from an objective to compute an unknown value.

20

A worksheet, created by a company making toothbrushes, contains the following information within specified cells (given in brackets): Number of toothbrushes sold (K10), Sale price * number of toothbrushes sold (K11), Transportation cost per toothbrush * number of toothbrushes sold (K12), the fixed cost (K13) involved in manufacturing the toothbrushes, and the net profit (K14). If the company wants to find the number of toothbrushes they have to sell to make a profit of $5,000, what must they enter in the "By changing cell" in the Goal Seek Dialog box?

21

A biscuit manufacturer sells 10 packets of biscuits for $50. The cost involved in making 10 packets is $15, the cost of transporting 10 packets to the customers is $20, and the fixed costs involved amount to $5. If this information is put into a worksheet, what must one enter in the "To value" field of the Goal Seek dialog box to find the number of packets that need to be sold to make a profit of $200?

22

A list containing customer and customer purchase information has the following columns: customer name, location (of the customer, i.e., North, South, East, and West), customer income, customer age, and mode of payment during last purchase (cash or card). A pivot table is created dividing the customers based on their location. Which of the following would result in the creation of a three-dimensional pivot table?

23

Which of the following represents the steps for selecting the Goal Seek tool?

24

If you had a listing of customer information and you need to quickly group and summarize this information, which spreadsheet feature would you use?

25

What is the difference between a Filter and a pivot table?

26

Which of the following spreadsheet features allows you to quickly create a two-dimensional table with totals for groups of information?

27

_____ is an Excel function which allows you to view the entire list while having certain information called to your attention.

28

The results for a class of 10 after an examination are as follows: 56, 59, 64, 76, 78, 49, 62, 79, 86, 94. A teacher creates a list of students and their marks using spreadsheet software. To find the number of students who scored between 65 and 75, he selects the Custom Filter function and enters "Greater Than" 65 and "Lesser Than" 75 as his criteria. How many students will be selected?

29

Which of the following can be achieved using the conditional formatting function of Excel?

30

If you wanted customers who earned an annual income of less than $25,000 to appear in red, what spreadsheet feature would you use?

31

A psychologist wants to find the prevalence of stress-related disorders in patients between the ages of 30 to 55. He creates a list of all of his patients aged 55 or below who came to him with symptoms of stress. Using Excel software's Custom Filter function, he clicks on the "Age" column arrow box, and selects Number Filters. Which of the following steps must he subsequently follow to answer his question?

32

A list is created by the sales manager of a firm, listing the number of sales per week for the current financial quarter. The column for number of sales per week is as follows: 25, 37, 34, 56, 44, 26, 35, 35, 37. The sales manager wants to find the number of weeks where sales was above 37. Using Excel, he clicks on a cell in the list, on Data (from the menu bar), and on Filter. Subsequently, he clicks on the list box arrow next to the Sales/week column and selects 37. What will his answer be?

33

The _____ function allows you to use criteria such as greater than, less than, and so on, to create a sublist of required elements.

34

A company uses Excel to maintain a list of its customers. It maintains details of customer name, id, age, and region of residence (East, West, North, and South). If a manager wants a list of only those customers living in the North, which of the following functions of Excel can the manager use?

Find your answers, solutions and more...

We made it much easier for you to find exactly what you're looking for on Sciemce. Enjoy our search engine "Clutch."

Save a GPA. Donate your notes with us.

Quiz Facts 1. Business - Office Technologies

Recent Packs