MIS 111 Study Guide - Final Guide: Pivot Table, Dialog Box, Data Validation
azurerhinoceros284 and 2 others unlocked
41
MIS 111 Full Course Notes
Verified Note
41 documents
Document Summary
Mis lab final practice: questions & answers are from practice test, while a few are common knowledge to remember. All questions are possible to show up on test. Then select a new worksheet and choose home (tab) -> 31: charts are dynamic, i. e. , they change as the underlying data changes. 4500: consider the following formula: =sumifs(inventory_cost, category,=beverages, In this formula, the second statement in the or (i. e. , checking for the category. =soups) is only checked/evaluated if the first part (i. e. , checking if category. =pasta) evaluates to false: how do you group pivot table items manually, after creating the pivot table, select the items to be grouped and then choose. Options (tab) under pivottable tools and select group (group) -> group. What is this type of investment called: annuity, a #ref! error occurs in excel when a formula uses a / an ________ cell reference.