31. With the __feature, you can see how theme formatting will affect your worksheet.
a. Sneak peek
b. Prototype
c. Theme preview
d. Live preview
What is "live preview"
100
36. A vertical inch contains approximately this many points
a. 58
b. 25
c. 72
d. 90
What is "72"
100
41. Double-clicking in a cell and then selecting the data in the cell will display the
a. Mini toolbar
b. Format cells dialog box with the Font tab active
c. Clipboard
d. ScreenTip
What is "Mini toolbar"
100
Which button should you click if you want to rotate data in a cell?
a. Orientation
b. Move
c. Spin
d. Rotation
What is "Orientation"
100
Justice told his boss he would finish the financial report by Friday. Following through on his commitment is an example of which positive workplace trait?
a. Resourcefulness
b. Problem-solving
c. Reliability
d. Honesty
What is "Reliability"
200
32. Which of the following number formats adds a dollar sign and two decimal points and also lines up the currency symbols and decimal points?
a. Currency
b. Number
c. Fractions
d. Accounting
What is "accounting"
200
37. In the Number group on the HOME tab, the formal symbols you can use to format numbers include each of the following except the
a. Dollar sign ($)
b. Ampersand (&)
c. Comma (,)
d. Percent sign (%)
What is Ampersand (&)"
200
42. Pressing the Delete key to delete cells
a. Only deleted the cell contents
b. Deletes the cell data and formatting
c. Deletes the entire cell from the worksheet
d. Only deletes the cell formatting
What is "Only deleted the cell contents"
200
Double-clicking in a cell and then selecting the data in the cell will display the
a. Clipboard
b. Mini toolbar
c. Format cells dialog box with the Font tab active
d. ScreenTip
What is "Mini toolbar"
200
Why is having diversity in a company culture’s staff a good idea?
a. There is a broader range of talents, skills and creativity
b. It creates a homogenous work ethic
c. The work environment will be more ethical
d. It meets the quota for minority cultures
What is "There is a broader range of talents, skills and creativity"
300
33. To insert a row in a worksheet, select the __ and then click the Insert button in the Cells group.
a. Row above where the new row is to be inserted
b. Row below where the new row is to be inserted
c. Last row in the worksheet
d. First row in the worksheet
What is "Row below where the new row is to be inserted"
300
38. Text typed into a cell will overlap into the next cell if it is too long. To prevent this, use options in the __section on the Alignment tab in the Format Cells dialog box.
a. Text alignment
b. Orientation
c. Right-to-left
d. Text control
What is "Text control"
300
43. In addition to using the Hide Columns option, Chapter 3 suggests that you can hide columns by
a. Reducing the font size in the column to zero
b. Using a white font color for the text in the column
c. Setting the column width to zero
d. Moving the column to the far right of the worksheet
What is "Setting the column width to zero"
300
Which button would you use to copy formatting to different locations in the worksheet?
a. Format Painter
b. Pictures
c. Online Pictures
d. Copy
What is "Format Painter"
300
Future Business Leaders of America-Phi Beta Lambda is a ______________________ association:
a. Profit, Education
b. Non-Profit, Business
c. Non-Profit, Education
d. Profit, Business
What is " Non-Profit, Education"
400
34. Buttons in the Font group allow you to change the font size, effects, and color, as well as
a. Add borders
b. Insert formulas
c. Clear cell contents
d. Delete rows or columns
What is "add borders"
400
39. You can change the height of a row by positioning the mouse pointer on the boundary between rows until it displays as a ___ and then dragging up or down to the desired height.
a. Double-headed arrow pointing left and right
b. Ruler
c. Double-headed arrow pointing up and down
d. Pointing finger
What is "Double-headed arrow pointing up and down"
400
The Number tab in the Format Cells dialog box opens with the default number format category of
a. Custom
b. General
c. Number
d. Currency
What is "General"
400
In page break preview, a __indicates a page break inserted by Excel, and a(n) __indicates a page break manually.
a. Thin blue line; thick blue line
b. Solid blue line; dashed blue line
c. Dashed red line; solid red line
d. Gray line; orange line
What is "Solid blue line; dashed blue line"
400
FBLA prepares students for careers in Business and _______________related fields:
a. Education
b. Business
c. Healthcare
d. Law
What is "Business"
500
35. The formatting for numbers can be specified
a. Either before or after the number is entered into the cell
b. Only before the number is entered into the cell
c. Only after the number is entered into the cell
d. Only before any data is entered into the worksheet
What is "Either before or after the number is entered into the cell"
500
40. When you insert columns in a worksheet, what happens to the cell references that are affected by the new columns?
a. They are automatically adjusted
b. They are deleted
c. The row references are updated automatically, but the references must be updated manually
d. You must update both the row and column references manually
What is "They are automatically adjusted"
500
When applying formatting to cells in your worksheet, you can repeat the last command by pressing __ or __.
a. F4; Alt + Enter
b. Ctrl + R; F1
c. Ctrl + S; F8
d. Ctrl + Y; F4
What is "Ctrl + Y; F4"
500
On the Border tab in the Format Cells dialog box, the Presets section contains each of the following options except
a. Outline
b. Inside
c. Top and bottom
d. None
What is "Top and bottom"
500
The first high school chapter was chartered in _________________________?
a. Johnson City, TN
b. Knoxville, TN
c. Cedar Rapids, IA
d. Miami, FL