blue
orange
red
yellow
green
100
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? A. Home B. Page Layout C. Data D. View
What is B. Page Layout
100
SUMIF and SUMIFS are in which category of functions? A. Math & Trig B. Text C. Logical D. Lookup & Reference
What is A. Math & Trig
100
Which command on the Home Ribbon do you use to organize data in ascending or descending order? A. Find & Select B. Format Cell C. Sort & Filter D. Organize
What is C. Sort & Filter
100
Maria needs to share a form from her database to other members of her work team, but she is not sure everyone has Microsoft Access. She should save the form in which file format to ensure everyone can read the information? A. PDF B. XPS C. Either PDF or XPS D. DOC
What is C. Either PDF or XPS
100
David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task? A. AutoFill B. Filter C. Find and Replace D. Sort
What is D. Sort
200
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? . Formatting B. Printing C. Arranging D. Configuring
What is A. Formatting
200
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use? A. FIND B. SUBSTITUTE C. VLOOKUP D. SEARCH
What is B. Substitute
200
Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate function should she use? A. Count B. Max C. Min D. Average
What is D. Average
200
John has created a PivotChart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this? A. Report filter B. Legend fields C. Axis fields D. Values
What is B. Legend fields
200
Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to remove the Y-axis value. Which tab in Chart Options would he select? A. Titles B. Axes C. Data labels D. Legend
What is B. Axes
300
Keton wants to add a graphic by one of the fields on his form . Which type of control will he add to the form? A. Bound B. Unbound C. Button D. Calculated
What is B. Unbound
300
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable? A. Layout B. Options C. Design D. Format
What is C. Design
300
John would like to change the order of the worksheets in his workbook. Which option would he choose? A. Insert B. Delete C. Copy D. Move
What is D. Move
300
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? A. Group B. Collapse C. Subtotal D. Outline
What is B. Collapse
300
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select? A. Freeze B. Header C. Hide D. Scale
What is D. Scale
400
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? A. RAND() B. RAND BETWEEN(1000,5000) C. BETWEEN(1000,5000) D. RANDOM(1000,5000)
What is B. RAND BETWEEN(1000,5000)
400
What is the process of bringing data containing text fields separated by commas into Excel called? A. Importing data B. Data collection C. Data integration D. Data migration
What is A. Importing Data
400
In Sam's spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use? A. Convert Text to Column Wizard B. Split View C. View Side by Side D. Comma Delimited
What is A. Convert Text to Column Wizard
400
Ashawn has created a table from his database to see his company's income and expenses for the year and now would like to see the totals for each category. Which table feature should he use? A. Insert a Totals Row B. Sort by Selection C. Insert a Chart D. Create a Relationship
What is A. Insert a Totals Row
400
Susie has a relational database for her catering business. She wants to create a form which shows the data in a customer table one record at a time. This type of form is a: A. main form B. subform C. heirarchical form D. datasheet
What is A. main form
500
What term refers to an Excel Chart with offset pieces? A. Exploded B. Shattered C. Separated D. Detached
What is A. Exploded
500
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches? A. Text B. String C. Thread D. Key
What is B. String
500
All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made? A. Track Changes B. Change History C. History D. Names Manager
What is B. Change History
500
John wants to create a query that will display the total number of hamburger patties in stock at two different locations. The results should display the sum of the values from each location. Which solution should John use for his query? A. Crosstab Query B. Expression Builder C. Simple Query D. Tota
What is B. Expression Builder
500
Jessica needs to capitalize the first letter in each word. Which function would she use? A. Trim B. Proper C. Upper D. Lower
What is B. Proper
M
e
n
u