What command do you use to apply a background color to cells in a worksheet?
Fill Color
100
David only wants to view the employees in the Marketing department who earn a salary of more than
$25,000. What command should he use to complete this task?
Filter
100
Which command do you use to reduce the margin between the border and the text in an indented cell?
Decrease Indent
100
The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your
school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the
new member ID numbers?
RAND BETWEEN(1000,5000)
200
Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her
advisor of an incorrect address for a member. What option in the comments group should she use?
New
200
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
Format Cells
200
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
String
200
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
Review
300
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he
select?
Format as table
300
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or
worksheets?
Template
300
Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a
worksheet?
Orientation
300
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this
problem?
AutoFit
400
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a
summary view of all of the first period classes. Which feature would allow him to do this?
Collapse
400
What area contains the command used to customize the print options in Microsoft Excel?
File Tab
400
What is the process of bringing data containing text fields separated by commas into Excel called?
Importing data
400
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for
the data in column D?
Text
500
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style
should he select?
Cell style
500
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a
new location?
Save As
500
How do you quickly modify a table style to meet user preferences?
Right-click on a style and choose Duplicate
500
What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a
workbook?