Excel - Formulas - Dates

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Agazaheer
A
Agazaheer
Community Contributor
Quizzes Created: 3 | Total Attempts: 14,117
Questions: 16 | Attempts: 317

SettingsSettingsSettings
Excel - Formulas - Dates - Quiz

Learning how to enter formulas into worksheets and perform simple calculations


Questions and Answers
  • 1. 

    In Excel 2007 you can write simple formulas that cannot automatically update their results when values change

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    In Excel 2007, simple formulas can automatically update their results when values change. This means that if any of the input values in the formula are modified, the formula will recalculate and update the result accordingly. Therefore, the statement that simple formulas cannot automatically update their results when values change is false.

    Rate this question:

  • 2. 

    The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the CD expense for the month. You can add these values in Excel by typing a simple formula in a cell:

    • A.

      =12.99+16.99

    • B.

      2.99+16.99

    • C.

      (12.99+16.99)

    • D.

      =12+16

    Correct Answer
    A. =12.99+16.99
    Explanation
    The given answer is incorrect. The correct answer is =12.99+16.99, which is the formula to add the two CD costs together. The other options provided in the question are either incorrect formulas or incorrect calculations.

    Rate this question:

  • 3. 

    A 'function' in Excel is :

    • A.

      There is no such thing as a function in Excel

    • B.

      Prewritten formula

    • C.

      Non of the above

    Correct Answer
    B. Prewritten formula
    Explanation
    The correct answer is "prewritten formula." In Excel, a function is a predefined formula that performs calculations or manipulates data. These functions can be used to perform various tasks, such as mathematical calculations, text manipulation, date and time calculations, and more. By using functions, users can save time and effort by utilizing these prewritten formulas instead of manually creating complex calculations.

    Rate this question:

  • 4. 

    The button shown below is use for ________ in Excel

    • A.

      Adds up all the values in Excel Sheet

    • B.

      Calculate exponent of any given cell

    • C.

      Adds up all the values in a range of cells

    • D.

      Non of the Above

    Correct Answer
    C. Adds up all the values in a range of cells
    Explanation
    The button shown below is used to add up all the values in a range of cells in Excel. This feature is commonly used when you want to quickly calculate the total of a set of values in a specific range. By selecting the range of cells and clicking on this button, Excel will automatically sum up all the values and display the result. This is a convenient way to perform calculations and obtain the total sum without having to manually input the formula.

    Rate this question:

  • 5. 

    A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

    • A.

      Click in cell C6, and then press CTRL+SHIFT.

    • B.

      Click in cell C6, and then press F5.

    • C.

      Click in cell C6

    Correct Answer
    C. Click in cell C6
    Explanation
    Clicking in cell C6 allows you to view the formula in the formula bar at the top of the Excel window. This way, you can see the formula that was used to calculate the result in cell C6.

    Rate this question:

  • 6. 

    Relative references:

    • A.

      Are absolute references

    • B.

      Stay the same as they are copied.

    • C.

      Change as they are copied

    • D.

      Are references you give in an interview to get job

    Correct Answer
    C. Change as they are copied
    Explanation
    Relative references change as they are copied. This means that when a formula or reference is copied to another cell, the reference will adjust based on its new location. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically adjust to B2. This allows for easy replication of formulas without having to manually update each reference.

    Rate this question:

  • 7. 

    Formula =C4*$D$9 - absolute cell reference is:

    • A.

      =C4*$D$9

    • B.

      $D

    • C.

      =

    • D.

      $D$9

    Correct Answer
    D. $D$9
    Explanation
    The correct answer is $D$9 because it is an example of an absolute cell reference. In Excel, the dollar sign ($) is used to indicate an absolute reference, which means that the cell reference will not change when copied or filled down to other cells. In this case, $D$9 will always refer to the same cell, regardless of where the formula is copied to.

    Rate this question:

  • 8. 

     $A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The given statement is true. A1 is an example of a mixed reference because it contains both an absolute reference (column A) and a relative reference (row 1). When a mixed reference is copied from one cell to another, the absolute reference remains the same while the relative reference changes based on the new cell location.

    Rate this question:

  • 9. 

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

    • A.

      C2*$D$9

    • B.

      C1*$D$9

    • C.

      C5*$D$9

    • D.

      Cant say from the given question

    Correct Answer
    D. Cant say from the given question
  • 10. 

    The MAX function finds the _______

    • A.

      Largest number in Excel Sheet

    • B.

      Largest number in a range of numbers

    • C.

      Smallest number in a range of numbers

    • D.

      It does nothing

    Correct Answer
    B. Largest number in a range of numbers
    Explanation
    The MAX function in Excel Sheet finds the largest number within a specified range of numbers. It is used to determine the maximum value in a set of data, allowing users to easily identify the highest value present.

    Rate this question:

  • 11. 

    The ##### error value indicates

    • A.

      That wrong formula has been entered into the cell

    • B.

      Divide Error

    • C.

      You are trying to apply formulas on text

    • D.

      That the column is too narrow to display the contents of this

    Correct Answer
    D. That the column is too narrow to display the contents of this
    Explanation
    The given correct answer suggests that the ##### error value indicates that the column is too narrow to display the contents of this. This error occurs when the data in a cell is too wide to fit within the column width, causing the cell to display a series of hash marks (#####) instead of the actual content. To resolve this error, the column width needs to be adjusted to accommodate the data.

    Rate this question:

  • 12. 

    How would you print formulas?

    • A.

      Click the Microsoft Office Button and then click Print.

    • B.

      Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.

    • C.

      Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.

    • D.

      You cant print formulas in Excel 2007

    Correct Answer
    C. Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.
    Explanation
    To print formulas in Excel 2007, you need to go to the Formulas tab and point to Formula Auditing. Then, click on Show Formulas to display the formulas in the cells. After that, click the Microsoft Office Button and select Print to print the formulas along with the rest of the spreadsheet.

    Rate this question:

  • 13. 

    In the practice, you learned that if you misspell SUM in this formula =SUME(B4:B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The explanation for the given correct answer, which is False, is that if you misspell "SUM" in the formula "=SUME(B4:B7)", you can simply edit the formula and correct the spelling mistake. You do not need to delete the formula and start over again.

    Rate this question:

  • 14. 

    Excel will calculate date :1/20/1900 (month/day/year) as:

    • A.

      1921

    • B.

      Excel treats dates as text and cannot calculate dates

    • C.

      20

    • D.

      Non of the above

    Correct Answer
    C. 20
    Explanation
    Excel treats dates as numbers, with each date being represented by a unique number. In this case, the date 1/20/1900 would be represented by the number 20. Therefore, the correct answer is 20.

    Rate this question:

  • 15. 

    What would happen if you used a formula to do math with dates?

    • A.

      Excel will give Error : #####

    • B.

      Excel will give Error : ?Name

    • C.

      Excel will not give any Error as you can do math with dates in Excel

    • D.

      Excel will give Error : #VALUE!

    Correct Answer
    C. Excel will not give any Error as you can do math with dates in Excel
    Explanation
    When using a formula to do math with dates in Excel, the program will not give any error. This is because Excel has built-in functions and formulas that allow for mathematical operations to be performed on dates. These functions and formulas can be used to calculate the difference between two dates, add or subtract days, months, or years from a date, and perform other mathematical operations involving dates. Therefore, Excel will not give an error when using a formula to do math with dates.

    Rate this question:

  • 16. 

    In Excel if you write =TODAY() in the formula bar (Fx)

    • A.

      It will do nothing

    • B.

      It will give you today's date

    • C.

      It will give you today's news

    • D.

      It will give you today's Tip

    Correct Answer
    B. It will give you today's date
    Explanation
    When you write =TODAY() in the formula bar in Excel, it will give you today's date. The TODAY() function is a built-in function in Excel that returns the current date. By entering this formula, Excel will automatically update the cell with the current date whenever the worksheet is opened or recalculated.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Mar 14, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 01, 2010
    Quiz Created by
    Agazaheer
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.