PHILNITS REVIEW 2

 

Which of the following represents the “S” and “W” in SWOT analysis?

• Schedule and Workings

• System and Workflow

• Security and Web

• Strengths and Weaknesses

Answer explanation

SWOT analysis is an analysis technique used for planning corporate strategies. The “S” stands for strengths, and “W” for weaknesses.

A net sales projection for the next fiscal year is being formulated for various markets, based

on a 15% market growth rate. The formula is entered in cell C4, and the contents of cell C4

are to be copied to cells C5 and C6. Which of the following formulas should be entered in

cell C4?

• =B4*(1+B1)

• =B4*1+B$1

• =B4*(1+B$1)

• =B4*B$1

Answer explanation

The net sales for the next fi scal year is calculated by multiplying the sales in the current fiscal

year for each market by the market growth rate plus one (1). When the formula is entered in

cell C4, it is copied to cells C5 and C6, so the reference to the market growth rate must be fixed to the first column. Therefore, the correct answer is =B4*(1+B$1) in b).

Ms. F is to summarize monthly sales performance in a table, by product. To calculate monthly sales performance by product, which of the following combinations of sales performance data is required?

• Product_name and Sales_amount

• Sales_date, Product_name, Category, and Sales_amount

• Sales_date, Product_name, and Sales_amount

• Sales_date, Product_name, Category, Unit_price, and Sales_amount

Answer explanation

In order to calculate the monthly sales performance by product, the sales_date, product_name,

and sales_amount are required at the very least.

a): The monthly calculation cannot be performed with only the product_name and

sales_amount.

c): The category is unnecessary for the sales performance by product.

d): The unit_price is unnecessary, since it is determined by the product.

 

It would appear that the amount of ultraviolet rays tend to increase when the concentration of the ozone layer decreases. Therefore, data is collected and examined. Which of the following is the most suitable type of diagram for this analysis?

• 
• 
• 
• 

Answer explanation

When using a scatter diagram, two (2) attribute values are used, one for the vertical axis and

another for the horizontal axis, so the correlative relationship between two (2) types of data

can be shown. To analyze the cause-effect relationship between low ozone layer concentration

and increased amounts of ultraviolet rays, a scatter diagram is the most suitable.

 

If the condition given below applies, which of the following is appropriate as an ER diagram showing the departments employees belong to?

Condition: An employee belongs to one department, and one department has one or

more employees belonging to it.

• 
• 
• 
• 

Answer explanation

Rectangular entities represent “employees” and “departments.” Each employee belongs to one (1) department, and each department has one (1) or more employees, so the arrow should point from the department to the employee (“many” side).

Which of the following is the correct characteristic of a Gantt chart?

• Allows you to grasp work start and finish schedules and achievements.

• Allows you to represent the relationship as a straight line when there is a correlation

  between two (2) types of data.

• Allows you to sort and display collected data and survey results by characteristic.

• Allows you to divide the range of compiled data into a number of segments and rep-

  resent the number of pieces of data in the segments using a bar graph.

Answer explanation

A Gantt chart shows the work schedule and results using horizontal bars. By placing hours or days on the horizontal axis and work items on the vertical axis, the order of work, the number of days required etc. can be managed.

When conducting testing in the following order, and items such as test case design and

manual verification according to the system’s requirements specification are taken into ac-

count, which of the following is the stage where it is desirable to have staff from the user does department participate?

Unit testing → Integration testing → System testing → Operational testing

• Unit testing

• System testing

• Integration testing

• Operational testing

Answer explanation

System requirements specification is carried out as part of systems architecture design. The

test process corresponding to systems architecture design is the system test (Comprehensive

test) that checks whether the system as a whole meets the requirements.

Unit tests are carried out for the programming process, joint tests are carried out for software

architecture design, and operations tests are carried out for the basic design process.

. 

The system administrator, Mr. N told Mr. M, “Peer-to-peer software such as Winny and Share has caused many incidents recently. That is why we established the rule _______.” Which rule number of the “Rules for Initial Settings of New PCs”

should be inserted in the above blank box ?

• 1

• 2

• 3

• 4

Answer explanation

Incidents of leaks of personal and confi dential information due to virus infections from in-

stalling software unrelated to work activities have been reported. The fundamental solution to

the problem is not to install software such as Winny and Share.

Which of the following graphs shows an ABC analysis of product sales by size? The vertical axis is sales, and the horizontal axis is size.

• 
• 
• 
• 

Answer explanation

An ABC analysis is an analysis technique used in areas such as sales management and inven-

tory control to clarify the importance and priority of products. It is used to manage the sales

situation of products by arranging them in descending order of amount of sales.

The results of a spreadsheet software skills test given to 100 people are shown in the table below. Which of the following is the correct average, median, and mode for the test results?

• A

• B

• C

• D

Answer explanation

The mean can be found by “Total of scores ÷ No. of people.” The median is the value at the

center position when the data is arranged in ascending or descending order, so it is 60. The

mode is the value that appears most often in the data, so it is 60.