Computer Concepts & Software ~ Semester 2 Exam Review

The MAX function in Microsoft Excel is used to determine the largest number in a list of numbers. It calculates and returns the maximum value from the given range of cells or numbers. In this case, since we want to find the largest number among 100 numbers, the MAX function is the appropriate choice.

This answer is correct because a one-to-one relationship occurs when there is exactly one record in the first table that corresponds to exactly one record in the related table. In this type of relationship, each record in one table is associated with only one record in the other table, and vice versa. It is a unique and direct relationship between the two tables, ensuring that each record has a single, specific match in the other table.

In any Microsoft program, the text that is placed within the bottom margin of a document is called the footer. The footer is typically used to display information such as page numbers, author name, date, or other relevant details that need to appear consistently at the bottom of each page in the document. It helps in providing additional context or reference to the content of the document.

Queries are a predefined format used to present questions to a database. They allow users to retrieve specific information from the database by specifying certain criteria or conditions. Queries help in extracting relevant data from the database and are an essential tool in data analysis and reporting.

In a database, a field title refers to the name given to a specific category or attribute of data. It helps to identify and organize the information stored in the database. In this case, "PART C" is an example of a field title as it represents a specific category or attribute within the database.

An input mask is a good way to format all of the above types of numbers (zip codes, telephone numbers, and social security numbers). An input mask is a predetermined pattern that is applied to an input field, allowing the user to enter data in a specific format. In the case of zip codes, telephone numbers, and social security numbers, input masks can be used to ensure that the numbers are entered correctly and consistently, following the required format for each type of number.

The type of "field" that every database must have is the primary key. A primary key ensures that each record in the database is unique from all others. It serves as a unique identifier for each record and is used to establish relationships between different tables in the database.

A report is a document that presents information retrieved from a table or query in a preformatted, attractive manner. It is commonly used to summarize and organize data in a clear and concise format, making it easier for the reader to understand and analyze the information. Reports often include headers, footers, titles, and other formatting elements to enhance the presentation of the data.

In a database, a record refers to a collection of related data fields that are grouped together. In this question, the given options are labeled as PART A, PART B, PART C, and PART C. Since PART A is mentioned only once and the other options are repeated, it can be inferred that PART A is an example of a database's record.

In Access 2007, one way to create a database is by using a database template. A database template provides a pre-designed structure and layout for creating a database. It includes predefined tables, forms, reports, and other objects that can be customized to suit specific needs. By utilizing a database template, users can save time and effort in designing and setting up a database from scratch, as the template already provides a foundation to build upon.

The cell with the dark border around it in Microsoft Excel is considered to be the active cell. The active cell is the cell that is currently selected and ready for data entry or manipulation. It is the cell that is affected by any actions or commands performed in Excel, such as entering data, applying formulas, or formatting.

The correct answer is "DEFAULT VALUE". In this context, "DEFAULT VALUE" refers to the pre-set length or size of a new text field, which is 255 characters in this case. The default value determines the maximum number of characters that can be entered into the text field.

A field is a single unit of data stored as part of a database record. It represents a specific attribute or characteristic of the record and holds the actual data values. Fields are used to organize and categorize data within a database, allowing for efficient storage, retrieval, and manipulation of information.

An absolute cell reference in Microsoft Excel is denoted by a dollar sign before both the column letter and row number. In this case, $A$4 is the only option that follows this format, making it the correct answer.

If the "IF" statement shown here was entered and filled down, the value "yes" would appear in cell D9.

The correct function to calculate the average of cells A1 through A15 is =AVERAGE(A1:A11). This function takes the range of cells A1 to A11 and calculates the average of the values in those cells.

A colon is used to define a range of adjacent cells in a formula in Microsoft Excel. For example, if we want to sum the values in cells A1 to A5, we would use the formula "=SUM(A1:A5)". The colon between A1 and A5 indicates that we want to include all the cells between A1 and A5 in the range.

The Lookup Wizard field type should be used when you want the user of the database to choose one entry from a list of four items. The Lookup Wizard allows you to create a dropdown list or a combo box that displays the available options for the user to choose from. This ensures that the user can only select one item from the list, providing a more controlled and accurate input for the database.

A "field" in a database refers to a specific category of information within a record. It is used to organize and store data in a structured manner. In this case, "PART D" is identified as the correct answer because it represents the part of the database that contains the fields.

The black symbol in the lower right corner of the active cell is called the fill handle. It is used by clicking and dragging to copy cell contents or create a series.