ISM Final Exam

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

ECCO: Hemodynamic Monitoring Critically Ill Patients: Part 1

View Set

NCLEX - Management of Care, Interprofessional Collaboration, Delegating & Supervising

View Set

Intro to Data Analytics Study Guide

View Set

Malcolm X, Nation of Islam and Black Power

View Set