pre excel

Question 1

60. Which of the following Excel chart types is best suited for visualizing trends over time?

Accepted Answer

- b. Line Chart

Question 2

47. How does a stock chart differ from other charts in Excel?

Accepted Answer

- a. It requires historical data points

Question 3

20. The first step in the problem-solving process is:

Accepted Answer

- a. Defining the problem

Question 4

19. Algorithms are used to:

Accepted Answer

- c. Find optimal solutions systematically

Question 5

4. The evolution of Business Analytics includes:

Accepted Answer

- d. All of the above

Question 6

59. In Excel, what is the main advantage of using a PivotTable?

Accepted Answer

- b. It enables dynamic data summarization and filtering

Question 7

36. Which tool in Excel helps find the optimal solution to a problem under constraints?

Accepted Answer

- a. Solver

Question 8

37. Which logical function returns TRUE if all conditions are true?

Accepted Answer

- c. AND

Question 9

13. A decision model is primarily used for:

Accepted Answer

- b. Facilitating decision-making

Question 10

7. Prescriptive Analytics helps:

Accepted Answer

- c. Identify best solution

Question 11

56. What does a radar chart best represent?

Accepted Answer

- c. Multivariate data across multiple axes

Question 12

38. Which function returns the position of a value in a range?

Accepted Answer

- a. MATCH

Question 13

58. What does a Pareto analysis help identify?

Accepted Answer

- c. The most significant contributors to an outcome

Question 14

26. What is the term for the process of confirming that a spreadsheet model is free from logical errors?

Accepted Answer

- c. Validation

Question 15

28. Which logical function checks if at least one condition is true?

Accepted Answer

- b. OR

Question 16

50. Which of the following is the correct syntax for calculating the 75th percentile in Excel?

Accepted Answer

- a. PERCENTILE.INC(range, 0.75)

Question 17

11. Which type of data lacks a true zero point?

Accepted Answer

- c. Interval Data

Question 18

34. What does =COUNTIF (range, criteria) do?

Accepted Answer

- c. Counts cells that meet a condition.

Question 19

Business Analytics is important because it:

Accepted Answer

b. Enhances understanding of data

Question 20

25. Which function looks for data in the first column of a table?

Accepted Answer

- d. VLOOKUP

Question 21

54. Which of the following is NOT a measure of central tendency?

Accepted Answer

- c. RANGE

Question 22

16. Constraints in a model refer to:

Accepted Answer

- c. Limitations or restrictions

Question 23

14. Uncontrollable variables in decision models are:

Accepted Answer

- c. Beyond decision-maker control

Question 24

41. When working with geographic mapping in Excel, what data type is required?

Accepted Answer

- c. Geographic locations such as country names or coordinates.

Question 25

23. Which of the following is a key feature of Premium Risk Solver Platform?

Accepted Answer

- a. Advanced optimization algorithms

Question 26

31. What is Spreadsheet Engineering?

Accepted Answer

- a. The process of developing accurate and correct spreadsheet models.

Question 27

21. What is the purpose of the fill handle in Excel?

Accepted Answer

- a. To copy formulas or values

Question 28

55. When using sorting in Excel, why is it difficult to restore the original order?

Accepted Answer

- a. Excel does not store previous sorting states

Question 29

35. How do you reference a cell absolutely in Excel?

Accepted Answer

- b. $A$1

Question 30

22. Which formula finds a value based on a specific row and column position?

Accepted Answer

- d. INDEX

Question 31

9. Which of the following is an example of Categorical (Nominal) Data?

Accepted Answer

- c. Customer's location

Question 32

24. Which logical function allows for nested conditions in Excel?

Accepted Answer

- b. IF

Question 33

15. An objective function in optimization:

Accepted Answer

- b. Minimizes or maximizes a quantity

Question 34

39. Which add-in is used for descriptive statistics and regression analysis?

Accepted Answer

- b. Analysis Toolpak

Question 35

5. Descriptive Analytics focuses on:

Accepted Answer

- b. Understanding past and present data

Question 36

6. Predictive Analytics uses:

Accepted Answer

- b. Past performance data

Question 37

29. What is the purpose of the Analysis Toolpak VBA?

Accepted Answer

- a. Automating data analysis tasks through VBA programming

Question 38

30. What is the primary use of the Solver tool in Excel?

Accepted Answer

- c. Optimization and what-if analysis

Question 39

8. Data is defined as:

Accepted Answer

- b. Collected facts and figures

Question 40

49. Which chart type is best for showing the composition of a dataset where multiple categories are involved?

Accepted Answer

- b. Pie Chart

Question 41

44. In PivotTables, what function would you use to count the occurrences of a category?

Accepted Answer

- b. COUNT

Question 42

52. A bubble chart is most useful for comparing data points based on:

Accepted Answer

- b. Three variables

Question 43

17. Deterministic models are defined by:

Accepted Answer

- b. Fixed and known inputs

Question 44

43. Which of the following statistical values is NOT calculated in the standard Descriptive Statistics output in Excel?

Accepted Answer

- d. Hypothesis Test Results

Question 45

57. Which statistical function in Excel is used to calculate the middle value of a dataset?

Accepted Answer

- b. MEDIAN()

Question 46

42. What is an advantage of using slicers with PivotTables?

Accepted Answer

- b. They help filter data visually

Question 47

51. What key feature makes the Analysis ToolPak useful in Excel?

Accepted Answer

- b. It enables advanced statistical analysis

Question 48

53. In an Excel PivotTable, where would you place categorical variables?

Accepted Answer

- b. Rows or Columns

Question 49

18. Stochastic models differ from deterministic models because they:

Accepted Answer

- b. Have uncertain inputs

Question 50

Which of the following is NOT an application of Business Analytics?

Accepted Answer

c. Recipe development

Question 51

12. Ratio Data is characterized by:

Accepted Answer

- a. Continuous values with a natural zero point

Question 52

40. What does the =IF(condition, value_if_true, value_if_false) function do?

Accepted Answer

- d. Returns a value based on a condition.

Question 53

27. Which tool is used for predictive analytics in Excel?

Accepted Answer

- c. Analysis Toolpak

Question 54

10. Ordinal Data differs from Categorical Data because it:

Accepted Answer

- b. Is ordered or ranked

Question 55

32. Which add-in allows Monte Carlo simulations?

Accepted Answer

- d. Risk Solver Platform

Question 56

46. What is a key characteristic of an area chart?

Accepted Answer

- c. It visually emphasizes the magnitude of change over time

Question 57

48. What is the primary purpose of using filtering in Excel?

Accepted Answer

- b. To restrict the view to specific data subsets

Question 58

33. What is the function to calculate the arithmetic mean of a range?

Accepted Answer

- d. AVERAGE

Question 59

45. When performing a custom sort in Excel, which option allows for sorting by multiple columns?

Accepted Answer

- c. Sort & Filter > Custom Sort

Question 60

Business Analytics is the use of

Accepted Answer

d. All of the above

pre excel

Questions 60

pre excel

Questions 60