MS Excel Workbook and Formulas! Trivia Quiz

The symbol for multiplication is the asterisk (*). This symbol is commonly used in mathematics to indicate multiplication between two numbers or variables. It is a widely recognized symbol and is used in various contexts, such as in equations, formulas, and calculations.

The symbol for division is "\". This symbol is commonly used in mathematics to represent the operation of dividing one number by another. It is a diagonal line that separates the dividend (the number being divided) from the divisor (the number by which it is being divided).

The equal sign (=) is used to indicate that a formula is being entered in a cell. It is the symbol that separates the formula from the rest of the content in the cell. The asterisk (*) is used for multiplication, the forward slash (/) is used for division, and the equal sign (=) is used to start a formula.

The cell address refers to the specific location of a cell in a worksheet, which is indicated by the column letter and row number. It is used to identify and reference a particular cell in formulas, calculations, and data manipulation. By specifying the cell address, users can perform various operations on the data within that specific cell.

The cell reference (D4:D9) refers to a range of cells in column D, specifically rows 4 through 9. This means that it includes all the cells in column D starting from row 4 and ending at row 9.

If #### shows in a cell after entering a formula, it means that the column width is not wide enough to display the results of the formula. This happens when the result of the formula is too long to fit within the width of the column. To fix this, you can either increase the column width or decrease the font size to make the result visible.

When entering data across a row, using the TAB key to move the cursor to the next cell is a common practice. This allows for efficient and quick data entry as the TAB key automatically moves the cursor to the next cell in the same row. It eliminates the need to manually click or use the arrow keys to navigate to the next cell. Therefore, the statement is true.

The correct answer is column because in the example C5, the "C" represents the column of the cell. The letter is used to identify the vertical position of the cell within the spreadsheet.

The cell reference in the formula =SUM(A10:A15) is (A10:A15). This is because (A10:A15) represents a range of cells from A10 to A15, and the SUM function will calculate the sum of the values in those cells. The colon ":" is used to indicate the range of cells.

To easily add a header or footer to your worksheet, you should be in page layout view. This is because page layout view allows you to see how your worksheet will look when printed, including any headers or footers that you add. In page layout view, you can easily access the header and footer options and make any necessary changes or additions. Therefore, the statement "To easily add a header or footer to your worksheet you should be in page layout view" is true.

When you open up a new workbook in most spreadsheet software, it usually comes with three ready-to-use worksheets. These worksheets are already set up with columns and rows, allowing users to input data and perform calculations easily. Having multiple worksheets in a new workbook provides flexibility and organization for users who may need to work on different sets of data or create separate sections within the same workbook.

The sheet tab is located at the bottom of the worksheet window and is used to display the worksheet name. It allows users to easily navigate between different worksheets within a workbook. By clicking on the sheet tab, users can quickly switch to a specific worksheet and view its contents. This feature is particularly useful when working with large workbooks that contain multiple worksheets.

A row is a horizontal range of cells referred to by a number. In a spreadsheet or table, rows are identified by numbers that indicate their position in the vertical direction. Each row contains multiple cells that can be used to input data or perform calculations. By referring to a specific row number, users can easily navigate and manipulate data within a spreadsheet.

This answer is correct because the term "function" refers to a built-in formula in a workbook that allows users to perform common calculations. It is a predefined set of instructions that can be used to perform specific tasks or calculations in a spreadsheet.

When the formula =C4*$D$9 is copied from cell C4 to C5, the cell references in the formula will adjust accordingly. Since the formula is copied one row down, the row reference in the formula will change from C4 to C5. Therefore, the formula in cell C5 will be =C5*$D$9.

The statement is false because there are two ways to view a formula you entered in a cell. One way is to look at the formula bar, as mentioned in the statement. However, another way is to select the cell containing the formula and then look at the formula displayed in the formula bar as well as in the cell itself. Therefore, the statement is incorrect as it implies that the formula can only be viewed in the formula bar.

The shortcut to show formulas in your worksheet is Ctrl + ~.

If you entered the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you don't necessarily have to delete the formula and start again. You can simply edit the formula and correct the spelling mistake.

The statement is true because in the cell reference $F9, the dollar sign ($) before the column letter (F) indicates that the column is fixed. This means that when the cell reference is copied to other cells, the column will remain the same. However, since there is no dollar sign before the row number (9), the row will change when the cell reference is copied.

An absolute cell reference is a fixed or locked cell reference that does not change when the formula is copied or filled down a column or across a row. This means that the reference always points to the same cell, regardless of where the formula is copied. This is useful when you want to keep a specific cell reference constant in a formula, such as when using a constant or a fixed value in a calculation.