Exam (elaborations)
CPSP Exam 1 Questions And Answers
- Course
- Institution
CPSP Exam 1 Questions And Answers...
[Show more]
Content preview
CPSP Exam 1 Questions And AnswersT/F You can use the END or OR functions to build complex conditions in you IF function -
Answer True
T/F You can "nest" IF functions by having the if_true or if_false parameters be a call to
another IF function. This allows for ore complicated logical structures - Answer True
T/F A workbook can contain multiple worksheets in Excel - Answer True
T/F In excel, you can name for your Table - Answer True
T/F It is not possible to enforce any kind of order to be utilized when sorting the text
values. In excel the text values can only be sorted alphabetically - Answer False
T/F PivotTables can only display existent data, cannot calculate new values - Answer
True
T/F Filtering a field from a PivotChart will filter that field from the associated PivotTable
- Answer True
T/F Goal Seek allows for you to change multiple variables in you calculation to find one
specific value for the output of that equation - Answer False
T/F Tables only make you spreadsheet look nicer, and contain no extra functionality -
Answer False
T/F You can apply a name to an individual cell to a range of cells - Answer True
, T/F Excel can be considered a database - Answer False
T/F In excel you can reference cells on different worksheets, but not cells in different
workbooks - Answer False
T/F You can import data only from a text or cvs file into Excel and no others
Answer False
T/F When you make a change to the underlying data table that a PivotTable uses, the
PivotTable will refresh
Answer False
T?F Excel does not have any functions that manipulate text, only functions that
manipulates numbers
Answer False
T/F You cannot use conditional formatting in excel unless you are working with a Table -
Answer False
T/F You can "nest" your logical function calls by calling one logical function as the
argument to another logical function - Answer True
T/F The SUMIFS function allows you to enter criteria that will determine whether that
values in the individual cells will be included in the sum - Answer True
T/F When doing an approximate match using a lookup function call, the rows in the
lookup table must be sorted in ascending order - True
T/F In excel you can only sort by the values in one column. If there are any rows which
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 Stetson. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now