Study sets, textbooks, questions
Upgrade to remove ads
ISYS 2103 Exam 1
Terms in this set (62)
Sales forecasts are historical records of sales.
Information systems that are designed so functional areas share data are called integrated information systems.
What are the computers, people, procedures, and software that store, organize, and deliver information in an organization?
Which business function is performed by Accounting and Finance?
Cost allocation and control
Accounts receivable are recorded by the Human Resources department (HR).
The business process of Cash Flow Management is handled under the Accounting and Finance functional area of operation.
Information systems that can be designed so that functional areas of operation share data are called:
Integrated information systems
Today's managers are beginning to think in terms of business process. A business process cuts across which functional areas of operation?
All of the above
Which of the following outputs would emerge from the Accounting and Finance functional area?
Estimates of future product demand, which are the amount of a product that customers will want to buy, are called:
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
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
Josh teaches sixth grade math. He created a table showing marks that his students scored on an assessment—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.
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 the Ascending command.
Leigh-Ann wants to filter data in a PIvotChart using a slicer. She clicks on the table and then selects Slicer in a particular group on the insert tab. She then ticks the check boxes for the columns that she wants to filter in the Insert Slicers dialog box and clicks OK. What tab did click during the procedure?
To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?
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?
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 Window group.
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.
Which of these keys will you hold to select more than one item while inserting a slicer into a PivotTable?
To remove a field, in the PivotTable Field List clear the check box of the field you want to remove In the Choose fields to add to report box.
Jin 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 dialog box that appears after step 2. What can step 2 be?
Click Recommended PivotTables on the Insert tab, in the Tables group.
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, then 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?
To add fields to a PivotTable, one can use the field section of the Field List and tick the box next to field names to place them in the default area of the Field List.
Izzy wants to move a pivot table to a new worksheet. Which of these should she select after the following clicks to do so: PivotTable > Analyze tab > PivotTable tools > Move PivotTable > Move PivotTable dialog box > Choose where you want the PivotTable to be placed?
To hide the PivotTable Field list, right click on any cell of the pivot table, and select Hide Field List option from the context menu.
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?
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?
To display the PivotTable Field list, right-click any cell in the pivot table and select Show Field List from the menu.
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 PivotTable on the Insert tab, in the Tables group.
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
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)
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.
To illustrate different data levels using small graphics representing values, which of the following can you use?
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
4 Functional Areas of operation
Marketing and sales
Supply chain management
Accounting and finance
Business Function: Customer Support and Customer Relationship MGT
Business Function: Plant Maintenance
Marketing and sales inputs
Sales trend data
Company travel expense policy
Outputs for m/s
Inputs for SCM
Product sales data
Layoffs and recall company policy
Outputs for SCM
-Raw material orders
-Resource expenditure data
-Production and inventory reports
Inputs for A/F
-Payments from customers
-Accounts receivable data
-Accounts payable data
-Production and inventory data
-Payroll and expense data
Outputs for Accounting and Finance
Payments to Suppliers
Customer Credit Data
Inputs for HR
Outputs for HR
employee training and certification
employee evaluation and compensation
What term is used for when out of stock?
What term is used for extra quantity of a product?
Know Range of Data
Range to table
Home-style-format as table
Change name of table
Table tool design-properties-table name-change name
Select cell-select design-total row
Under table styles
Options of table-buttons
Inserting pivot table/recommended pivot table
Filter, columns, rows, values
Default layer of pivot table
Report layout of pivot table
hold --- to select an area of cells
hold ---to pick specific cells
Sets found in the same folder
Exam 1 (ISYS)
Exam 2 (ISYS)
Other sets by this creator
Medical Coding and Billing
ANTH EXAM 3
SCMT EXAM 3
Other Quizlet sets
wes civ midterm
CNA Module 4: Safe Environment
Wk. 6: Quiz