MIS UNH EXAM 3 |Questions Solved
100% Correct| Verified Solutions
what is data validation? - ANSWER the process of ensuring that a program operates
on clean, correct and useful data
how do you use goal seek? - ANSWER Click the cell you want to change. ...
From the Data tab, select the What if Analysis... ...
Select Goal seek.. ...
In the Goal Seek dialog, enter the new "what if" amount in the To value text box. ...
We also need to tell Excel which cell to change. ...
Click OK.
what is a data table? - ANSWER Instead of entering formulas and variables
individually, to compare results, you can set up a Data Table
how do you make data tables?
why would you want to anyways? - ANSWER When you create a two-input table, you
specify input cells in the Row Input Cell and Column Input Cell boxes in the Table
dialog box. Note In Microsoft Office Excel 2007, the Table dialog box is called the Data
Table dialog box.
how do you use conditional formatting? - ANSWER Select cells
Then, click Home > Conditional Formatting > New Rule.
In the New Formatting Rule dialog box, click Use a formula to determine which cells
to format.
Under Format values where this formula is true, type the formula: =A2>TODAY() ...
, Click Format
how would you create a pivot table? - ANSWER Open the spreadsheet that contains
the data you'd like to use for your pivot table. From the Data menu, select Pivot table
report. A new sheet named "Pivot Table 1" opens in your spreadsheet with the Report
Editor open to the right.
how do you use the table feature in excel? - ANSWER Click any single cell inside the data
set.
On the Insert tab, click Table.
Excel automatically selects the data for you. Check 'My table has headers' and click
on OK.
how do you perform filtering using the table feature? - ANSWER Click the arrow Filter
drop-down arrow in the table header of the column you want to filter.
In the list of text or numbers, uncheck the (Select All) box at the top of the list, and
then check the boxes of the items you want to show in your table.
10-K - ANSWER highlights achievements of past year. Overview of profits,
business conditions, risk factors.
5 component model of information systems - ANSWER Hardware: something you
could touch
Software: the instructions for the hardware
Data: the input/raw material
100% Correct| Verified Solutions
what is data validation? - ANSWER the process of ensuring that a program operates
on clean, correct and useful data
how do you use goal seek? - ANSWER Click the cell you want to change. ...
From the Data tab, select the What if Analysis... ...
Select Goal seek.. ...
In the Goal Seek dialog, enter the new "what if" amount in the To value text box. ...
We also need to tell Excel which cell to change. ...
Click OK.
what is a data table? - ANSWER Instead of entering formulas and variables
individually, to compare results, you can set up a Data Table
how do you make data tables?
why would you want to anyways? - ANSWER When you create a two-input table, you
specify input cells in the Row Input Cell and Column Input Cell boxes in the Table
dialog box. Note In Microsoft Office Excel 2007, the Table dialog box is called the Data
Table dialog box.
how do you use conditional formatting? - ANSWER Select cells
Then, click Home > Conditional Formatting > New Rule.
In the New Formatting Rule dialog box, click Use a formula to determine which cells
to format.
Under Format values where this formula is true, type the formula: =A2>TODAY() ...
, Click Format
how would you create a pivot table? - ANSWER Open the spreadsheet that contains
the data you'd like to use for your pivot table. From the Data menu, select Pivot table
report. A new sheet named "Pivot Table 1" opens in your spreadsheet with the Report
Editor open to the right.
how do you use the table feature in excel? - ANSWER Click any single cell inside the data
set.
On the Insert tab, click Table.
Excel automatically selects the data for you. Check 'My table has headers' and click
on OK.
how do you perform filtering using the table feature? - ANSWER Click the arrow Filter
drop-down arrow in the table header of the column you want to filter.
In the list of text or numbers, uncheck the (Select All) box at the top of the list, and
then check the boxes of the items you want to show in your table.
10-K - ANSWER highlights achievements of past year. Overview of profits,
business conditions, risk factors.
5 component model of information systems - ANSWER Hardware: something you
could touch
Software: the instructions for the hardware
Data: the input/raw material
