1.
This error is the most often the result of specifying a mathematical operation with one or more cells that contain text.
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.
2.
This warning means that your formula referred to a cell that doesn’t exist, and thus the result cannot be displayed.
Correct Answer
B. #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!
3.
Occurs if you insert a space instead of a comma between ranges used in function arguments.
Correct Answer
D. #NULL
Explanation
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.
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.
Correct Answer
C. #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.
5.
The content of the cell cannot be displayed correctly as the cell column is too narrow.
Correct Answer
B. ####
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.
6.
A cell that contains the value o or is blank.
Correct Answer
C. #DIV/o
Explanation
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.
7.
No value available appear, Technically, this is not an error value but a special value.
Correct Answer
D. #N/A
Explanation
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.
8.
Excel doesn’t recognize a name, which formula cannot be computed if text is included.
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.
9.
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.
Correct Answer
C. References
Explanation
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.
10.
It does not adjust the cell reference when you move or copy a formula.
Correct Answer
B. Absolute References
Explanation
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.
11.
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.
Correct Answer
A. Relative References
Explanation
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.
12.
These are combination of relative and absolute reference such as relative column and absolute row or column and relative row.
Correct Answer
D. Mix References
Explanation
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.
13.
This function allows you to compute the periodic payment amount for a loan on a car, house, or Education plan.
Correct Answer
A. PMT Function
Explanation
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.
14.
This function will give you the present value or the lump-sum amount that a series of payment is worth right now.
Correct Answer
D. PV
Explanation
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.
15.
This function is the payment made each period; thus, it cannot change over the life of an annual.
Correct Answer
A. PMT Function
Explanation
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.
16.
This function is the total number of payment period in a year
Correct Answer
C. NPER
Explanation
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.
17.
This function will return the interest rate per period of an annuity. It calculated by iteration and can have zero or more solutions.
Correct Answer
B. RATE
Explanation
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.
18.
It is to create a new file.
Correct Answer
A. Ctrl + N
Explanation
Pressing Ctrl + N is the keyboard shortcut to create a new file. This shortcut is commonly used in various software applications, including text editors, word processors, and graphic design programs. By pressing Ctrl + N, users can quickly start a new project or document without having to go through the menu options or toolbar buttons. It is a convenient way to increase productivity and efficiency when working with multiple files or documents simultaneously.
19.
It is used to close single file.
Correct Answer
A. Crtl + W
Explanation
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.
20.
It is used to close application file.
Correct Answer
D. Alt + F4
Explanation
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.
21.
It is used to save a file.
Correct Answer
D. All of the above
Explanation
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.
22.
To open ms excel using cmd command, type:
Correct Answer
C. Type excel.exe
Explanation
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.
23.
It is to undo your previous action.
Correct Answer
A. Ctrl + Z
Explanation
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.
24.
In Using Formulas, One of the most valuable features of excel is to:
Correct Answer
A. To store mathematical calculation
Explanation
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.
25.
It is a data entry capable of performing mathematical and logical operations automatically.
Correct Answer
C. Formulas
Explanation
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.