Software
59 questions · IT Passport
When a record in a file is modified, which of the following is an appropriate way of identifying the modified contents?
Which of the following is an OS function that executes multiple application programs concurrently on a single PC by alternating between them, such as data is processed with spreadsheet software while a file is being downloaded from a website ?
When directories d1 and d2 are placed on a web server as shown in the figure, which of the following descriptions specifies the reference of the web page file f2.html on directory d2 from the web page file f1.html on directory d1 (current directory)? Here, the reference method of files is shown as below.
Among the descriptions below concerning Open Source Software (OSS), which of the following lists all and only the appropriate descriptions?
The types of programs that are running when a PC is started are broadly classified into three (3) categories, namely BIOS (Basic Input Output System), OS, and resident application programs. Which of the following is the order of execution of the programs?
Multiple files stored on a hard disk are used in work, from Monday to Friday. In order to handle failure of the hard disk, the data is backed up to another hard disk after the end of each day’s work. When the backup has following conditions, what is the total time required (in minutes) to perform backups of data from Monday to Friday?
Spreadsheet software is to be used to perform a calculation with the monthly sales data for each product shown in the worksheet below. When the expression “COUNTIF(B2:D2,>15000)” is entered in cell E2 and then copied to cell E3 and cell E4, which of the following is the value that is displayed in cell E4?
Which of the following is an Open Source Software (OSS) OS that is used in mobile devices such as smartphones and tablets?
In document creation software, spreadsheet software, and other such software, which of the following is a function that predefines and executes a series of operation procedures?
There is a desk that can hold at most four (4) files. On this desk, six (6) files A through F are used for a job. When the fifth file needs to be put on the desk, the file with the longest time since the last use among the four (4) will be put in a drawer. If the files are put on the desk and referenced in order of A, B, C, D, E, C, B, D, F, B, which of the following is the last file to be put in the drawer?
In a web server, five (5) directories have a hierarchical structure as shown in the figure below. In an HTML document stored in directory B, which of the following references the file img.jpg stored in the directory E? Here, directories and files are referenced using the method described below.
[Method of referencing directories and files]
(1)A file is referenced as “directory name/ ⋯ /directory name/file name”, where the directory names on the path are listed and separated with “/” in sequence, followed by the file name.(2)The current directory is represented by “.” (a period).(3)The directory one level above is represented by “..” (two (2) periods).(4)When a reference begins with a “/”, it is assumed that the root directory has been omitted from the beginning of the reference.(5)When a reference does not start with “/”, “.” (a period), or “..” (two (2) periods), it is assumed that “./” for the current directory has been omitted from the beginning of the reference.There is a system where a full backup is made after closing time every Sunday, and an incremental backup is made after closing time on Monday through Saturday. On a Wednesday, a failure happened during business hours, so a decision was made to restore data to the state at the closing time on Tuesday by using backup files. Which of the following lists all and only the necessary backup files for restoring data? Here, an incremental backup file means a backup file that contains only the data that has been modified since the previous backup (a full backup or an incremental backup) was made.
Which of the following is the appropriate description concerning Open Source Software (OSS)?
Spreadsheet software is used to predict sales according to the weather. The probability for the weather type (sunny, cloudy, rainy) on the day to be predicted and the predicted sales amount by weather type for each product are entered into the worksheet below. An expression is entered in cell E4 to calculate the predicted sales amount on the day for Product A, and this is copied to cells E5 through E6 and used. Under these conditions, which of the following is the appropriate expression to be entered in cell E4? Here, to obtain the predicted sales amount on the day for each product, the probability for each weather type is multiplied by the predicted sales amount for each of weather type, and then these values are added up.
If a process from when a PC is powered on to when it becomes ready to use is divided into four (4) stages, which of the following is the stage that is performed first?
In a file system with the hierarchy structure shown in the Figure, when “..\..\DIRB\Fn.txt” is specified from the directory marked with an * (the current directory), which of the following is the file that is referenced? Here, blank in the Figure show the directory name, and the reference method for a file is as below.
Which of the following is an appropriate description concerning OSS (Open Source Software)?
Sales data by month for each branch is evaluated. In the “Evaluation” field for each branch by month, if the amount of sales at the branch is below the average sales amount of branches A through C for the month, the symbol “X” is to be displayed, and if the amount is above or equal to the average, the symbol “O” is to be displayed. Which of the following is an appropriate expression to be entered in cell C3? Here, the expression that is entered in cell C3 is copied and used in cell D3, cell E3, cells C5 through E5, and cells C7 through E7.
On a desk that is only large enough to place four (4) files at the same time, six (6) files, A through F, are used to perform a task. When four (4) files are already placed on the desk, the least recently used file must be placed back into the drawer before the fifth file is placed on the desk. When the files are used in the sequence A, B, C, D, B, A, E, A, B, F, which of the following is the last file placed back into the drawer?
It is determined whether an examinee passed or failed by evaluating the score for two (2) subjects X and Y with a spreadsheet software program. The score of each subject is entered in cells A2 and B2 of the worksheet. When passing criteria (1) or (2) is met, “Pass” is displayed in cell C2, and otherwise, “Fail” is displayed. Which of the following is the expression that is entered in cell C2?
Among the descriptions A through C below concerning Open Source Software (OSS), which of the following is the list that contains all and only the appropriate descriptions?
The tax-inclusive prices of products A and B are calculated by using two (2) tax rates that are set in cells D2 and E2 below. The correct expression that should be entered in cell D4 is $B4*(1.0+D$2), but a wrong expression $B4*(1.0+$D$2) was entered. When the expression that was entered in cell D4 is copied to cells D5, E4, and E5, which of the following is the numeric value that is displayed in cell E5?
Which of the following is an OS function that executes multiple application programs concurrently on a single PC, such as when a file is downloaded from a website while data is processed with spreadsheet software?
When the spreadsheet shown below is converted into CSV format, which of the following is an appropriate list of data that is generated by spreadsheet software? Here, records are separated by the carriage return code “CR”. The expression in a cell is automatically recalculated, and the resulting value is written back into that cell. Although the entered expressions are shown in row 3 and column C below, the resulting values are actually displayed on the screen.
Which of the following is an appropriate description concerning OSs used for PCs?
Which of the following is an appropriate combination of the terms and explanations A through D concerning the file system of a hierarchical directory structure?
Among the descriptions A through C concerning OSS (Open Source Software), which of the following is the list that contains all appropriate descriptions?
If data is repeatedly added to and deleted from a hard disk on a PC, data may not be stored in consecutive areas on the hard disk. When no measures are taken, which of the following can most likely occur?
A search is performed by specifying a character string comprised of multiple alphabetic characters and one delimiter character “.” (period). An “*” (asterisk) represents an arbitrary character string with zero or more characters, and a “?” (question mark) represents an arbitrary single character. Which of the following is a character string that matches the character string represented below?
X*.Y??
In the description below concerning a file system, which of the following is an appropriate combination of terms to be inserted into blanks A through C?
When files and directories on a PC are managed hierarchically, the directory at the highest level is called the A directory, and the directory that a user is now manipulating is called the B directory. A notation that uses the B directory as its starting point and shows the location of a file or a directory is called a(n) C path.
Which of the following is an appropriate description concerning the OS for PCs?
Which of the following is software for performing basic control of hardware mounted on a gaming console, household appliances, etc.?
Which of the following is an appropriate combination of software that includes only OSS (Open Source Software)?
Which of the following is a purpose of the virtual memory system that is one of the functions provided by an OS?
Which of the following is an appropriate description concerning the use of OSS (Open Source Software)?
If data is repeatedly added to and deleted from a hard disk on a PC, data may not be stored in consecutive areas on the hard disk. When no measures are taken, which of the following can occur?
The diagram below shows the directory structure for a part of a certain file system. Which of the following is the reference from the current directory D3 (indicated with an asterisk “∗”) to the file “a” under the directory D4 (indicated with an arrow)? Here, files are specified as follows:
When character strings are searched by using wildcard characters, which of the following lists all and only the character strings that match the search expression “*A*.te??” among the character strings I through IV? Here, the wildcard character “?” represents any one (1) character and “*” represents a character string that consists of zero (0) or more of any characters.
When a record in a file is modified, which of the following is an appropriate way of identifying the modified contents?
What is the minimum amount (in Mbytes) of virtual memory that is required under the conditions below?
Which of the following explains the functions of an archiver, which is one (1) type of data management utility?
A spreadsheet program is used to create a quick reference chart for the compound interest per a principal of 1,000 dollars. Which of the following is the expression that should be entered in cell B4? Here, the expression in cell B4 is copied to each of cells B4 through F13.
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?
Unit: Yen
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?