Question 1

The calculations and their results are inputs.

Accepted Answer

Calculations are processes or operations performed on inputs to produce results, not inputs themselves. Inputs are the data or values used in the calculations.

Question 2

In the Format Cells dialog box, the Category box lists the available number formats.

Accepted Answer

The Category box in the Format Cells dialog box does indeed list the available number formats.

Question 3

Sheet names are only needed in formulas when the cell being referenced is on another worksheet.

Accepted Answer

When referencing a cell on the same worksheet, sheet names are not needed in formulas. However, when referencing a cell on a different worksheet, the sheet name must be included in the formula to specify which worksheet the cell is on.

Question 4

The rules programmed into a function are referred to as the function's algorithm.

Accepted Answer

The algorithm is a series of steps or instructions that are programmed into a function to achieve a specific task or solve a problem.

Question 5

When working with multiple worksheets in a workbook, it's a good idea to rename each worksheet tab based on the default labels (Sheet1, Sheet2, and so on).

Accepted Answer

Renaming worksheet tabs based on their default labels can make it easier to navigate and locate specific worksheets within a workbook.

Question 6

Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet.

Accepted Answer

Typing a value into a cell instead of entering the formula that produced the value is not a good practice when building a spreadsheet. It can lead to errors and the spreadsheet may not be dynamic and adaptable for changes. It is better to enter the formula so that the value will update automatically if any changes are made to the data.

Question 7

If there is insufficient room to display a label in a cell, the text may be displayed in a truncated format.

Accepted Answer

When there is insufficient room to display a label in a cell, the text may be displayed in a truncated format, where part of the text is cut off and replaced with ellipses (...) or a tooltip may appear when hovering over the cell to show the full label.

Question 8

The ### signs indicate that the column width is insufficient to display the complete value in the cell.

Accepted Answer

The ### signs in a cell indicate that the column width is not enough to display the complete value in the cell. This happens when the content in the cell is wider than the width of the column. To display the full value, either increase the column width or adjust the font size.

Question 9

The fill handle is a small square in the lower-right corner of a selected cell that you use to delete the contents of the selected cell.

Accepted Answer

The fill handle is used to fill adjacent cells with data or formulas, not to delete the contents of a cell. To delete the contents of a cell, you can press the delete key or use the clear function in the Home ribbon.

Question 10

A formula is an equation that performs calculations, the result of which can be either a value or a label.

Accepted Answer

A formula is indeed an equation that performs calculations, and the result can be either a value or a label depending on the formula's purpose and design.

Question 11

The labels and values upon which Excel calculations are based are outputs.

Accepted Answer

The labels and values upon which Excel calculations are based are inputs, not outputs. The outputs are the results of the calculations.

Question 12

The pound sign (#) is the syntax used by Excel to indicate that a cell reference is absolute.

Accepted Answer

The pound sign (#) is used in Excel to indicate errors in formulas, such as #DIV/0 and #REF!. Absolute cell references are indicated by a dollar sign ($) before the column and/or row reference.

Question 13

Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.

Accepted Answer

Excel does provide a variety of tools for designing a worksheet or spreadsheet.

Question 14

To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.

Accepted Answer

The feature described is more accurately referred to as using variables or parameters in programming and formulas, not "Rotating Values." Variables allow you to input different numbers into the same formula.

Question 15

Range names, like text labels, are enclosed in quotation marks when used in formulas.

Accepted Answer

Range names are not enclosed in quotation marks in formulas; they are used directly without quotes. Quotation marks are used for text strings.

Question 16

The Comma Style button formats numbers with commas and no decimal places.

Accepted Answer

The Comma Style button formats numbers with commas for thousands but retains two decimal places by default.

Question 17

When entering a value in a cell, you should enter the value with commas.

Accepted Answer

When entering a value in a cell, commas should not be used. Numbers should be entered without any separators or symbols, such as commas or dollar signs.

Question 18

The COUNT function ignores blank cells and cells with text.

Accepted Answer

The COUNT function only counts numerical values and ignores blank cells and cells with text.

Question 19

When Excel rounds the display, it does so by rounding any number half or lower down to the next value.

Accepted Answer

Excel rounds numbers that are exactly halfway between two values up, following the standard rule of rounding to the nearest even number in case of a tie, known as "round half to even" or "bankers' rounding."

Question 20

Some of the most common formatting options available in the Format Cells dialog box are also available on the HOME tab and on the Mini toolbar.

Accepted Answer

The statement is true.

Quiz 1: Applying Fundamental Excel Skills and Tools in Problem Solving