CMP 540 Excel Trivia Questions Quiz

When typing an equation into a cell, the first thing that must be entered is an equal sign. This is because the equal sign is used to indicate that what follows is a formula or equation rather than a regular text entry. Without the equal sign, the cell will treat the input as plain text instead of a mathematical expression.

The intersection of a row and a column in a table or spreadsheet is referred to as a cell. A cell is a unit that contains data or information, and it is the fundamental building block of a table or spreadsheet. It represents a specific value within the table and can hold various types of data such as text, numbers, or formulas. Therefore, the correct answer for this question is a cell.

The advantage of using a spreadsheet is that it allows calculations to be done automatically, which saves time and reduces the risk of errors. Additionally, changing data in a spreadsheet automatically updates the calculations, as long as the software is set to calculate automatically. This ensures that the results are always accurate and up to date. Lastly, spreadsheets offer more flexibility compared to manual calculations or other tools, allowing users to easily manipulate and analyze data in various ways. Therefore, the correct answer is "all of the above."

The cell labeled F5 refers to the intersection of column F and row 5 in a spreadsheet. Each cell in a spreadsheet is identified by its column letter and row number, so F5 specifically refers to the cell in column F and row 5.

A constant is another name for a fixed value or a value that does not change. In this context, a number can be considered a constant as it represents a specific value that remains constant throughout the program or calculation. Unlike equations, formulas, or descriptions, numbers do not change and can be considered as constant data.

The correct answer is "numbers, formulas, labels." In a spreadsheet, numbers are used to represent numerical values, formulas are used to perform calculations or manipulate data, and labels are used to provide descriptions or titles for data entries. These three types of data are fundamental in organizing and analyzing information within a spreadsheet.

When the formula =B2+A3 in cell B3 is copied and pasted into cell D4, the cell references in the formula adjust accordingly. The column reference B in B2 becomes D in D4, and the row reference 2 in B2 becomes 3 in D4. Therefore, the resulting formula in cell D4 would be =D3+C4.

When the formula =$c$3*D3 is copied and pasted into cell C1, the formula will adjust to the new location. The column reference remains fixed as $C$3, but the row reference adjusts to the new row, resulting in =$c$3*E3. Therefore, the resulting formula in cell C1 would be =$c$3*E3.