D100-Introduction to Spreadsheets

Correct answer D. Right-click and choose 'Format Cells'.

Explanation:

The first step to format numbers with commas in Excel is to right-click the selected cells and choose "Format Cells". In the Format Cells dialog box, navigate to the Number tab, select Number format, and check the option to use a thousands separator (comma). This ensures that large numbers are displayed in a readable format (e.g., 1,000 instead of 1000).

Why other options are wrong:

A. Click on 'decrease decimal'.

The "Decrease Decimal" option only reduces the number of decimal places displayed. It does not add commas to separate thousands.

B. Click on the comma format.

While the Comma Style button in the toolbar can add commas, the proper first step to gain full control over number formatting is through the Format Cells dialog box. This method allows for additional customization, such as specifying decimal places.

C. Select the cell and press Enter.

Pressing Enter does not change the number format. Formatting requires applying a specific setting within the Format Cells menu or the ribbon options.

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. To identify and navigate between different worksheets in a workbook

Explanation:

The primary function of sheet tabs in a spreadsheet application is to help users identify and navigate between different worksheets within the same workbook. Each sheet tab represents a different worksheet, and clicking on a tab switches the view to that particular sheet. This feature allows users to organize related data across multiple worksheets within one workbook, making it easy to manage complex datasets. Without sheet tabs, it would be difficult to access and work on different sheets within the same file.

Why other options are wrong:

A. To format the cells within a worksheet

Cell formatting is done within the worksheet itself, not via the sheet tabs. Formatting cells involves adjusting the appearance of the data within the individual cells (e.g., changing font size, color, or cell borders). This function is unrelated to the purpose of sheet tabs, which are used for navigation between sheets.

C. To create charts and graphs

Charts and graphs are typically created from the data within the worksheet, not from the sheet tabs. While you can use sheet tabs to navigate between sheets where charts are located, the primary role of sheet tabs is for navigation, not for creating charts or graphs.

D. To apply formulas to selected cells

Formulas are applied within a worksheet, not through the sheet tabs. While formulas can reference data in different worksheets, the sheet tabs themselves are not used to apply formulas. The function of the sheet tabs is strictly related to navigation between worksheets.

Correct Answer C. A formula that automatically totals a series of numbers in a column

Explanation

The AutoSum feature in a spreadsheet automatically calculates the sum of a series of numbers in a selected range, typically a column or row. By selecting the cells to be totaled and then using the AutoSum command, Excel inserts the SUM function, which totals the selected numbers. This feature is commonly used for quickly adding up values without manually typing a formula.

Why other options are wrong

A. A tool that formats cells for better visibility

This option is incorrect because Auto Sum is not a formatting tool. While there are various tools in Excel for formatting cells, such as bolding text, adjusting font size, or changing colors, Auto Sum is specifically a calculation tool that performs mathematical functions.

B. A function that calculates the average of a selected range

This option is incorrect because AutoSum calculates the total sum of selected numbers, not the average. While Excel also has an AVERAGE function for calculating averages, Auto Sum specifically adds up the numbers in a range, not finding their mean.

D. A command that sorts data in ascending order

This option is incorrect because sorting refers to the process of arranging data in a specific order, which is a different function from AutoSum. Sorting data can be done using the Sort command in Excel, but it does not involve performing any mathematical operations like adding values together.

Correct answer B. Active cell

Explanation:

The term "active cell" refers to the currently selected cell in a spreadsheet where data can be entered or edited. The active cell is typically highlighted with a distinct border or color, making it easy to identify. It is the cell that receives input or where a formula is applied. The active cell can be changed by clicking on a different cell within the spreadsheet.

Why other options are wrong:

A. Current cell

While the term "current cell" might seem similar, it is not the standard term used in spreadsheet applications. The correct term for the selected cell is "active cell," not "current cell." The concept of a "current" cell might exist in casual conversation, but it is not technically recognized in spreadsheet terminology.

C. Live cell

"Live cell" is not a recognized term in spreadsheet software. The active cell is the one that is selected and ready for input or modification. The term "live" does not align with any specific function in spreadsheets, and using it instead of "active" is incorrect.

D. Trigger cell

"Trigger cell" is also not a term used in spreadsheets. This term may be used in some other technical contexts, but it does not apply to the concept of a selected or active cell in spreadsheet software. The appropriate term for the selected cell is "active cell."

Correct answer A. Apply a filter to show only the current year's data

Explanation:

A pie chart is used to represent parts of a whole. When comparing sales by location for the current year, it is important to filter out data from other years before creating the chart. This ensures that the pie chart only includes relevant data and accurately reflects the sales distribution for that year.

Why other options are wrong:

B. Change the chart type to a line graph.

A line graph is best for showing trends over time, not for comparing sales by location in a single year.

C. Add a new column for average sales.

While averages may be useful for analysis, a pie chart does not require an average value, only total sales for each location.

D. Delete any irrelevant data from the spreadsheet.

Instead of deleting data permanently, applying a filter is a better practice. Filters allow you to view specific data without losing other information that may be needed later.

Correct answer A. Select the chart, go to Design, and choose Data Labels.

Explanation:

To display percentages on a pie chart in Excel, you need to enable data labels and change their format. First, select the pie chart, then navigate to the Chart Design tab. Click on Add Chart Element, choose Data Labels, and select More Data Label Options. From there, enable the Percentage option to display each slice as a proportion of the total dataset.

Why other options are wrong:

B. Double-click the chart, navigate to Customize, and adjust the Slice label settings.

Double-clicking the chart does not provide a direct option to modify slice labels. The correct method is to go through the Design tab and modify the Data Labels settings.

C. Right-click the chart, select Format Data Series, and change the label type.

While the Format Data Series option allows changes to chart appearance, it does not directly control data labels. Data labels are managed separately under Chart Design or through right-clicking on the labels themselves.

D. Click on the chart, go to Layout, and select Percentage from the options.

The Layout tab is not available in newer versions of Excel. Instead, data labels are adjusted through the Chart Design tab.

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.

Correct answer A. A page in a spreadsheet

Explanation:

A "worksheet" in a spreadsheet is a single page or tab within a workbook where data is entered and organized. It typically consists of rows and columns where users can input data, perform calculations, and analyze information. Worksheets are the primary workspace in a spreadsheet program like Excel, and multiple worksheets can exist within one workbook. It serves as a digital grid where each cell can hold various types of data, from text to formulas.

Why other options are wrong:

B. A sheet to show calculations

While a worksheet can contain calculations, its function is not limited to showing only calculations. A worksheet is a versatile space where you can enter data, apply formulas, and visualize results. The focus on just calculations makes this option too narrow, as a worksheet can hold much more than just calculated results.

C. A blank document

A worksheet is not just a blank document; it is a structured grid containing rows and columns that can be used to input data. While a new worksheet may start out as blank, the concept of a worksheet goes beyond just being a blank canvas. It is specifically designed for data management, calculation, and analysis.

D. A photocopy from a textbook

A worksheet is a digital space for data entry, not a physical or copied document from a textbook. This option is incorrect because it confuses the purpose and nature of a worksheet, which exists within spreadsheet software, not as a physical copy or text.

E. A document from a textbook

Similar to the previous option, a worksheet is not a document extracted from a textbook. It is a digital page within spreadsheet software used for organizing and analyzing data. The term "worksheet" does not refer to any physical document or source material from a textbook.