CPSP EXAM 1 2024 WITH 100% CORRECT ANSWERS

CPSP EXAM 1 2024 WITH 100% CORRECT ANSWERS T/F You can use the END or OR functions to build complex conditions in you IF function - correct 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 - correct answer True T/F A workbook can contain multiple worksheets in Excel - correct answer True T/F In excel, you can assign a name for your Table - correct answer 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 - correct answer False T/F PivotTables can only display existing data, not calculate new values - correct answer True T/F Filtering a field from a PivotChart will filter that field from the associated PivotTable - correct answer True