BADM 210 EXAM 1 STUDYING
QUESTIONS AND ANSWERS
What is the technique called where an analyst will select a column of data and put it in
order from largest to smallest?
(a)
Moving/Copying a Sheet
(b)
Saving the File
(c)
Referencing a group of cells
(d)
Sorting and Filtering - Correct Answers -Sorting and Filtering
What is the function of an absolute reference?
(a)
Protects cell from edits
(b)
References the entire column selected
(c)
Locks the appropriate cell to prevent changes when copied
(d)
Renames the cell for easier referencing in subsequent formulas - Correct Answers -
Locks the appropriate cell to prevent changes when copied
What type of reference in Excel is this: $A$45?
(a)
Full Column Reference
(b)
Absolute Reference
(c)
Full Row Reference
(d)
Relative Reference - Correct Answers -Absolute Reference
What does the COUNTIF function in Excel return?
, (a)
The number of cells in a specified range whose values meet a certain condition
(b)
The number of cells in a specified range without entries
(c)
The average of all the values in a specified range
(d)
The sum of all the values in a specified range meeting a certain condition - Correct
Answers -The number of cells in a specified range whose values meet a certain
condition
An analyst types "=0.95" into a cell but it is displayed as "1.0" after exiting the cell. How
can the analyst see the value with more decimal precision?
(a)
The analyst can format the cell with "Align Right" under Alignment to show all values to
the right of the decimal point
(b)
The analyst can format the cell with "Align Left" under Alignment to show all values to
the right of the decimal point
(c)
The analyst can format the cell with "Decrease Decimal" under Number to see fewer
decimal figures
(d)
The analyst can format the cell with "Increase Decimal" under Number to see more
decimal figures - Correct Answers -The analyst can format the cell with "Increase
Decimal" under Number to see more decimal figures
Why do analysts use the VLOOKUP function in Excel?
(a)
To search a series of horizontal values for a reference value and return the associated
value
(b)
To find the row number of a data point of interest
(c)
To search a series of vertical values for a reference value and return the associated
value
(d)
To find the number of occupied cells within a selected range - Correct Answers -To
search a series of vertical values for a reference value and return the associated value
What does the "=" sign tell Excel when typed into a cell?
(a)
QUESTIONS AND ANSWERS
What is the technique called where an analyst will select a column of data and put it in
order from largest to smallest?
(a)
Moving/Copying a Sheet
(b)
Saving the File
(c)
Referencing a group of cells
(d)
Sorting and Filtering - Correct Answers -Sorting and Filtering
What is the function of an absolute reference?
(a)
Protects cell from edits
(b)
References the entire column selected
(c)
Locks the appropriate cell to prevent changes when copied
(d)
Renames the cell for easier referencing in subsequent formulas - Correct Answers -
Locks the appropriate cell to prevent changes when copied
What type of reference in Excel is this: $A$45?
(a)
Full Column Reference
(b)
Absolute Reference
(c)
Full Row Reference
(d)
Relative Reference - Correct Answers -Absolute Reference
What does the COUNTIF function in Excel return?
, (a)
The number of cells in a specified range whose values meet a certain condition
(b)
The number of cells in a specified range without entries
(c)
The average of all the values in a specified range
(d)
The sum of all the values in a specified range meeting a certain condition - Correct
Answers -The number of cells in a specified range whose values meet a certain
condition
An analyst types "=0.95" into a cell but it is displayed as "1.0" after exiting the cell. How
can the analyst see the value with more decimal precision?
(a)
The analyst can format the cell with "Align Right" under Alignment to show all values to
the right of the decimal point
(b)
The analyst can format the cell with "Align Left" under Alignment to show all values to
the right of the decimal point
(c)
The analyst can format the cell with "Decrease Decimal" under Number to see fewer
decimal figures
(d)
The analyst can format the cell with "Increase Decimal" under Number to see more
decimal figures - Correct Answers -The analyst can format the cell with "Increase
Decimal" under Number to see more decimal figures
Why do analysts use the VLOOKUP function in Excel?
(a)
To search a series of horizontal values for a reference value and return the associated
value
(b)
To find the row number of a data point of interest
(c)
To search a series of vertical values for a reference value and return the associated
value
(d)
To find the number of occupied cells within a selected range - Correct Answers -To
search a series of vertical values for a reference value and return the associated value
What does the "=" sign tell Excel when typed into a cell?
(a)
