STATS 250 Midterm: 350 F08 Exam 1 Review Questions.pdf

Multiple Choice

1. You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this task?

(a) Set a print area.

(b) Print titles.

(c) Adjust page breaks.

(d) Change the print page order.

2. You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and 2?

(a) Freeze Panes command

(b) Hide Rows command

(c) New Window command and cascade the windows

(d) Split Rows command

3. Which statement is not a recommended guideline for designing and creating an Excel table?

(a) Avoid naming two fields with the same name.

(b) Ensure that no blank columns separate data columns within the table.

(c)-Leave one blank row between records in the table.

(d) Include field names on the first row of the table.

4. Which of the following characters are wildcards in Excel? (Check all that apply.)

(a) *

(b) #

(e) ?

(d) $

5. What should you do to ensure that records in a table are unique?

(a) Do nothing; a logical reason probably exist to keep identical records.

(b) Use the remove duplicates command.

(c) Look at each row yourself and manually delete duplicate records.

(d) Find the duplicate records and change some of the data to be different

6. Which Conditional Formatting rule is best suited to apply formatting to the top five values in a range of values?

(a) Above Average

(b) Greater Than

(c). Top 10 Items

(d) Between

7. Which date filter option enables you to restrict the view to only dates that occur in March of 2018?

(a) Equals

(b) Before

(c) After

(d) Between

8. Which of the following is an unqualified structured reference?

(a) =[Purchase_Price]-[Down Payment]

(b) =Sales[Purchase_Price]-Sales[Down_Payment]

(c) =Purchase Price-Down_Payment

(d) =[Sales]Purchase_Price [Sales]Down_Payment

9. Which of the following is not an aggregate function that can be applied in a total row?

(a) MAX

(b) AVERAGE

(c) COUNT

(d) VLOOKUP

10. If you would like to set a conditional formatting rule based on the function=AND(G6"Finance". H7<7000), which formatting rule type is needed?

(a) Format all cells based on their values

(b) Format only cells that contain

(c) use formula to determine which cells to format

(d) Format only values that are above or below average

Hi. You should write a Java program to meet the specification shown below. 

In this game(dice poker), the computer rolls two standard six-sided dice and you bet on the outcome. The outcome is the configuration of the numbers rolled (explanation below). The input/output should utilise a graphical user interface (input and message boxes).

1.1 Game flow

You start with some money in your bank. You play a number of rounds, where for each round you place a bet and the computer rolls the dice, checks results and modifies your bank balance. After certain conditions, the game ends and you're presented with some final information shown as a message box.

1.2 Placing bets

Before the computer rolls the dice, you can bet some money from your bank.

ˆ If the numbers are sequential (e.g. 1 and 2, 5 and 4, etc. Not 6 and 1), you earn double your bet.

ˆ If the numbers are identical (rolling doubles), you earn triple your bet.

ˆ Otherwise, you win nothing therefore you lose the amount of money you bet.

Before placing a bet, the computer should inform you of your current bank balance.

1.3 Starting Game- Game rules

When the game starts you are given £6 in your bank. Each bet costs £1 and you are allowed to make up to five bets before the game ends. The game will end if you run out of money, or you have no more attempts left (you made all five bets). At the end of the game, you will be told which of these conditions has ended the game.

1.4 Results display

Once the game has finished (all bets have been placed or you ran out of money) the computer will collate and display the results in a single message box, comprised by:

ˆ On row per bet, displaying your bet, the numbers rolled, the amount of money earned or lost for that bet.

ˆ One row at the end, displaying the amount of money that you have remaining in your bank at the end of the game.

1.5..Variable bet amount

Allow the user to change how much they would like to bet and change the amount you win accordingly. Allow bets between £1 and 4£ (integers only)

1.6.High score table

Create a high score table. The more money you have remaining in your bank at the end of the game the higher up the table you will be. In order to implement this, players will have to enter their name before they play. The high score table should be displayed as a separate message box after the results have been displayed at the end of the game(1.4)

Not1: Please use JoptionPane class instead of scanner class. 

Not2: Also If possible explain the description of your classes: what each does and how they relate to each other. And if possible, program should be extensible. E.g. Is it easy to change the number of dice? The number of rounds to play? The sides of the dice?Etc.