Introduction to Spreadsheets (D100)

Correct answer B. Highlight the column, click on the comma format, and then click 'decrease decimal' twice

Explanation:

To format sales figures with commas and no decimal places, first apply the comma format (which automatically adds thousand separators and two decimal places) and then decrease the decimal count twice to remove decimals.

Why other options are wrong:

A. Select the column, click on 'increase decimal', then apply the currency format.

This option is incorrect because increasing decimals would add more decimal places instead of removing them. Additionally, the currency format includes a currency symbol, which is not required in this case.

C. Select the column, right-click and choose 'Format Cells', then select 'General'.

The 'General' format does not add commas or adjust decimal places. It simply displays numbers in their default format, which may not include thousands separators.

D. Click on the 'Home' tab, select 'Cell Styles', and choose 'Currency'.

The currency format includes a currency symbol (e.g., "$" or "€"), which is not required in this case. Also, it does not automatically remove decimals without additional adjustments.

Correct Answer A. You can drag the fill handle or use the copy and paste functions.

Explanation

In Excel, copying a formula to multiple cells can be done efficiently using two main methods:

Using the Fill Handle: Select the cell with the formula, then move your cursor to the small square at the bottom-right corner of the cell (the fill handle). Click and drag it down or across to copy the formula to adjacent cells. This automatically adjusts relative cell references within the formula.

Using Copy and Paste: Select the cell with the formula, press Ctrl + C (or right-click and choose "Copy"), then highlight the target cells where you want to copy the formula and press Ctrl + V (or right-click and choose "Paste"). This method is useful when copying formulas to non-adjacent cells.

Why other options are wrong

B. You can manually enter the formula in each cell or use the fill handle.

While using the fill handle is correct, manually entering the formula in each cell is inefficient and unnecessary, especially when dealing with large datasets.

C. You can copy the contents of the cell and paste them into the desired cells, or use Control D to fill down.

While copying and pasting is correct, Ctrl + D only works for filling down within a selected column and does not apply to copying formulas across rows or non-contiguous ranges. This method is more limited than using the fill handle.

D. You can use the formula bar to replicate the formula in each cell or use the fill handle.

While the formula bar displays the formula of a selected cell, it is not used to copy formulas across multiple cells efficiently. The fill handle is correct, but the formula bar is not typically used for this purpose.

Correct answer B. =AVERAGE(range)

Explanation:

The =AVERAGE(range) formula in Excel calculates the mean (arithmetic average) of a set of numbers. It sums all the numbers in the specified range and then divides the total by the number of values in that range. This function is commonly used in financial analysis, statistics, and general data analysis.

Why other options are wrong:

A. =SUM(range).

The SUM function adds all the values in the specified range but does not calculate the average. While summing the values is a step in calculating an average, the SUM function alone does not perform the division needed to find the mean.

C. =COUNT(range).

The COUNT function counts the number of numeric entries in a specified range but does not perform any calculations on the values themselves. It is useful for determining how many numbers are in a dataset but does not return an average.

D. =MEDIAN(range).

The MEDIAN function finds the middle value in a sorted list of numbers. While both median and average measure central tendency, they are calculated differently. The median is useful for datasets with skewed distributions, while the average considers all values in the range.

Correct answer B. Fill

Explanation:

The "Fill" feature in a spreadsheet allows you to quickly replicate the contents of a cell into adjacent cells. By dragging the fill handle (the small square at the bottom right corner of the selected cell) across or down to neighboring cells, you can duplicate the data, whether it's text, numbers, or formulas, without having to manually enter the data again. This feature is a time-saver, particularly for large datasets or formulas that need to be applied across multiple cells.

Why other options are wrong:

A. Merge

The "Merge" function is used to combine two or more adjacent cells into one larger cell. It does not replicate the contents of a cell into others. Merging cells is useful for formatting purposes, especially for headers or titles, but it does not duplicate data across cells. Thus, "Merge" is not the correct option for quickly replicating cell contents.

C. Sort

The "Sort" feature in spreadsheets is used to reorder data in a specific order, either ascending or descending. While it helps in organizing data, it does not replicate cell contents. Sorting only rearranges the data but does not automatically copy data into adjacent cells, making it an incorrect choice in this context.

D. Filter

The "Filter" feature is used to display only the data that meets certain criteria, effectively hiding the rest of the information. It does not replicate or duplicate cell contents into adjacent cells. Filters are useful for narrowing down data but are unrelated to the process of copying data, which is why "Filter" is not the right option here.

Correct answer B. Alignment

Explanation:

The term "alignment" in a spreadsheet refers to the positioning of text or data within the boundaries of a cell. This includes how the content is aligned relative to the cell's edges, such as left-aligned, right-aligned, or centered. Alignment controls the display of text and helps organize data for better readability and presentation within the cell.

Why other options are wrong:

A. Cell reference

This option is incorrect because a cell reference refers to the unique identifier of a cell, such as "A1" or "B2," which points to the location of a specific cell in the spreadsheet. Cell references are used in formulas to refer to the data in other cells but do not pertain to the positioning of text within a cell.

C. Formula

This option is incorrect because a formula is a calculation that processes data in the spreadsheet. While formulas can reference data in cells, they are not related to the positioning of text within a cell. Formulas are about computation, whereas alignment refers to the appearance of the content in a cell.

D. Active cell

This option is incorrect because the active cell refers to the cell that is currently selected or being worked on in the spreadsheet. The active cell is where data can be entered or edited, but it does not relate to the positioning or alignment of the text within the cell.

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 A. =AVERAGE(A2:A7)

Explanation

In Excel, the AVERAGE function calculates the mean (average) of a range of numbers. The correct syntax is =AVERAGE(A2:A7), which tells Excel to compute the average of all values in cells A2 through A7. This function automatically sums the values and divides by the number of entries in the range.

Why other options are wrong

B. =AVERAGE(A2:A7)/6

This formula is incorrect because the AVERAGE function already divides by the count of numbers in the range. Manually dividing by 6 would result in an incorrect calculation.

C. =AVERAGE((A2)(A7))

This is incorrect formula syntax. The AVERAGE function requires a range or a list of numbers, not separate values inside parentheses with multiplication-like notation.

D. =AVERAGE(A2):(A7)

The colon (:) inside the parentheses is misplaced. The correct way to specify a range in Excel is A2:A7, not A2):(A7).

Correct answer A. Next Year, bold

Explanation:

A subtitle should clearly indicate the time period the pie chart represents. Since the chart is for next year's sales data, "Next Year" is the most appropriate label. Additionally, formatting it in bold ensures visibility and emphasis, making the chart more readable.

Why other options are wrong:

B. Next Year, not bold.

While "Next Year" is correct, not using bold formatting reduces visibility and makes the subtitle less prominent in the chart.

C. This Year, not bold.

"This Year" refers to the current sales period, not next year’s data, making it inaccurate.

D. Future Sales, bold.

While "Future Sales" is related, it is too vague compared to "Next Year," which directly specifies the period of sales data being presented.

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.