Introduction to Spreadsheets (D100)

Correct Answer B. To evaluate how different inputs impact the outcome of calculations

Explanation

What-if analysis in a spreadsheet allows users to explore how changes in input values affect the outcome of calculations or results. This technique is commonly used for forecasting or making decisions based on various hypothetical scenarios. It helps users understand the sensitivity of their results to different variables, making it a powerful tool for decision-making, budgeting, and planning. By testing different input values, users can assess potential outcomes and adjust their strategies accordingly.

Why other options are wrong

A. To create a visual representation of data trends over time

This option is incorrect because creating visual representations of data trends over time is typically done through charts or graphs, not through what-if analysis. While what-if analysis may help inform the data used in such charts, the primary purpose of what-if analysis is to evaluate how changes in input values influence outcomes, not to create visual trends.

C. To format cells for better readability and presentation

This option is incorrect because formatting cells for better readability and presentation falls under formatting tasks, such as changing font styles, colors, and borders. What-if analysis, on the other hand, is focused on examining the effects of input changes on results, not on the appearance of the spreadsheet.

D. To automate repetitive tasks within the spreadsheet

This option is incorrect because automating repetitive tasks is done using tools like macros, not what-if analysis. What-if analysis involves testing different scenarios to understand how inputs influence outputs, whereas automation of tasks focuses on efficiency and reducing manual work, which is a different function altogether.

Correct answer A. Right-click on the row number and select 'Delete.'

Explanation:

To permanently remove a row from an Excel spreadsheet, you need to right-click on the row number (located on the left side of the spreadsheet) and choose "Delete." This removes the row entirely and shifts the remaining rows up.

Why other options are wrong:

B. Click on the row number and press 'Delete' on the keyboard.

Pressing 'Delete' only clears the contents of the row but does not remove the row itself. The row remains, but it will be empty.

C. Select the row and choose 'Remove' from the menu.

There is no "Remove" option in Excel for deleting rows. The correct option is "Delete."

D. Highlight the row and click 'Cut.'

Cutting a row only removes the data from the cells but does not delete the row. The row remains empty unless additional action is taken.

Correct answer B. Fill a range of cells following a particular pattern

Explanation:

The Fill button on the Home ribbon in Excel allows you to quickly fill a range of cells with data following a specific pattern or sequence. This is particularly useful for tasks such as filling in numbers, dates, or custom patterns. The feature saves time when you need to extend a pattern across multiple cells without having to manually enter each value.

Why other options are wrong:

A. Delete existing cell data

The Fill button does not perform any deletion of data. Instead, it fills cells with data based on the existing pattern or information in the selected range. Deleting data requires using the "Delete" key or the "Clear" option, not the Fill button.

C. Create new cells in the worksheet

The Fill button does not create new cells. It is used to populate existing cells with data according to a pattern or sequence. If you need to add new cells to a worksheet, you would use the "Insert" options in the ribbon, not the Fill button.

D. Apply formatting to selected cells

The Fill button is not used for applying formatting, although it may fill cells with specific data or patterns. Formatting cells such as changing fonts, colors, or borders would be done using the formatting tools in the Home ribbon. The Fill button specifically deals with data entry and not formatting.

Correct Answer B. Horizontal or vertical lines that span across the chart

Explanation

In Excel 2016, gridlines are the horizontal or vertical lines that span across the chart to help visually align and separate data points. These lines make it easier to interpret the values displayed on the chart by providing reference points. Gridlines do not directly represent data but serve as a guide to better understand the scale and values being presented in the chart. By default, gridlines are visible in most chart types, but they can be customized or removed if needed.

Why other options are wrong

A. Numeric values that describe a single value on a chart

This option is incorrect because gridlines are not numeric values; they are visual elements that help in reading the chart. Numeric values are typically shown on the axes of the chart, not as gridlines.

C. Lines used to depict trends and forecast future data

This option is incorrect because gridlines do not represent trends or forecasts. They are static visual lines used to aid in reading and interpreting the chart's data but do not indicate any data patterns or future predictions.

D. A visual representation of numerical data

This option is incorrect because a visual representation of numerical data refers to the chart itself, not the gridlines. The gridlines are a guide within the chart, while the chart itself is the graphical representation of the data.

Correct Answer C. It ensures that financial data is easily readable and understood.

Explanation

Formatting cells as currency is crucial for presenting financial data clearly and consistently. By using the currency format, Excel automatically includes the correct currency symbols (e.g., $, €, £) and ensures the numbers are displayed with the appropriate decimal places. This formatting helps users quickly identify financial data and makes it easier to comprehend, especially in reports or documents where multiple financial figures are involved.

Why other options are wrong

A. It makes the spreadsheet look more colorful.

While formatting may add some color to the spreadsheet, the main purpose of currency formatting is not aesthetics but rather to ensure financial data is clear and easily understood. The goal is to make the numbers more comprehensible, not to simply add color.

B. It helps in distinguishing between different data types.

Currency formatting does indeed help distinguish financial data from other types of data like text or dates. However, the primary reason for using currency formatting is to ensure the financial figures are correctly understood, not just to distinguish data types.

D. It allows for the automatic calculation of totals.

Currency formatting does not affect the calculation of totals or formulas in a spreadsheet. The calculations will work the same way regardless of the cell formatting. The currency format only affects how the data is displayed, not the underlying calculations.

Correct answer C. Percentage of net sales by product for Lenovo in Year 1

Explanation:

A pie chart is most useful when displaying proportions of a whole in a visual format. Since percentages of net sales by product represent parts of a total revenue distribution, a pie chart effectively illustrates how each product contributes to the overall sales.

Why other options are wrong:

A. Heights of high school freshmen.

A pie chart is not suitable for this data set because heights are numerical values that do not represent parts of a whole. A histogram or box plot would be more effective for analyzing height distributions.

B. Growth rates of firms in a particular industry.

Growth rates are better visualized using a bar chart or line graph rather than a pie chart because they represent independent values rather than parts of a whole. A pie chart would not effectively show trends or comparisons over time.

D. Ambient temperatures in the US capitol building.

Temperature readings are continuous data that vary over time, making a line chart or scatter plot more appropriate. A pie chart is not suitable because temperature measurements do not represent proportions of a whole.

Correct answer B. =B5-C5

Explanation:

The subtraction operator (-) is used in Excel to find the difference between two values. The formula =B5-C5 subtracts the value in cell C5 from the value in cell B5, giving the difference. This is commonly used in financial and business spreadsheets to track changes in sales, expenses, or profits over time.

Why other options are wrong:

A. =B5+C5

This formula adds the two values instead of calculating the difference. Addition is useful for summing sales but does not determine a change in sales figures.

C. =C5-B5

While this also calculates a difference, it subtracts in the opposite order, which may lead to a negative result if B5 is larger than C5. The correct order depends on the context of the calculation.

D. =B5*C5

This formula multiplies the values in B5 and C5 instead of finding the difference. Multiplication is used for calculating totals, percentages, or projections, not for determining changes.

Correct answer B. Adjusting column widths and applying consistent font styles

Explanation:

Ensuring readability and professionalism in a spreadsheet presentation requires proper formatting, including adjusting column widths for clarity and applying consistent font styles. This makes the data easier to read, reduces visual clutter, and maintains a polished appearance for stakeholders.

Why other options are wrong:

A. Using a variety of font colors for each cell.

While color can help differentiate data, excessive use of different colors can be distracting and reduce readability. It is best to use subtle color coding sparingly and consistently.

C. Inserting multiple pie charts for each data set.

While visualizations like pie charts can be helpful, using too many can make the presentation overwhelming and less effective. Some data sets may be better represented with bar charts or line graphs instead.

D. Leaving the cells unformatted for a clean look.

An unformatted spreadsheet can appear cluttered and difficult to read, especially when presented to stakeholders. Proper formatting, including bold headers, gridlines, and alignment, improves clarity and comprehension.

Correct Answer B. A reference that remains constant regardless of where it is copied

Explanation

An absolute cell reference in a spreadsheet is a reference that remains fixed no matter where it is copied within the spreadsheet. It is denoted by placing dollar signs before both the row and column references (e.g., $A$1). This ensures that when the formula containing the absolute reference is copied to another cell, the reference does not adjust based on the new cell’s position. Absolute references are essential for maintaining consistent references to specific cells when performing calculations across multiple locations.

Why other options are wrong

A. A reference that changes when copied to another cell

This option is incorrect because it describes a relative cell reference, not an absolute one. In a relative reference, the reference changes when the formula is copied to another cell, adjusting based on its new location. This is the opposite of an absolute reference, where the reference remains fixed.

C. A reference that only applies to formulas

This option is incorrect because an absolute reference can be used in various contexts, not just in formulas. Although absolute references are commonly used in formulas, they can be applied to any cell reference in a spreadsheet, regardless of whether a formula is involved.

D. A reference that is automatically generated by the spreadsheet software

This option is incorrect because absolute references are manually created by the user by adding dollar signs to the row and column references. Spreadsheet software automatically uses relative references unless specified otherwise by the user. Absolute references do not get generated automatically without user input.