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?

Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:

In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?

Which command on the Fill options dialog box is the default option if a month or day is entered?

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?

Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?

Jim would like to print only the cell range A1:F20. What page setup option should he change?

Steve would like to print only the worksheet he is currently working on. What print option should he choose?

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?

Which are valid Microsoft Excel functions?

What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?

How is an exact copy of a worksheet created within the same workbook?

What type of formatting appears only when the value in a cell meets conditions specified by a user?

Carl notices that the data in cell E4 reads ######. What command could Carl choose to correct this problem?

Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?

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?

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?

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?

Joan wants to see her sales representatives in numerical order with the salesperson who sold the least at the top. Which sorting option should she choose?

Where is the Insert Function button found in Microsoft Excel?

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?

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?

Which notebook-like feature organizes the sheets for use in Excel?

Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

Which group on the Insert Ribbon enables a user to create charts?

What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?

David wants to change all occurrences of 'North Carolina' to 'NC' in his spreadsheet. What command should he use to complete this task?

Which command creates decorative text in a worksheet?

What command is used to apply a background color to cells in a worksheet?

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?

How can a table style be quickly modified to meet user preferences?

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?

What graphically represents trends in plotted data and predicts future values?

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

Which of the descriptions listed below best describe what a macro in Excel does?

Which part of the process of creating a macro is reflected in this image?

Where on the ribbon can the macro options be located?

Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?

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?

Which tab in Microsoft Access is used to open the File menu?

What type of database contains multiple collections of data that are related to one another?

When a database is created, what is defined when names and data types are assigned to all data fields in a table?

Juan needs to view and access all parts of his database. Where can these objects be located most efficiently?

Which type of database consists of a collection of tables, each of which contains information on a specific subject?

Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?

What are three valid methods for saving a database in Microsoft Access?

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?

Dillan wants to ensure social security numbers are entered in a proper format. Which field property will be used?

Avery is the president of her FBLA chapter. FBLA keeps all member information in a database. She is often asked by members to pull a detailed summary of all competition participation for scholarship applications. Which report creation tool will automatically pull all the fields from the competition table?

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?

Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header?

Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?

Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?

Nick wants to make notes for future users of his database so they will properly use the field names and types. Where would he make these notes?

What are the rules that a user should follow when entering data into a table?

Dennis needs to format his sales amount column to show dollar signs. Which format would he use?

Which type of field enables a user to select from a list of values when updating the contents of a field?

Donna's Bakery lost a customer named Dingin' Donuts. What action should be taken to remove all records from her database for Dingin' Donuts?

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?

Delores is doing a search of the bed and breakfasts in Southport, NC. She wants to know which bed and breakfast is less than one mile from the waterfront and allows pets. Which comparison operator would she use?

What ensures that a query result appears in a specific order?

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?

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?

Marci has a database of all the planets. She needs to know what planets have moons or rings. Which comparison operator would she use to perform the query?

After a query is created, which action must take place to display the results of the query?

Curt wants to search his CD collection database for the names of the albums from his favorite artist that were released after 2010. What object should Curt create and save to obtain this information most efficiently?

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?

The report Jamie created has a dark background and the page number is not displaying correctly. Which formatting option would he apply to the page number to add contrast between the background and the page number?

Chad needs to change a member’s telephone number in the FBLA database. What step should he take?

Label the following picture.

A form/subform combination is sometimes referred to as which of the following?

Which type of form already has a predefined layout and can automatically contain command buttons?

Which type of form can be added to a database to simplify your interaction with objects preventing the need to use the Navigation Pane?

Which type of query displays its results in a grid similar to an Excel worksheet?

Which of the following is not an aggregated function?

Which of the following is not a type of join?

The Chart Wizard is a control.

A legend can be displayed only on the right side of a chart.

The Refresh All button updates data in a chart with data modified in the underlying data source.

You can save a table as a report.

An Axis is a type of chart.

What is the result of 'Select * from customer where CustID>10 and CustID<100' query?

A Primary Key is a code that uniquely identifies a ____________ in a Database.

A __________ is a computerized filing system that is used to organize and maintain a collection of information for future use.

In a database table, rows are called a(n) __________

A primary key field from one table appears in a second table. What is the field in the second table called?

In the image to the right, where would you click to look for a name in the database?

Look at the information in the database table to the right. What field is being used to SORT the table?

Does Microsoft Access need to be told about relationships between tables?

A primary key field from one table appears in a second table. What can be said about these tables?

Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What is auto numbering an example of?