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
A vertical inch contains approximately this many points
(a) 58
(b) 25
(c) 72
(d) 90
What is "72"
100
Double-clicking in a cell and then selecting the data in the cell will display the
(a) mini toolbar
(b) format cells dialog with the Font tab active
(c) clipboard
(d) screenTip
What is "mini toolbar"
100
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
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
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 (d) accounting
(b) number
(c) fractions
What is "accounting"
200
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 sign
(c) comma
(d) percent sign
What is "ampersand sign (&)
200
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 deletes the cell contents"
200
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"
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
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
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 cell dialog box.
(a) text alignment (d) text control
(b) orientation
(c) right-to-left
What is "text control"
300
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
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"
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
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
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 up and down
(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
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"
400
The official colors of FBLA_PBL are ___
(a) navy blue and yellow
(b) red, white, and blue
(c) red and black
(d) blue and gold
What is "blue and gold"
500
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
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
What is "they are automatically adjusted"
500
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"
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