CPSP Exam 1 Questions and Answers (100% Pass)

T/F You can use the END or OR functions to build complex conditions in you IF function 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 True T/F A workbook can contain multiple worksheets in Excel True T/F In excel, you can assign a name for your Table True T/F There is no way to enforce a certain order to be used when sorting text values. Text values can only be sorted alphabetically in excel False Master01 | October, 2024/2025 | Latest update 1 | P a g e | © copyright 2024/2025 | Grade A+ T/F PivotTables can only display existing data, not calculate new values True T/F Filtering a field from a PivotChart will filter that field from the associated PivotTable 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 False T/F Tables only make you spreadsheet look nicer, and contain no extra functionality False T/F You can apply a name to an individual cell to to a range of cells True T/F Excel can be considered a database False Master01 | October, 2024/2025 | Latest update 1 | P a g e | © copyright 2024/2025 | Grade A+ T/F In excel you can reference cells on different worksheets, but not cells in different workbooks False T/F You can only import data from a text or cvs file into Excel, but not from any other file type or data source False T/F When you make a change to the underlying data table that a PivotTable uses, the PivotTable will update automatically False T?F Excel does not have any functions that manipulate text, only functions that manipulates numbers False T/F You cannot use conditional formatting in excel unless you are working with a Table False Master01 | October, 2024/2025 | Latest update 1 | P a g e | © copyright 2024/2025 | Grade A+ T/F You can "nest" your logical function calls by calling one logical function as the argument to another logical function 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 True T/F When using an approximate match with a lookup function call, the rows in the lookup table must be in ascending order True T/F You can only sort by the values in one column in excel. If there are any rows with the same values