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
L...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller HopeJewels. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
