Excel & Access
A monthly sales workbook contains the formula =(January!B3). 'January' is an example of a/an:
external reference.
What does to parse data mean?
interpret character by character
Your monthly sales workbook contains the formula =SUM(Sales). 'Sales' is an example of a/an:
named range.
Ava's spreadsheet has data about the number of music download in F1:F25. F1:F25 represents a:
range
What is the process of using the mouse to move or copy cells called?
Drop and Drag
Which formatting style would you select to convert the cell range A1:F20 to a Medium 19 style?
Format as Table
In Microsoft Excel, what is used to emphasize certain entries and make the worksheet easier to read and understand?
Formatting
Jen is calculating her GPA. If she uses '=(A1+A2+A3+A4)/4', this is an example of a _____
Formula
Which group on the Formula Ribbon has the command that checks for errors found in a formula?
Formula Auditing
Where is the Insert Function button found in Microsoft Excel?
Formula Bar
To calculate your GPA, you use'=(A1+A2+A3+A4)/4', this is an example of which type of entry?
Formulas
To have data in Row 1 to remain stationary while scrolling which option do you select?
Freeze
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
Freeze Panes
What feature of Excel keeps a portion of a worksheet visible while the other portion scrolls?
Freeze Panes
Which is a pre-written formula that is built into Microsoft Excel?
Function
To find average sales, Angie used '=AVERAGE(B1:B4)'. What type of entry is it?
Functions
What function should you use to search for a value in the fourth row of your spreadsheet.
HLOOKUP
What command is used to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Header & Footer
Jack do not want the data in Row 10 to display on his worksheet. Which option should he select?
Hide
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
Hide
Which ribbon includes the commands to apply a quick table style to a range of cells?
Home
Where is the command to apply a fill color to a cell or range of cells in a worksheet?
Home Ribbon
What is the process of bringing data containing text fields separated by commas into Excel?
Importing Data
Tom wants to convert all text to lowercase. Which function should he use?
Lower
Which function do you use to find the highest grade in a row that had test grades for 9 weeks.
MAX
Describes the blank portions of a page that fall outside the main body of the printed document.
Margins
Command on the Home Tab that joins selected cells into one larger single cell & centers content
Merge & Center
To change the order of the worksheets in his workbook which option would you choose?
Move
To transfer a worksheet in a workbook to a different workbook which command should you choose?
Move
Which area on the left side of the formula bar indicates the cell address of a selected cell?
Name box
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
Page Layout
Which view lets you create or modify a worksheet while seeing how it looks in printed format?
Page layout
Jim would like to print only the cell range A1:F20. What page setup option should he change?
Print Area
John's workbook includes 3 worksheets. Which option should he choose to print them?
Print Entire Workbook
The MS Office object that gives you quick, convenient access to frequently used Excel commands?
Quick Access Toolbar
Which term refers to a group of selected cells that may be moved, copied, or deleted as a group
Range
Which command is used to remove manual page breaks from a worksheet area?
Select Remove Page Break from the Breaks drop-down area
The command among the window control buttons used to close a file and completely exit Excel?
Close
Type of formatting appearing only when the value in a cell meets conditions specified by user.
Conditional
Which tool should you use to separate first and last names in one column into two columns?
Convert Text to Column Wizard
The most efficient way to copy five separate formulas to adjacent cells simultaneously is..?
Copy using the Fill Handle
Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
Cut
Which command on the Home ribbon allows data to be moved from one worksheet location to another
Cut
Which command is used to reduce the margin between the border and the text in an indented cell?
Decrease Indent
John would like to remove a worksheet from his workbook. Which option would he choose?
Delete
Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?
Delete
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Sheet Options
The list of often used commands available when a user right-clicks an item in the worksheet
Shortcut Menu
Which command on the Home Ribbon do you use to organize data in ascending or descending order?
Sort and Filter
What function do you use to put the date in a worksheet so that it updates when it opens?
Today
To search a spreadsheet for a value in the first column, what function should you use?
VLOOKUP
Excel will only save macros in a workbook using which file type?
.xlsm
Up to how many source columns can Access import?
225
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=$B$1+25
Sai wants a formula that does not change when copied to cell B2. Which formula should he create
=$B$1+25
To create a formula that does not change when copied to cell B2 which formula should you create
=$B$1+25
Criterion you use in a query to find schools with enrollment that equals 5,000 or greater
=>'5000'
Sam enters a numeric criterion in a query to find out which UNC schools have an enrollment that equals 5,000 or greater. What would he enter?
=>'5000'
Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
=D4*F4
Jordan created a formula to multiply the values in cells D4 and F4. What is the right formula?
=D4*F4
You want a formula to multiply the values in cells D4 and F4. Which formula should you use?
=D4*F4
A formula in B40 to calculate total sales located in cells B1 through B39?
=SUM(B1:B39)
Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?
=SUM(B1:B39)
The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information?
>200 AND swimming
Returns True when all its arguments are true and False when one or more arguments are false.
AND
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
AVERAGE
Which are valid Microsoft Excel functions?
AVERAGE, MAX, and MIN
What function should you use to average only cells in a range that are > 100 but < 500.
AVERAGEIFS
Which quick-number style button formats numbers to display as currency in the worksheet?
Accounting
Steve would like to print only the worksheet he is currently working on. What print option should he choose?
Active Sheets
Aaron needs to duplicate a field that is used in his customer table in the business database for a new form he is creating for entering customer orders. Which item from the tools group would enable him to perform this operation?
Add Existing Fields
Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation?
Add Existing Fields
Keton created a customer information form from his customer table. He realizes he left the e-mail address off the form. What tool would he use to add the e-mail address to the existing form?
Add Existing Fields
You left a field off of a form. What tool would you use to add the missing field to the form?
Add Existing Fields
Which type of operation performs functions, such as MAX, MIN, or COUNT, on a group of records?
Aggregate
Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records?
Aggregate
Which of the following messages displays when an import operation has failed?
An error occurred trying to import file
What type of query enables a user to add the results of a query to an existing database table?
Append
What type of query enables a user to add the results of a query to an existing table in a database?
Append
Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
Application Parts
To quickly add contacts to a Driver Education database, what predefined object can he create?
Application Parts
Which type of form already has a predefined layout and can automatically have command buttons?
Application Parts Blank form
Unbound forms can be easily created that display messages to users using
Application Parts Blank forms
What command will arrange Excel windows so that they appear side-by-side on the screen?
Arrange All
What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?
Arrange All
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What data type should he use?
Auto Number
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
AutoComplete
David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?
AutoFill
To enter numbers 1 to 1000 in a worksheet column, what command should you use to complete?
AutoFill
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
AutoFit
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?
AutoFit
To have Access automatically assign an ID number to each record, what data type should he use?
AutoNumber
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
AutoSum
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?
Average
Frank needs an estimated number of services his company performs each month. Using a calculated field, which total function would he use to answer his question?
Average
Juan is creating a chart that graphs 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?
Axes
Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data?
Blank form
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
Breaks
What function should you use to count the number of cells in a range that contain 100.
COUNTIF
Preston's form needs to display the tax on an order. Which type of control would allow Preston to display information that would change every day?
Calculated
Which control would display a person's exact age based on today's date and their DOB in the DB?
Calculated
Which type of control would display the tax on an order that changes everyday?
Calculated
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Calculations
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
To apply the Title format to data in Row 1 of a spreadsheet which formatting style do you use?
Cell Style
How is a cell reference in a formula and its corresponding location in a worksheet identified?
Cell reference and location are outlined in matching colors
Michelle used the property sheet to customize her form in Access. Which task can she complete?
Change the background and add captions.
Michelle used the property sheet to customize her form in Microsoft Access. Which task can she complete?
Change the background and add captions.
A/an ___________ is a graphical representation of data or information.
Chart
Alicia needs to delete the data in cell B5. Which command would she select?
Clear
How would sheet tabs be moved to a new position in the workbook?
Click and drag the sheet tab to the new location
Curt needs to exit his database in order to work on another database. What action should he take after saving his work?
Close
To exit a database to work on another database, what should you do after saving your work?
Close
Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?
Close
To rename a table or other database object, you do which of the following?
Close it
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
Collapse/Expand
John has created a Pivot chart 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?
Collapse/Expand
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
Collapse/Expand
Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
Collapse/Expand
What graphically represents trends in plotted data and predicts future values?
Collapse/Expand
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
Collapse/Expand
What ribbon contains the commands used to create a chart in Excel?
Collapse/Expand
When creating a PivotTable, which are drawn in columns in the worksheet data?
Collapse/Expand
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
Collapse/Expand
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
Collapse/Expand
Which is a tiny chart that provides a visual representation of data in a worksheet cell?
Collapse/Expand
Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories for grouping?
Collapse/Expand
Which of the following is not a field property?
Column Template
What term describes the process of repairing and removing wasted space from a database?
Compacting
Which type of operator enables a user to compare two values in a query criterion?
Comparison
What type of formatting appears only when the value in a cell meets conditions specified by a user?
Conditional
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
Conditional Formatting
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
Copy
What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
Copy using the Fill Handle
Ashawn has created a table from his database to know the number of products currently available for sale in his spring catalog. Which aggregate function should he use?
Count
Frank needs to know the number of service calls he has received from 123 Walnut Street in one week. Using a calculated field, which total function would he use to answer this question?
Count
Where is the command for creating a new table from Table Design view?
Create Ribbon
In which row in the query design grid can you add conditional logic to a query?
Criteria
To group inventory by types of dog food with a subtotal for each group which query do you use?
Crosstab Query
The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query action will display this information?
Crosstab query
Which query action will group the inventory of dog food by types with a subtotal for each group
Crosstab query
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?
Ctrl + End
What are three valid methods for saving a database in Microsoft Access?
Ctrl + S, File tab Save command, Quick Access Save command
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
Currency
Dennis needs to format his sales amount column to show dollar signs.Which format would he use?
Currency
Which tab contains the Subtotal Command?
Data
Juan is creating a chart which graphs attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to show individual data values. Which tab in Chart Options would he select?
Data Labels
In order to insert the datasheet at the bottom of the chart using the Chart Option dialog box, which of the following is the proper procedure?
Data Table tab >\; Check Show data table
John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he choose?
Decrease/Increase
What is the process of viewing a PivotTable report for a subset that meets the criterion only?
Decrease/Increase
What term refers to an Excel Chart with offset pieces for emphasis?
Decrease/Increase
Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
Decrease/Increase
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
Decrease/Increase
Donna's Bakery lost a customer named Dingin' Donuts. What actionshould be taken to remove all records from her database for Dingin'Donuts?
Delete Query
Chad needs to remove a student from the FBLA database. Which option should he choose?
Delete Record
Donna's Bakery lost a customer named Dingin' Donuts. What action should be taken to remove all records from her database for Dingin' Donuts?
Delete query
Before importing a file, all unnecessary blank columns and rows should be ___________.
Deleted
Which file type places each record on a separate line and uses a special character to separate fields?
Delimited
Notes for future users of a database so they will properly use the field names and types.
Description
In order to resize the chart, which view must the report be in?
Design
Which view displays the area used to create a table or to modify the structure of a table?
Design
Ashton needs to add a footer to the Form for his database. Which view will allow him to add it.
Design View
Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer?
Design View
Which view is best to create the new database?
Design View
Which view will allow you to resize A Report header?
Design View
Chad needs to change a members telephone number in the FBLA database. What step should he take?
Edit Record
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. In which file format should she save the form to ensure everyone can read the information?
Either PDF or XPS
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?
Entry
What is the process of transferring data from an Microsoft Access database for use in another application called?
Exporting
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?
Expression Builder
Which tab contains the import and export commands?
External Data
What function should you use to search a spreadsheet for a specific string in a text string.
FIND
Which tab is used to display the area that contains the print command?
File
What area contains the command used to customize the print options in Microsoft Excel?
File Tab
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?
File tab
Joe wants to add color to the header section of his form. Which formatting option would he use?
Fill Color
What command is used to apply a background color to cells in a worksheet?
Fill Color
Which command on the Fill options dialog box is the default if a month or day is entered?
Fill Series
Which command on the Fill options dialog box is the default option if a month or day is entered
Fill Series
Which command on the Fill options dialog box is the default option if a month or day is entered?
Fill Series
What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?
Fill handle
An operation to determine how many students in NHS are seniors, but without saving the result?
Filter
Eddie needs to know which employees work in the Southeast District. Which command would he use?
Filter
What command should you use to view only employees who earn a salary of more than $25,000.
Filter
Which of the following is not a way to validate data?
Filtering
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?
Filters
Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use?
Find
Mr. Smith needs to know Jenny's address. Which command would he use?
Find
To search for the specific employee who lives on 225 Mayberry Lane, what command would you use?
Find
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
Find & Select
David wants to change all occurrences of 'North Carolina' to 'NC' in his spreadsheet. What command should he use to complete this task?
Find and Replace
Dennis needs to format the numbers in his database to three decimal places. Which number format would he use?
Fixed
To format numbers in a database to three decimal places which number format would you use?
Fixed
On the Home Ribbon, what is used to change the font size of characters in a cell?
Font Size drop-down list
Michelle needs each National Technical Honor Society member to complete an information sheet. Which tool would be best?
Form
Tia needs each Honor Society member to complete an information sheet. Which tool would be best?
Form
Tyler is using Microsoft Access for a class assignment. Which database object would she use to enter one record at a time?
Form
Which database object do you use to enter one record at a time?
Form
Which option will automatically include all fields from a single Table to create a quick Form.
Form Tool
An assistant at Doggie Daycare was asked to update the patient information for all new pets. What view is best to enter the new patient information?
Form View
Juan wants to view one record at a time in his database. Which view should he use?
Form View
Which tool would you sue to create a subform?
Form Wizard
A split form shows your data in which views?
Form view and Datasheet view
Linda wants to ensure birth dates are entered as MM/DD/YYYY. Whichfield property will be used?
Format
Which command on the Home Ribbon is used to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
Format
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Format Cells
Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?
Format Cells
Jennifer is calculating her GPA. If she uses '=(A1+A2+A3+A4)/4', this is an example of which type of entry?
Formulas
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
Freeze
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
Freeze
Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input this information. What should she do?
Freeze Fields
Which is a prewritten formula that is built into Microsoft Excel?
Function
Angie is calculating her average sales for the past four months. If she uses '=AVERAGE(B1:B4)', this is an example of which type of entry?
Functions
Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
Gather the information
Mrs. Wilson needs to create a report that lists students by their homeroom teacher. Each teacher needs a separate list for attendance. Which option would allow Mrs. Wilson to put students together by homeroom on separate sections of the report?
Grouping
Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?
Hide
Format as Table can be found under what tab?
Home
Nick wants to immediately open an employee email from his database. What data type should be used for the email address?
Hyperlink
Dillan wants to ensure social security numbers are entered in a proper format. Which field property will be used?
Input Mask
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?
Insert a Totals Row
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?
Key Tips
Which ribbon option opens a related dialog box?
Launcher
Juan is creating a chart which graphs attendance at FBLA State Leadership conferences from the past five years from his database. He wants to display a list of colors, shapes, or patterns used as categories in a chart on the right side. Which tab in Chart Options would he select?
Legend
Amanda wants to ensure there are only two characters for the state abbreviation. What should she do?
Limit field size
You want to ensure there are only 2 characters for the state abbreviation. What should you do?
Limit field size
John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?
Line Chart
IF, AND, OR and NOT are all part of which category of functions?
Logical
The type of field that lets you select from a list of values when updating its contents?
Lookup
Which type of field enables a user to select from a list of values when updating the contents of a field?
Lookup
What action would Donna perform to create a new table named Customer Appreciation from the existing Customer Information table and Order History table?
Make table query
Which term describes the blank portions of a page that fall outside the main body of the printed document?
Margins
SUMIF and SUMIFS are in which category of functions?
Math & Trig
Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know which chapter has the most active members in the region. Which aggregate function should she use?
Max
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
Merge & Center
Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
Microsoft Excel
Which is not a file type that may be imported into Microsoft Access?
Microsoft Publisher files (PUB)
Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use?
Min
John would like to change the order of the worksheets in his workbook. Which option would he choose?
Move
Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
Move
A (n) __________ form resembles a datasheet, but it gives you more customization options.
Multi-item
Which tool creates a customizable form that displays multiple records?
Multiple Items
What function should you use if you want to return True when the logical value is False.
NOT
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?
NOW
Jackson is starting a new company database to manage his fall line of products. What form tool could he use to quickly create a set of tabs a user could click to access forms and reports in the database?
Navigation Form
Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database?
Navigation Form
Which type pf form allows you to view data from more than one table or query on the same form?
Navigation Form
Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?
Navigation Pane
What type of form can be added to a database to simplify your interaction with objects?
Navigation form
Which type of form allows you to view data from more than one table or query on the same form?
Navigation form
Which view is the default view used in Microsoft Excel?
Normal
The process of applying rules to a database design to ensure that you have divided your information into the appropriate tables
Normalization
Relationship that means a record in the 1st table is related to > one record in 2nd table?
One to many
Which type of relationship means that a record in the first table is related or matches more than one record in the second table?
One to many
Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database?
Open
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
Open
Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
Orientation
Which command on the Home Tab can be used to rotate text to a vertical or diagonal angle?
Orientation
Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use?
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
Page Layout
In a table, which is a way of exclusively identifying each record in the database?
Primary Key
Wendy needs to print to the color printer instead of the default printer on her computer. Which option would give her the choice to change the printer?
Which option would give you the choice to change the printer?
To see what a Report will look like without printing a hard copy which option would you choose?
Print Preview
Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose?
Print Preview
William has created a report. Which view could he use to see exactly how the report will look on paper?
Print Preview
You created a report. Which view could you use to see exactly how the report will look on paper
Print Preview
Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?
Print Titles
Jessica needs to capitalize the first letter in each word. Which function would she use?
Proper
Nick needs to specify two characters for the student ID field. What area of Design View would he access to specify this?
Properties
Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?
Provide a caption
Beth needs to determine the seniors with a GPA of 4.0 or higher. Which object would allow her to create a saved search to find this information in the database?
Query
Beth needs to determine the seniors with a GPA of 4.0 or higher. Whichobject would allow her to create a saved search to find this informationin the database?
Query
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 and save it for later use?
Query
Keisha created a database of her music. She wants to locate only thesongs by Beyoncé. What tool should she use in order to view thisinformation and save it for later use?
Query
Joe wants to modify the query he created to incorporate various colors, fonts, and styles to create a custom look. Which query would he use?
Query Design View
Joe wants to modify the query he created to incorporate various colors,fonts, and styles to create a custom look. Which query would he use?
Query Design View
You need to add a Total Row on the design grid. Which tab contains the Totals button?
Query Tools: Design
How do you access the Make Table dialog box?
Query Tools: Design tab > Query type > Make Table button
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
Quick Access Toolbar
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
Range
Which term refers to a group of selected cells that may be moved, copied or deleted as a group?
Range
Ali has worked for years cataloging his comic book collection into a database. Recently his computer crashed, but fortunately he has a backup in his OneDrive cloud storage. Which method should he use to restore his database on his new computer?
Recover from Backup
Kurt has worked for years cataloging his music collection into a database. During a recent storm, Kurt's computer was damaged, but fortunately he has a backup on his flash drive. Which method should he use to restore his database on his new computer?
Recover from Backup
Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include?
Reduce/Add
Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?
Reduce/Add
In order to directly report the data, what must a PivotChart always be associated with?
Reduce/Add
John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?
Reduce/Add
John wants to identify the exact value that each column in his chart represents. Which option should he choose?
Reduce/Add
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
Reduce/Add
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
Reduce/Add
What ribbon contains the commands for creating charts in Microsoft Excel?
Reduce/Add
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
Reduce/Add
Which type of database consists of a collection of tables, each of which contains information on a specific subject?
Relational
When copying formulas, which feature automatically adjusts cell references in the new location?
Relative reference
When copying values in Excel, which feature will adjusts cell references for the new location?
Relative reference
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Relative reference
To customize sheet tabs in a workbook with names June, July, and August choose this command.
Rename
Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?
Rename
Keisha wants to print her completed music databases. Which tool would she use?
Report
Margaret wants to send an address change to all the customers in her current database. She wants to create address labels to accomplish this. Which would she use?
Report
Which database object would you use to organize & display data pulled from tables and queries?
Report
Which ribbon displays report printing options?
Report Design Tools Page Setup Ribbon
Which ribbon in Layout View contains commands to insert or delete rows and columns in a report?
Report Layout Tools Arrange
Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?
Report Layout Tools Arrange
The owner of Ima Graphic Animator, Inc., a graphic design company, wants to place the company's logo at the top of the first page on a report. Where should the logo be placed in the Report Design View?
Report header section
How is an exact copy of a worksheet created within the same workbook?
Right click sheet tab, choose Move or Copy from Shortcut Menu
How can a table style be quickly modified to meet user preferences?
Right-click on a style and choose Duplicate
Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?
Row
After a query is created, which action must take place to display theresults of the query?
Run
Which SQL statement selects all the columns and rows in the Resource table?
SELECT * FROM Resource
To replace a specific text in a text string in a spreadsheet. What function should you use?
SUBSTITUTE
What function should you use to add only cells in a range that are greater than 1000?
SUMIF
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
Save
Curt needs to create a backup to his existing database on an external hard drive. What action should he take?
Save As
To create a backup to a database on an external hard drive, what action should you take?
Save As
Which command allows you to save an existing worksheet with a new name or in a new location?
Save As
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
Save As
Which of the following commands allows you to save database objects as other forms of objects?
Save Object As
Marty has spent a lot of time creating a database to track her sales contacts.She has been asked by management to share the database with her colleagues as an example to follow. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms?
Save as Database Template
Rachel has spent a lot of time creating a membership database for her FBLA chapter, which she has been asked to share with other chapters in her region as an example. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms?
Save as Database Template
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
Scale
In Datasheet view, how does a user delete a record?
Select the record and choose Delete from the Home Ribbon
If fields in the import file contain an assortment of data types, the wizard will usually suggest using the ___________ data type during import operation.
Short Text
What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
Shortcut Menu
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
Show
Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use?
Simple query
Which group on the Form Design Tools/Arrange Ribbon allows the user to align to grid?
Sizing & Ordering
What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
Slicer
To arrange a Report by last name, what tool is used to ensure that records are in proper order.
Sort
Ed works for ABC Auto. To view which employee has the lowest sale , which command does he use?
Sort Ascending
Eddie works for ABC Finance. He needs to view which employee has the lowest sales for the month. Which command should he use?
Sort Ascending
Ed works for ABC Auto. To see which employee has the highest sales, which command should he use
Sort Descending
What ensures that a query result appears in a specific order?
Sorting
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
Split
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
String
When a database is created, what is defined when names and data types are assigned to all data fields in a table?
Structure
When creating a dbase, what is defined when names and data types are given to all data fields?
Structure
Susie has a relational database for her catering business. She wants to create a form which shows the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a:
Subform
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?
Subtract/Add
John would like to display the count of employee last names on the Y-axis of a PivotChart. What area would he drag this information to in order to display correctly?
Subtract/Add
Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include?
Subtract/Add
What is typically included in the range of data selected to create a chart?
Subtract/Add
Which is the default method for summarizing data in a PivotTable?
Subtract/Add
What function adds all of the numbers in a range of cells?
Sum
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
TODAY
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose
Tab Color
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
Tab Color
Helen is creating a form to gather important information about graduation requirements from her senior homeroom students. What tool would she use to ensure that the sequence in navigating the form fields so data is entered in the order she wants?
Tab Order
What tool is used to ensure that the sequence in navigating the form fields is in correct order
Tab Order
A wizard that performs the normalization process by examining a table design and suggesting a way to divide the table for maximum efficiency
Table Analyzer
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
Template
Jenny is setting the addresses for each patient. Which data type should she use?
Text
Michelle wants to change the color of her form to make it more attractive.Which should she use?
Theme
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
Theme
Susie wants to locate the file name of her current document. Where she should look?
Title Bar
Susie wants to locate the file name of her current document. Where should she look?
Title Bar
Juan is creating a chart graphing his inventory database. He needs to name the chart "August Inventory Report." Which tab in Chart Options would he select?
Titles
Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?
Today
The Table Analyzer does not remove the original table. True or False?
True
The Table Analyzer gives you the choice of whether to create a query. True or False?
True
Dean needs to add the FBLA logo to the top of his form.Which type of control should he use?
Unbound
Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
Unbound
To add a graphic by one of the fields on a form, which type of control will you add to the form
Unbound
Which type of control would you use to add instructions by one of the fields on your form.
Unbound
What is the purpose of a primary key in a database?
Unique Identifier
Query enables a user to make the same change to all records satisfying a certain criterion?
Update
What type of query enables a user to make the same change to all records satisfying a certain criterion?
Update
What type of query makes the same change to all records satisfying a certain criterion?
Update
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
Upper
What are the rules that a user should follow when entering data into a table?
Validation
Asiah has created a senior information form from her student table. She wants the parent's home phone text box to have the exact same width as the cell phone text box. What tool would she use to ensure they are exactly the same?
View Code Add
Which notebook-like feature organizes the sheets for use in Excel?
Workbook
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
Worksheet
What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?
Zoom to Selection
In Ty's monthly sales worksheet, he entered a formula =(January!B3). 'January' is an example of
an external reference
Marci is searching a Planet Database. She wants to find out how many moons Saturn has and the names. Which comparison operator would she use?
and
Marci is searching a Planet Database. She wants to find out how manymoons Saturn has and the names. Which comparison operator would she use?
and
Which type of query adds the records in the query's result set to the end of an existing table?
append
When you use the Multiple Items tool, the form that Access creates resembles a
datasheet
Joshua created a budget workbook that contains the formula =(Summary!B3). 'Summary' is an example of a/an:
external reference
Tyler created a monthly sales workbook that contains the formula =(January!B3). 'January' is an example of a/an:
external reference
You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of:
fields
Which of the following describes how a crosstab query displays its results?
grid
A form/subform combination is sometimes referred to as a
hierarchial form, master/detail form & parent/child form
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:
main form
Marci has a database of all the planets. She needs to know what planetshave moons or rings. Which comparison operator would she use to perform the query?
moons or rings
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:
named range
Once the Chart button is selected from the Design tab, the pointer changes to which of the following icons?
plus sign with a chart icon
The Import Spreadsheet Wizard will provide an option for the user to define a/an ___________ key for the new table, which will uniquely identify the record in your table.
primary
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
range
Your worksheet has info about the number of music downloads in F1:F25. F1:F25 represents a:
range
Al's worksheet has information about the number of music downloads in F25. '25' identifies the:
row
Sharon's spreadsheet contains information about the number of music downloads in F25. In this address, '25' identifies the:
row
To print only the worksheet you are currently working on; what print option should you choose?
Active Sheets
Carl notices that the data in cell E4 reads #######. What command could correct this problem?
AutoFit
What is a character, word, or phrase in a cell in a worksheet that is used in searches?
String
Home Ribbon group with command to convert selected cells to a table by picking a table style
Styles
A special workbook a user can create and use as a pattern to create new, similar workbooks.
Template
