44. In an ERP (Enterprise Resource Planning) system like SAP (as used in ERPsim

Question

44. In an ERP (Enterprise Resource Planning) system like SAP (as used in ERPsim lab sessiona), the MRP (Materials Requirements Planning)transaction automatically calculates the additional inventory items needed based on: . Looking at current inventory only b. Calculating the difference between the saved Sales Forecast per product and the curzent inventory per product c. Check current sales orders and multipiying by 20 daya d. Using ZMarket transaction to determine future sales for next 5 day interval 45. When comparing PC applications and an ERP system 1ike SAP, which of the following statements is true: a. ERP system coordinates activities within the company and allows real-time data sharing b. ERP systems have a very familiar user intorface similar to desktop PC' s single user office applications c. ERP systems require over an hour to output a summary report on inventory status. d. ERP system only support US currency and US tax regulations 46. An Excel Pivot table provides the capability to productively and Logically organize data: a. Sorted in ascending alphabetical order b. Without changing the order of the referenced source data c. Temporarily filtered d. By keyword search 47. When inserting a pivot table, the user much click on source data including: Only original data without headers and totals b. Multiple rows of headers at top of columns containing data Original data with a single top row of headers above columns d. All contents on the source worksheet whether or not it will be used in the pivot table. 48. The strength of pivot tables is: a. Their flexibility in quickly reorganizing sub-groups b. The summary provided by producing sub-totals for every grouping c. The use of value field selections to pick top/bottom of entries, or comparisons of values. d. That one numeric value in the source data can be used in multiple ways in same pivot table such as use as a direct value and a percent value of grand total. All of the above 49. When is the most appropriate time to use an absolute cell reference? a. When planning to copy a formula to another worksheet b. When plan ning to copy a formula down the column and want to maintain the same exact cell reference for a parameter in the assumptions area lanning to copy a formula into cells to the right in the same row and nsure that the referenced cell location is updated to maintain a relativ c. When p also e position the formula. formula like Payments 1.e. d. When using a cell reference in a built-in Excel PMT

Explanation / Answer

44)
Ans:d)
SAP atomatically calculates the additional inventory items needed based on,using zmarket transaction to determine future sales for next several days interval.

45)
Ans:
a)ERP system coordinates activities within the company and allows organizations to sare real-time data

46)
Ans:
c)Temporarly filtered. We can make filters and organize data by using pivot table.

47)
Ans:b)
Multiple rows of headers at top of columns coontaining data.

48)
Ans: e)
All above are main functionalities of pivot table

49)Ans: b)

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.