CPSP Exam Practice questions and Answers 2025, Exams of Business Economics

Download CPSP Exam Practice questions and Answers 2025 and more Exams Business Economics in PDF only on Docsity!

• CPSP Exam Practice questions and Answers

AND Function - CORRECT ANSWER returns TRUE is all arguments evaluate to TRUE but false if not Arguments - CORRECT ANSWER input values that we pass into an excel function Cell - CORRECT ANSWER - singular unit of data in Excel

• where a row and a column meet
• named after the column and row EX: B Conditional Formatting - CORRECT ANSWER allows us to change the formatting rules of our cells based on some evaluation of a logical formula Criteria - CORRECT ANSWER - one or more arguments use with advanced logical functions
• cells are compared to the criteria
• if cells match, they are used Data Mining - CORRECT ANSWER fracture of examining large datasets and identifying patters, trends or other items of statistical significance Data Point in Charts - CORRECT ANSWER in a chart this is a cell containing a single piece of data Data series - CORRECT ANSWER in a chart is a set of related data points that will be associated together in the chart Field - CORRECT ANSWER small unit of data that we want to know about in our table. represented as a column Freeze - CORRECT ANSWER allow you to keep row and or column headers in view as you scroll through a large spreadsheet Function - CORRECT ANSWER - short cut for many common equations
• mini-program in Excel
• takes in info (arguments) and returns some value
• can call a function in a cell on a spreadsheet Function returns - CORRECT ANSWER - returns a value whenever it is called
• can be returned in a cell, formula, or value can be used as a argument to another function call Goal Seek - CORRECT ANSWER Allows us to find an exact value in variables tables How to type in a formula - CORRECT ANSWER use = to show that we are typing a formula and not text to display IF Function - CORRECT ANSWER - first argument is any statement that evaluates to true or false

/ for division ^ for exponent Spreadsheet - CORRECT ANSWER - one page in our workbook

• can select different or add new ones in the bottom left corner
• right click on the selector to rename it T?F Excel does not have any functions that manipulate text, only functions that manipulates numbers - CORRECT ANSWER False T/F A workbook can contain multiple worksheets in Excel - CORRECT ANSWER True T/F Excel can be considered a database - CORRECT ANSWER False T/F Filtering a field from a PivotChart will filter that field from the associated PivotTable - CORRECT 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 - CORRECT ANSWER False T/F If you have private info stored in a column in you workbook, and you need to send the workbook to someone else, you can just hide the column to secure that private info. The other user won't be able to unhide the column to view the private info - CORRECT ANSWER False T/F In excel you can reference cells on different worksheets, but not cells in different workbooks - CORRECT ANSWER False T/F In excel, you can assign a name for your Table - CORRECT ANSWER True T/F In excel, you can only sort a range of data on multiple columns if you turn the range into a Table. EX; sorting car sales by Date, then by profit - CORRECT ANSWER True T/F PivotTables can only display existing data, not calculate new values - CORRECT ANSWER True T/F Tables only make you spreadsheet look nicer, and contain no extra functionality - CORRECT ANSWER False 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 - 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 variable data tables that we create using What-If Analysis can only have one actual piece of data be variable - CORRECT ANSWER Fales T/F we can use custom formatting to display text in a cell while hiding the formula actually contained in the cell - CORRECT ANSWER True

T/F When using an approximate match with a lookup function call, the rows in the lookup table must be in ascending order - CORRECT ANSWER True T/F When you make a change to the underlying data table that a PivotTable uses, the PivotTable will update automatically - CORRECT ANSWER False 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 You can "nest" your logical function calls by calling one logical function as the argument to another logical function - CORRECT ANSWER True T/F You can always reference another cell in another workbook by supplying the workbook name - CORRECT ANSWER False T/F You can apply a name to an individual cell to to a range of cells - CORRECT ANSWER True 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 - CORRECT ANSWER False T/F You can only reference a cell that is touching the current cell - CORRECT ANSWER False T/F You can only reference another cell if it is on the same worksheet - CORRECT ANSWER False T/F You can only sort by the values in one column in excel. If there are any rows with the same values for that column, they are sorted randomly - CORRECT ANSWER False T/F You can reference a cell in another workbook is you can include the full file path to the workbook - CORRECT ANSWER True T/F You can reference cells on another worksheet by including the worksheet name in the reference - CORRECT ANSWER True T/F You can use the END or OR functions to build complex conditions in you IF function - CORRECT ANSWER True T/F You cannot use conditional formatting in excel unless you are working with a Table - CORRECT ANSWER False Table - CORRECT ANSWER structured range of related data in Excel What are columns named with - CORRECT ANSWER letters What are rows named with - CORRECT ANSWER numbers What are spreadsheets divided into? - CORRECT ANSWER rows and columns What are ways to filter data in a PivotTable - CORRECT ANSWER - Add the field you want to filter by to the "Filters" Area

• Create a Slicer

Sleepily silly When you make a change, such as applying a filter, to a PivotChart, what else will change? - CORRECT ANSWER - PivotTable related to a chart

• any PivotCharts related to the same table as this chart Where can you call a function in Excel - CORRECT ANSWER - in a cell
• as part of a formula
• as an argument inside another function call XOR Function - CORRECT ANSWER - returns TRUE if ONLY one of the arguments evaluate to TRUE
• if both are false or true, it returns false