MS Excel Workbook And Formulas! Trivia Quiz
.
Questions and Answers
- 1.
The location of a cell in a worksheet indicated by the column and a row.
- A.
Formula
- B.
Operator
- C.
Cell address
Correct Answer
C. Cell addressExplanation
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.Rate this question:
-
- 2.
In the example C5, the "C" represents the cells.
- A.
Column
- B.
Row
- C.
Absolute reference
Correct Answer
A. ColumnExplanation
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.Rate this question:
-
- 3.
A row is
- A.
A vertical range of cells referred to by a number.
- B.
A horizontal range of cells referred to by a number.
- C.
A vertical range of cells referred to by a letter.
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.Rate this question:
-
- 4.
A sheet tab is located at the bottom of the worksheet window and is used to display the...
- A.
Active cell
- B.
Formula bar
- C.
Worksheet name
Correct Answer
C. Worksheet nameExplanation
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.Rate this question:
-
- 5.
This is a built-in formula that enables you to perform common calculations in a workbook.
- A.
Function
- B.
Value
- C.
Sort
Correct Answer
A. FunctionExplanation
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.Rate this question:
-
- 6.
All formulas begin with this symbol.
- A.
* (asterisk)
- B.
\ (forward slash)
- C.
= (equal sign)
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.Rate this question:
-
- 7.
In the formula =SUM(A10:A15), which part is the cell reference?
- A.
=
- B.
(A10:A15)
- C.
SUM
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.Rate this question:
-
- 8.
What is an absolute cell reference?
- A.
The cell reference automatically changes when the formula is copied down a column or across a row.
- B.
The cell uses the A1 reference style.
- C.
The cell reference is fixed or locked.
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.Rate this question:
-
- 9.
What cell reference refers to a range of cells in column D, rows 4 through 9?
- A.
(D4:D9)
- B.
(D4,D9)
- C.
(D4+D9)
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.Rate this question:
-
- 10.
If you copy the formula =C4*$D$9 from C4 to C5, what will the formula be in cell C5?
- A.
=C5*$D$9
- B.
=C4*$D$9
- C.
=C5*D9
Correct Answer
A. =C5*$D$9Explanation
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.Rate this question:
-
- 11.
If you enter a formula and #### shows in the cell, what does that mean?
- A.
The formula is missing the math operator.
- B.
The column width is not wide enough to display the results.
- C.
You entered an invalid cell reference.
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.Rate this question:
-
- 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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 13.
The symbol for multiplication is a(n)...
- A.
$
- B.
\
- C.
*
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.Rate this question:
-
- 14.
The symbol for division is...
- A.
$
- B.
\
- C.
*
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).Rate this question:
-
- 15.
When entering data across a row, you should use the TAB key to move the cursor to the next cell.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 16.
The only way to view a formula you entered in a cell is to look at the formula bar.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 17.
To easily add a header or footer to your worksheet you should be in page layout view.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 18.
In the cell reference $F9, the column is fixed, but the row will change when copied.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 19.
The shortcut to show formulas in your worksheet is...
- A.
Ctrl + ~
- B.
Ctrl + F5
- C.
Ctrl + $
Correct Answer
A. Ctrl + ~Explanation
The shortcut to show formulas in your worksheet is Ctrl + ~.Rate this question:
-
- 20.
When you open up a new workbook it comes with how many ready to use worksheets?
- A.
1
- B.
3
- C.
5
Correct Answer
B. 3Explanation
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.Rate this question:
-
Back to top