309 final - excel
Which of the following is an Excel tool that can parse strings of data into their
component parts?
Text to Columns
Pivot Tables
Conditional Formatting correct answers Text to Columns
Which of the following is not a commonly used character extraction formula?
RIGHT
SUMIF
MID
LEFT correct answers sumif
TRUE OR FALSE Delimited text can be separated by delimiters such as commas,
spaces, or other characters. correct answers true
TRUE OR FALSE When a filter is applied to a data set, it should be applied at the
column heading level. correct answers TRUE
Which tab is the 'Text to Columns' feature located on? correct answers data
Which dialog box allows users to view, edit, and delete named ranges?
Print titles
Data validation
Text box
Name manager correct answers name manager
The following scope for a named range allows for the name to be used in any worksheet
in the workbook:
Workbook-level names
Worksheet-level names correct answers workbook
Formatting can be applied efficiently to multiple tabs by grouping worksheets.
True
False correct answers true
Which type of message is viewable prior to entering data in a cell?
Input message
Error alert correct answers input
success
, Data validation is located under which group within the Data tab?
Data tools
Sheet options
Analyze
Connections correct answers data tools
Which of the following will result if a column referenced elsewhere in a formula is
deleted?
Formula will result in errors
Formula will be flagged
Formula will not be impacted
Formula will be erased correct answers Formula will result in errors
Which of the following dialog boxes is useful when editing the range of conditional
formatting rules?
Clear Rules
Manage Rules
Highlight Cells Rules
Conditional Formatting correct answers manage rules
How would the minimum score to achieve a certain letter grade be calculated?
(Regular points - Extra credit points) x Letter grade %
Extra credit points x Letter grade %
(Regular points + Extra credit points) x Letter grade %
Regular points x Letter grade % correct answers Regular points x Letter grade %
Which of the following dialog boxes is useful when entering formula syntax and
arguments?
Data Validation
Name Manager
Insert Function
Page Setup correct answers insert function
Which of the following calculations is inherently subject to rounding?
MINIMUM
MAXIMUM
MODE
AVERAGE correct answers average
Writing formulas that have functions within functions is sometimes referred to as
_______.
entering
nesting
naming
success
Which of the following is an Excel tool that can parse strings of data into their
component parts?
Text to Columns
Pivot Tables
Conditional Formatting correct answers Text to Columns
Which of the following is not a commonly used character extraction formula?
RIGHT
SUMIF
MID
LEFT correct answers sumif
TRUE OR FALSE Delimited text can be separated by delimiters such as commas,
spaces, or other characters. correct answers true
TRUE OR FALSE When a filter is applied to a data set, it should be applied at the
column heading level. correct answers TRUE
Which tab is the 'Text to Columns' feature located on? correct answers data
Which dialog box allows users to view, edit, and delete named ranges?
Print titles
Data validation
Text box
Name manager correct answers name manager
The following scope for a named range allows for the name to be used in any worksheet
in the workbook:
Workbook-level names
Worksheet-level names correct answers workbook
Formatting can be applied efficiently to multiple tabs by grouping worksheets.
True
False correct answers true
Which type of message is viewable prior to entering data in a cell?
Input message
Error alert correct answers input
success
, Data validation is located under which group within the Data tab?
Data tools
Sheet options
Analyze
Connections correct answers data tools
Which of the following will result if a column referenced elsewhere in a formula is
deleted?
Formula will result in errors
Formula will be flagged
Formula will not be impacted
Formula will be erased correct answers Formula will result in errors
Which of the following dialog boxes is useful when editing the range of conditional
formatting rules?
Clear Rules
Manage Rules
Highlight Cells Rules
Conditional Formatting correct answers manage rules
How would the minimum score to achieve a certain letter grade be calculated?
(Regular points - Extra credit points) x Letter grade %
Extra credit points x Letter grade %
(Regular points + Extra credit points) x Letter grade %
Regular points x Letter grade % correct answers Regular points x Letter grade %
Which of the following dialog boxes is useful when entering formula syntax and
arguments?
Data Validation
Name Manager
Insert Function
Page Setup correct answers insert function
Which of the following calculations is inherently subject to rounding?
MINIMUM
MAXIMUM
MODE
AVERAGE correct answers average
Writing formulas that have functions within functions is sometimes referred to as
_______.
entering
nesting
naming
success
