MS Excel Workbook And Formulas! Trivia Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Denisemcgov
D
Denisemcgov
Community Contributor
Quizzes Created: 1 | Total Attempts: 360
| Attempts: 360
SettingsSettings
Please wait...
  • 1/20 Questions

    The symbol for multiplication is a(n)...

    • $
    • \
    • *
Please wait...
About This Quiz

Dive into the essentials of MS Excel with this trivia quiz! Explore key concepts like cell addresses, columns, rows, sheet tabs, and built-in functions. Perfect for enhancing your Excel skills and understanding, this quiz is tailored for learners aiming to master workbook operations and formula usage.

MS Excel Workbook And Formulas! Trivia Quiz - Quiz

Quiz Preview

  • 2. 

    The symbol for division is...

    • $

    • \

    • *

    Correct Answer
    A. \
    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:

  • 3. 

    All formulas begin with this symbol.

    • * (asterisk)

    • \ (forward slash)

    • = (equal sign)

    Correct Answer
    A. = (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:

  • 4. 

    The location of a cell in a worksheet indicated by the column and a row.

    • Formula

    • Operator

    • Cell address

    Correct Answer
    A. 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.

    Rate this question:

  • 5. 

    What cell reference refers to a range of cells in column D, rows 4 through 9?

    • (D4:D9)

    • (D4,D9)

    • (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:

  • 6. 

    If you enter a formula and #### shows in the cell, what does that mean?

    • The formula is missing the math operator.

    • The column width is not wide enough to display the results.

    • You entered an invalid cell reference.

    Correct Answer
    A. 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:

  • 7. 

    When entering data across a row, you should use the TAB key to move the cursor to the next cell.

    • True

    • False

    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.

    Rate this question:

  • 8. 

    In the example C5, the "C" represents the cells.

    • Column

    • Row

    • Absolute reference

    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.

    Rate this question:

  • 9. 

    In the formula =SUM(A10:A15), which part is the cell reference?

    • =

    • (A10:A15)

    • SUM

    Correct Answer
    A. (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:

  • 10. 

    When you open up a new workbook it comes with how many ready to use worksheets?

    • 1

    • 3

    • 5

    Correct Answer
    A. 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.

    Rate this question:

  • 11. 

    To easily add a header or footer to your worksheet you should be in page layout view.

    • True

    • False

    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.

    Rate this question:

  • 12. 

    A sheet tab is located at the bottom of the worksheet window and is used to display the...

    • Active cell

    • Formula bar

    • Worksheet name

    Correct Answer
    A. 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.

    Rate this question:

  • 13. 

    The only way to view a formula you entered in a cell is to look at the formula bar.

    • True

    • False

    Correct Answer
    A. 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.

    Rate this question:

  • 14. 

    The shortcut to show formulas in your worksheet is...

    • Ctrl + ~

    • Ctrl + F5

    • Ctrl + $

    Correct Answer
    A. Ctrl + ~
    Explanation
    The shortcut to show formulas in your worksheet is Ctrl + ~.

    Rate this question:

  • 15. 

    A row is

    • A vertical range of cells referred to by a number.

    • A horizontal range of cells referred to by a number.

    • A vertical range of cells referred to by a letter.

    Correct Answer
    A. 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:

  • 16. 

    This is a built-in formula that enables you to perform common calculations in a workbook.

    • Function

    • Value

    • Sort

    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.

    Rate this question:

  • 17. 

    If you copy the formula =C4*$D$9 from C4 to C5, what will the formula be in cell C5?

    • =C5*$D$9

    • =C4*$D$9

    • =C5*D9

    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.

    Rate this question:

  • 18. 

    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.

    • True

    • False

    Correct Answer
    A. 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.

    Rate this question:

  • 19. 

    What is an absolute cell reference?

    • The cell reference automatically changes when the formula is copied down a column or across a row.

    • The cell uses the A1 reference style.

    • The cell reference is fixed or locked.

    Correct Answer
    A. 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:

  • 20. 

    In the cell reference $F9, the column is fixed, but the row will change when copied.

    • True

    • False

    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.

    Rate this question:

Quiz Review Timeline (Updated): Mar 17, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 24, 2011
    Quiz Created by
    Denisemcgov

Recent Quizzes

Business Analyst Excel quiz Business Analyst Excel quiz
Microsoft Excel 2016 Test Microsoft Excel 2016 Test
identify the proficiency of Microsoft Excel quiz identify the proficiency of Microsoft Excel quiz
End of Term - Year 9 End of Term - Year 9
Take The Ultimate Quiz On Microsoft Excel! Take The Ultimate Quiz On Microsoft Excel!
Microsoft Excel Proficiency Trivia questions Microsoft Excel Proficiency Trivia questions
Can you pass this Microsoft Excel Exam Quiz? Can you pass this Microsoft Excel Exam Quiz?
Microsoft Excel Proficiency Test Microsoft Excel Proficiency Test
G4S MIS - Qualifying exam G4S MIS - Qualifying exam
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.