Quiz 3 SEC A

The intersection of a column and a row on a worksheet is called a cell. A cell is the smallest unit of a worksheet and is identified by its unique address, which is a combination of the column letter and the row number. Cells are used to store and display data in a spreadsheet, and they can contain various types of information such as text, numbers, formulas, and formatting.

Functions in MS Excel must begin with an equal sign because the equal sign is used to indicate that a formula or function is being entered. By starting with an equal sign, Excel recognizes that the following characters are part of a formula rather than regular text. This allows Excel to calculate the result based on the specified function or formula.

The data type "Label" is not found in MS Excel. MS Excel offers various data types for organizing and analyzing data, such as Number, Currency, and Date/Time. However, there is no specific data type called "Label" in MS Excel.

The correct answer is B1:E5 because in Excel, a range is denoted by specifying the starting cell followed by a colon and then the ending cell. In this case, B1 is the starting cell and E5 is the ending cell, so the range is B1:E5.

A pie chart is useful for comparing parts of a whole because it visually represents the proportions of different categories or components in relation to the whole. The chart is divided into slices, with each slice representing a specific category or component. The size of each slice corresponds to the proportion or percentage it represents in relation to the total. This allows for easy comparison and understanding of the relative sizes or percentages of the different parts of the whole.

When we create a new Excel file, there are typically three sheets that are created by default. These sheets are named Sheet1, Sheet2, and Sheet3. These sheets can be used to organize and store different sets of data within the same Excel file.

A 3-D reference in MS-Excel is a reference that spans multiple worksheets. It allows you to perform calculations or retrieve data from multiple worksheets at once. Unlike regular cell references, a 3-D reference cannot be modified or changed. It is useful when you want to consolidate data from multiple worksheets or perform calculations across multiple sheets.

Filtering is a feature that displays only the data in column(s) according to specified criteria. It allows users to narrow down the data set and view only the information that meets certain conditions. By applying filters, users can easily identify and analyze specific data subsets, making it a useful tool for data analysis and exploration.

In MS Excel, the "#" sign is displayed when there is a formula error. This error can occur when there is a problem with the formula syntax, such as using incorrect operators or not closing brackets properly. When the formula error is detected, Excel displays the "#" sign to indicate that there is an issue with the formula. The user can then investigate and correct the error to ensure accurate calculations.

The active cell on an excel sheet is indicated by a dark wide border. This helps the user easily identify which cell they are currently working on or selecting. The dark wide border stands out from the other cells and provides a visual cue to the user.

The default style for new data keyed in a new workbook is "Normal". This means that any data entered will have the default formatting, such as regular font, no special number formatting, and no currency or percent symbols.

To protect a worksheet in MS-Excel, you can choose "Protection" and then select "Protect Sheet" from the "Tools" menu. This option allows you to secure the worksheet by preventing users from making any changes to the data or formatting. By selecting this option, you can restrict access to the worksheet and ensure the integrity of the information it contains.

A column chart would be the best choice to compare the performance of sales of two products. This type of chart uses vertical columns to represent different categories or groups, making it easy to compare the sales figures of the two products side by side. The height of each column corresponds to the sales value, allowing for a clear visual comparison of the performance. A line chart, on the other hand, would be more suitable for showing trends over time, while a pie chart is used to represent proportions or percentages. "Both A and B" is not a valid answer as it is not clear what A and B refer to.

The Auto Fill feature of MS Excel quickly completes a series of data by automatically filling in values based on a pattern or existing data. It saves time and effort by predicting the desired sequence and filling it in for the user. This feature is particularly useful when working with repetitive data such as dates, numbers, or text.

A line chart is the most suitable type of chart for showing trends or changes over time. It uses a series of data points connected by lines to represent the progression of a variable over a specific period. This allows for a clear visualization of how the data changes over time and makes it easy to identify patterns or trends. Unlike a pie chart or column chart, a line chart focuses specifically on the relationship between the data points and their chronological order, making it ideal for tracking changes over time. A dot graph is not a commonly used chart type for showing trends or changes over time.

The correct answer is Data because the Sort option is typically found under the Data menu in MS Excel. This option allows users to organize and arrange data in ascending or descending order based on specific criteria such as numbers, dates, or alphabetical order. By selecting the Data menu, users can easily access the Sort option and apply sorting functionality to their spreadsheet.

The correct answer is D. Both (b) & (c). This is because in MS-Excel, data markers on a chart are linked to data points in a worksheet. This means that if you change the position of a data marker, it will automatically change the data point value in the worksheet (option b). Similarly, if you change a data point value, it will automatically be drawn in the chart (option c). Therefore, both options b and c are correct.

Sorting is the correct answer because it refers to the process of arranging the items in a column in a specific sequence or order. This can be done in ascending or descending order based on certain criteria, such as alphabetical order, numerical order, or chronological order. Sorting allows for better organization and easier access to the data, making it a fundamental operation in data management and analysis.

The Weekday function in MS-Excel calculates the number of weekdays between two dates. In this case, it will calculate the number of weekdays between 6/9/2013 and 8/12/2013. This function excludes weekends (Saturday and Sunday) from the calculation, so it will give the number of workdays (Monday to Friday) between the two dates.

The correct answer is "Graph" because "Graph" is not a type of chart that exists in MS Excel. MS Excel does have other types of charts such as Scatter, Line, and Doughnut, but "Graph" is not one of them.