D100 Introduction to Spreadsheets - Set 2 - Part 1

Correct Answer: Select "Freeze Panes" from the VIEW tab

The Freeze Panes option in the VIEW tab allows you to lock rows or columns, making them visible while scrolling through the rest of the worksheet.

Correct Answer: ####

When the content exceeds the width of a column, Excel displays #### instead of the content.

Correct Answer: Show Formula

The Show Formula tool displays the formulas applied in a cell rather than the result.

Correct Answer: Double-click the border between two column headings

Double-clicking the border between column headings will automatically adjust the column to fit the longest entry.

Correct Answer: MAX

The MAX function identifies the largest number in a specified range.

Correct Answer: To summarize and analyze data

PivotTables allow you to summarize and analyze data, especially from large datasets.

Correct Answer: Ctrl + D

Ctrl + D duplicates the contents of the selected cell into the cell directly below it.

Correct Answer: It vertically looks for a value in a table

VLOOKUP is used to search for a value in the first column of a table and return a value in the same row from a specified column.

Correct Answer: Combine selected cells into one and center-align the content

Merge & Center combines multiple cells into a single cell and centers the text or value within that cell.

Correct Answer: =SUM(A1

Correct Answer: The equals sign (=)

Every Excel or Google Sheets formula must begin with an equals sign (=). Typing = signals to the program that the following characters should be evaluated as a calculation or function rather than stored literally. If you omit the equals sign, the entry such as SUM(A1:A2) is treated as a text label. While some spreadsheet programs also accept a leading + as a legacy shortcut, the standard and universally correct way to start a formula is with the equals sign.

Correct Answer: 14, because multiplication is performed before addition

Excel follows the standard mathematical order of operations, so multiplication and division are performed before addition and subtraction. In =2+3*4, the multiplication 3*4 is evaluated first to give 12, and then 2 is added to produce 14. Excel does not simply calculate left to right when higher-precedence operators are present. To force the addition to happen first you would need parentheses, as in =(2+3)*4, which would return 20.

Correct Answer: An absolute reference that does not change when the formula is copied

The dollar signs in $A$1 create an absolute reference, meaning both the column (A) and the row (1) are locked. When you copy a formula containing $A$1 to another cell, the reference continues to point to cell A1 rather than shifting. This is useful when a formula must always refer to a fixed value, such as a tax rate or a constant. Removing one dollar sign (for example A$1 or $A1) creates a mixed reference that locks only the row or only the column.

Correct Answer: B$3

A mixed reference locks either the row or the column, but not both, by placing a single dollar sign before the locked part. In B$3, the row (3) is locked with the dollar sign while the column (B) remains relative and will change when the formula is copied across columns. In contrast, A1 and C5 are fully relative references, and $A$1 is a fully absolute reference where both parts are locked. Mixed references are helpful when building formulas that must be copied in one direction while keeping one coordinate fixed.

Correct Answer: 5 cells

A range written as A1:A5 uses a colon to indicate all cells from the first reference through the last reference, inclusive. This range covers A1, A2, A3, A4, and A5, which is a total of five cells in a single column. Because both endpoints are counted, the number of cells equals the difference in row numbers plus one (5 minus 1, then plus 1). The colon operator always refers to a continuous block of cells between and including the two references.

Correct Answer: =MAX(B2:B10)

The MAX function returns the highest numeric value found in a range, so =MAX(B2:B10) correctly identifies the largest number in that block of cells. TOP and HIGH are not valid Excel functions. LARGE is a real function but requires a second argument specifying which ranked position you want (for example =LARGE(B2:B10,1) returns the largest); used alone without that argument it will produce an error. For simply finding the single greatest value, MAX is the standard and simplest choice.

Correct Answer: A workbook is a single file that can contain one or more worksheets

A workbook is the entire Excel file (saved with an extension such as .xlsx), and it can contain one or many worksheets. A worksheet is a single tabbed page of rows and columns within that workbook, where you actually enter and organize data. You can add, delete, rename, and reorder worksheets using the sheet tabs at the bottom of the window. The relationship is hierarchical: the workbook is the container, and worksheets are the individual pages inside it.

Correct Answer: COUNT

The COUNT function tallies only the cells in a range that contain numbers, ignoring text, blanks, and logical values. This makes it ideal when you want to know how many numeric entries exist. COUNTA is different because it counts all non-empty cells, including text. COUNTBLANK counts empty cells, and SUM adds numeric values together rather than counting them. If a range mixes text and numbers, COUNT returns only the quantity of numeric cells.

Correct Answer: It continues the series with 3, 4, 5, and so on

When two or more cells that establish a pattern are selected before dragging the fill handle, Excel recognizes the sequence and extends it. Selecting cells containing 1 and 2 defines a step of one, so dragging down produces 3, 4, 5, and so forth. The fill handle is the small square at the bottom-right corner of a selection. If only a single number is selected and dragged, Excel typically copies that value instead of creating a series, which is why establishing the pattern first matters.

Correct Answer: =SUM(A1:A3)

The SUM function adds a range of cells, and the correct way to specify a continuous range is with a colon, as in =SUM(A1:A3), which totals A1, A2, and A3. A hyphen (A1-A3) would be interpreted as subtraction rather than a range. Excel does not use a semicolon as the range operator in this context, and ADD is not a valid Excel function. The colon operator is the standard way to reference all cells between two endpoints.