CPSP Exam 1 Questions And Answers
T/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
T/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
