1.
Which of these is not a predefined formula for analysis in excel?
Correct Answer
D. NUL
Explanation
The answer is NUL because it is not a predefined formula in Excel. IF, SUM, and VLOOKUP are all commonly used formulas in Excel for conditional statements, adding up values, and searching for specific data, respectively. However, NUL is not a recognized formula in Excel and does not perform any specific analysis function.
2.
What are the predefined excel formulas such as index etc, referred to?
Correct Answer
C. Functions
Explanation
The predefined Excel formulas such as index are referred to as functions. Functions are built-in formulas that perform specific calculations or actions in Excel. They are designed to simplify complex calculations and automate repetitive tasks. Functions can be used to perform various operations such as mathematical calculations, logical operations, text manipulation, date and time calculations, and more.
3.
What is the function wizard called in Excel for Mac 2011?
Correct Answer
D. Formula builder
Explanation
The function wizard in Excel for Mac 2011 is called the "Formula builder." This tool helps users create complex formulas by providing a step-by-step guide and allowing them to select the desired functions and arguments. It simplifies the process of constructing formulas and ensures accuracy by providing a clear interface and options to choose from.
4.
Which of these is not a type of function used in Excel by a business analyst?
Correct Answer
D. Index Functions
Explanation
Index Functions is not a type of function used in Excel by a business analyst. Excel offers various types of functions that are commonly used by business analysts, such as Logical Functions, Financial Functions, and Lookup Functions. However, Index Functions are not typically used by business analysts in their data analysis and reporting tasks.
5.
Which of these is not an example of financial functions?
Correct Answer
A. IQT
Explanation
IQT is not an example of a financial function. Financial functions typically involve calculations related to money, investments, and financial planning. IQT is not a commonly used financial function and does not have a specific financial meaning.
6.
Which does a business analyst find more convenient to use when working on excel ?
Correct Answer
D. Keyboard
Explanation
A business analyst finds the keyboard more convenient to use when working on Excel because it allows for faster data entry and navigation. The keyboard shortcuts in Excel can help the analyst perform tasks quickly and efficiently, such as copying and pasting data, formatting cells, and navigating between worksheets. Additionally, the keyboard provides a tactile feedback that can aid in accuracy and precision when entering data.
7.
What does a business analyst use equal sign (=) shortcut for in excel modelling?
Correct Answer
C. Start a formula
Explanation
A business analyst uses the equal sign (=) shortcut in Excel modelling to start a formula. This is because in Excel, formulas always begin with an equal sign to indicate that the following characters are part of a calculation. By using the equal sign, the analyst can perform various calculations and manipulate data within the spreadsheet.
8.
The IF statement in excel takes three fields called?
Correct Answer
D. Arguments
Explanation
The IF statement in Excel takes three fields called arguments. Arguments are the values or expressions that are used by a function to perform calculations or operations. In the case of the IF statement, the arguments typically consist of a logical test, the value to return if the test is true, and the value to return if the test is false. These arguments allow the IF statement to evaluate a condition and return different results based on the outcome of the condition.
9.
What does a business analyst use COUNTIF for in excel?
Correct Answer
D. Counting the cells that match specified criteria
Explanation
A business analyst uses COUNTIF in Excel to count the cells that match specified criteria. This function allows the analyst to determine the number of cells that meet a certain condition or criteria, such as counting the number of sales transactions that exceed a certain amount or counting the number of customers in a specific age range. By using COUNTIF, the business analyst can quickly and accurately calculate the desired count based on the specified criteria.
10.
Can an analyst use AVERAGEIF in Excel 2007?
Correct Answer
A. Yes
Explanation
Yes, an analyst can use AVERAGEIF in Excel 2007. AVERAGEIF is a function in Excel that allows you to calculate the average of a range of cells based on a specified condition. It is available in Excel 2007 and can be used by analysts to calculate averages based on specific criteria, making it a useful tool for data analysis.