Computer Science Expert Answers & Study Resources

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Using a multiple-items form is easier than entering records directly into the table. 42) Following the rules of Normalization helps to ensure that your database performs as expected. 43) Proofreading data is critical to maintaining accuracy in.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) When you ________ a video, you delete parts of it to make it shorter. 62) Information organized in columns and rows on a slide is formatted in a(n) ________. 63) The intersection of a row and.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 81) The ________ Align command aligns text so that it is centered between the top and bottom of the cell. 82) The formula that displays in the Formula Bar is known as the ________ formula. 83) The.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 21) Within an Access table, each row is a field and each column is called a record. 22) After creating a new database from a Blank desktop database, Access opens a blank table named Table1. 23) In the.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Goal Seek is a what-if analysis tool. 42) A funnel chart is named that way because the values decrease gradually, allowing the bars to resemble a funnel. 43) A location chart compares values and shows categories across.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Which of the following is true about a pie chart? A) A pie chart should be your first choice when there are two data series to plot. B) It shows the relationship of each part to a.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) When setting the table relationships between two tables, the fields that are used to establish the relationship must have the same ________ and field size. 62) When setting the Relationship Options for a relationship.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Photographic images add interest and add impact to a presentation if done well. 42) Sizing handles display as small black squares that surround a selected image. 43) There is only one print option in PowerPoint—to print full.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) A column chart can use only one set of data to create the chart. 42) A chart legend identifies the colors or patterns assigned to each data series in a chart. 43) Each related data point is.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) Entering the actual records is known as ________ entry. 62) When a user clicks the Tab key to move to the next field within a form, it is the Tab ________ that determines the sequence.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 61) A synonym is a word that has the same or similar meaning to a word that you have selected. 62) When you open the Thesaurus pane in Word, it displays on the left side of the.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) In ________ view of a table, the data is not displayed, instead the structure of the table and its fields are displayed. 62) A user can query specific data from ________ or from other existing.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 61) When you crop a picture, you remove an unwanted or unnecessary portion of the image. 62) The crop pointer helps you select the unwanted or unnecessary areas of a picture. 63) When you recolor a picture, all.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) Which of the following is true about the Text Pane? A) The Text Pane displays on the right of a SmartArt graphic within which you can insert pictures. B) The Text Pane displays only when you select.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Auto Fill works only with alphabetic values. 42) Auto Fill generates and extends a series of values into adjacent cells in a worksheet. 43) The Quick Analysis tool displays in the lower right corner of a selected.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) When using a touchscreen, which of the following actions is the same as clicking an item? A) Press and hold for a few seconds B) Slide right C) Touch the item with two fingers D) Tap the item 2) Using.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Text Highlight Color is a Word command with which you can apply a highlight color to selected text. 42) Crop handles are used like sizing handles to define unwanted areas of the picture. 43) Sources in a.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) The IFS function checks only one condition. 42) The IFS function, unlike the IF function, returns the first FALSE condition. 43) Excel's Scale to Fit commands enable you to stretch or shrink the width, height, or both.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Once a user creates a form using the Form Wizard, the form cannot be edited. To create an editable form, a user should use the Form Design Method. 42) Users can select multiple controls to move.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) When you ________ data from Access to Excel a copy of the data is created in an Excel workbook. A) move B) import C) export D) transfer 2) To open an existing Access file, click Open Other Files and then.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 61) You can insert footers in worksheets and in chart sheets at the same time. 62) By clicking the border of an object, you select the entire object, not just a part of the object. 63) When a.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) Access creates a calculated control that is set to ________ any field that is formatted as currency when using the Report tool. A) Ave B) Count C) Sum D) Min 22) ________ order is the order in which the.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) A(n) ________ displays the relationship of each part of a whole. 62) A(n) ________ refers to a cell by its fixed position in a worksheet; the reference will not change when copied and pasted. 63) A(n).

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) In Access, when you add a new record by using a form, you must ________ to save the new record to the database. A) click submit B) do nothing (auto-saved) C) click save D) click update 22) In a Word.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Theme colors are not applied to which of the following? A) Objects B) Text C) Slide outlines D) Backgrounds 2) You can change the theme colors of a presentation from the ________ tab. A) Design B) Slide Show C) Home D) View 3) ________ is.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) A user can change the sort order of a query from the Datasheet View. 42) Query criteria is case sensitive and must match exactly to return the desired results. 43) Users can perform mathematical calculations on numbers.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) Which of the following is not considered a chart element? A) Legend B) Chart area C) Background D) Plot area 22) Which of the following is best to display trends over time? A) A line chart B) A column chart C) A pie.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) The values in parentheses in the SUM function (and other functions) are known as ________. 62) The ________ function checks whether one or more conditions are met, and then returns a value corresponding to the.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) AutoFill will fill a series when you establish a pattern ________. A) with two or more cells B) through the use of a formula C) through the use of a function D) with a minimum of three cells 22) Which.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) When you start PowerPoint 2019, what displays on the right side of the window? A) A list of all PowerPoint files on the hard drive B) A title slide for your presentation C) Recently-opened presentations D) Blank presentation and.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) It is helpful to look at the ________ row in the Query Design Grid in case a field may have the same name in multiple locations with different data in each. A) Field B) Show C) Table D) Criteria 22).

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) Which of the following is included in only some business letters, not necessarily all? A) Writer's signature block B) Subject line C) Inside address D) Salutation 22) Which of the following is always included in a business letter? A) Initials of.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 78) The ________ theme is listed first in the available themes. 79) The horizontal placement of text within a placeholder is referred to as ________. 80) On a black and white printer, colors in your presentation will.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) The ________ is the temporary storage location for cell contents copied from a worksheet. A) Excel table B) Clipboard C) Office Pane D) Paste area 22) If a sheet tab has ________ you know that it is not selected. A) a.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) A user can set the security and privacy settings on what is displayed in the Message Bar from the ________ within the options menu. A) General B) Client Settings C) Add-ins D) Trust Center 2) To connect two or more.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) ________ refers to changing the appearance of the text, layout, and design of a slide. A) Formatting B) Animating C) Enhancing D) Editing 22) A variant offers variations to which of the following? A) The theme style and animations B) The animation.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) A ________ is an organized collection of data. A) title slide for your warehouse B) database C) catalog D) server 2) Data that is accurate, timely, and organized in a useful manner is ________. A) enhanced data B) information C) knowledge D) metadata 3) A.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) Use the ________ key to more easily define a selection that may be difficult to select by dragging the mouse or touchpad. A) Alt B) F1 C) Shift D) Ctrl 22) What does a column break indicator look like? A) A.

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 61) If you have two monitors, you can take full advantage of the ________ view. 62) In Normal view, the left side of the screen displays miniature images called ________. 63) Increasing the list level of a.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Make sure to delete any merge field formatting marks before printing your document. 42) When you copy a chart from Excel to a PowerPoint slide, you can hide the background images for that slide so that.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 21) A defined set of formatting characteristics such as font, font size, and font color are known as a ________. A) cell style B) theme C) series D) label 22) Hold down the ________ key to select nonadjacent cells. A) Alt B) F2 C).

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. 81) The ________ principle of good database design is to use techniques that ensure the accuracy and consistency of data as it is entered into the table. 82) Making sure that everyone enters data in a.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) Skype enables you to present a Word document through a web browser. 42) While you are presenting in Office Presentation Service, you can make minor edits to the document. 43) When presenting a document online, you can.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 61) The purpose of the process graphic type is to show steps in a timeline. 62) The purpose of the cycle graphic type is to show a step by step process. 63) The purpose of the relationship graphic.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 41) You can only use one shape fill, outline color, or line weight; you cannot use them in combination. 42) The eyedropper lets you capture a color and use that color to create a more cohesive look.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 61) Selecting the range before you enter data saves time because it confines the movement of the active cell to the selected range. 62) The AutoCalculate feature displays three calculations by default: Sum, Subtraction, and Multiplication. 63) General.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Which of the following Excel features recognizes a pattern in the data of a worksheet? A) Flash Fill B) IF function C) COUNTIF function D) Find and Replace 2) What is the keyboard shortcut for Flash Fill? A) Ctrl + F2 B).

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Single record forms are helpful to users who ________. A) perform statistical calculations B) perform mass updates C) perform database changes D) perform data entry 2) In ________ view, you can change the arrangement of controls on a form. A) Preview B).

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Which of the following is one of the MLA standards for formatting text? A) 2" margins B) 0.75" first line indent C) Line spacing of 1.15 D) No extra space above or below paragraphs 2) A research paper using MLA.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) The font, color, and style of bullets in a presentation are determined by ________. A) the theme B) the variant C) the style D) PowerPoint artistic effects 2) Which of the following is false about the Bullets feature? A) Bullet style.