MS Excel and Access Final Review
What is the process of transferring data from an Access database for use in another application called?
Exporting
Michelle needs each National Technical Honor Society member to complete an information sheet. Which tool would be best?
Form
Mr. Johnson, the FBLA adviser, is updating the membership database table for the new school year. He wants to define the fields to display and simplify the interface by adding labels and instructions. He would use a:
Form
Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table?
Form Tool
You are employed as an assistant at Doggie Daycare. Your boss has asked you to update the new pet patient information. If you opened the form in Design View, which view should you switch to in order to enter patient information?
Form View
Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used?
Format
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
Format as Table
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
Drag the boundary next to the column heading
How do you increase or decrease a column's width?
What is the process of bringing data containing text fields separated by commas into Excel called?
Importing data
Dillano wants to ensure social security numbers are entered in a proper format. Which field property will be used?
Input Mask
Orientation
Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
Which type of field enables a user to select from a list of values when updating the contents of a field?
Lookup
Which is NOT a file type that may be imported into Microsoft Access?
Microsoft Publisher files (.pub)
James wants his spreadsheet to return true when the logical value is false. What function should he use?
NOT
Jackson is starting a new company database to manage his new 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
Juan needs to view and access all parts of his database. Where can these objects be located most efficiently?
Navigation Pane
Which of the following is the difference between an Auto Outlined worksheet and a worksheet with multiple groups?
None
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?
William has created a report. Which view could he use to see exactly how the report will look on paper?
Print Preview
Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this?
Properties
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Query
Which type of database consists of a collection of tables, each of which contains information on a specific subject?
Relational
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?
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
You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to place your logo at the top of the first page on a report. Where would you place the logo in the Report Design View?
Report header section
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
Review
How do you quickly modify a table style to meet user preferences?
Right-click on a style and choose Duplicate
How is an exact copy of a worksheet created within the same workbook?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
After a query is created, which action must take place to display the results of the query?
Run
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?
Change History
Michelle used the property sheet to customize her form in Access. Which task can she complete?
Change the background and add captions.
Which of the following procedures is not a way to sort a table by the contents of one column?
Click an AutoFilter button in the total row.
Which of the following procedures is not a way to filter a table by the contents of one column?
Click the AutoFilter button in the total row at the bottom.
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
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
Donna's Bakery lost a customer named Doggie Donuts. What action should be taken to remove all records from her database for Doggie Donuts?
Delete query
Which file type places each record on a separate line and uses a special character to separate fields?
Delimited
You can have no more than two criteria in a custom AutoFilter.
True
You cannot sort a table in alphabetical or numerical order for one column and by conditional formatting for another column at the same time.
True
In a table, which is a way of exclusively identifying each record in the database?
Unique Identifier
What type of query enables a user to enables a user to make the same change to all records satisfying a certain criterion?
Update
What are the rules that a user should follow when entering data into a table?
Validation
Conditional
What type of formatting appears only when the value in a cell meets conditions specified by a user?
Home Ribbon
Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
Select Remove Page Break from the Breaks drop-down area
Which command do you use to remove manual page breaks from a worksheet area?
Which of the following is a selected cell?
Active Cell
Ann 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
You want to fit a long column heading into a small space without changing the font size or column width. Which of the following is the best choice?
Adjust text orientation
Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records?
Aggregate
What type of query enables a user to add the results of a query to an existing table in a database?
Append
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
Arrange All
Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?
Auction Items[#Totals]
Which Excel feature automatically fills cells with data from another cell or range or completes a data series?
Auto Fill
Which Excel feature helps you quickly enter previous data into cells?
AutoComplete
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
AutoComplete
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
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
When you modify the ribbon, which of the following do you create?
Button
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Calculation
Which of the following can you not copy using Format Painter?
Cell content
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?
Column
Text
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
Which of the following is used to drag or double-click to change the width of a column?
Column marker
Which of the following places a duplicate of a selection in the Office Clipboard?
Copy
To get the cell on the worksheet, which of the following should you press?
Ctrl+End
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Defined Names
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 data entry form in his gaming database. Which view will allow Ashton to add a footer?
Design View
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?
Design View
Juan is creating a new database. He wants to assign field names. Which view is BEST to create the new database?
Design View
Which of the following consists of details that describe or identify a file, including the author?
Document Properties
What is the process of using the mouse to move or copy cells called?
Drag and drop
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?
Either PDF or XPS
Which command do you use to close an open file and completely exit the Microsoft Excel program?
Exit
Per the order of operations, which of the following is calculated first?
Exponential (^)
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
Ctrl+F Displays Backstage view
False
Ctrl+O Opens a new workbook
False
Dates can be displayed in only one way in Excel.
False
If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width
False
Pressing the f1 key displays backstage view
False
The formula bar is found at the bottom of the Excel window.
False
The quick access toolbar appears on the right side of the title bar, above the ribbon
False
The title given to a table appears above the field names row.
False
To evaluate the error in the formula, select the Edit in Formula Bar option from the pop-up menu that appears after you click the warning icon.
False
To remove only the formats from a cell, you can use the Delete key.
False
Using the Delete key removes both text and formats from a cell.
False
When data is too wide for a cell, the part of the data that will not fit is automatically deleted.
False
When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.
False
You can assign keywords so that others can search for your documents online.
False
You remove duplicate rows from a table the same way you would for a named range of AutoFiltered records.
False
Use Ctrl + : to enter the current date in a worksheet cell.
False (it enters the current time)
Which tab do you use 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
To use a worksheet or workbook outside Excel, you have the option to save as which of the following?
File format
Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?
Fill handle
Which command on the Fill options dialog box is the default option if you enter a month or day?
Fill series
Curt needs to format the numbers in his database to two decimal places. Which number format would he use?
Fixed
Which of the following attributes is not a potential criterion for an AutoFilter sort?
Font style
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
Format
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
Formula Auditing
Where can you find the Insert Function button in Microsoft Excel?
Formula bar
Which of the following is a bar near the top of the Excel window where you can enter or edit cell entries or formulas?
Formula bar
Which of the following is not a required argument for the PMT function?
Fv
When you click the help button,what opens?
Help Window
In which group on the HOME tab is the Clear Formats command located?
In the Editing group
You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which alignment option do you choose?
Justify
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
Which dialog box in Backstage view should you access to view and alter your workbook's properties?
Options
Which of the following do you click in the navigation pane to change Excel's default settings by accessing Backstage view?
Options
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
Page Layout
Which command is used to insert a cut or copied selection to a cell or range of cells?
Paste
In order to directly report the data, what must a PivotChart always be associated with?
PivotTable
Which feature enables you to preview headers and footers, page breaks and other features that will print
Print layout
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
Which of the following is a group of adjacent cells that you select to perform operations on all of the selected cells?
Range
Which feature enables you to create custom tabs and groups?
Ribbon
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
Row
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 Form Design Tools Arrange Ribbon allows the user to align to grid?
Sizing & Ordering
When a database is created, what is defined when names and data types are assigned to all data fields in a table?
Structure
Which of the following starts off with open,undo and redo and can be customized to contain the commands you use most frequently?
The Quick Access Toolbar
Boundary
The lines between rows or columns.
After a file has been opened, the filename appears in which of the following
Tile Bar
Which is a valid reason you'd want to convert a table to a range?
To prepare for importing new data from a non-Excel file.
50%
To render twice the normal amount of worksheet for any given area of the screen, what would you change the Zoom to?
Borders
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A cell cannot be a trace dependent and a trace precedent for the same formula
True
All dates in Excel are actually stored in the serial date number system.
True
Click the file tab to get to the backstage view
True
In the PMT function, the Nper argument is the total number of payments for the loan.
True
Once you remove an automatic style from a table, it is no longer a table.
True
Page layout view is useful when preparing your data for printing
True
Press Ctrl+home to go to cell Ā1
True
Pressing the Alt key activates key-tips that allow you to use the keyboard to choose tabs instead of click them with the mouse
True
The active cell in a worksheet is outlined by a bold retangle
True
Use the fill handle to create a natural series, such as the months of the year.
True
When functions take more than one argument, you should enter them in multiple sets of nested parentheses, separated by commas.
True
Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.
True
You can create a completely new Ribbon tab as well as groups on that ribbon.
True
You cannot split a single worksheet cell that has not been merged.
True
When you split a window, the window is divided into how many panes?
Two or Four
Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
Unbound
Keton wants to add a graphic by one of the fields on his form . Which type of control will he add to the form?
Unbound
Tammy wants to add instructions by one of the fields on her form to ensure that the data is entered correctly. Which type of control will she add to the form?
Unbound
False
When searching for dollar amounts, use a dollar sign in the Find What text box.
On the PAGE LAYOUT, in the Sheet Options group.
Where are check boxes you can select to view or print gridlines?
Page Break Preview
Which Excel feature or view lets you drag automatic page breaks, converting them to manual page breaks, to achieve a more desirable printed document?
Sheet Options
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Paste Special
Which dialog box do you use to transpose rows and columns?
Format Cells
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
A hidden worksheet cannot be inadvertently deleted.
Which of the following statements about hidden and unhidden worksheets is correct?
Click Worksheet on the Insert menu tab
Which of the following steps is not part of inserting a worksheet into a workbook?
Click Hide on the View menu tab.
Which of the following steps is required for hiding a worksheet window?
Page Layout
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
It lets you repeat formats and working formulas into a new sheet.
Why would you need to copy a worksheet within a workbook?
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Worksheet reference
False
You unhide a hidden worksheet window with the Unhide Sheet command.
Which is the reason you would want to record a macro with absolute references rather than relative?
You want the macro to reproduce its results in the same place each time.
Print titles
You want to repeat column A on every page when printing a multiple-page worksheet. Which feature do you use?
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
Transposing
[ ] a row or column causes your cell data to change orientation. Row data will become column data, and column data will become row data.
Row Height
[ ] is the top-to-bottom measurement of a row, measured in points.
Scaling
[ ] refers to shrinking or stretching printed output to a percentage of its actual size.
Which is the intersection of a row and column?
cell
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 type will display this information?
crosstab query
Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
external reference
The columns in a worksheet identified by numbers
false
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
formulas
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
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
How many worksheets does a new Excel 2013 Workbook open with?
one
The COUNT and SUM functions are examples of which functions?
statistical
Page Break
A(n) [ ] is a divider that breaks a worksheet into separate pages for printing.
Which of the following is an example of an absolute cell reference?
$A$9
When using the SUBTOTAL function, what is the function number for the SUM function?
9
Which characters may not be used to begin a field name in a table?
= @ -
An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available
A Dialog Box
Header
A line of text that appears at the top of each page of a printed worksheet.
Which is the difference between an AutoFiltered range of records in a list and a table?
A table given a title enables its field names to be used in formulas in place of cell references.
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
Barney would like to create a report in layout view so that he can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the report's appearance while displaying the data?
Blank Report
Document Theme
A(n) [ ] is a predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items within a workbook, such as charts or tables.
Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
Application Parts
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?
Subtotal
False
The Find and Replace button brings up the Find and Replace dialog box.
Column Heading
The identifying letter at the top of a column is called the [ ]
Gridlines
The lines that display around worksheet cells.
