Microsoft Excel 2007- Formulas And Function
-
It is to create a new file.
-
Ctrl + N
-
Ctrl + O
-
Ctrl + Z
-
Ctrl + H
-
About This Quiz
This Microsoft Excel 2007 quiz assesses understanding of formulas and functions, focusing on common errors like #VALUE! and #REF!, and nuances in function syntax. It enhances skills crucial for effective spreadsheet management and data analysis.
Quiz Preview
- 2.
Excel doesn’t recognize a name, which formula cannot be computed if text is included.
-
NAME?
-
####
-
#DIV/o
-
#N/A
Correct Answer
A. NAME?Explanation
When Excel encounters the text "NAME?" in a formula, it means that it does not recognize the name being referred to in the formula. This could be because the name has not been defined or it has been misspelled. As a result, the formula cannot be computed correctly and displays "NAME?" as an error.Rate this question:
-
- 3.
These are combination of relative and absolute reference such as relative column and absolute row or column and relative row.
-
Relative References
-
Absolute References
-
References
-
Mix References
Correct Answer
A. Mix ReferencesExplanation
Mix references refer to a combination of relative and absolute references in a formula. This means that some parts of the formula are fixed and will not change when copied or filled down, while other parts will adjust based on the relative position of the cell. This allows for more flexibility in formulas, as certain values can be kept constant while others change dynamically. Mix references are useful when you want to refer to a specific cell or range, but also want to apply the formula to other cells.Rate this question:
-
- 4.
Occurs when invalid argument exist in an Excel function or a formula procedures a number that is too large or too small to be represented in the worksheet.
-
#VALUE!
-
#REF!
-
#NUM!
-
#NULL
Correct Answer
A. #NUM!Explanation
The answer #NUM! is correct because it represents the error that occurs when an invalid argument is used in an Excel function or when a formula processes a number that is either too large or too small to be represented in the worksheet. This error can happen when performing calculations with extremely large or small numbers, or when using functions that require specific input formats that are not met.Rate this question:
-
- 5.
It is used to close application file.
-
Crtl + W
-
Ctrl + O
-
Ctrl + P
-
Alt + F4
Correct Answer
A. Alt + F4Explanation
Alt + F4 is the correct answer because it is a keyboard shortcut commonly used to close an application or window. When pressed, it sends a signal to the operating system to close the currently active window or application. This shortcut is widely known and used in many operating systems, including Windows.Rate this question:
-
- 6.
This function will return the interest rate per period of an annuity. It calculated by iteration and can have zero or more solutions.
-
PMT Function
-
RATE
-
NPER
-
PV
Correct Answer
A. RATEExplanation
The RATE function in the PMT formula is used to calculate the interest rate per period of an annuity. It is calculated through iteration and can have zero or more solutions. This means that depending on the values of NPER, PV, and PMT, the function may return a single interest rate or multiple possible interest rates. The exact calculation method and the number of solutions will vary depending on the specific values provided.Rate this question:
-
- 7.
It is to undo your previous action.
-
Ctrl + Z
-
Ctrl + Y
-
Ctrl + P
-
Ctrl + Y
Correct Answer
A. Ctrl + ZExplanation
Ctrl + Z is the correct answer because it is the keyboard shortcut used to undo the previous action. This shortcut is commonly used in various applications and programs to reverse the last action performed by the user. It is a convenient way to correct mistakes or revert changes without having to manually redo the entire process.Rate this question:
-
- 8.
It stores the exact location of the cell to which the formula refers while taking careful note of where those cells are located in relation to the cell that contains the formula.
-
Relative References
-
Absolute References
-
References
-
Mix References
Correct Answer
A. Relative ReferencesExplanation
Relative references in a formula store the location of the cell relative to the cell that contains the formula. This means that if the formula is copied to another cell, the reference will adjust accordingly. For example, if a formula refers to cell A1 and is copied to cell B1, the reference will automatically change to B1. This allows for easy replication of formulas across multiple cells without having to manually adjust the references.Rate this question:
-
- 9.
The content of the cell cannot be displayed correctly as the cell column is too narrow.
-
NAME?
-
####
-
#DIV/o
-
#N/A
Correct Answer
A. ####Explanation
The content of the cell cannot be displayed correctly as the cell column is too narrow. This is indicated by the fact that the value in the cell is displayed as "####" instead of the actual content. The "####" is a placeholder used to represent data that cannot be displayed due to formatting constraints.Rate this question:
-
- 10.
No value available appear, Technically, this is not an error value but a special value.
-
NAME?
-
####
-
#DIV/o
-
#N/A
Correct Answer
A. #N/AExplanation
The correct answer is #N/A. In this context, #N/A is not considered an error value but rather a special value. It is used to indicate that there is no available value or that the value is not applicable. It is commonly used in situations where data is missing or cannot be determined.Rate this question:
-
- 11.
This error is the most often the result of specifying a mathematical operation with one or more cells that contain text.
-
#VALUE!
-
#REF!
-
#NUM!
-
#NULL
Correct Answer
A. #VALUE!Explanation
The error #VALUE! occurs when a mathematical operation is performed on cells that contain text instead of numerical values. This error is commonly seen when trying to perform calculations or formulas on cells that have not been properly formatted as numbers or contain non-numeric characters.Rate this question:
-
- 12.
This warning means that your formula referred to a cell that doesn’t exist, and thus the result cannot be displayed.
-
#VALUE!
-
#REF!
-
#NUM!
-
#NULL
Correct Answer
A. #REF!Explanation
The warning #REF! means that the formula in question is referring to a cell that doesn't exist. This could be because the cell was deleted or moved, causing the formula to lose its reference. As a result, the correct answer is #REF!Rate this question:
-
- 13.
It is a data entry capable of performing mathematical and logical operations automatically.
-
Data Entry
-
Solution Program
-
Formulas
-
None of the above
Correct Answer
A. FormulasExplanation
The correct answer is "Formulas" because formulas are a set of instructions that perform mathematical and logical operations automatically. In the context of data entry, formulas are commonly used to perform calculations and manipulate data in spreadsheets or databases. They allow for efficient and accurate data processing by automating repetitive tasks and ensuring consistency in calculations.Rate this question:
-
- 14.
In Using Formulas, One of the most valuable features of excel is to:
-
To store mathematical calculation
-
Expression in individual cell
-
To edit the text on the workspace
-
None of the above
Correct Answer
A. To store mathematical calculationExplanation
Excel is a powerful tool for storing and manipulating data, and one of its most valuable features is the ability to store mathematical calculations in individual cells. This allows users to perform complex calculations and formulas within the spreadsheet, making it easier to analyze and interpret data. By storing mathematical calculations in cells, users can easily update and modify the calculations as needed, saving time and effort.Rate this question:
-
- 15.
It identifies a cell or range on a worksheet and tells MS Excel where to look for the values or data that you want to use in a formula.
-
Relative References
-
Absolute References
-
References
-
Mix References
Correct Answer
A. ReferencesExplanation
The correct answer is "References". In MS Excel, references are used to identify a cell or range on a worksheet. They tell Excel where to look for the values or data that you want to use in a formula. References can be either relative or absolute, depending on whether they adjust when the formula is copied or not. Mixing references allows you to combine both relative and absolute references in a formula.Rate this question:
-
- 16.
Occurs if you insert a space instead of a comma between ranges used in function arguments.
-
#VALUE!
-
#REF!
-
#NUM!
-
#NULL
Correct Answer
A. #NULLExplanation
The given correct answer is #NULL. This error occurs when you insert a space instead of a comma between ranges used in function arguments. This means that the function is unable to recognize the intended ranges and returns the #NULL error.Rate this question:
-
- 17.
It does not adjust the cell reference when you move or copy a formula.
-
Relative References
-
Absolute References
-
References
-
Mix References
Correct Answer
A. Absolute ReferencesExplanation
Absolute references do not adjust the cell reference when you move or copy a formula. This means that if you have a formula with an absolute reference, the cell reference will remain the same even if you move or copy the formula to a different cell. This is useful when you want to refer to a specific cell or range of cells that should not change regardless of where the formula is copied or moved.Rate this question:
-
- 18.
This function allows you to compute the periodic payment amount for a loan on a car, house, or Education plan.
-
PMT Function
-
RATE
-
NPER
-
PV
Correct Answer
A. PMT FunctionExplanation
The PMT function is used to calculate the periodic payment amount for a loan on a car, house, or education plan. It requires three inputs: RATE (the interest rate for the loan), NPER (the total number of payment periods), and PV (the present value or loan amount). By using these inputs, the PMT function can determine the fixed payment amount that needs to be made at regular intervals to repay the loan.Rate this question:
-
- 19.
A cell that contains the value o or is blank.
-
NAME?
-
####
-
#DIV/o
-
#N/A
Correct Answer
A. #DIV/oExplanation
The correct answer is #DIV/o. This is because the question states that a cell is considered to have the value of zero or be blank. Among the given options, #DIV/o is the only one that fits this criteria. The other options, NAME? and #N/A, do not represent a value of zero or a blank cell.Rate this question:
-
- 20.
This function is the total number of payment period in a year
-
PMT Function
-
RATE
-
NPER
-
PV
Correct Answer
A. NPERExplanation
The NPER function calculates the total number of payment periods in a year. It is used in financial calculations to determine the length of time required to pay off a loan or investment, based on a fixed payment amount and interest rate. The NPER function takes into account the interest rate, payment amount, and present value of the loan or investment to calculate the number of periods needed to reach the desired outcome.Rate this question:
-
- 21.
It is used to close single file.
-
Crtl + W
-
Ctrl + O
-
Ctrl + P
-
Alt + F4
Correct Answer
A. Crtl + WExplanation
Ctrl + W is the correct answer because it is a keyboard shortcut commonly used to close a single file or tab in various applications, including web browsers and text editors. This shortcut is often used as an alternative to clicking the close button or selecting the close option from the file menu.Rate this question:
-
- 22.
This function will give you the present value or the lump-sum amount that a series of payment is worth right now.
-
PMT Function
-
RATE
-
NPER
-
PV
Correct Answer
A. PVExplanation
The correct answer is PV because the given explanation states that the function will give the present value or lump-sum amount that a series of payment is worth right now. The PV function in finance is used to calculate the present value of an investment or a series of cash flows. It takes into account the interest rate, the number of periods, and the future value of the cash flows to determine their current worth. Therefore, the PV function is the correct answer in this context.Rate this question:
-
- 23.
It is used to save a file.
-
Ctrl + S
-
File>Save As
-
Save Button
-
All of the above
Correct Answer
A. All of the aboveExplanation
The correct answer is "All of the above" because all three options - Ctrl + S, File>Save As, and the Save Button - can be used to save a file. Ctrl + S is a keyboard shortcut commonly used to save a file, File>Save As is a menu option to save a file with a different name or format, and the Save Button is a graphical button typically found in software applications that allows users to save their work. Therefore, all three options are valid ways to save a file.Rate this question:
-
- 24.
To open ms excel using cmd command, type:
-
Type msexcel
-
Type msexcel.exe
-
Type excel.exe
-
Type msexcel2007.exe
Correct Answer
A. Type excel.exeExplanation
The correct answer is "type excel.exe" because "excel.exe" is the executable file for Microsoft Excel. By typing this command in the command prompt, it will open Microsoft Excel application.Rate this question:
-
- 25.
This function is the payment made each period; thus, it cannot change over the life of an annual.
-
PMT Function
-
RATE
-
NPER
-
PV
Correct Answer
A. PMT FunctionExplanation
The PMT function is used to calculate the payment made each period. It calculates a constant payment amount that remains the same over the life of an annual. This means that the payment amount does not change throughout the duration of the loan or investment. The PMT function is commonly used in financial calculations to determine loan payments, mortgage payments, or annuity payments.Rate this question:
-
Quiz Review Timeline (Updated): Mar 20, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 17, 2011Quiz Created by
Johnwyne