ISM Final Exam
Which one of the following statements is true?
Horizontal sorting can be done only for the data stored in rows
Which one of the following statements about the coefficient of variation is NOT correct?
it is useful in comparing the mean of two data sets with the different standard deviations
Which one of the following is correct about the MEDIAN function?
it returns the average of middle values in a data set with even numbers of values
Which one of the following is correct about MODE.SNGL?
it returns the lowest value if there are multiple values with the same frequency
Which one of the following is an accurate statement about frequency?
it tells us how man times an outcome has occurred when an experiment is repeated several times
Which one of the following is the most ideal graph and chart type to visualize the relationship between a pair of continuous variables?
line chart
Which one of the following is correct?
one can apply stack concept to bar, column, and area charts
Which one of the following is suitable to compare composite parts of the whole?
pie chart
Which one of the following s correct about the Boolean expression "X>3" AND "Y>5" OR "Z=3"?
returns 1 when "X>3" = TRUE, "Y>5" =TRUE, "Z=3"= FALSE
Which one of the following about the IF statement =IF(OR(Red Card>=2, Yellow cad>=2, Green card>=2), Yes, No
returns NO if ant one card is shown less than two times
Which one of the following statements about unique value filtering is the true statement?
selected values are displayed
Which one of the following formulae has an absolute cell reference?
"=$A$1"
Which one of the following statements is true about bubble and radar chart are true?
Both bubble and radar charts are 3D charts
If 4 is stored in cell A1 and 2 is stored in cell B1 and 6 is stored in cell C1; which one of the following formulas will return an answer 36?
"=(A1+B1)*C1"
Which of the following formulae has a relative cell reference?
"=B2"
Which one of the following is not a Boolean expression?
"XUY"
Which error SUMPRODUCT will throw when the number of cells in array1 is not equal to number of cells in array2?
#VALUE! Error
Which one of the following is more correct?
100% stacked bars charts are not useful for comparing levels across categories but are useful in comparing compositions within and across categories
A cell formatted as % when a value of 2 is entered in the cell, the value displayed will be
200%
To freeze the top 3 rows, the rows the cursor should be placed at the following cell location
A4
Which one of the following is the correct interpretation of the formula with structured reference =Sum (Quarterly sales[[#totals],[2017],[2018]])
Add totals sales of the column 2017 and column 2018
Bars and columns are similar, except
Both A and B are correct
Which one of the following will identify the cell reference in a formula and its corresponding location in a worksheet?
Cell reference are highlighted, and cell location are outlined in matching colours.
Which one of the following is NOT true about cell style and productivity?
Cell styles offer eye soothing look and feel and hence improve productivity
Which one of the following is accurate about COUNTIFS and FREQUENCY functions in excel?
FREQUENCY function is enough to count frequencies for all bins
The small green square in the lower-right corner of a selected cell that is used to copy the formula down is known as
Fill handle
Which one of the following groups has error checking and evaluate formula commands?
Formula auditing
A prewritten or inbuilt formula in excel is also known as
Function
Which one of the following cell styles is ideal to be a visual cue for Employee performance?
Good-Bad-Neutral
Which one of the following statements is correct about the if statement "=IF(AND(Weekday<> "saturday". Weekday<> "Sunday"), "GO TO WORK", "HEAD TO BEACH"))"?
HEAD TO BEACH if weekday is either Saturday or Sunday
Which one of the following statements about the IFS statement is accurate?
IFS function is available in office 365 but not in office 2019
Which one of the following statements about the IFS statement is not accurate?
IFS statement does not have a Boolean expression
The main difference between nested IF statement and ifs statement is
IFS statement does not have a value assigned for FALSE outcome whereas nested IF statement has a value assigned for the False outcome
Which one of the following formatting properties are defined in cell styles?
Number, alignment, font, border, fill, and protection
Sorting means
Rearranging data
Applying clear formatting command to a group of cells will
Restore the entire cell content to default format as well as unmerge the cells
The workbook name is displayed in
Ribbon
Which one of the statements is correct about STDEV.S and STDEV.P?
STDEV.P can be used for any data set whee you do not want t make a statement about the population
Which one of the following is correct with respect to X-axis label and X-axis title? 1. X-axis label= January, February.... December and x-axis title is "months in a year" 2. X-axis title= January, February.... December and x-axis label is "months in a year"
Statement 1 is correct, and the statement 2 is incorrect
Which of the following will occur when the formula =B1+$B$2 in E5 is copied down the column?
The cell reference B1 will change and the cell reference $B$2 will not change
Which one of the statements is correct about VAR.S and VAR.P?
VAR.P can be used for any data set where you do not want to make a statement about the population
Which one of the following is true about the FREQUENCY function?
While counting frequencies for a given class interval, it includes the upper limit of class interval
Which one of the following is not a Boolean expression?
X*Y
Which one of the following is true with 100% stack bar charts?
all bars are of the same length
Excel can be used as a
all of the above
In a nested IF statement the second IF function can be in
anywhere in Boolean expression or values assigned for either TRUE or False outcome
Which one of the following is NOT an accurate statement about conditional formatting?
applies cell formatting based on the color scale
Which one of the following is an accurate statement about conditional formatting?
applies cell formatting conditional to the cell value
Which one is more accurate: a nested logical function will have
at least on logical function in addition to IF function
Which one of the following is more correct? A nested if statement will have:
at least two if statements
The command on the home tab which computed the total of the selected cells automatically is
autosum
Which one of the following is suitable to compare categories
bar chart
Which of the following is correct with respect to the distorted scale? 1. A distorted scale magnifies relative change in one axis with respect to the other 2. A distorted scale diminished relative change in one axis with respect to the other
both are correct
Which of the following statements about count function is true? 1. A count function will count the cell if the cell is blank 2. A count function will count the cell if the cell has text value
both are incorrect
Overflowing content in a cell can be fitted by
both options A and B are correct
Which one of the following statements about count function is true? 1. Autosum command is found in home tab under editing grup 2. Autosum command is found in formula tab next to insert function command
both statements are correct
A cell is displaying today's date in MM-DD-YYYY format, applying clear formatting to the cell will
display the cell content as number
Statistical experiment is
drawing a sample from a population
Which one of the following is the most correct any given 100% stacked column chart?
columns will be of the equal height and compositions within a column will be of varying height
Groups are subdivided into
commands
Which one of the following cell styles is ideal to be a visual cue for stimulating quarterly sales?
data and model
Which one of the following is indicated by the Legend?
data series
Which one of the following is accurate about statistical experiment?
each event will haven an equal chance to occur
A worksheet can be renamed by
either A or B
Which one of the following is NOT correct about the excel tables?
excel tables are convenient in performing sensitivity analysis
Which one of the following statements about filtering and sorting is true?
filtering can be applied to columns but not rows
Which one of the following is NOT a part of the excel table?
footer
Where is the insert function command function found in Microsoft excel?
formula bar
Tabs are subdivided into
groups
Which one of the following is true about the KURT function?
if KURT function returns a numbers is higher than +1, then more values in the data set are crowded at the center
Which one of the following is true about the SKEW function?
if SKEW returns a positive value, then ,more data points are higher than the central value
Average is an example of which function library
statistical
Which one of the following statements is correct about structured reference?
structured reference is a method of referencing the tables values in formulas located inside or outside the table
Which one of the following is NOT correct about the structured reference?
structured reference is the same as a cell reference
Page layout is a
tab
A right aligned cell has content whose length is more than the cell width, the content will be shown overflowing in
the cells which are to the right of the current cell
A cell may display #### value because
the column is not wide enough to show the cell value
Which one of the following statements is more accurate when data is multiple columns are sorted vertically in descending order?
the entire row containing the lowest value in the sorted column will be at the top
Which one of the following is true about #SPILL error?
the frequency function returns #SPILL error if there are insufficient empty cells to display frequencies
Which one of the following is the most accurate about the dynamic chart?
the graph will automatically change when we add or remove rows and columns in the excel table
Which one of the following is true about the OHLC chart?
the thin bar is always longer than thick bar
Which one of following is true about OHLC chart?
thick bar connects OPEN and CLOSE price points whereas thin bar connects HIGH and LOW prices
Which one is more correct: q typical IF statement will have
three argument
By default, excel creates a workbook with
three worksheets
Which one of the following cell styles is ideal to be a visual cue for research report?
titles and heading
Which one of the following is true about filtering and sorting?
two columns can be filtered independently
Which one of the statements is true about frequency distribution?
values in the data array are distributed into bins
Which one of the following is not a Boolean expression
warm and humid
Which one of the following is true about slicer?
we can deselect rows but not columns to remove them from the display