ISYS 2263

The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75. Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?

=AND(B2>=70, C2>=80)

The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60. Which of these functions will you insert in the D2 cell so that it returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?

=OR(B2>=60, C2>=60)

Luca wants to insert a pivot table. He clicks on a single cell inside the data set, then proceeds to step X, and finally clicks OK in the dialog box that appears after step 2. What can step 2 be?

Click Pivot Table on the Insert tab, int the Tables group.

Jim wants to insert a recommended pivot table. He clicks a single cell inside the data set, then proceeds to step X and finally clicks OK in the dialogue box that appears after step 2. What can step 2 be?

Click Recommended Pivot Tables on the Insert tab, in the Tables group.

How can one filter a PivotTable using a report filter?

Click the Report Filter's drop-down arrow, then click on an item to select an item in the list and click OK

How can you remove Split panes in a worksheet you are working on?

Click the View tab in the Ribbon, then click the Split button in the Windows group

Safety Stock

Extra inventory that a company holds to protect itself against uncertainties in either demand or replenishment time.

In which of these boxes will you list all the possible fields that can be included in your formula in a PivotTable?

Fields List Box

Inputs for Marketing and Sales

-Customer data -Order data -Sales trend data -Per-unit cost -Company travel expense policy

Inputs for Accounting and Finance

-Payments from customers -Accounts receivable data -Accounts payable data -Sales data -Production and inventory data -Payroll and expense data

Outputs for Accounting and Finance

-Payments to Suppliers -Financial Reports -Customer Credit Data

Inputs for Human Resources

-Personnel forecasts -Skills data

Inputs for Supply Chain Management

-Product sales data -Production plans -Inventory levels -Layoff and recall company policy

Outputs for Supply Chain Management

-Raw material orders -Packaging orders -Resource expenditure data -Production and inventory reports -Hiring information

Outputs for Marketing and Sales

-Sales strategies -Product pricing -Employment needs

Outputs for Human Resources

-regulation compliance -employee training and certification -skills database -employee evaluation and compensation

Business process

Collection of activities that takes some input and creates an output that is of value to the customer

Alejandro wants to change the color of a Pivot Chart he has created to make it a little more impactful. To do so, he clicks the chart he wants to change, the clicks Chart Styles in the upper right corner next to chart, clicks X and selects the color scheme he wants. What can X be in the series of clicks?

Color

Which of these keys will you hold to select more than one item while inserting a slicer into a Pivot Table?

Ctrl.

Leigh-Ann wants to filter data in a Pivot Chart using a slicer. She clicks on the table and then selects Slicer in a particular group on the insert tab. She then clicks the check boxes for the columns that she wants to filter in the Insert Slicers dialog box and clicks OK. What tab did she click during the procedure?

Filters

Which of the following will you select as X in the following series of clicks to format a range as a table: Home tab > Styles group > X > Table Styles?

Format as Table

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Gridlines View

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions?

Height and Width under Buttons group

To illustrate different data levels using small graphics representing values, which of the following can you use?

Icon Sets

Izzy wants to move a pivot table to a new worksheet. Which of these should she select after the following clicks to do so : Pivot Table > Analyze tab > Pivot Table Tools > Move Pivot Table > Move Pivot Table dialog box > Choose where you want the Pivot Table to be placed?

New Worksheet

Chasity wants to rename her pivot table from PivotTable1 to ProductData. She clicks the Pivot Table then goes to Pivot Table Tools > Analyze, and clicks the X text box in the Pivot Table group. She then types a new names and presses ENTER. What can X be in the procedure?

PivotTable Name

Josh teaches sixth grade math. He created a table showing marks that his students scored on an assignment -- the last column on the right displays this information. He now wants to add another column to the right showing percentage of marks that each students scored. What should he do after selecting the current last column on the right?

Right click on it and select Insert from the drop-down menu

Nolan wants to group data in a Pivot table to analyze a subset of data. Which of these series of clicks/ selections/ entries should he follow to do so?

Right-click value > Group > Grouping box > Edit values in Starting at and Ending at checkboxes > Under By, select a time period > OK

Which of the following can help you quickly format a cell range with labels in the left column and top row, and totals in the bottom row?

Table Style

A manager creates data for cost of products of the firm he works for. He enters headings in cells A1, B1, C1 and D1 as Order ID, Quantity, Unit Cost and Total Cost respectively. He mentions the criteria >1000 and >=5 in cells A2 and B2 respectively. Cells A3 to A10 with heading "Order ID" in A4 cell contain data for the order IDs, cells B3 to B10 with heading "Quantity" in B3 cell contain data for quantities for each order ID, cells C3 to C10 with heading "Unit Cost" in C3 cell contain data for unit cost of each order ID and cells D3 to D10 with heading "Total Cost" in D3 cell contain data for total cost of each order ID. He can use the formula: =DCOUNT(A4:D10, "Unit Cost", A1:B2) to count the occurrences that meet the conditions in A1:B2.

True

A student creates data for trees in an orchard. He enters headings in cells A1, B1, C1, D1, and E1 as Tree, Height, Age, Yield, and Height respectively. He mentions the criteria ="=Mango", >10, ="Orange" and <15 in cells A2, B2, A3 and E2 respectively. Cells A4 to A10 with heading "Type of trees" in A4 cell contain data for the type of trees, cells B4 to B10 with heading "Height" in B4 cell contain data for the height of trees, cells C4 to C10 with heading "Age" in C4 cell contain data for the age of trees and cells D4 to D10 with heading "Yield" in D4 cell contain data of their annual yield. He can use the formula: =DCOUNTA(A5:D10, "Yield", A1:E2) to count the rows containing Mango in column A with a height >10 and <15.

True

A teacher creates a table that contains data about winners of a Sports Day event in 4 columns, A to D under headings : Event, Rank, First name, Last name, and Grade, respectively. To sort the table by Event and then by Rank, she can select a cell in the column A, select the Data tab on the Ribbon, then select the Sort command. Under the Sort dialog box, in the Sort by drop down menu, she can select Event, click Add Level and then select Rank in the Then by drop down menu and finally click OK.

True

A teacher creates a table that contains data in three columns, A to C under headings : First name, Last name, and Date of birth respectively. To sort the table by the last names of students from A to Z, she can select a cell in the column B, select the Data tab on the Ribbon, then click Ascending command.

True

If you wish to see how formatting changes affect your table, the Preview list on the right side of the New Table Style box that opens under Table Styles gallery lets you do so.

True

To add fields to a Pivot Table, one can use the field selection of the Field List and click the box next to field names to place them in the default area of the Field List.

True

To display the Pivot Table Field list, right-click any cell in the pivot table and select Show Field List from the menu.

True

To filter data in a Pivot Table, follow the series of selections : A cell in the Pivot Table > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the Pivot Table.

True

To hide the Pivot Table Field list, right-click on any cell of the pivot table, and select Hide Field List option from the context menu.

True

To remove a field, in the Pivot Table Field List clear the check box of the field you want to remove In the Choose fields to add to report box.

True

Shelley creates a table containing the marks of Language Arts students in her class with these columns : Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks?

Uncheck (Select All), select the box beside the number 60 and click OK

Enterprise Resource Planning

•Core software used by companies to coordinate information in every area of business -Help manage companywide business processes -Use common database and shared management reporting tools

Functional Areas of Operation

•Marketing and Sales (M/S) •Supply Chain Management (SCM) •Accounting and Finance (A/F) •Human Resources (HR)