Microsoft Excel/Access Starters
2nd 9 Weeks
Monday November 7, 2016
1) Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
A) Freeze B) Header C) Hide D) Scale
____ 2) Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
A) Freeze B) Split C) Page Break D) Hide
____ 3) 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
____ 4) Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
A) Insert B) Move C) Rename D) Tab Color
____ 5) John would like to remove a worksheet from his workbook. Which option would he choose?
A) Insert B) Delete C) Copy D) Move
Wednesday November 9, 2016
6. David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command
should he use to complete this task?
A) AutoFill B) Filter C) Find and Replace D) Sort
____ 7) Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?
A) Insert B) Move C) Rename D) Tab Color
____ 8) What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
A) Zoom B) Select C) Freeze Panes D) Rotate
____ 9) 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
____ 10) Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
A) Insert B) Move C) Rename D) Tab Color
Monday November 14, 2016
11) How would you move sheet tabs to a new position in the workbook?
A) Choose Move on the Home Ribbon. B) Click and drag the sheet tab to the new location.
C) Choose Move on the Insert Ribbon. D) Choose Relocate on the Quick Access Toolbar.
____ 12) How is an exact copy of a worksheet created within the same workbook?
A) While pointing to the sheet tab, choose Copy from the Shortcut Menu
B) Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
C) While pointing to the Select All button, choose Move or Copy from the Shortcut Menu
D) Choose Move or Copy from the Quick Access Toolbar
____ 13) Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
A) Font B) Format Cell C) Cell Styles D) Find & Select
1) Joan has created a spreadsheet that displays sales of her employees. She would like to view only those
employees with sales above $25,000 who are from Region 3. What option will allow her to do that?
A) Ascending B) Descending C) Filter D) Custom Filter
____ 2) How do you quickly modify a table style to meet user preferences?
A) Right-click on a style and choose Modify. B) Right-click on a style and choose Duplicate.
C) Double-click a style from the Table Quick Styles Gallery.
D) Choose Modify from the Styles Group on the Home Ribbon.
____ 3) Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
A) Find & Select B) Format Cell C) Sort & Filter D) Organize
____ 4) 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?
A) AutoFill B) Filter C) Find and Replace D) Sort
____ 5) 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
____ 6) Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?
A) Ascending B) Descending C) Primary Sort D) Customer Filter
____ 7) Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this?
A) Group B) Collapse C) Subtotal D) Outline
Tuesday November 15, 2016
8) Which ribbon includes the commands to apply a quick table style to a range of cells?
A) Home B) Insert C) Page Layout D) Data
____ 9) Which is a way to qualify data by specifying a matching condition or asking a question of the data?
A) Insert B) Sort C) Query D) Probe
____ 10) Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?
A) Macro B) Sort C) Filter D) Formula
____ 11) 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
____ 12) 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
____ 13) Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
A) Cell style B) Conditional formatting C) Fill color D) Format as table
____ 14) 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
____ 15) What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
A) Styles B) Alignment C) Editing D) Font
Wednesday November 16, 2016
1) Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells
in that range that contain 100. What function should he use?
A) SUMIF
B) AVERAGEIF
C) TOTALIF
D) COUNTIF
____ 2) Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
A) VLOOKUP
B) HLOOKUP
C) LOOKUP
D) SEARCH
____ 3) Tom wants to convert all text to lowercase. Which function she he use?
A) Trim
B) Proper
C) Upper
D) Lower
____ 4) SUMIF and SUMIFS are in which category of functions?
A) Math & Trig
B) Text
C) Logical
D) Lookup & Reference
____ 5) 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
____ 6) Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in
that range that are greater than 100 but less than 500. What function should he use?
A) SUMIFS
B) AVERAGEIFS
C) TOTALIFS
D) COUNTIFS
____ 7) James wants to use an advanced function to search his spreadsheet for a specific string in a text string?
A) FIND
B) SUBSTITUTE
C) VLOOKUP
D) REPLACE
8) Maggie wants to use a function that will return True when all its arguments are true, and False when one or
more arguments are false. What function would she use?
A) IF
B) AND
C) OR
D) NOT
____ 9) IF, AND, OR and NOT are all part of which category of functions?
A) Math & Trig
B) Text
C) Logical
D) Lookup & Reference
____ 10) 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
____ 11) Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range
that are greater than 1,000. What function should she use?
A) SUMIF
B) AVERAGEIF
C) TOTALIF
D) COUNTIF
____ 12) Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
A) VLOOKUP
B) HLOOKUP
C) LOOKUP
D) SEARCH
____ 13) Jessica needs to capitalize the first letter in each word. Which function would she use?
A) Trim
B) Proper
C) Upper
D) Lower
____ 14) James wants his spreadsheet to return true when the logical value is false. What function should he use?
A) IF
B) AND
C) OR
D) NOT
____ 15) Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
A) Trim
B) Proper
C) Upper
D) Lower
Thursday November 17, 2016
) What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
A) Protect Workbook B) Protect Sheet C) Share D) Protection
____ 2) 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
____ 3) Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?
A) Share Workbook B) Protect Workbook C) Tracking Changes D) Export
____ 4) Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?
A) Share Workbook B) Protect Workbook C) Tracking Changes D) Export
____ 5) 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?
A) New B) Delete C) Edit Comment D) Show Ink
____ 6) Which ribbon contains commands to add a comment about a selected cell in a worksheet?
A) Home B) Insert C) Data D) Review
____ 7) 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)
____ 8) Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?
A) New B) Delete C) Edit Comment D) Show Ink
____ 9) Where is the spellchecker located?
A) Home Ribbon B) Page Layout Ribbon C) Review Ribbon D) View Ribbon
Monday November 28, 2016
1. An address book containing all FBLA members would be an example of a:
A) cells B) databases C) fields D) records
____ 2) Juan needs to view and access all parts of his database. Where can these objects be located most efficiently?
A) Design view B) Form view C) Layout view D) Navigation pane
____ 3) You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of:
A) cells B) databases C) fields D) records
____ 4) Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?
A) Objects pane B) Database pane C) Navigation pane D) List pane
____ 5) Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database?
A) Close B) Create New C) Open from Existing D) Save As
____ 6) Which software program is used to create a database on a computer, add, change, and delete data in the database, and create queries, forms, and reports using the data in the database?
A) Microsoft Access B) Microsoft Excel C) Microsoft OneNote D) Microsoft Outlook
November 29, 2016
____ 7) Which term refers to storing the same field in more than one location in a database?
A) Redundancy
B) Repetition
C) Replication
D) Recurrence
____ 8) What type of database contains multiple collections of data that are related to one another?
A) Joined
B) Relational
C) Flat
D) Managed
____ 9) Which type of database consists of a collection of tables, each of which contains information on a specific
subject?
A) Relational
B) Interactive
C) Collaborative
D) Independent
____ 10) Individual entries in the FBLA address book would be entered into a:
A) cells
B) databases
C) fields
D) records
____ 11) When a database is created, what is defined when names and data types are assigned to all data fields in a
table?
A) Structure
B) Definition
C) Design
D) Theme
____ 12) When saving a Microsoft Access database as another file type, which ribbon contains an area of centralized
tasks that are related to file management known as the backstage?
A) Home ribbon
B) File tab
C) External Data ribbon
D) Database Tools ribbon
Wednesday November 30, 2016
____ 1) Jenny is setting the addresses for each patient. Which data type should she use?
A) AutoNumber B) Currency C) Number D) Text
____ 2) Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
A) Determine what information to include B) Discuss the database with users
C) Gather the information D) Input data
____ 3) Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
A) Application Parts B) Quick Start C) Sharepoint List D) Database Object
____ 4) Curt needs to create a backup to his existing database on an external hard drive. What action should he take?
A) Close B) Create New C) Open from Existing D) Save As
____ 5) Erin needs to prepare a custom table for her recipe collection. She has to include the ingredient portions. Which is the correct tool to use?
A) Design view
B) Template
C) Sharepoint List
D) Application Parts
____ 6) Isabel wants to design a database for her FBLA club to include all the members' information. What data type should she use for Last Name?
A) Text
B) Memo
C) Number
D) Date/Time
Thursday December 1, 2016
7) Juan is creating a new database. He wants to assign field names. Which view is BEST to create the new
database?
A) Design view B) Form view C) Layout view D) Navigation pane
____ 8) Nick wants to design a database and wants Access to automatically assign an ID number to each record. What is auto numbering an example of?
A) Data Type B) Description C) Field Name D) Properties
____ 9) Nick wants to immediately open an employees' email from his database . What data type should be used for the email address?
A) Auto Number B) Currency C) Yes/No D) Hyperlink
____ 10) Susie wants to locate the file name of her current document. Where she should look?
A) Rename B) Navigation pane C) Title bar D) Status bar
____ 11) Which view displays the area used to create a table or to modify the structure of a table?
A) Design B) Datasheet C) File D) Backstage
FRIDAY December 2, 2016
12) Where is the command for creating a new table from Table Design view?
A) File tab B) Home Ribbon C) Create Ribbon D) Database Tools Ribbon
____ 13) Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he use?
A) Auto Number B) Currency C) Yes/No D) Hyperlink
____ 14) What are three valid methods for saving a database in Microsoft Access?
A) Alt + S, File tab Save command, Quick Access Toolbar Save command
B) Alt + S, Home Ribbon Save command, Quick Access Save command
C) Alt + S, File tab Save command, Shortcut Save command
D) Ctrl + S, File tab Save command, Quick Access Save command
____ 15) Curt needs to exit his database in order to work on another database. What action should he take after saving his work?
A) Close B) Create New C) Open from Existing D) Save As
Monday December 5, 2016
1) Keisha created a database of her music. She wants to locate only the songs by Beyoncé. What tool should she use in order to view this information without saving?
A) Filters B) Form C) Query D) Report
____ 2) The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information?
A) >=200 AND swimming B) >200 OR swimming C) >=200 OR swimming D) >200 AND swimming
____ 3) Eddie works for ABC Finance. He needs to view which employee(s) has the lowest sales for the month. Which command should he use?
A) Filter B) Find C) Sort Ascending D) Sort Descending
____ 4) Which type of relationship means that a record in the first table is related or matches more than one record in the second table?
A) One to one B) Many to many C) One to many D) One to any
____ 5) In Datasheet view, how does a user delete a record?
A) Double-click the record.
B) Select the record and choose Delete from the Create Ribbon.
C) Double-click the record and choose Delete from the Database Tools Ribbon.
D) Select the record and choose Delete from the Home Ribbon.
____ 6) Eddie needs to know which employee(s) work in the Southeast District. Which command would he use?
A) Filter B) Find C) Sort Ascending D) Sort Descending
7) Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input medication information. What should she do?
A) Format B) Freeze Fields C) Hide Fields D) Sort
Tuesday December 6, 2017
8) Eddie works for ABC Finance. He needs to view which employee(s) has the highest sales for the month. Which command should he use?
A) Filter B) Find C) Sort Ascending D) Sort Descending
____ 9) Chad needs to change a members telephone number in the FBLA database. What step should he take?
A) Add New Record B) Delete Record C) Move Field D) Edit Record
____ 10) Michelle needs a list of senior National Technical Honor Society members so she can order their tassels for graduation. Which tool would be best to identify only the seniors?
A) Form B) Filter C) Controls D) Theme
____ 11) Chad needs to remove a student from the FBLA database. Which option should he choose?
A) Add New Record B) Delete Record C) Move Field D) Edit Record
____ 12) In a table, which is a way of exclusively identifying each record in the database?
A) Unique marker B) Primary Key C) Primary marker D) Primary category
____ 13) Mr. Smith needs to know Jenny's address. Which command would he use?
A) Find B) Select C) Sort Ascending D) Sort Descending
14) Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use?
A) Filter B) Find C) Sort Ascending D) Sort Descending
____ 15) Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform?
A) Filter B) Find C) Query D) Sort
Wednesday December 7, 2016
Today’s Assignment: Study, Study, Study. Starters:
Lessons 9-13
Lesson 1-3
Monday December 12, 2016
1) Dennis needs to format his sales amount column to show dollar signs. Which format would he use?