Software

When a spreadsheet application to create a line graph based on actual sales in the table below is used, the scale range of the vertical axis was automatically set between 0 and 1,500,000 yen. However, as the graph does not show clearly the change of sales over time, the change of sales needs to be more clearly shown without changing the frame size. Which of the following is the most appropriate chart editing operation?

As shown in the directory structure below, when D3 marked by an asterisk (*) is the current directory, which of the following the appropriate directory path that can designate file A under directory D4 marked by an arrow? Here, a file is designated as follows:

A certain company holds briefing sessions six times a month to attract customers. To manage the attendees in January by using spreadsheet software, a table is created as shown in cells A1 through D8. Then, to manage the attendees in February, cells A2 through D8 are copied to cells F2 through I8, and cell I3 is corrected. Which of the following is the appropriate expression to be entered into cell I3? Here, when the table for February is copied to the table for March, cells should be filled so that the expressions in cells do not have to be changed.

The types of programs that are executed at the startup time of a PC are generally classified into three categories: BIOS, OS, and startup services. Which of the following is the list that is arranged in the sequence of the execution of the programs?

A survey into the amount of pocket money is conducted at three (3) schools. When the consolidated results of the survey are used to calculate the average pocket money per student for all the students of the three (3) schools, which of the following is the expression that is entered into cell C5?

As shown in the spreadsheet below, three types of examinations were conducted. Each type of examination has a different perfect score. Each resulting score is converted to a value assuming 100 points as the perfect score, and displayed in cells F3 through H10. Which of the following is the expression to be entered in cell F3? Here, the expression in cell F3 is copied to cells F3 through H10.

An examination is conducted, and the results of the examination are grouped into four grades “Excellent,” “Good,” “Passed,” and “Not passed,” based on the scores by using spreadsheet software. To show the results of grouping in column C, an expression is entered in cell C1 and then copied to cells C2 through C35. Which of the following is the appropriate expression to be entered into cell C1? Here, the procedure for grouping is as shown below.

Which of the following is the expression to be entered into cell D4 in order to calculate the after-tax prices of the products shown in cells A4 and A5 by using the two tentative sales tax rates that are set in cells D2 and E2? Here, the expression to be entered into cell D4 is copied to cells D5, E4, and E5.

A hard disk failure occurred on a mail server, and e-mails of many users were lost. Recovery of data was attempted, but e-mails sent and received during the two-week period after the last backup could not be restored because backups were only created every two weeks. Taking a lesson from this incident, a measure is to be implemented to allow restoration up to the state of the day before such a failure. Which of the following is an appropriate measure?

Which of the following is an appropriate description concerning copyleft in the licenses of OSS (Open Source Software)?

Spreadsheet software is used to calculate the sum of two binary numbers α and β. The number of digits of α and β is limited to 2, and the values of the digits are entered in cells B3 and C3, and in cells B4 and C4, in the order of the 2’s place and the 1’s place. The worksheet is an example where the binary numbers are α = 10 and β = 11. The result is to be displayed in cells A5, B5 and C5 in the order of the 4’s place, the 2’s place and the 1’s place. Cell B2 is used to store information on the carry from the 1’s place, and the expression IF(C3+C4=2,1,0) is entered in it. Which of the following is the expression that is entered in cell B5?

In preparation for database failures, backup files are made every day after closing time. A full backup file is made every Saturday, and a differential backup file is made from Sunday through Friday. A differential backup file means a backup file of all the differential data from the last full backup file up to the day on which the differential backup file is made. Because the database was damaged on a Wednesday, a decision was made to restore the database to the state at the closing time on Tuesday, the previous day. Which of the following is the minimum set of backup files required to restore the database?

Among the descriptions below concerning the handling of OSS (Open Source Software), which of the following lists all and only the appropriate descriptions?

Which of the following is an appropriate combination of terms to be inserted into blanks A through C in the description below concerning the virtual memory system of an OS?

When a program is executed, it provides, without being restricted by the B capacity of the A unit of the computer, a C address space.

There is a spreadsheet worksheet that calculates the tax-included prices of products. The consumption tax rate is entered in cell B1, and the tax-excluded prices are entered in cells B4 through B6. To display the tax-included prices in cells C4 through C6, an expression is entered in cell C4 and copied to cells C5 and C6. Which of the following is the expression to be entered in cell C4? Here, cell B1 is displayed in percentage format.

Among the descriptions below concerning OSS (Open Source Software), which of the following lists all and only the appropriate descriptions?

Among the following OSs, which of the following lists all and only those that are provided as OSS (Open Source Software)?

Which of the following is an example where kinsoku processing (line breaking rules), a function of document creation software, was performed?

There is a file system that can be represented by a tree structure in which directories or files correspond to nodes. When it is represented as shown in the figure with the root directory as the root, which of the following is the most appropriate combination of what corresponds to a node, which is an intermediate node, and to a leaf, which is an end node? Here, empty directories are allowed.

Which of the following is an appropriate description concerning OSS (Open Source Software)?

Which of the following is the term for combining multiple files into one (1) for the purpose of saving and storing many files?

In a computer that uses virtual memory, it was found that the processing performance is decreasing because contents are frequently swapped between main memory and auxiliary storage. Which of the following is the most appropriate countermeasure to remove the cause of this decrease in processing performance? Here, the computer has only one (1) auxiliary storage device.

Which of the following is an appropriate description concerning OSS (Open Source Software)?