Excel & Access

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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 &gt\; 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?

PDF

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?

Print

Which option would give you the choice to change the printer?

Print

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


Kaugnay na mga set ng pag-aaral

Ethical Hacking Chapter 1, Ethical Hacking Chapter 2, Ethical Hacking Chapter 3, Ethical Hacking Chapter 4, Ethical Hacking Chapter 5

View Set

SUCCESS! In Clinical Laboratory Science - Chemistry: Enzymes and Cardiac Assessment

View Set

MODULE 3 - INTRODUCTION TO COMPUTER PROGRAMMING

View Set

Lean Six Sigma Yellow Belt Flash Cards

View Set

WC Exam 2 Study Guide (Look at once a day)

View Set