Case 3-2 Bea Is the Best Pie Baker Around.She Has Decided to Decided

question 89

Multiple Choice

Case 3-2
Bea is the best pie baker around.She has decided to go into business and takes a survey in her town to find out what types of pies are favorites.She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea is new to using Excel,however,and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.
-Bea finished adding the results of her survey to a worksheet in her new workbook,including the number of people who voted for each type of pie.If in manipulating the worksheet she wants to copy the contents and formatting of a source area but not the formula,which keyboard shortcut will she use?

• A) CTRL+R
• B) CTRL+A
• C) CTRL+E
• D) CTRL+W

---

Definitions:

SSB

Sum of Squares Between groups; a measure used in statistical analysis to quantify the variance among different groups.

Randomized Block Experiment

An experimental design in which subjects are first divided into blocks based on certain inherent characteristics, and then within each block, treatments are randomly assigned to subjects to control for the block effects.

Variation

The degree to which data points in a statistical distribution or data set diverge from the average or mean.

Degrees of Freedom

The number of independent values or quantities which can be assigned to a statistical distribution, minus the number of parameters estimated.