Entering Formulas & Functions

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 Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 15,757
| Attempts: 280
SettingsSettings
Please wait...
  • 1/10 Questions

    The function arguments dialog box tells you how to use functions.

    • True
    • False
Please wait...
About This Quiz

This quiz assesses knowledge of entering formulas and functions in Excel 2007, focusing on syntax, function arguments, and the use of cell references. It is ideal for learners looking to enhance their spreadsheet skills and understand function application.

Excel Functions Quizzes & Trivia

Quiz Preview

  • 2. 

    What is a Formula?

    • A calculation that describes the relationship between cells

    • Excel automatically knows that you want to add the column of numbers above or add the row of numbers to the left

    • This is what rows are sorted by

    Correct Answer
    A. A calculation that describes the relationship between cells
    Explanation
    A formula is a calculation that describes the relationship between cells in a spreadsheet. It is used in programs like Excel to perform mathematical operations or manipulate data. With formulas, Excel can automatically determine if you want to add the column of numbers above or add the row of numbers to the left. Formulas are essential for performing calculations and analyzing data in spreadsheets.

    Rate this question:

  • 3. 

    The Insert Function dialog box tells you how to use functions.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because the Insert Function dialog box is a tool in various software applications, such as Microsoft Excel, that helps users understand and utilize different functions available in the software. It provides information about the purpose, syntax, and arguments of each function, making it easier for users to input and apply functions correctly in their calculations or data analysis.

    Rate this question:

  • 4. 

    When using Excel 2007 what symbol is used to create a formula or function in a cell?

    • ?

    • +

    • =

    Correct Answer
    A. =
    Explanation
    In Excel 2007, the symbol "=" is used to create a formula or function in a cell. This symbol indicates that the content of the cell is a formula and Excel will calculate the result based on the formula entered. By using the "=" symbol, users can perform various calculations and operations within cells to manipulate data and obtain desired results.

    Rate this question:

  • 5. 

    All functions have arguments.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because in programming, a function is a block of code that performs a specific task and it can take inputs called arguments. These arguments allow the function to receive data or information that it needs to perform its task. Without arguments, a function would not be able to receive any input and therefore would not be able to perform its intended task. So, it can be concluded that all functions have arguments.

    Rate this question:

  • 6. 

    in "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.

    • Letters

    • Cell references

    • Symbols

    • Operators

    Correct Answer
    A. Cell references
    Explanation
    In the "SUM(number1 [,number2 ,number3 ...])" function, the numbers inside the parentheses can be either numbers or cell references. Cell references refer to specific cells in a spreadsheet and allow you to perform calculations using the values in those cells. So, in addition to using actual numbers, you can also use cell references as arguments in the SUM function to calculate the sum of the values in those cells.

    Rate this question:

  • 7. 

    What function would you use to calculate today's date so that tomorrow it updates.

    • =TODAY()

    • =[date]

    • =[system date]

    Correct Answer
    A. =TODAY()
    Explanation
    The correct answer is "=TODAY()". This function is used in Excel to calculate the current date. When this formula is used, it will automatically update to the current date every time the spreadsheet is opened or recalculated. This ensures that the date displayed is always accurate and reflects the current day.

    Rate this question:

  • 8. 

    You can display a formula by pressing the _____ keys.

    • Alt+~

    • Ctrl+~

    • Ctrl+W

    • Ctrl+¬

    Correct Answer
    A. Ctrl+~
    Explanation
    To display a formula, you can press the Ctrl+~ keys.

    Rate this question:

  • 9. 

    FUNCTION(argument1,argument2, ...) Is ________.

    • The syntax of writing optional arguments.

    • An example of a formula.

    • The general syntax of all functions.

    Correct Answer
    A. The general syntax of all functions.
    Explanation
    The given correct answer states that the function "FUNCTION(argument1,argument2, ...)" represents the general syntax of all functions. This means that the syntax provided is a template that can be used to define any function, regardless of the specific arguments or functionality it may have. It does not refer to optional arguments or a specific formula, but rather serves as a general representation of how functions are written in programming or mathematical contexts.

    Rate this question:

  • 10. 

    A function inside another function is called a _____________ function.

    • Nested

    • Round

    • Complex

    • Compound

    Correct Answer
    A. Compound
    Explanation
    A function inside another function is called a compound function because it is a combination of multiple functions working together to achieve a specific task. The outer function acts as a container or wrapper for the inner function, allowing them to interact and share data. This nesting of functions can help organize code, improve modularity, and make it easier to understand and maintain.

    Rate this question:

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

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 07, 2011
    Quiz Created by
    Nsurani
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.