cisc 1050
Express cell reference E10 as an absolute reference: _____.
$
Assume you copied the range B13:F13. Now, you want to paste to B18:F18 using the option Values & Number Formatting: Open cell B18's shortcut menu. On the shortcut menu under Paste Options, point to _____1.______, which opens another menu (gallery). Last, under ____2.____ click Values & Number Formatting.
1.Paste specials 2.Paste Values
In Datasheet view, another name for a row is ___1.___, and another name for a column is ____2.___. (Activity 1.01: See the paragraph beginning with "Tables are the foundation")
1.record 2.field
In Query Design view in the Field row, you enter a calculated field: You type a name,_____, and finally an expression.
:
In Query Design view, you type 300 in a Criteria row under Amount (a numeric field). The assumed comparison operator (with respect to Amount and 300) is _____.
=
You created a filter for a form. In Form view, to clear the filter: On the Home tab in the Sort & Filter group, click _____, and then click Clear All Filters.
Advanced
_____displays ribbon labels called KeyTips.
Alt
To create a PivotChart report from a PivotTable report: on the _____ tab in the Tools group, click PivotChart, and then complete the dialog box.
Analyze
Type "1." and then click the Spacebar. If Word automatically starts a numbered list then Word will display the _____ Options button.
AutoCorrect
To stretch a narrow table fully between the left and right margins: on the Table Tools Layout tab in the Cell Size group click _____, and then in the menu click AutoFit Window.
AutoFit
To select three paragraphs: select the first paragraph then press the ____ key then select the second and third paragraphs and then release the pressed key.
CTRL
To select two or more adjacent ranges: select one or more cells as an adjacent range then press the _____ key then select one or more additional adjacent ranges and then release the pressed key.
CTRL
_____enters the current date in a selected cell.
CTRL ;
_____ invokes the Flash Fill command.
CTRL E
_____ makes cell A1 active (but not always).
CTRL+HOME
To apply "Colorful Range - Accent Colors 3 to 4" to a selected Process SmartArt graphic: on the SmartArt Tools Design tab in the SmartArt Styles groups click _____, and then click "Colorful Range - Accent Colors 3 to 4".
Change Colors
______ a picture removes unwanted or unnecessary areas of the picture.
Crop
_____displays Word's Navigation pane.
Ctrl f
_____displays Print Preview and Print (in one window).
Ctrl p
To display or hide some formatting marks (nonprinting characters): on the Home tab in the Paragraph group click____
Ctrl+*
_____selects all text of a textbox (or a document).
Ctrl+A
_____(three shortcuts) copies, pastes, and cuts, respectively.
Ctrl+C, Ctrl+P, Ctrl+X
_____centers (all the lines of) a selected paragraph.
Ctrl+E
_____moves the insertion point to the end of a document.
Ctrl+End
_____moves the insertion point to the beginning of a document.
Ctrl+Home
_____moves the insertion point to the left, one word at a time.
Ctrl+Left
____undoes the last command.
Ctrl+Z
For a data range, to create groups of rows (records) based on changes in the values in one column, and for each group find the sum for a (numeric) column of the group: select the range, then on the _____ tab in the Outline group, click Subtotal, and then complete the Subtotal dialog box.
Data
To create a Validation List for each cell of a selected range: On the _____ tab in the Data Tools group, click Data Validation, and then complete the Data Validation dialog box.
Data
To add Page Borders: on the _____ tab in the Page Background group click Page Borders and then complete the Page Border tab on the Borders and Shading dialog box.
Design
To apply a predesigned chart layout: select a chart, then on the Chart Tools _____ tab in the Chart Layouts group, open the Quick Layout gallery and click a layout option.
Design
To change the type of PivotChart from Clustered Column to Stacked Column: on the _____ tab in the Type group, click Change Chart Type, and then complete the dialog box.
Design
To convert a selected SmartArt to text: on the SmartArt Tools _____ tab in the Reset group, open the Convert menu and click Convert to Text.
Design
To display the Total Row of a selected table: on the _____ tab in the Table Style Options group, click Header Row.
Design
To move a selected floating chart to a new chart sheet: on the _____ tab in the Location group click Move Chart, and then complete the Move Chart dialog box.
Design
To remove all borders from some cells of a table: select the cells, on the Table Tools _____ tab in the Borders group click Borders, and then in the menu click No Border.
Design
To insert a File Name field into a footer at the insertion point: on the Header & Footer Tools Design tab in the Insert group click ____ and then click File Name.
Document info
To insert a text box approximately 1.5" high and 4" wide: on the Insert tab in the Text group click Text Box then (near the bottom of the menu) click ____ Text Box then position the pointer and drag.
Draw
You select three objects. To middle align the three objects relative to each other: on a ______ tab in the Arrange group, open the Align menu and if necessary click Align Selected Objects, and then open the Align menu again, and then click Align Middle.
Drawing Tools Format
To add both Category Name and Percentage data labels to a selected chart: begin by clicking the Chart _____ button on the right of the chart. End by completing the Format Data Labels pane.
Element
A cell contains a formula, which has a cell reference. To change the cell reference type to absolute: place the insertion point at the cell reference, and then use the _____ key.
F4
_____ is used to cycle through the four cell reference types ($A$1, A$1, $A1, A1).
F4
A form is in Layout view, and six controls are in a Stacked layout. You want to add the Student ID field to the form. First, you display the ______, and then drag the Student ID to the appropriate position on the Stacked layout.
Field List pane
Column C has a list of entries such as 13129-Oak. This column C entry is in row 11. Column D is empty except for one selected cell, which is also in row 11 and has the entry 13129. To use the Flash Fill command: on the Home tab in the Editing group open the ____ menu, and then click Flash Fill.
Fill
To create the series April May June in cells B3:D3, type April in cell B3 then click Enter on the formula bar and then drag B3's ______
Fill Handle
One way to enter a formula containing the PMT function in a selected cell (say B5): on the Formulas tab in the Function Library group click ______, then on the menu click PMT, and then complete the displayed Function Arguments dialog box.
Financial
To select all blank cells of a range: on the Home tab in the Editing group, click _____, then click Go To Special, and then complete the Go To Special dialog box.
Find & Select
To copy just the formatting of some selected formatted text: on the Home tab in the Clipboard group double-click _____.
Format Painter
To create a new table style: on the Home tab in the Styles group, click ______, then click New Table Style, and then complete the New Table Style dialog box.
Format as Table
One way to rotate the content of selected cells: display the Alignment tab of the _____ dialog box, and under Orientation specify the rotation, and then click OK.
Format cells
When you print a report, you do not want the data in a group to split across two pages. With the report in Layout view, on the Design tab in the Grouping & Totals group, click _____, and then complete the displayed pane.
Group & sort
To insert only slide numbers on all slides (including title slides): on the Insert tab in the Text group, click ______, then, if necessary, click the Slide tab, then select only Slide number, and then click Apply to All.
Header & Footer
In Datasheet view, you sort a table into ascending order. In Datasheet view to remove the sort: On the _____ tab in the Sort & Filter group, you click Remove Sort.
Home
To add space before a selected paragraph: on the _____ tab in the Paragraph group under "Spacing" use the Before control.
Home
To delete just the (applied) formatting of selected cells: on the _____ tab in the Editing group, open the Clear menu and click Clear Formats.
Home
To insert a new Panoramic Picture with Caption slide into a PowerPoint presentation: you select a slide, then on the ______ tab in the Slides group, open the New Slide menu, and click the layout.
Home
To insert a picture at the insertion point: on the Insert tab in the _____ group click Pictures and then complete the Insert Picture dialog box.
Illustrations
To create a group of Line Sparklines based on selected data cells: on the _____ tab in the Sparklines group click Line, and then complete the Create Sparklines dialog box.
Insert
To display a footer area: on the _____ Tab in the Header & Footer group click Footer and then click Edit Footer.
Insert
To insert the date (and time) with one of a number of available formats at the insertion point: on the Insert tab in the Text group click _____ Date & Time.
Insert
To filter a PivotTable using the Fire/Police field: on the Analyze tab in the Filter group, click _____, then click Fire/Police, and then click OK.
Insert Slicer
To merge two selected adjacent table cells, which are in the same row: on the Table Tools _____ tab in the Merge group click Merge Cells.
Layout
To change the text wrapping property of an object to Square: click the object then click _____, which appears next to the selected object, and then under "With Text Wrapping" click Square.
Layout Options
To double-space the lines of a selected paragraph: on the Home tab in the Paragraph group click ______ and then click 2.0.
Line and Paragraph spacing
One way to enter a formula containing the VLOOKUP function in a selected cell (say B9): on the Formulas tab in the Function Library group click _____, then on the menu click VLOOKUP, and then complete the displayed Function Arguments dialog box.
Lookup & Reference
To make cell A4 active: to the left of the formula bar, type A4 in the _____ and click the Enter key.
Name Box
If you decide to change the name of a defined name, you can use the _____.
Name Manager
In a PivotTable report, to specify 0 Decimal places and a 1000's separator: right-click a cell displaying a numeric value, then click _____, and then complete the Format Cells dialog box.
Number
One way to compute the monthly payment for a loan of $300,000, to be repaid in 3 years at a yearly interest rate of 4% is to use the _____ function.
PMT
To print a horizontally centered sheet, whose footer contains the sheet's file name, first: use the Page Layout tab to display the ______ dialog box. Then use the dialog box's Margins tab to specify a centered sheet and use the dialog box's Header/Footer tab to specify the footer.
Page Setup
To change a workbook's theme to Retrospect: on the _____ tab in the Themes group click Themes and then click Retrospect.
Page layout
To apply a border to one or more selected paragraphs: on the Home tab in the Paragraph group click Borders (menu) then click Borders and Shading and then complete the Borders tab of the Borders and Shading dialog box, being sure that ______ is displayed under Apply to.
Paragraph
To indent the first line of a selected paragraph: on the Home tab in the Paragraph group click the Dialog Box _____ then complete the two controls under "Special" and "By" on the Indents and Spacing tab of the Paragraph dialog box.
Paragraph Settings
When printing a worksheet, to have some column labels print on each following page: on the Layout tab in the Page Setup group click _____, and then complete the Sheet tab of the Page Setup dialog box.
Print Titles
To have Word automatically replace resumee with resume: open the Word Options dialog box then click the _____ tab then click AutoCorrect Options, and then complete the AutoCorrect tab of the AutoCorrect dialog box.
Proofing
To change the width of three selected boxes (Campus, Last Name, First Name) of a Report in Layout view: On the Design tab in the Tools group, click _____, and then change the Width property.
Property sheet
To insert slides from an existing presentation: on the Home tab in the Slides group, open the New Slide menu, then click _____, and complete the displayed pane.
Reuse Slides
To display the Spelling dialog box: on the _____ tab in the Proofing group click Spelling.
Review
To display the Tabs dialog box: double-click a tab marker on the horizontal _____.
Ruler
To indent the first line of a selected paragraph: on the horizontal _____ drag the First Line Indent marker.
Ruler
To insert text from a file at the insertion point: on the Insert tab in the Text group click Object (menu) then click_____and then complete the Insert File dialog box.
Text from file
A table has three columns: Style Code, Description, and Unit Price. Excel has a function that can compute a Unit Price given a Style Code (and at least two other arguments). The function would find a table row, and then return an answer. The function is _____.
VLOOKUP
In a PivotTable, rather than displaying Sums of numeric data, you want Averages: in the PivotTable, right-click any cell displaying the Sum of numeric data, then click _____, and then complete the dialog box.
Value Field Settings
To display Page Break Preview: on the _____ tab in the Workbook Views group, click Page Break Preview.
View
To split a particular worksheet into two separate parts (assuming A50 is the selected cell): on the _____ tab in the Window group, click Split.
View
Cell B2 contains a constant and cell B5 contains a formula: The formula depends on cell B2. To determine a value for B2, such that B5 will have the value 8000: On the Data tab in the Forecast group click _____, then on the displayed menu click Goal Seek, and then complete the displayed dialog box.
What if analysis
To create a Data Table for a selected appropriately filled range (say B7:I24): on the Data tab in the Forecast group, click _____, then on the displayed menu click Data Table, and then complete the displayed dialog box.
What if analysis
In a (3-D Clustered) column chart, to add a title to the Vertical (Value) Axis: on the Design tab in the Chart Layouts group, click ______, then point to Axis Titles, and then click Primary Vertical.
add char element
You want to use Filter By Form to display records for which City is equal to Dripping Springs: On the Home tab in the Sort & Filter group, click _____, then click Filter By Form, then complete the form, and then click Toggle Filter.
advanced
_____ inserts =SUM() into the selected active cell.
alt =
A form is in Layout view, and you selected six controls. You want to group the controls into a Stacked layout: On the _____ tab in the Table group, click Stacked.
arrange
In Query Design view, to use an aggregate function on each group of records and/or to divide the records into groups: begin by clicking ______, which in on the Design tab in the Show/Hide group.
arrow
In Query Design view in a criteria row: The wildcard character ______ represents (or matches) zero or more (the ebook has "one or more", which is an error) characters.
asterisk(*)
To apply the Title cell style to cell A1: select cell A1 then on the Home tab in the Styles group open the _____ menu and then click Title.
cell style
Excel displays a series of # symbols for a cell with an underlying numeric value. The reason may be _____.
cell width is too narrow
Two joined tables are joined by _____.
common field
To highlight selected cells that contain the text "Order": on the Home tab in the Styles group, click _____, point to Highlight Cell Rules and click Text That Contains, and then complete the Text That Contains dialog box.
conditional formatting
A ______ uses an aggregate function for data that can be grouped by two types of information, and displays the data in a compact, spreadsheet-like format with column headings and row heads.
crosstab query
To select a sentence: press the _____ key then click the sentence and then release the key.
ctrl
A numeric value referred to as a _____, is represented in a chart as a data marker.
data point
To save a document as a Word template: display the Save As dialog box. Open the Save as type menu and click ______, and note the folder in which Word will save your new template.
desktop
A principle of database design is to avoid redundant data. Redundant data means _____.
duplicate data does not occur
To save a workbook as a template file: display the Save As dialog box, then click Save as type, then click ______, then choose a folder, and then click Save.
excel template
A command that you can use to append data from an Excel workbook into an existing Access table is on the _____ tab.
external data
(Assume two tables are in a One-to-Many relationship.) The ______ is the general name of a field in the Related (or Many) table that connects to the primary key in the Primary (or One) table.
foreign key
In table Datasheet view, you can change the data type of an existing field:_____
formatting group
Cell C11 contains a formula that depends on cell C10, which contains a constant. To find a value for C10 such that C11 will equal 100,000,000: on the Data tab in the Forecast group open the What-If Analysis menu and click _____, which opens a dialog box. Last, complete the dialog box.
goal seek
To create a Process SmartArt Graphic: on the _____ tab in the Illustrations group, click SmartArt, and then complete the Choose a SmartArt Graphic dialog box.
insert
To create a table from a selected range: on the _____ tab in the Tables group click Table, and then complete the Create Table dialog box.
insert
To insert a 2×4 (2 columns by 4 rows) Word table at the insertion point: on the Insert tab in the Tables group click Table to display a menu. Under _____ in the fourth row of the grid, point to the second square and then click once.
insert table
In Query Design view, you want to create a query to locate records with an empty Credit field: In Query Design view in a Criteria row under Credit, you type_____.
is null
To specify custom margins: on the ____ tab in the Page Setup group click Margins then click Custom Margins and then in the Page Setup dialog box complete the Margins tab.
layout
A form is in Layout view, the Student ID text box is in a Stacked layout, and you want to change the width of the Student ID text box (and all the controls in the same column). With the Student ID text box selected: On the Design tab, click _____, and then complete the displayed pane.
property sheet
When you run a query, you want the Alumni Donation (a numeric field) to display without any decimal places. In Query Design view with Alumni Donation selected, on the Design tab in the Show/Hide group, click ______, and then set Decimal Places to 0.
property sheet
To hide columns E:G: select columns E:G, then _____ the selected columns, and then click Hide.
right click
A report is in Report Layout view, and you want to delete the Job ID column. First, click Job ID, then on the Arrange tab in the Rows & Columns group, click _____, and then click the Delete key.
select common
To explode exactly one slice of a 3-D Pie chart: display the Format ____ pane for the slice, and then complete the pane.
series
To insert a 1" by 1" Rounded Rectangle: on the Insert tab in the Illustrations group click ____ then under "Rectangles" click Rounded Rectangle and then position the pointer and click.
shapes
In a PivotTable report, to display all Major Crime records (in a separate report) right-click the cell displaying the total for the Major Crime records, and then click _____.
show details
To change a slide's layout to a Section Header layout: select the slide, then on the Home tab in the Slides group, click _____, and then click Section Header.
slide layout
______are the motion effects that occur in Slide Show view when you move from one slide to the next during a presentation.
slide transitions
The statistical COUNTIF function has two arguments, which are_____.
the range of cells to check and the criteria
(Assume two tables are in a One-to-Many relationship.) With the Cascade _____ option enabled: If you change the primary key value of a record in the Parent (or One) table, Access will automatically update the corresponding records in the Child "or Many" table.
update related fields
To display or hide the rulers: on the_____tab in the Show group click Ruler.
view
The logical IF function has three arguments, which are _____.
whether a condition is met, and returns one value if true and another value if false
