COMP 1000 Final Exam Review

 

Question Software  

1

Access

Open the Class form.

2

Access

Open the Course table.


3


Access


Go to record number 20.


4


Access


Go to the first record.


5


Access


Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.


6


Access


Add a new record to this form.


7


Access


Create a new table in Datasheet view. Save it with the name: Degrees


8


Access


Move the Description field so it is the last field in the table.


9


Access


Move the StartDate field so it is the last field in the table. Save the table.


10


Access


From Datasheet view, add a new field the far right of the table to store a picture for each resident advisor.


11


Excel


Click any cell in row 12.


12


Excel


Click any cell in column D.


13


Excel


Click cell B6.


14


Excel


Click the Name Box.


15


Excel


Click the Profit Projection worksheet tab.


16


Excel


Move to cell D3.


17


Excel


Select column B.


18


Excel


Add the word TOTAL to cell A9.


19


Excel


Select row 5.


20


Excel


Copy cell F3, and paste to cell F2.


21


Excel


Cut cell B7 and paste it to cell E12.


22


Excel


Delete the selected cell range, shifting up the cells below the range.


23


Excel


Insert blank cells above the selected cell range, so the remaining cells shift down and the inserted cells are formatted the same as those below.


24


Excel


Wrap the text in the selected cell.


25


Excel


Reverse the last instance of the Undo command.


26


Excel


Center the content in the selected cells horizontally.


27


Excel


Undo the last action taken in Excel.


28


Excel


Use the Function Arguments dialog to enter a SUM function in cell B7 to calculate the total of cells B2:B6.


29


Excel


Use Formula AutoComplete to enter a SUM function in cell B7 to calculate the total of cells B2:B6.


30


Excel


Enter a formula in cell B7 to calculate the average value of cells B2:B6.


31


Excel


On the Year1 sheet, in cell B8, enter a formula to display the value of cell B7 from the Salaries sheet.


32


Excel


Name cell B9 as follows: COLA


33


Excel


Use the Create from Selection command to create named ranges for the selected data table in cells B2:E6 using the labels in row 1as the basis for the names.


34


Excel


Enter a formula in cell C2 to calculate next year's salary increase by multiplying the previous year's salary (cell B2) times the Cost of Living Adjustment (cell named COLA). Use the cell name in the formula.


35


Excel


Hide all of the dependency tracer arrows at once.


36


PP


Click the Slides tab.


37


PP


Switch to Normal view.


38


PP


Switch to Reading view.


39


PP


Switch to Slide Show view.


40


PP


Switch to Slide Sorter view.


41


PP


Using the Slides tab, navigate to the fourth slide in the presentation.


42


PP


Add the text Overview as the title text for the slide. When you are done, click outside the text placeholder.


43


PP


Change the font color of the selected text to Blue-Gray, Text 2, Darker 25%. It is the second option from the bottom in the fourth column under Theme Colors.


44


PP


Apply the 1. 2. 3. numbered list style to the items.


45


PP


Click the icon in the content placeholder that will allow you to add a chart to the presentation.


46


PP


Insert a Stacked Bar chart to the slide (it is the second option in the Bar category).


47


PP


Using the drag method, make the image larger.


48


PP


Hide the gridlines in the presentation.


49


PP


Show the gridlines in the presentation.


50


PP


Insert the a picture into the presentation.