Multiple Choice Questions

In the Create Ribbon Tab in the Reports Ribbon Group, you clicked the Blank Report button.
  • Create a new query in Design view using the following fields in this order: From the Students table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.
  • Create a new blank report that will open in Layout view.
  • Preview how this report will look when printed.
  • From Design view, display the Property Sheet for this form.
On the Page Layout tab, in the Themes group, click the Themes button. Click the Ion theme.
  • Display the Total row for this query.
  • Apply the Ion theme to the worksheet.
  • Insert the current date and time in the selected cell
  • Clear the selected Sparklines from the worksheet.
TypePress Enter
  • Open the Course table.
  • Go to the first record
  • Enter the number 530 in cell C7
  • Add the text 21% to the shape. Click outside the shape when you..
On the Insert tab, in the Charts group, click the Insert Hierarchy Chart button. Select Sunburst.
  • Apply conditional formatting to the selected cells using the red gradient...
  • Delete this row.
  • Insert a sunburst chart based on the selected cells.
  • Clear the conditional formatting rules from the worksheet.
In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the More Forms button. In the More Forms menu, you clicked the Split Form menu item.
  • Create a Single Record form from the Classes table.
  • Create a new query in Design view using the following fields in this order: From the Students table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.
  • Create a new blank desktop database named Accounting.
  • Create a Split form from the Classes table.
On the Home tab, in the clipboard group, click the Copy button. Click cell F2, and click the Paste button.
  • Change the width of the selected columns to 14
  • Copy cell F3 , and paste to cell F2
  • Delete the Timesheets worksheet
  • Wrap the text in the selected cell
In the Access Table, you clicked the arrow at the top of the CourseDescription column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Foundation in the CourseDescription contains input, clicked the OK button.
  • Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.1/1
  • Clear the filter from the Department field.
  • Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
  • From Design view, modify the field properties to display the message Asset accounts must be in the 1000s when the field validation rule is violated.
You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Tables and Related Views menu item
  • Switch to the view where you can modify the structure of the report without viewing any live data.
  • Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
  • Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.
  • Go to the previous record.
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You double-clicked the connection between the department and professor tables. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK button.
  • Modify the table relationships so that when a record is updated in the Department table, the related records in the Professor table will also be updated.
  • From Layout view, change the width of the DeptName column, so the department names do not wrap to two lines (approximately 2.3 inches).
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
  • Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
On the Insert tab, in the Illustrations group, click the Shapes button and select the Up Arrow shape from the Block Arrows section. Click on the 2020 column in the chart.
  • Insert a column to the left of the selected cell.
  • Insert an Up Arrow block arrow shape on top of the 2020 column..
  • Use AutoSum to enter a formula in the selected cell to calculate the sum.
  • Insert a sunburst chart based on the selected cells.
In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Page Numbers button. Inside the Page Numbers dialog, you selected the Page N of M Radio Button, selected the Bottom of Page [Footer] Radio Button, and clicked the OK button.
  • Modify the table properties to display the message Due date cannot be before invoice date if the table validation rule is violated.
  • Add automatic page numbers centered at the bottom of the page footer on every page. Use the format that includes the current page number and the total number of pages. Do not change views.
  • From Design view, modify this form's properties to not allow new records.
  • Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.
Click and drag a resize handle up or down toward the center of the chart to make it smaller.
  • Switch the rows and columns in the chart, so the data points are grouped..
  • Resize the selected chart so it is approximately 11 rows tall.
  • From Design view, display the Property Sheet for this form.
  • Move the selected chart to empty are of the worksheet...
Type ECN Department in cell B2 and press Enter. Type ENG in cell B3 and press Enter to accept Flash Fill.
  • The Anne Cole data point has been selected for you. Explode the Annie Cole..
  • Move Salaries worksheet so it is positioned before the working data worksheet
  • Modify the width of the CourseDescription column to best fit the data.
  • Use Flash Fill to autofill the cells in this column. Start by entering the...
In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button. Inside the Show Table dialog from the Table list, you double-clicked the Students list item, double-clicked the ResidenceHalls list item. Inside the Show Table dialog, you clicked the Close button. You double-clicked the LastName field in the Students table, double-clicked the FirstName field in the Students table, double-clicked the Classification field in the Students table, clicked a , double-clicked the ResidenceHall field in the Students table, double-clicked the ResidenceName field in the ResidenceHalls table, and double-clicked the FreshmenOnly field in the ResidenceHalls table. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Start a new query without using one of the query wizards.
  • Create a new query in Design view using the following fields in this order: From the Students table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.
  • Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
  • Create a new blank form that will open in Layout view.
In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form button.
  • Start a new query without using one of the query wizards.
  • Create a new blank desktop database named Accounting.
  • Create a Single Record form from the Classes table.
  • From Design view, display the Property Sheet for this form.
You clicked the Credits field's criteria row, changed the Credits field's criteria to >In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: Resident Advisors
  • Add criteria to this summary query to include only records where the value in the Days field is TTh. Do not include the Days field in the query groups. Run the query.
  • Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
In the Design Ribbon Tab in the Show/Hide Ribbon Group, you clicked the Totals button.
  • Insert the current date and time in the selected cell
  • Display the Total row for this query.
  • Display the data labels on this chart above the data markers.
  • Apply the Table Style Light 14 Quick Style...
In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Print Preview menu item.
  • Create a Split form from the Classes table.
  • Display the Total row for this query.
  • Hide the column showing 2016 data and the bonus rate.
  • Preview how this report will look when printed.
On the Home tab, in the alignment group, click the Wrap Text button.
  • Enable filtering
  • Wrap the text in the selected cell
  • Delete the Timesheets worksheet
  • Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
On the Table Tools Design tab, in the Table Style Options group, click the Total Row check box. In the total row at thee bottom of thee table, click in the Cost Column. Click the arrow and select Average.
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
  • The chart area is selected. Apply the Linear Down gradient...
  • Use a slicer to filter the data in this table t show only rows where the Catergory...
  • Add a total row to this table and display the average for the Cost column..
In the PivotTable Fields pane, click the Profit-Sharing check box to add the field to the Pivot Table.
  • Add slicers to filter the data in this table by Date.
  • Add the Profit-Sharing field to the PivotTable.
  • Set the print area so only the selected cells will print.
  • Clear the print area
Right-click the worksheet tab and point to Tab Color. Click Green, Accent 6, Lighter 80%
  • Modify this query so the DeptCode field is hidden in the query results, and then run the query.
  • Change the color of the sheet tab for the Dec 18 worksheet to Green, Accent 6, Lighter 80%
  • Use the Quick Analysis tool to apply the Data Bars conditional formatting...
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
Click the Quick Analysis tool button, and then click the Charts tab. Click Line.
  • Use the spelling checker to find and change all instances of any misspelled words.
  • Move the selected chart to empty are of the worksheet...
  • Insert a Line chart based on the first recommended chart type.
  • Create a Single Record form from the Classes table.
In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Title button. You updated the header title to Review.
  • Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.
  • Add a new Short Text field to the far right side of the table. Name the field: Description
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Modify this query so results are grouped by values in the DeptName field and values in the Credits field are summarized with the Sum function. Run the query.
You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 and
  • Create a new blank desktop database named Accounting.
  • Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.
  • Use the Create from the Selection command to create named ranges for the data table B8:E11 using the labels in row 1 as the basis for the names.
  • Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: Resident Advisors
You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.
  • Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.
  • Insert a new row into the form layout above the TuitionPaid and GPA controls.
  • Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.
In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Design View menu item.
  • Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.
  • From Layout view, delete the conditional formatting rule for the selected field.
  • From Page Break Preview view, insert a page break immediately above the selected cell.
  • Switch to the view where you can modify the structure of the report without viewing any live data.
In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form Wizard button. Inside the Form Wizard dialog in the Table: Courses drop-down, you clicked the Table: Departments list item. Inside the Form Wizard dialog from the Available Fields list, you double-clicked the DeptCode list item, double-clicked the DeptName list item. Inside the Form Wizard dialog in the Table: Courses drop-down, you selected Table: Courses. Inside the Form Wizard dialog from the Available Fields list, you clicked the DeptCode list item, double-clicked the CourseNumber list item, and double-clicked the CourseDescription list item. Inside the Form Wizard dialog, you clicked the Next > button, clicked the Next > button, clicked the Next > button, typed Departments in the formWizardTitleInput input, and clicked the Finish button.
  • Add a new conditional formatting to the selected field to display data bars. Use the default data bars settings.
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
  • Use the Form Wizard to create a new form. Include these fields in this order from the Departments table: DeptCode and DeptName fields and then add these fields from the Courses table: CourseNumber and CourseDescription. Organize the form by the Departments table with data from the Courses table as a datasheet subform. Accept the suggested names for the form and subform. Allow Access to open the form in Form view when you are finished.
  • Use the Field List pane to add the DOB field to the form immediately to the right of the LastName controls. Do not switch views.
You clicked the DeptCode column's Show box. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Modify this query so the DeptCode field is hidden in the query results, and then run the query.
  • Go to record number 20.
  • Preview how the results of this query will look when printed.
  • Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.
On the Home tab, in the Font group, click the Font arrow, and select Cambria.
  • Insert a column to the left of the selected cell.
  • Modify this worksheet so you see four different areas of the worksheet at the same time and scroll each area independently of the others.
  • Change the font for the selected cell to Cambria
  • Apply the Top and Bottom Border to the selected cells with a single command.
On the Chart Tools Format tab, Shape Styles group, click the Shape Outline button, point to Weight, and select 2 1/4 pt.
  • The 2019 data point in the Gross Profit data series has been selected...
  • Display the data labels on this chart above the data markers.
  • Use a slicer to filter the data in this table t show only rows where the Catergory...
  • Add a liner trendline to this chart. Use the default trendline formatting.
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You double-clicked the connection between the department and professor tables. Inside the Edit Relationships dialog, you checked the Cascade Delete Related Records check box, clicked the OK button.
  • Modify the Bonus field to use the MAX function instead of the SUM function.
  • Modify the table relationships so that when a record is deleted in the Department table, the related records in the Professor table will also be deleted.
  • Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.1/1
  • Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
In the Access Table, you clicked in the Major Cell. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Delete Rows button. Inside the Spa : Database dialog, you clicked the Yes button.
  • Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out.
  • Add the Status Quick Start fields to the right of the DegreeName field.
  • From Design view, apply the Medium Time format to the StartTime field.
  • Using the current view, delete the Major field from the table.
On the Table Tools Design tab, in the External Table Data group, click the Refresh button.
  • Sort this data by values in the Cost column so the most expensive item...
  • From Design view, display the Property Sheet for this form.
  • Use the spelling checker to find and change all instances of any misspelled words.
  • This worksheet is linked to an Access database. Update the worksheet..
Click the Quick Analysis Tool button and click the Sparklines tab. Click Column.
  • Add a new record to the table with the student ID 6412 and advance to the second field.
  • Add an element to the center section of the header to display the current date.
  • Use AutoFill to copy the formula and the formatting in cell E2 to cels E3:E6
  • Add column Sparklines to cells F2:F11 to represent the values in..
[...] Inside the Report Wizard dialog in the Table: Classes drop-down, you selected Table: Departments. Inside the Report Wizard dialog from the Available Fields list, you double-clicked the DeptName list item. Inside the Report Wizard dialog in the Table: Classes drop-down, you selected Table: Courses. Inside the Report Wizard dialog from the Available Fields list, you double-clicked the CourseNumber list item, double-clicked the CourseDescription list item. Inside the Report Wizard dialog in the Table: Classes drop-down, you selected Table: Classes. Inside the Report Wizard dialog from the Available Fields list, you double-clicked the ClassCode list item, double-clicked the Time list item. Inside the Report Wizard dialog, you clicked the Next > button, clicked the Next > button. Inside the Report Wizard dialog from the reportWizardGroupingSelectList list, you selected CourseNumber. Inside the Report Wizard dialog, you clicked the > button, clicked the Next > button. Inside the Report Wizard dialog in the 1 drop-down, you selected Time. Inside the Report Wizard dialog, you clicked the Next > button, clicked the Next > button, typed CoursesByDepartment in the What title do you want for your report? input, and clicked the Finish button.
  • Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: Resident Advisors
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
  • Use the Report Wizard to create a new report. Include fields in this order: DeptName from the Departments table, CourseNumber and CourseDescription from the Courses table, and ClassCode and Time from the Classes table. View the report data by the Departments table. Add grouping by CourseNumber. Sort records by the Time field. Use the Stepped layout and Portrait orientation. Name the report CoursesByDepartment and allow Access to display the report in Print Preview view when you finish. 1/1
  • From Layout view, create a new conditional formatting rule for the selected field. If the field value is greater than or equal to the value in the RequiredCredits field, apply bold, dark blue formatting. Dark blue is the second color from the right in the last row of the color palette.
Click the File tab. Click Save As. On the Save As page, click the Save as type arrow and select Text (Tab delimited) (*.txt) Click Save.
  • Switch the view that shows all the worksheet elements as they will print, including headers and footers.
  • Export this worksheet as a tab-delimited text file.
  • Change the shape outline color to Orange, Accent 2.
  • Preview how this report will look when printed.
In the Access Table, you clicked the Validation Rule property box, typed <2000 in the Validation Rule property box, and pressed the Enter key.
  • Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
  • Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.
  • Switch to the view where you can modify the structure of the report without viewing any live data.
  • From Design view, add a field validation rule to the AccountID field to require that values are less than 2000.
On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page.
  • Filter the data in place so that only rows where the Category value is ...
  • Enter a formula in cell D2 to calculate C2/C14 rounded to 3 decimal places.
  • Sort this data by values in the Cost column so the most expensive item...
  • Without adjusting the column widths, guarantee that all columns will print on one page.
Click the + symbol next to row 23.
  • Apply the Ion theme to the worksheet.
  • Change the chart typw to the first stacked bar option..
  • Clear the selected Sparklines from the worksheet.
  • Display the details for just the Office Expenses group.
In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Wizard button. Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you clicked the Table: Students list item. Inside the Simple Query Wizard dialog from the Available Fields list, you double-clicked the LastName list item, double-clicked the FirstName list item, double-clicked the Classification list item, and double-clicked the Credits list item. Inside the Simple Query Wizard dialog, you clicked the Next > button, clicked the Next > button, typed Tuition in the What title do you want for your query? input, and clicked the Finish button.
  • Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, Classification, and Credits fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Tuition and view the query results.
  • Create a new blank report that will open in Layout view.
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
  • Create a Split form from the Classes table.
Double-click cell B9 to edit the formula. Change the formula to be =E2*$B$8). Press Enter Click the Fill Handle tool and drag down to cell Brelease the mouse button.
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Edit the formula in cell B9 so the references to cell E2 will update when the formula is copied, and the reference to cell B8 will remain constant. Use Auto fill to copy the formula to cells B10:B12
  • Use the Create from the Selection command to create named ranges for the data table B8:E11 using the labels in row 1 as the basis for the names.
  • Enter a formula in cell D2 to calculate C2/C14 rounded up to 3 decimal places.
On the Formulas tab, in the Formulas Auditing group, click the Trace Dependents button.
  • From Page Break Preview view, insert a page break immediately above the selected cell.
  • Apply the Offset Diagonal Button Right shadow effect to the shape...
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
  • Insert the current date in the selected cell. Do not include the current time
You clicked the Credits field's sort row, expanded the Credits field's sort options list, and selected the Descending option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Apply conditional formatting to the selected cells using the red gradient...
  • Insert a Waterfall chart based on cells A1:B10
  • Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.
  • Change the font for the selected cell to Cambria
You clicked the Credits field's criteria row, changed the Credits field's criteria to >124, clicked the Classification field's criteria row, and changed the Classification field's criteria to Sr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.
  • Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.
  • Change the Navigation Pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc.)
  • Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.
Click the Table Tools Design tab. In the Tools group, click the Insert Slicer button. Click the Date checkbox. Click OK.
  • Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.
  • Start a new query without using one of the query wizards.
  • Add slicers to filter the data in this table by Date.
  • Add markers for just the highest values in the Sparkline group.
On the Data tab, in the Get & Transform group, click the Get Data button. Point to From Database and click From Microsoft Access Database. Click the Registration database file, and then click the Import button. Click ClassSchedule, and then click the Load button.
  • Import data from ClassSchedule table in the Registration Access database into a new worksheet.
  • Sort this data by values in the Cost column so the most expensive item...
  • Enter a formula in cell D2 to calculate C2/C14 rounded down to 3 decimal places
  • From Layout view, add automatic totals to the GPA column to calculate the average GPA.
On the Tables Tools Design tab, in the Tools group, click the Insert Slicer button. Click the Category check box. Click OK. in the Category slicer, click the Coffee button.
  • In cell C12, enter a formula using a counting function to count the number of items in the ..
  • Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.
  • Use a slicer to filter the data in this table to show only rows where the category...
  • Use a slicer to filter the data in this table t show only rows where the Catergory...
On the formulas tab, in the Formulas Auditing group, click the Remove Arrows button.
  • Show the tracer arrows from the precedent cells to cell B5
  • Display the Total row for this query.
  • Display the formulas in the worksheet.
  • Insert the current date and time in the selected cell
Click the Chart Tools Design tab. In the Chart Styles group, click Styleit is the seventh option in the Quick Styles gallery.
  • Apply the Monochromatic Palette 1 color scheme...
  • Apply the Style 7 Quick Style to the chart.
  • Export this worksheet as a tab-delimited text file.
  • Hide the column showing 2016 data and the bonus rate.
On the Formulas tab in the Formula Auditing group, click the Show Formulas button.
  • Move the Description field so it is the last field in the table.
  • Apply the Ion theme to the worksheet.
  • Apply the Colored Fill Green, Accent 6 Quick Styles to the shape...
  • Hide the formulas in this worksheet and display the values instead
You clicked the Next Record Button.
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Move the Description field so it is the last field in the table.
  • Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.
  • Go to the next record.
In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field Name menu, you clicked the Classification menu item.
  • Apply conditional Formatting to the selected cells so cells with the 10 items...
  • Insert an Up Arrow block arrow shape on top of the 2020 column..
  • From Layout view, group this report by values in the Classification field.
  • Use AutoSum to enter a formula in the selected cell to calculate the sum.
In the Design Ribbon Tab in the Show/Hide Ribbon Group, you clicked the Totals button. You clicked the Credits field's Total row, expanded the Total row's Group by list, and selected the Sum option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Modify the table relationships so that when a record is updated in the Department table, the related records in the Professor table will also be updated.
  • Modify the table properties to display the message Due date cannot be before invoice date if the table validation rule is violated.
  • Modify the width of the Time column to exactly 22
  • Modify this query so results are grouped by values in the DeptName field and values in the Credits field are summarized with the Sum function. Run the query.
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you clicked the DOB list item. You clicked the undefined view.
  • Modify the table relationships so that when a record is updated in the Department table, the related records in the Professor table will also be updated.
  • Use the Field List pane to add the DOB field to the form immediately to the right of the LastName controls. Do not switch views.
  • Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
  • Use the Create from the Selection command to create named ranges for the data table B8:E11 using the labels in row 1 as the basis for the names.
You clicked the Classification field's criteria row, changed the Classification field's criteria to FR. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Modify this query to show only students who are freshmen. Add criteria to the Classification field to return only records where the classification is FR. Run the query.
  • Change the color of the sheet tab for the Dec 18 worksheet to Green, Accent 6, Lighter 80%
  • This workbook will be used by people with Excel 2003 only. Save it in the best format for those users. Allow the compatibility issues.
  • Preview how the results of this query will look when printed when the page orientation is changed to landscape.
Click the arrow at the top of the Department column and click the (Select All) check box to remove all the checkmarks. CLick the Economics check box to add a checkmark. click OK. Click the arrow at the top of the Credits column and click the (Select All) check box to remove all the checkmarks. Click the 4 check box to add a checkmark. Click OK
  • Use the spelling checker to find and change all instances of any misspelled words.
  • From Layout view, change the width of the DeptName column, so the department names do not wrap to two lines (approximately 2.3 inches).
  • Use AutoFilter to filter the query results first to show only records where value in the Department field is Economics and the value in the Credits field is 4
  • Using cell references, enter a formula in cell B7 to calculate monthly payments for the loan described in this worksheet. Use a negative value for the Pv argument.
Type =EPress Enter.
  • Enter a formula in cell D2 to calculate C2/C14 rounded down to 3 decimal places
  • Enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6
  • Enter a formula in the selected cell to display the value of cell E3
  • Enter a formula in cell D2 to calculate C2/C14 rounded to 3 decimal places.
Click the Chart Elements button. Click the Data Labels arrow and select Above.
  • Remove duplicate rows where data in all the columns are identical
  • Display the data labels on this chart above the data markers.
  • Display the formulas in the worksheet.
  • Display the Total row for this query.
On the Chart Tools Format tab, in the Shape Styles group, click the Shape Fill button. Point to Gradient to expand the gallery and click the second gradient in the light variations section. (Liner Down).
  • Use a slicer to filter the data in this table t show only rows where the Catergory...
  • From Design view, add a Command Button control to the form.
  • The chart area is selected. Apply the Linear Down gradient...
  • The Anne Cole data point has been selected for you. Explode the Annie Cole..
On the View tab, in the Windows group, click the Freeze Panes button. Click Freeze top Row.
  • Use the Find and Replace dialog to find the record with the text julie, matching the case exactly.
  • Modify the worksheet so the first row is always visible when you scroll the worksheet down.
  • Manually create groups of rows that can be expanded or collapsed.
  • Apply the Accent1 cell style to the selected cell.
Click the Page Layout button on the status bar. Click in the center section of the header area above the worksheet grid. On the Header and Footer Tools Design tab, In the Header & Footer Elements group, click the Current Date button.
  • Add a footer that displays the page number in the center section.
  • Use the Quick Analysis tool to apply the Data Bars conditional formatting...
  • Create a new table in Datasheet view. Save it with the name: Degrees
  • Add an element to the center section of the header to display the current date.
On the Insert tab, in the Tables group, click the Recommended PivotTables button, Click the Sum of Bonus by Employee option. Click OK.
  • Create automatic subtotals to sum the cost for each change in the Category...
  • The total row for each expense category uses a SUM function to total the costs...
  • Insert a recommended PivotTable, using the SUM of Bonus by Employees...
  • Insert a clustered column-line combination chart based on the selector...
In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Blank Form button.
  • Create a new blank form that will open in Layout view.
  • Add a footer that displays the page number in the center section.
  • Set the print area so only the selected cells will print.
  • Move the Description field so it is the last field in the table.
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Departments field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Departments list, you double-clicked the DeptName list item. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Faculty field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Faculty list, you double-clicked the LastName list item, double-clicked the FirstName list item.
  • Use the Field List pane to add the following fields to the report: From the Departments table, add the DeptName field. From the Faculty table, add the LastName and FirstName fields. Do not switch views.
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
  • Use the Create from the Selection command to create named ranges for the data table B8:E11 using the labels in row 1 as the basis for the names.
  • Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.
You clicked the Previous Record Button.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Delete the Description field.
  • Go to the previous record.
  • Enable active content in this database.
You clicked the Search Box, typed Car in the Search Box.
  • Use the Search box to begin searching for a student with the last name beginning with Car.
  • Close the Navigation Pane.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
Click the Insert tab. In the Charts group, click the Insert Pie Chart button. Select the 3-D Pie chart type.
  • Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.
  • Create a Split form from the Classes table.
  • Create a 3-D pie chart from the selected data
  • From Layout view, group this report by values in the Classification field.
On the home tab, in the Find group, click the Replace button to open the Find and Replace dialog. Type julie in the Find What box. Type Julie in the Replace with box. Click the Match Case check box. Click the Replace All. Click Yes
  • Merge the cells so the text appears centered across the merged cells
  • Modify the number format do no decimal places are visible after the decimal point.
  • Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
  • Change font size for the selected cells to 18.
Click the Chart Elements button and click the Data Tables check box.
  • Insert a Line chart based on the first recommended chart type.
  • Sort the Date column so the oldest dates are listed first.
  • Switch the rows and columns in the chart, so the data points are grouped..
  • Display the data table, including the legend keys.
Type 21% and then click outside the shape
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Use the Search box to begin searching for a student with the last name beginning with Car.
  • Add the text 21% to the shape. Click outside the shape when you..
  • Change the zoom level for the worksheet to be 110%
You opened the backstage view, clicked the New navigation button, clicked the Updated: Students template, typed Students in the File Name box, and clicked the Create button.
  • Create a new blank report that will open in Layout view.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.
  • Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
In the Access Table, you clicked the Format property box, clicked the Drop-Down Button, and clicked the Medium Time Item.
  • Using the current view, delete the Major field from the table.
  • Create a new blank report that will open in Layout view.
  • From Design view, add a field validation rule to the AccountID field to require that values are less than 2000.
  • From Design view, apply the Medium Time format to the StartTime field.
On the Charts Tools Design tab, in the Data group, click the Select Data button. In the Select Data Source dialog, click the Add button. Click cell A2 to enter it in the Series name box. Click in the series values box and delete the default entry. Click and drag cells B2:DClick OK to add the new series. Click OK to accept the change to the chart data source.
  • Modify the Bonus field to use the MAX function instead of the SUM function.
  • Add another data series to the chart to represent gross profit.
  • Change the chart typw to the first stacked bar option..
  • Create a new table in Datasheet view. Save it with the name: Degrees
On the Data tab, in the Sort & Filter group, click the Sort Z to A button.
  • Display the data labels on this chart above the data markers.
  • Sort this data by values in the Cost column so the most expensive item...
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
  • Apply the Ion theme to the worksheet.
Click the Paste button arrow, and then click the Formulas button
  • Cell F4 has been copied. Paste the formula only into the selected cell ( cell F5). Do not include the cell formatting.
  • Use AutoFilter to filter the query results first to show only records where value in the Department field is Economics and the value in the Credits field is 4
  • Apply the Style 7 Quick Style to the chart.
  • Filter the chart so the lines for Dr.Patella and John Patterson are hidden.
In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.
  • Apply the Colored Fill Green, Accent 6 Quick Styles to the shape...
  • Apply the Offset Diagonal Button Right shadow effect to the shape...
  • The 2019 data point in the Gross Profit data series has been selected...
  • Add the Status Quick Start fields to the right of the DegreeName field.
On the Home tab, in the Editing group, click the Clear button. Select Clear All.
  • Apply the Top and Bottom Border to the selected cells with a single command.
  • Use a single command to clear everything from the selected cell.
  • Wrap the text in the selected cell
  • Insert an Up Arrow block arrow shape on top of the 2020 column..
On the Home tab, In the Editing group, click the Sort and Filter button and select Filter. Click the arrow at the top of the Category column. Click the (Select All) check box to remove all the checkmarks. Click the check box in front of Coffee. Click OK.
  • Insert an Up Arrow block arrow shape on top of the 2020 column..
  • Create automatic subtotals to sum the cost for each change in the Category...
  • Filter the Category column so only rows with Coffee are shown.
  • Apply the Accounting Number Format to the selected cells.
In the Design Ribbon Tab in the Show/Hide Ribbon Group, you clicked the Property Sheet button. You clicked the Validation Rule option. Inside the Property Sheet dialog, you typed [DueDate]>[Date] in the Validation Rule input, pressed the Enter key.
  • Enter a validation rule for the table to require values in the DueDate field to be greater than the values in the Date field. Remember to enclose the field names in square brackets. 1/1
  • Create a 3-D pie chart from the selected data
  • Insert a recommended PivotTable, using the SUM of Bonus by Employees...
  • Convert the table to a normal range
On the Home tab, in Font group, click the Boarders button arrow, and select Top and Bottom Border.
  • Change the font color of the selected cells to the Blue-Gray, Text 2 color.
  • Modify the number format do no decimal places are visible after the decimal point.
  • Apply the Top and Bottom Border to the selected cells with a single command.
  • Use Format Painter to copy the formatting from cell D1 and apply it to cell E1
On the Home tab, in the Alignment group, click the Marge & Center button.
  • Apply the Top and Bottom Border to the selected cells with a single command.
  • Filter the Category column so only rows with Coffee are shown.
  • Merge the cells so the text appears centered across the merged cells
  • Insert an Up Arrow block arrow shape on top of the 2020 column..
On the Formulas tab, in the Function Library group, click the MoreFunctions button. Point to Statistical and select COUNTA from the list. Click and drag to select cells C2:CClick OK.
  • From Design view, modify the form's property to restrict data entry to new records only.
  • Enter a formula in cell B2 using VLOOKUP function to find the total sales for the date in cell B1.
  • In cell C12, enter a formula using a counting function to count the number of items in the ..
  • Sort the date first Alphabetically by the values in the Category column and then...
On the Data tab, in the Sort & Filter group, click the Sort button. Expand the Sort by list and select Category. Click the Add Level button. Expand the Then by list and select Date. Click OK.
  • Import data from ClassSchedule table in the Registration Access database into a new worksheet.
  • Switch to the view where you can modify the structure of the report without viewing any live data.
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
  • Sort the date first Alphabetically by the values in the Category column and then...
On the Data tab, in the Sort & Filter group, click the Filter button to display the AutoFilter arrow at the top of the Category column, and the point to Text Filters. Click Contains... Type Server in the box next to contains. Click OK.
  • Sort this data by values in the Cost column so the most expensive item...
  • Use a custom text filter to show only rows where the expense category...
  • Use a slicer to filter the data in this table t show only rows where the Catergory...
  • The Anne Cole data point has been selected for you. Rotate..
In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button.
  • Create a new blank report that will open in Layout view.
  • Start a new query without using one of the query wizards.
  • Create a new blank form that will open in Layout view.
  • From Design view, apply the Medium Time format to the StartTime field.
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Property Sheet button.
  • Sort the Date column so the oldest dates are listed first.
  • From Design view, add a field validation rule to the AccountID field to require that values are less than 2000.
  • Create a Single Record form from the Classes table.
  • From Design view, display the Property Sheet for this form.
On the Data tab, in the Sort & Filter group, click the Advanced button. Enter A1:C2 in the Criteria range box. Click OK.
  • Insert the current date in the selected cell. Do not include the current time
  • Modify the Bonus field to use the MAX function instead of the SUM function.
  • Insert the current date and time in the selected cell
  • Filter the data in place so that only rows where the Category value is ...
Click the Table Tools Design tab. In the Tools group, click the Remove Duplicates button. Click OK. Click OK.
  • Display the data labels on this chart above the data markers.
  • Remove duplicate rows where data in all the columns are identical
  • Change the shape fill color to Green, Accent 6, Lighter 40%.
  • Add slicers to filter the data in this table by Date.
On the PivotTable Tools Analyze tab, in the Active Field group, click the Field Settings button. Select Max. Click OK.
  • Change the Field Size property for the RAStudentID field to 4.1/1
  • The 2019 data point in the Gross Profit data series has been selected...
  • Modify the Bonus field to use the MAX function instead of the SUM function.
  • Apply the present margin option that will add the least amount of white space around the edges of the printed page
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog, you clicked the Show all tables item. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you double-clicked the LastName list item.
  • Using the current view, insert a new Date/Time field named StartDate between the DegreeName and Status fields. Save the table when you are finished. 1/1
  • Add a new conditional formatting to the selected field to display data bars. Use the default data bars settings.
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
Type the formulas =SUM(B2:B6) in the cell or the formula bar and press Enter.
  • Insert a new row into the form layout above the TuitionPaid and GPA controls.
  • Sort this data by values in the Cost column so the most expensive item...
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
  • Enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6
You clicked the Credits field's criteria row, changed the Credits field's criteria to <90, clicked the credits field's or row, changed the credits field's or row to <90, clicked the Classification field's criteria row, changed the Classification field's criteria to Jr, clicked the classification field's or row, and changed the classification field's or row to Sr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Use the Search box to begin searching for a student with the last name beginning with Car.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
Click the Fill Handle tool in the selected cell and drag across to cell ERelease the mouse button.
  • Switch the view that shows all the worksheet elements as they will print, including headers and footers.
  • Resize the selected chart so it is approximately 11 rows tall.
  • Export this worksheet as a tab-delimited text file.
  • Use AutoFill to copy the formula and the formatting in cell E2 to cels E3:E6
On the Table Tools Design tab, in the table Style Options group, click the Total Row check box.
  • This worksheet is linked to an Access database. Update the worksheet..
  • Add a total row to this table
  • Display the Total row for this query.
  • Add a total row to this table and display the average for the Cost column..
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. In the application header, you clicked the Save button. Inside the Save As dialog, you typed Degrees in the Table Name: input, clicked the OK button.
  • Add the Status Quick Start fields to the right of the DegreeName field.
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
  • Add a new table in Design view.
  • Create a new table in Datasheet view. Save it with the name: Degrees
Type Justin Fine and press Enter. Type Jul and press Enter.
  • There is an error in cell D6. Accept Excel's suggestion for fixing the error.
  • Add markers for just the highest values in the Sparkline group.
  • Type Justin Fine in cell D2 and press Enter. Begin typing Julie...
  • From Design view, add a Command Button control to the form.
On the Chart Tools Format tab, in the Shape Styles group, click the Shape Outline button. Point to Dashes, and select the fourth dash style in the gallery. (Dash)
  • Change the Field Size property for the RAStudentID field to 4.1/1
  • Change the gridliness to use the Dash style.
  • Rename the ID field to: DegreeName
  • Change the shape outline color to Orange, Accent 2.
On the Data tab, in the Outline group, click the Group button arrow, and click Auto Outline.
  • Apply the Top and Bottom Border to the selected cells with a single command.
  • Modify the number format do no decimal places are visible after the decimal point.
  • The total row for each expense category uses a SUM function to total the costs...
  • Apply conditional formatting to the selected cells so cells with a value greater...
In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field Name menu, you clicked the DOB menu item. You clicked the from oldest to newest arrow, clicked the from oldest to newest arrow, clicked the DOB arrow, clicked the DOB arrow, clicked the DOB arrow, clicked the from oldest to newest arrow, and clicked the by quarter arrow. In the Sort By menu, you clicked the by year menu radio button.
  • Create automatic subtotals to sum the cost for each change in the Category...
  • From Layout view, group this report by values in the DOB field. Change the grouping to group by year instead of by quarter.
  • Apply conditional formatting to the selected cells so cells with a value greater...
  • Apply bold and italic formatting to the selected cell.
Double-click the right column boundary for column D.
  • Autofit column D to best fit the data
  • Center the content in the selected cells horizontally.
  • Modify the width of the CourseDescription column to best fit the data.
  • Use the Search box to begin searching for a student with the last name beginning with Car.
On the Home tab, in the Cells group, click the Insert button arrow and select Insert Sheet Column.
  • Insert a clustered column-line combination chart based on the selector...
  • Insert a column to the left of the selected cell.
  • Create a new blank report that will open in Layout view.
  • Insert the current date in the selected cell. Do not include the current time
In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Date and Time button. Inside the Date and Time dialog, you selected the 28-Apr-19 Radio Button, selected the 7:38 AM Radio Button, and clicked the OK button.
  • In cell G2, enter a formula using a counting function to count the number of blank cells in the received column G2:G11
  • From Layout view, add the date and time to the report header using the date format similar to 31-May-16 and the time format similar to 1:12 PM.
  • Modify this query so results are grouped by values in the DeptName field and values in the Credits field are summarized with the Sum function. Run the query.
  • Use the Field List pane to add the following fields to the report: From the Departments table, add the DeptName field. From the Faculty table, add the LastName and FirstName fields. Do not switch views.
You clicked the Course Tab Header, clicked the close table button.
  • Go to the first record
  • Close the Course table.
  • Add a new record to the table with the student ID 6412 and advance to the second field.
  • Open the Course table.
On the Formulas tab, in the Function Library group, click the Math & Trig button. Click ROUNDDOWN, In the Number argument box, type C2/CIn the Num_digits argument box, typeClick OK.
  • Enter a formula in cell D2 to calculate C2/C14 rounded down to 3 decimal places
  • Hide the formulas in this worksheet and display the values instead
  • Create a backup of the database. You do not need to change the backup location.
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
On the Home tab, in the Cells group, click the Format button. select Column width... Type 14, and click OK.
  • Change the font color of the selected cells to the Blue-Gray, Text 2 color.
  • Change the width of the selected columns to 14
  • Add a new worksheet to the left of the Dec. 18 sheet
  • Apply the Accounting Number Format to the selected cells.
You clicked the New Record Button. In the Access Table, you typed 6412, typed 6412 and pressed Tab.
  • Modify this query so the DeptCode field is hidden in the query results, and then run the query.
  • Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Add a new record to the table with the student ID 6412 and advance to the second field.
In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button, clicked the Short Text button. In the Access Table, you typed Description and pressed Enter.
  • Use a slicer to filter the data in this table to show only rows where the category...
  • Add a new Short Text field to the far right side of the table. Name the field: Description
  • Create a new blank report that will open in Layout view.
  • Set the Default Value property for the Classification field to Fr.
You clicked the Shutter Bar Open/Close button, clicked the Nav Pane Open/Close button. In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button. In the Access Table, you typed RA ID, clicked in the AutoNumber Cell, clicked the Drop-Down Button, clicked the AutoNumber Item, clicked in the Unique RA ID Cell, typed Unique RA ID, clicked the Field Size property box, and typed in the Field Size property box. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Primary Key button. In the application header, you clicked the Save button. Inside the Save As dialog, you typed Resident Advisors in the Table Name: input, clicked the OK button.
  • Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.
  • Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: Resident Advisors
  • Insert a new row into the form layout above the TuitionPaid and GPA controls.
  • Create a new blank desktop database named Accounting.
on the PivotTable Tools Analyze tab, in the Tools group, click the PivoChart button. Click Pie in the list of chart types at the left side of the Insert chart dialog. Click OK.
  • Insert the current date in the selected cell. Do not include the current time
  • Insert a PivotChart using the first pie chart type.
  • Insert the current date and time in the selected cell
  • Enter a formula in cell D2 to calculate C2/C14 rounded up to 3 decimal places.
On the Home tab, in the Font group, click the Boarders button arrow, and select More Borders... In the Format Cells dialog. Border tab, click the thickest line available in the style section. Expand the Color palette and select Blue, AccentIn the border section, click the button representing a bottom border.
  • Apply conditional Formatting to the selected cells so cells with the 10 items...
  • Add a Blue, Accent 5.. bottom border to the selected cells. Use the thickest single line style available
  • Apply the Top and Bottom Border to the selected cells with a single command.
  • Apply bold and italic formatting to the selected cell.
Click the Zoom In bottom on the zoom slider
  • Change the zoom level for the worksheet to be 110%
  • Use the spelling checker to find and change all instances of any misspelled words.
  • Move the selected chart to empty are of the worksheet...
  • Insert a Line chart based on the first recommended chart type.
On the Charts Tools Format tab, in the Current Selection group, click the Format Selection button to open the Format Data Point task pane. In the Angle of first slice box, type the 200 and press Enter.
  • Use a custom text filter to show only rows where the expense category...
  • The Anne Cole data point has been selected for you. Rotate..
  • Change the gridliness to use the Dash style.
  • Change the chart typw to the first stacked bar option..
On the Home tab, in the Cells group, click the Delete button arrow and select Delete
  • Apply the Top and Bottom Border to the selected cells with a single command.
  • Delete this row.
  • Apply the Accounting Number Format to the selected cells.
  • Change the width of the selected columns to 14
You clicked the Last Record Button.
  • Go to the next record.
  • Clear the print area
  • Go to the first record
  • Go to the last record.
In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Z to A menu item. In the Access Table, you clicked the arrow at the top of the Classification column. In the Table Column Filter Right-Click menu, you clicked the Sort A to Z menu item.
  • Sort the data so cells with the red down arrow icon in the Cost level...
  • Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out.
  • Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
  • Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, Classification, and Credits fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Tuition and view the query results.
Click the 2019 column in the Gross Profit data series once to select it. On the Chart Tools Format tab, Shape Styles group, click the Shape Outline button, and click Black, Text 1.
  • Sort the date first Alphabetically by the values in the Category column and then...
  • From Layout view, delete the conditional formatting rule for the selected field.
  • Switch to the view where you can see live data while modifying the report layout.
  • The Gross Profit data series is already selected. Select just the 2019 data point.
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.
  • Filter the data in place so that only rows where the Category value is ...
  • Insert the current date and time in the selected cell
  • Create a new table in Datasheet view. Save it with the name: Degrees
  • Preview how the results of this query will look when printed.
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Property Sheet button. You clicked the Allow Additions option. Inside the Property Sheet dialog in the Allow Additions drop-down, you selected No.
  • From Design view, modify this form's properties to not allow new records.
  • Use a custom text filter to show only rows where the expense category...
  • From Design view, modify the field properties to display the message Asset accounts must be in the 1000s when the field validation rule is violated.
  • Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in the Page Layout Ribbon Group, you clicked the Landscape button.
  • Preview how the results of this query will look when printed when the page orientation is changed to landscape.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Create a backup of the database. You do not need to change the backup location.
You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to [Enter Department Code]. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button. Inside the Enter Parameter Value dialog, you typed FIN in the Enter last name input, clicked the OK button. History
  • Create a parameter query where the user will enter a value to use as the criterion for the DeptCode field. Use the prompt Enter Department Code. Run the query using the Department Code FIN.
  • Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: Resident Advisors
  • Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.
  • Add criteria to this summary query to include only records where the value in the Days field is TTh. Do not include the Days field in the query groups. Run the query.
On the Insert tab, in the Charts group, click the Combo Chart button. Click the first chart type in the gallery.
  • Apply conditional formatting to the selected cells so cells with a value greater...
  • Insert a clustered column-line combination chart based on the selector...
  • Copy cell F3 , and paste to cell F2
  • Filter the Category column so only rows with Coffee are shown.
Type Asset account must be in the 1000s in the Validation Text box in the Field Properties pane. Press Enter
  • From Layout view, add automatic totals to the GPA column to calculate the average GPA.
  • Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
  • From Design view, modify the field properties to display the message Asset accounts must be in the 1000s when the field validation rule is violated.
  • From Layout view, add the date and time to the report header using the date format similar to 31-May-16 and the time format similar to 1:12 PM.
On the Home tab, in the Font group, click the Font Size arrow, and select 18.
  • Cut cell B7 and paste it to cell E12
  • Change font size for the selected cells to 18.
  • Apply conditional Formatting to the selected cells so cells with the 10 items...
  • Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
On the Formulas tab, in the Function Library group, click the More Functions button. Point to Statistics and Select COUNTBLANK from the list. Click and drag to select cells G2:GClick OK.
  • Enter a formula in cell B2 using VLOOKUP function to find the total sales for the date in cell B1.
  • In cell G2, enter a formula using a counting function to count the number of blank cells in the received column G2:G11
  • Insert the current date in the selected cell. Do not include the current time
  • Use the Create from the Selection command to create named ranges for the data table B8:E11 using the labels in row 1 as the basis for the names.
You opened the backstage view, clicked the Save As navigation button, clicked the Back Up Database button, and clicked the Save As button. Inside the Save As dialog, you clicked the Save button.
  • Create a backup of the database. You do not need to change the backup location.
  • The 2019 data point in the Gross Profit data series has been selected...
  • Modify the chart so the Owner Draw data series is plotted along the..
  • Enter a formula in cell D2 to calculate C2/C14 rounded to 3 decimal places.
On the Insert tab, in the Charts group, click the Insert Waterfall or Stock Chart button. Select Waterfall.
  • Insert a Waterfall chart based on cells A1:B10
  • Use a single command to clear everything from the selected cell.
  • Filter the Category column so only rows with Coffee are shown.
  • Insert a recommended PivotTable, using the SUM of Bonus by Employees...
In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Remove Sort button.
  • Insert the current date in the selected cell. Do not include the current time
  • Switch to the view where you can modify the structure of the report without viewing any live data.
  • Create a new blank form that will open in Layout view.
  • Clear the sorting from this table.
On the Formulas tab, in the Function Library group click the AutoSum arrow, and click Min. Press Enter.
  • Show the tracer arrows from the precedent cells to cell B5
  • In cell H12, enter a formula to find the lowest percentage of items of items received in the order.
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
  • Enter a formula in cell C2 to return a value of yes if the value in cell E8 is greater than or equal to value B2 or no if it is not.
On the Formulas tab, in the Function Library group, click the Math and Trig button. Click Round. In the Number argument box, typeClick OK.
  • Enter a formula in cell D2 to calculate C2/C14 rounded to 3 decimal places.
  • Sort the date first Alphabetically by the values in the Category column and then...
  • The 2019 data point in the Gross Profit data series has been selected...
  • Sort the data so cells with the red down arrow icon in the Cost level...
You opened the backstage view, clicked the New navigation button, clicked the Blank desktop database template, typed Accounting in the File Name box, and clicked the Create button.
  • Preview how this report will look when printed.
  • Create a Split form from the Classes table.
  • Create a new blank desktop database named Accounting.
  • Start a new query without using one of the query wizards.
You clicked the First Record Button.
  • Hide the chart title.
  • Go to record number 20.
  • Rename Sheet1: Dec 26
  • Go to the first record
On the Home tab, in the Cells group, click the Delete button arrow, select Delete Sheet. Click Delete.
  • Delete the Timesheets worksheet
  • Modify the number format do no decimal places are visible after the decimal point.
  • Filter the Category column so only rows with Coffee are shown.
  • Apply the Top and Bottom Border to the selected cells with a single command.
Click the 2 outlines symbol at the left of the column headings.
  • Create a new blank form that will open in Layout view.
  • Collapse the entire outline to show just the subtotals
  • Mov the selected chart to a new chart sheet
  • Apply the Style 7 Quick Style to the chart.
On the Data tab, in the Get & Transform Data group, click the From Text/CSV button. In the Import Data dialog, click StudentGPA, and click the Import button. Click the Load button.
  • Apply the light orange Pivot Style Medium 3 Quick Style...
  • Add a total row to this table and display the average for the Cost column..
  • From Design view, modify the form's property to restrict data entry to new records only.
  • Import data from the StudentGPA text file into a table in a new worksheet
On the Drawing Tools Format tab, in the Shape Styles group, click the Shape Fill button. Click Green, Accent 6, Lighter 40%
  • Create a new blank report that will open in Layout view.
  • Apply the Table Style Light 14 Quick Style...
  • The 2019 data point in the Gross Profit data series has been selected...
  • Change the shape fill color to Green, Accent 6, Lighter 40%.
In the Access Table, you clicked on DOB, clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Newest to Oldest menu item.
  • Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.
  • Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.
  • Rename the ID field to: DegreeName
  • Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.
On the Home tab, in Cells group, click the Insert button arrow, and select Insert Sheet.
  • Add a new worksheet to the left of the Dec. 18 sheet
  • Insert a sunburst chart based on the selected cells.
  • Use Format Painter to copy the formatting from cell D1 and apply it to cell E1
  • Copy cell F3 , and paste to cell F2
On the Formulas tab, in the Function Library group, click the Date & Time button. Click NOW Click OK.
  • Insert the current date and time in the selected cell
  • Insert the current date in the selected cell. Do not include the current time
  • Show the tracer arrows from the precedent cells to cell B5
  • Show the tracer arrow from cell B5 to the cell(s) that are dependent on it.
On the Header & Footer Tools Design tab, in the Header and Footer Elements group, click the Page Number button.
  • Change the shape fill color to Green, Accent 6, Lighter 40%.
  • Start a new query without using one of the query wizards.
  • The 2019 data point in the Gross Profit data series has been selected...
  • Add a footer that displays the page number in the center section.
On the Drawing tools Format tab, in the Shape Styles group, click the More button to display the gallery. Click the Colored Fill - Green, Accent 6 Quick Style.
  • Using the current view, delete the Major field from the table.
  • Filter the chart so the lines for Dr.Patella and John Patterson are hidden.
  • Use a slicer to filter the data in this table to show only rows where the category...
  • Apply the Colored Fill Green, Accent 6 Quick Styles to the shape...
Click the record selector to select the entire record. On the Home tab, in the Records group, click the Delete button. Click Yes
  • Refresh the PivotTable data
  • Clear the print area
  • Delete this student record.
  • Add slicers to filter the data in this table by Date.
In the Format Ribbon Tab in the Control Formatting Ribbon Group, you clicked the Conditional Formatting button. Inside the Conditional Formatting Rules Manager dialog, you clicked the New Rule... button. Inside the New Formatting Rule dialog in the Comparison Type drop-down, you selected greater than or equal to. Inside the New Formatting Rule dialog, you typed [RequiredCredits] in the Comparison Value input, clicked the Bold item, and clicked the Font color item. In the Color menu, you selected the Dark Blue color option. Inside the New Formatting Rule dialog, you clicked the OK button. Inside the Conditional Formatting Rules Manager dialog, you clicked the OK button.
  • From Layout view, create a new conditional formatting rule for the selected field. If the field value is greater than or equal to the value in the RequiredCredits field, apply bold, dark blue formatting. Dark blue is the second color from the right in the last row of the color palette.
  • Use the Field List pane to add the following fields to the report: From the Departments table, add the DeptName field. From the Faculty table, add the LastName and FirstName fields. Do not switch views.
  • From Layout view, delete the conditional formatting rule for the selected field.
  • From Design view, modify the field properties to display the message Asset accounts must be in the 1000s when the field validation rule is violated.
Click the File tab to open Backstage. Click Print. Click the Print Active Sheets button. Click Print Entire Workbook. Click the Print button.
  • Use the spelling checker to find and change all instances of any misspelled words.
  • Rename the ID field to: DegreeName
  • Print the entire workbook.
  • Filter the chart so the lines for Dr.Patella and John Patterson are hidden.
You changed the LastName field's criteria to Like "A*". In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
  • Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.
  • Preview how the results of this query will look when printed when the page orientation is changed to landscape.
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.
On the Page Layout tab, in the Page Setup group, click the Print Area button. Click Clear Print Area.
  • Modify the Bonus field to use the MAX function instead of the SUM function.
  • Set the print area so only the selected cells will print.
  • Filter the data in place so that only rows where the Category value is ...
  • Clear the print area
On the Data tab, in the Outline group, click the group button. In the Group dialog, Rows is selected by default. Click OK.
  • Convert the cell range to a table using style...
  • Apply bold and italic formatting to the selected cell.
  • Manually create groups of rows that can be expanded or collapsed.
  • Insert a column to the left of the selected cell.
On the Data tab, in the Outline group, click the Subtotal button. Expand the At each change in list and select Category. Click OK.
  • Insert a recommended PivotTable, using the SUM of Bonus by Employees...
  • Create automatic subtotals to sum the cost for each change in the Category...
  • Change the width of the selected columns to 14
  • Apply bold and italic formatting to the selected cell.
On the Chart Tools Format tab, in the WordArt Styles group, click the WordArt Quick Styles button to expand the gallery. Click the second style in the first row.
  • Filter the data in place so that only rows where the Category value is ...
  • The Anne Cole data point has been selected for you. Explode the Annie Cole..
  • The chart title is selected. Apply the Fill: Blue, Accent color 1...
  • Create a new table in Datasheet view. Save it with the name: Degrees
Click and drag the chart so it appears below the Total Salaries row.
  • Modify the Dec 18 worksheet so gridlines will print
  • Resize the selected chart so it is approximately 11 rows tall.
  • Use AutoFill to copy the formula and the formatting in cell E2 to cels E3:E6
  • Move the selected chart to empty are of the worksheet...
On the Formulas tab, in the Function Library group, click the Financial button, and click PMT. Enter B5/12 in the Rate argument box. Enter B6 in the Nper argument box. Enter -B4 in the Pv argument box. Click OK.
  • Enter a formula in cell C2 to return a value of yes if the value in cell E8 is greater than or equal to value B2 or no if it is not.
  • In cell C12, enter a formula using a counting function to count the number of items in the ..
  • Using cell references, enter a formula in cell B7 to calculate monthly payments for the loan described in this worksheet. Use a negative value for the Pv argument.
  • Use a custom text filter to show only rows where the expense category...
On the PivotTable Tools Analyze tab, in the Data group, click the Refresh button.
  • Insert a PivotChart using the first pie chart type.
  • Apply the Ion theme to the worksheet.
  • Refresh the PivotTable data
  • Modify the Dec 18 worksheet so gridlines will print
You clicked the Enable Content button.
  • Enable active content in this database.
  • Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.
  • Autofit column D to best fit the data
  • Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.
On the Home tab, in the Styles group, click the Conditional Formatting button. Point to Highlight Cell Rules, and click Greater than... Type 400 in the Format cells that are GREATER THAN box. Expand the format selector box and select Light Red Fill. Click OK.
  • Apply the Accounting Number Format to the selected cells.
  • Apply conditional formatting to the selected cells so cells with a value greater...
  • Insert a column to the left of the selected cell.
  • Apply conditional formatting to the selected cells using the red gradient...
On the Home tab, In editing group, click the AutoSum button. Press Enter.
  • Use AutoSum to enter a formula in the selected cell to calculate the sum.
  • The total row for each expense category uses a SUM function to total the costs...
  • Apply conditional formatting to the selected cells so cells with a value greater...
  • Insert a clustered column-line combination chart based on the selector...
In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Property Sheet button. You clicked the Data Entry option. Inside the Property Sheet dialog in the Data Entry drop-down, you clicked the Yes list item.
  • From Design view, modify this form's properties to not allow new records.
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
  • From Design view, modify the form's property to restrict data entry to new records only.
  • From Layout view, delete the conditional formatting rule for the selected field.
In the Database Tools Ribbon Tab in the Tools Ribbon Group, you clicked the Compact and Repair Database button.
  • Create a new relationship between the EmployeeID field in the Professor table and the Advisor field in the Student table. Ensure that values in the Advisor field have a corresponding value in the EmployeeID field.1/1
  • Run the Compact & Repair tool to optimize database efficiency by compacting unused space and deleting unnecessary temporary objects.
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
  • Modify the table relationships so that when a record is deleted in the Department table, the related records in the Professor table will also be deleted.
On the Page Layout tab, in the Page Set up group click the Breaks button. Click Insert Page Break.
  • Modify the Dec 18 worksheet so gridlines will print
  • In Cell H12, Enter a formula to find the highest percentage of items received in the ...
  • The 2019 data point in the Gross Profit data series has been selected...
  • From Page Break Preview view, insert a page break immediately above the selected cell.
Click the Page Layout button at the lower right corner of the status bar, to the left of the zoom slider.
  • Sort this data alphabetically from A-Z by values in the Category...
  • Cell F4 has been copied. Paste the formula only into the selected cell ( cell F5). Do not include the cell formatting.
  • Switch the view that shows all the worksheet elements as they will print, including headers and footers.
  • Set the print area so only the selected cells will print.
On the Home tab, in the Font group, click the Font Color arrow, and select Blue_Gray Text 2
  • Delete this row.
  • Change the font color of the selected cells to the Blue-Gray, Text 2 color.
  • Use a single command to clear everything from the selected cell.
  • Apply conditional formatting to the selected cells so cells with a value greater...
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button.
  • Add a total row to this table
  • Add a footer that displays the page number in the center section.
  • Add a new Short Text field to the far right side of the table. Name the field: Description
  • Add a new table in Design view.
In the External Data Ribbon Tab in the Import & Link Ribbon Group, you clicked the New Data Source button. In the New Data Source menu in the From File menu, you clicked the Excel menu item. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the Browse... button. You clicked Cell 2xInside the File Open dialog, you clicked the Open button. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the OK button. Inside the Import Spreadsheet Wizard dialog, you clicked the Next > button, checked the First Row Contains Column Headings check box, clicked the Next > button, clicked the Next > button, selected the Choose my own primary key. Radio Button, clicked the Next > button, and clicked the Finish button. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the Close button.
  • Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
  • Import all of the fields from the Assets worksheet in the Accounting Excel file to a new table. Use the first row as column headings. Do not change any field information. Use the AccountID field as the primary key. Accept the new table Assets. Do not save the import steps.
  • Create a new query in Design view using the following fields in this order: From the Students table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.
  • Modify the table relationships so that when a record is deleted in the Department table, the related records in the Professor table will also be deleted.
In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Logo button. You double-clicked the UniversityLogo item.
  • From Design view, apply the Medium Time format to the StartTime field.
  • Change the shape outline color to Orange, Accent 2.
  • From Design view, apply the Medium Time format to the StartTime field.1/1
  • Add the image UniversityLogo to the form header as a logo. Do not switch views.
Click the Review tab and click the Spelling button. click the Change All button. Click OK.
  • Resize the selected chart so it is approximately 11 rows tall.
  • Move Salaries worksheet so it is positioned before the working data worksheet
  • Use the Search box to begin searching for a student with the last name beginning with Car.
  • Use the spelling checker to find and change all instances of any misspelled words.
On the Sparkline Tools Design tab in the Group group, click the Clear button.
  • Create a new blank report that will open in Layout view.
  • Clear the selected Sparklines from the worksheet.
  • Delete the Description field.
  • Clear the print area
Click the Chart Tools Design tab. In the Chart Styles group, click the Change Colors button. Click the Monochromatic Palette 1, it is the first option in the Monochromatic section.
  • Change the chart typw to the first stacked bar option..
  • Clear the selected Sparklines from the worksheet.
  • Hide the column showing 2016 data and the bonus rate.
  • Apply the Monochromatic Palette 1 color scheme...
On the formulas tab, in the Functions Library group. click the Math & Trig button. Click SUMPRODUCT. In the Array1 Augment box, type SpecialPrice. In the Array2 argument box, type MembershipSold. Click OK.
  • Enter a formula in cell C2 to return a value of yes if the value in cell E8 is greater than or equal to value B2 or no if it is not.
  • Enter a formula in cell C3 using the SUMPRODUCT function to calculate the total value.... SpecialPrice... MembershipsSold
  • Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.
  • Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0