1.
The location of a cell in a worksheet indicated by the column and a row.
Correct Answer
C. Cell address
Explanation
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.
2.
In the example C5, the "C" represents the cells.
Correct Answer
A. Column
Explanation
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.
3.
A row is
Correct Answer
B. A horizontal range of cells referred to by a number.
Explanation
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.
4.
A sheet tab is located at the bottom of the worksheet window and is used to display the...
Correct Answer
C. Worksheet name
Explanation
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.
5.
This is a built-in formula that enables you to perform common calculations in a workbook.
Correct Answer
A. Function
Explanation
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.
6.
All formulas begin with this symbol.
Correct Answer
C. = (equal sign)
Explanation
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.
7.
In the formula =SUM(A10:A15), which part is the cell reference?
Correct Answer
B. (A10:A15)
Explanation
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.
8.
What is an absolute cell reference?
Correct Answer
C. The cell reference is fixed or locked.
Explanation
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.
9.
What cell reference refers to a range of cells in column D, rows 4 through 9?
Correct Answer
A. (D4:D9)
Explanation
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.
10.
If you copy the formula =C4*$D$9 from C4 to C5, what will the formula be in cell C5?
Correct Answer
A. =C5*$D$9
Explanation
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.
11.
If you enter a formula and #### shows in the cell, what does that mean?
Correct Answer
B. The column width is not wide enough to display the results.
Explanation
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.
12.
If you entered in the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you have to delete the formula and start again.
Correct Answer
B. False
Explanation
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.
13.
The symbol for multiplication is a(n)...
Correct Answer
C. *
Explanation
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.
14.
The symbol for division is...
Correct Answer
B. \
Explanation
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).
15.
When entering data across a row, you should use the TAB key to move the cursor to the next cell.
Correct Answer
A. True
Explanation
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.
16.
The only way to view a formula you entered in a cell is to look at the formula bar.
Correct Answer
B. False
Explanation
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.
17.
To easily add a header or footer to your worksheet you should be in page layout view.
Correct Answer
A. True
Explanation
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.
18.
In the cell reference $F9, the column is fixed, but the row will change when copied.
Correct Answer
A. True
Explanation
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.
19.
The shortcut to show formulas in your worksheet is...
Correct Answer
A. Ctrl + ~
Explanation
The shortcut to show formulas in your worksheet is Ctrl + ~.
20.
When you open up a new workbook it comes with how many ready to use worksheets?
Correct Answer
B. 3
Explanation
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.