CGS1100

To have Excel enter the lowest price from a range of prices, which of the following would you use? Excel

ANSWER: A) *MIN function* B) COUNT function C) MAX function D) COUNTA function

Which of the following are animation categories? Select all the options that apply. PowerPoint

ANSWER: A) *Motion Paths* ANSWER: B) *Emphasis* ANSWER: C) *Entrance* ANSWER: D) *Exit*

Terry entered the word "teh" intentionally as a nonsense word, but AutoCorrect changed the word to "the". To change the word back to "teh", he should do which of the following? Select all that apply. Word

CORRECT: A) *Hover the cursor over the word, press the AutoCorrect icon, and then select the appropriate option.* CORRECT: B) *Press CTRL+Z*. C) Hover the cursor over the word, press the AutoCorrect icon, and then select the appropriate option. D) Press CTRL+Y.

A predesigned combination of formats, such as font size and color, is called a cell default.

FALSE

A query is a temporary view of the data that is removed when you close the query in Query Design view. (T/F) Final

FALSE

An animation that causes an object to appear on a slide after the slide appears during a slide show is an emphasis animation. (T/F) PowerPoint

FALSE

An object containing text on a slide is called a text placeholder. (T/F) PowerPoint

FALSE

Before you can rename a field, you must change its data type.

FALSE

Before you close a database, you must save any changes you made to the data. (T/F) Final

FALSE

Changing a worksheet window to Normal view changes the contents of the worksheet.

FALSE

Generate a works cited list to display the works cited and works consulted while creating a document. (T/F) Word

FALSE

If a data label, title, or legend in a chart is difficult to read, you can format them as bold, but you cannot change the font size. (T/F) Final

FALSE

If the volume of a video on a slide is too loud, you cannot change it, so you need to make sure you adjust the volume on you speakers. (T/F) Final

FALSE

If you link data to an Access database, you can edit the data in the original file, but not in the Access database.

FALSE

If you need to change the order in which animations on a slide occur, you must remove the animations, and then reapply them in the correct order. (T/F) PowerPoint

FALSE

If you want to align an object on a slide with the other objects on the slide, you should ignore the Smart Guides that appears as you drag the object. (T/F) Final

FALSE

If you want to export records to another Access database, create a Top Values query. (T/F) Access

FALSE

It is not necessary to look over a presentation for contextual errors if you use the Spelling command to check the spelling in a presentation. (T/F) Final

FALSE

It is not necessary to look over a presentation for contextual errors if you use the Spelling command to check the spelling in a presentation. (T/F) PowerPoint

FALSE

It's impossible to resize a shape to exact dimensions. (T/F) Final

FALSE

Jasmine needs an indent at the beginning of each paragraph in her document. The best way for her to achieve this is by entering eight spaces at the beginning of each paragraph. (T/F) Final

FALSE

Jordan consistently misspelled a name in a document. The most efficient way to correct his error is to manually locate each instance of the misspelled word, and then retype the word with the correct spelling. (T/F) Final

FALSE

Text that you delete by pressing DELETE or BACKSPACE is placed on the Clipboard. (T/F) Final

FALSE

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

FALSE

To change the background color of a cell, you use the Background color button. (T/F) Final

FALSE

To create a new page in a document, click the Multiple Pages button. (T/F) Final

FALSE

To display the data in a table, you open the table in Table Design view.

FALSE

To insert a picture from your desktop, click the Online Pictures button. (T/F) Final

FALSE

To move cell contents one space to the right, you can use the Increase Space button.

FALSE

To navigate to a record in a table, switch to Table Design view.

FALSE

To print worksheet contents across the length of a page, you can use portrait orientation. (T/F) Final

FALSE

To remove the spelling change indicator under a word, you must accept the suggested change. (T/F) Final

FALSE

To specify the location the cursor stops after the tab key is pressed, create a hanging indent (T/F) Final

FALSE

When you close a document, your work is automatically saved. (T/F) Final

FALSE

When you copy and paste a formula to a new location, the formula's relative references do not change.

FALSE

When you enter a record in a table, you are working in navigation mode.

FALSE

When you enter a value in a worksheet cell, it is automatically left-aligned.

FALSE

When you enter a value in a worksheet cell, it is automatically left-aligned. (T/F) Final

FALSE

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once. (T/F) Final

FALSE

When you use the Duplicate command to duplicate a shape, a copy of the shape is placed on the Clipboard. (T/F) Final

FALSE

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.

FALSE

You can use the I-beam pointer to copy cell contents into adjacent cells.

FALSE

You can use the I-beam pointer to copy cell contents into adjacent cells. (T/F) Final

FALSE

You cannot print more than one slide on a piece of paper. (T/F) Final

FALSE

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

A) =DCOUNTA(B1:B20) ANSWER: B) *=COUNTA(B1:B20)* C) =COUNTIF(B1:B20) D) =COUNT(B1:B20)

Nathan wants TRUE to be elicited if either of the statements are true, and FALSE if both are true. Which of the following formula can he use to ensure that? Final

A) =IFNA(...) ANSWER: B) *=XOR(...)* C) =TRUE OR FALSE(...) D) =IFERROR(...)

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed? Final

A) =OR(B2>=60, "Pass", "Fail") B) =AND(B2>=60, "Pass", "Fail") C) =NOT(OR((B2>=60, "Pass", "Fail")) ANSWER: D) *=IF(B2>=60, "Pass", "Fail")*

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

A) If it needs landscape orientation. B) If it needs a function. C) If it needs a relative cell reference. ANSWER: D) *If it needs an absolute cell reference.*

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

A) AND criteria B) parameter prompt C) sort order ANSWER: D) row headings

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?

A) Advanced ANSWER: B) *Formulas* C) Proofing D) Language

Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?

A) Border B) Shape ANSWER: C) *Style* D) Color

Which of the following functions would you use to calculate the arithmetic mean of a price list?

A) COUNT ANSWER: B) *AVERAGE C) SUM D) MAX

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database. Access

A) Caption ANSWER: B) *Validation Text* C) Validation Error D) Format

To change the color of cell content, you use the ________ color list arrow.

A) Cell ANSWER: B) Font C) Text D) Pattern

Which of the following are examples of changing a table's design? Select all the options that apply.

A) Change a field value. ANSWER: B) *Rename a field in the table.* ANSWER: C) *Change a field's data type.* ANSWER: D) *Add a field to the table.*

How can you list the records in a query datasheet in A-Z order by CustomerName?

A) Click a value in the CustomerName field, and then click the Descending button. B) Click the Advanced button, and then click Filter By Form. ANSWER: C) *Click a value in the CustomerName field, and then click the Ascending button.* D) Click the CustomerName column heading.

What should you do when you are finished working a database?

A) Close the Navigation Pane. B) Open and then save each object in the database. C) Sign out so other people can use the database. ANSWER: D) *Close the database.*

_____ connects an Access database to data in an external file, such as an Excel spreadsheet or Outlook folder, but does not copy the data into the database.

A) Exporting B) Importing ANSWER: C) *Linking* D) Relating

Where can you see a preview of how your worksheet will look when printed, including headers?

A) File preview B) Page Break preview ANSWER: C) *Print tab in Backstage view* D) Normal view

To see a preview of how a pasted value will look, which of the following would you use?

A) Fill button B) AutoFill Options button C) Paste button ANSWER: D) *Paste List arrow*

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

A) Format the range as a table. B) Delete the conditional formatting rule. ANSWER: C) *Edit the conditional formatting rule.* D) Format the range in the Font dialog box.

In the formula =A8*$A$1, which of the following describes A8?

A) Function B) AutoSum C) Absolute cell reference ANSWER: D) *Relative cell reference*

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

A) Home ANSWER: B) *Page Layout* C) View D) Insert

What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?

ANSWER: A) *Formulas* B) Proofing C) Advanced D) Language

Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

A) Inside End ANSWER: B) *Data Callout* C) Outside End D) Best Fit

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

A) Page Layout view B) Print Preview ANSWER: C) *Page Break Preview* D) Normal view

To format a range so that all values greater than $500 appear in red, which of the following can you use?

A) Quick Access toolbar B) cell styles ANSWER: C) *conditional formatting* D) cell formatting

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

A) Quick Analysis tools ANSWER: B) *Flash fill* C) What-if analysis D) Business Intelligence

If users must enter data in a LastName field, what property should you set for the field?

A) Referential Integrity ANSWER: B) *Required* C) Indexed D) Short Text

Run the steps in a saved export using the _____ button on the External Data tab.

A) Synchronize ANSWER: B) *Saved Exports* C) Rerun D) More

The Clipboard task pane shows the contents of the _____.

A) Table Styles gallery B) Recently-Used Add-Ins C) Quick Analysis tool ANSWER: D) Office Clipboard

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

A) The Auto Fill Options button appears. B) Pointing to the destination cell causes a preview of the cell contents to appear. C) The formula is copied with cell references you must adjust to avoid worksheet errors. ANSWER: D) *The Paste Options button then lets you paste specific elements of the copied cells.*

In a datasheet, which mode do you use for changing the value of a field? Access

A) Update mode B) Navigation mode C) Modify mode ANSWER: D) *Edit mode*

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

A) Worksheet window B) Name box ANSWER: C) *Clipboard* D) Backstage

Which of the following is true about moving cell contents?

A) You cannot move cells from one worksheet to another. B) When you move cell contents, they remain in their original location. ANSWER: C) *You can move cells using the drag-and-drop feature* D) You can move cells using the Copy command.

Which of the following is true about entering a function using the Insert Function dialog box?

A) You open the dialog box by typing "function" in the formula bar. ANSWER: B) *You don't need to type an equal sign to begin the formula.* ANSWER: C) *You can select a function you've recently used.* ANSWER: D) *You can search for a function that meets your needs.*

The fields and data types in an Append query must _____.

A) be different from the fields and data types in the target table B) *match the fields and data types in the target table* C) be identical D) be different from one another

To remove filter criteria from the Filter by Form grid, you _____. Access

A) click the Filter by Form button, and then click Clear B) click the Toggle Filter button C) open a new form ANSWER: D) *click the Advanced button, and then click Clear All Filters*

Each row in a table datasheet displays a _____.

A) data type B) field C) property ANSWER: D) record

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

A) ort orders B) listings C) layouts ANSWER: D) criteria

The _____ key field is the linking field on the "many" side of the relationship.

A) primary B) referential ANSWER: C) *foreign* D) AutoNumber

Which process is most like copying and pasting?

A) relating B) querying C) linking ANSWER: D) *importing*

A category of data such as a customer's name, city, state, or phone number is called a _____.

A) table B) data type C) record ANSWER: D) *field*

If you want to manage lists of data about customers and the products they order, use _____ software.

A) tabular B) communication ANSWER: C) relational database D) spreadsheet

An Access query can be the _____ for a mail merge in Word.

A) template B) merge field source C) main document ANSWER: D) *data source*

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

A) three B) four C) one ANSWER: D) *two*

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

A)A one-to-many relationship B) A common field ANSWER: C) *Referential integrity* D) Data redundancy

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59. Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B? Final

ANSWER: A) *=IF(B2<60,"F",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90,"B","A"))))* B) =IF(B2=0-59,"F",IF(B2=60-69,"D",IF(B2=70-79,"C",IF(B2=80-89,"B",IF(B2=90-100,"A")))) C) =IF(B2<59,"F",IF(B2<69,"D",IF(B2<79,"C",IF(B2<89,"B","A")))) D) =IF(B2</=59,"F",IF(B2</=69,"D",IF(B2</=79,"C",IF(B2</=89,"B", IF(B2</=100"A"))))

You can import Access table data from which of the following Office apps? Select all the options that apply.

ANSWER: A) *Access* ANSWER B) *Excel* C) PowerPoint ANSWER D) *Outlook*

When you double-click a cell's right column border, which of the following occurs?

ANSWER: A) *AutoFit resizes the column to the widest cell entry.* B) The column is deleted. C) A column is added to the right of the column's border. D) AutoFit resizes the column to 8.43 characters wide.

Which data type is used for sequential integers controlled by Access?

ANSWER: A) *AutoNumber* B) Number C) Integer D) SeqNumber

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

ANSWER: A) *CTRL* B) ALT C) ESC D) SHIFT

Which of the following lets you edit the contents of a cell?

ANSWER: A) *Double-click the cell or click in the formula bar.* B) Click the cell, click the status bar, and press Enter. C) Click the cell and click in the status bar. D) Double-click the cell, click in the status bar, or just start typing.

Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?

ANSWER: A) *F9* B) F10 C) F5 D) F12

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

ANSWER: A) *Row Heading* ANSWER: B) *Column heading* C) Sort Order ANSWER: D) *Value*

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

ANSWER: A) *The formula =SUM(B6:B10)* B) The formula +SUM(B6-B10) C) The formula =B6+B7+B8+B9+B10. D) The formula =TOTAL(B6-B10)

Which of the following statements are true about field properties? Select all the options that apply. Access

ANSWER: A) *The properties can be used to change the way data is displayed.* ANSWER: B) *Modifying the properties helps ensure database accuracy.* ANSWER: C) *Some properties are required, and some are optional.* D) The properties are the same for each data type.

How can you remove data labels from a chart?

ANSWER: A) *Uncheck the box beside Data Labels in Chart Elements.* B) Click to select the Data labels, then click on Edit and then Delete. C) Click on Remove on the options on the right side of Data Labels. D) Click on Delete on the options on the right side of Data Labels.

When should you use relative cell references?

ANSWER: A) *When you want to preserve the relationship to the formula location.* B) When you want to preserve the exact cell address in a formula. C) When you want to insert a function. D) When you want to enter sequential values in a range of cells.

Which of the following does the Accessibility Checker look for? Select all the options that apply.

ANSWER: A) *Worksheets with default names.* B) Worksheets with calculation errors. ANSWER: C) *Images without alternative text.* ANSWER: D) *Hyperlinks without alternative text.*

To export query data to Excel, you _____.

ANSWER: A) *click the External Data tab, and then click the Excel button in the Export group* B) select Excel as the destination when you run the query C) click the Create tab, and then click the Excel Query button in the Queries group D) save the query as an XLSX file

What are you saving when you click the Save button to save a table object?

ANSWER: A) *the table design* B) the records in the table C) the entire database D) the field values in the table

If you select 25 in the Top Values list, Access displays _____ in the query results.

ANSWER: A) *the top 25 records* B) 25 fields C) 25 randomly selected records D) the top 25% of the records

What is the difference between entering a record using a form and entering a record using a datasheet?

ANSWER: A) A form presents records one at a time, while a datasheet lists all records. B) A form cannot be sorted, while a datasheet can. C) A form uses a different navigation bar from the one in a datasheet. D) A form displays field names and record data, while a datasheet does not.

Which of the following options are available to you when you start Access? Select all the options that apply.

ANSWER: A) Create a database from a template. ANSWER: B) Open an existing database. C) Import an existing database. ANSWER: D) Create a new blank database.

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

ANSWER: A) To paste the value's number formatting only. B) To compute the results of a function. C) To paste all items on the clipboard. D) To erase the cell value from the clipboard.

In the formula =SUM(A6:A9), which of the following best describes A6?

ANSWER: A) argument B) active cell C) function D) label

A chart title summarizes the data shown in the chart. (T/F) Final

TRUE

A new blank desktop database includes one table named Table1.

TRUE

A new blank desktop database includes one table named Table1. (T/F) Final

TRUE

A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.

TRUE

An Append query adds selected records to an existing table.

TRUE

Currency is an example of a number format. (T/F) Final

TRUE

Delete queries delete entire records, not just selected fields within records. (T/F) Access

TRUE

Exporting is the opposite of importing.

TRUE

In order to format all the text in a text box at the same time, you must select the text box first. (T/F) Final

TRUE

Jasmine needs a double underline to appear beneath a word. She should change the underline style. (T/F) Final

TRUE

Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, 2/2/2000 will appear in AI5. (T/F) Final

TRUE

Pressing DELETE removes the character after the insertion point. (T/F) Final

TRUE

Shauna is preparing a newsletter that will be widely distributed. While checking the document for spelling and grammar errors, she notices that she consistently misspelled the word "disappear". She can correct all instances of the misspelled word by selecting Change All in the Spelling pane. (T/F) Final

TRUE

Sherri is trying to remember the word "tremendous". She knows "excellent" is similar to the word she's trying to remember. To help her remember, she can enter the word "excellent" in the document and then search for synonyms using the Thesaurus button in the Proofing group of the Review tab. (T/F) Final

TRUE

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

TRUE

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane. (T/F) Final

TRUE

To add, delete, or change fields in a query, you use Query Design view.

TRUE

To add, delete, or change fields in a query, you use Query Design view. (T/F) Final

TRUE

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

TRUE

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

TRUE

To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.

TRUE

To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER. (T/F) Final

TRUE

To make your workbooks usable by people with disabilities, you can add alternative text to worksheet images.

TRUE

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

TRUE

To provide emphasis to text, you can apply bold. (T/F) Final

TRUE

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button. (T/F) Final

TRUE

To right-justify text at a tab stop, change the tab stop alignment options. (T/F) Final

TRUE

Use the Tell Me box in the ribbon to perform a desired action in Word, such as increasing the font size. (T/F) Final

TRUE

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion. (T/F) Final

TRUE

When a presentation includes slide numbers on all of the slides, it is often appropriate to prevent the slide number from appearing on the title slide. (T/F) Final

TRUE

When you export a query to use in Word, Access creates a Rich Text Format (RTF) file.

TRUE

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

TRUE

You can apply date formats to cells by using the Date category in the Format Cells dialog box. (T/F) Final

TRUE

You can apply special effects, such as a shadow, a glow, a reflection, or a 3-D effect, to text. (T/F) Final

TRUE

You can create a new presentation when PowerPoint is running. (T/F) Final

TRUE

You can insert columns and rows into an existing table. (T/F) Final

TRUE

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop. (T/F) Final

TRUE

You can use Page Width view to resize a document to fit the width of the window. (T/F) Final

TRUE

You can use the DELETE key to clear cell contents. (T/F) Final

TRUE

You enter and edit data in a query datasheet in the same way you do in a table datasheet. (T/F) Final

TRUE

You must select the text or the text box before you change the font. (T/F) Final

TRUE

If you have already named and saved your presentation at least once, what happens when you click the Save button on the Quick Access Toolbar? PowerPoint

A) A dialog box opens asking where you would like to save the file. ANSWER: B) *The changes you made since the last time you saved the file are saved.* C) The Save As screen in Backstage view appears. D) Nothing happens because you need to click the Save button twice.

Anusha wants to use her computer, rather than handwriting the information on her notepad, to analyze her monthly expenses to make the job easier. Which of the following apps should she use? Word

A) A personal interest app to keep a track of all the expenses based on her personal interests B) A device management app to track all the expenses she makes using her credit and debit cards ANSWER: C) *A spreadsheet app to keep a record of her expenses, sort data, and make calculations* D) A word processor app to keep a record of her expenses and make calculations

Tiana wants a line to appear around a paragraph. She should do which of the following? Word

A) Apply a text effect. B) Apply a character style. ANSWER: C) *Add a paragraph border.* D) Add paragraph shading.

Imani needs to duplicate a picture in her document. She should do which of the following? Word

A) Change the picture. B) Reset the picture. ANSWER: C) *Copy and paste the picture.* D) Rotate the picture.

Aniyah needs to insert the date and time in her document. She should do which of the following? Word

A) Click the Cross-reference button. ANSWER: B) *Click the Insert Date and Time button and select the desired option.* C) Click the Link button and select the desired option. D) Click the Table button and select the desired option.

Andrew's company uses a special email program for communicating within the organization. What should the company do to ensure that its employees are able to access the inbox even when they are away from office? Word

A) Design a new e-mail program. B) Use a generic e-mail software like Gmail. C) Have a mobile app developed. ANSWER: D) Make the program available as a web app. ((Web apps run in browsers and their files are stored on the cloud. Users can access them from anywhere on any device that has a web browser.))

To prevent the last line of a paragraph from being separated from the rest of the paragraph as a result of flowing onto another page, which of the following should be done? Word

A) Enable the page break before option. B) Enable the don't hyphenate option. C) Enable the keep with next option. ANSWER: D) *Enable the widow and orphan control option.*

Amy needs to prevent the last line of a paragraph from being separated from the rest of the paragraph as a result of flowing onto another page. She should do which of the following after selecting the paragraph? Word

A) Enable the page break before option. B) Enable the keep with next option. ANSWER: C) *Enable the widow and orphan control option.* D) Enable the don't hyphenate option.

If you think you might want to show your audience a webpage during your presentation, which of the following should you include on a slide? PowerPoint

A) Hyperlink to another slide in the presentation B) Screenshot of the web page as it looked on the day you created the presentation C) Shape with the name of the web page in it ANSWER: D) *Hyperlink to the web page*

David Trueheart's last name is marked as misspelled on slides in his presentation. His name appears on several slides. When he uses the Spelling command and his last name appears in the Spelling pane, which of the following commands is the best choice for resolving this? PowerPoint

A) Ignore B) Change All C) Change ANSWER: D) *Ignore All*

Surya's computer monitor display does not seem to work despite repeated attempts to fix the issue. Which of the following is most likely to be causing display problems? Word

A) Improperly connected keyboard B) Power fluctuation ANSWER: C) *Faulty power or video cable* ((The power/video cables and the video card are directly responsible for any issue with the monitor.)) D) Dysfunctional UPS

To start entering text on a new page, do which of the following? Word

A) Insert a continuous section break. B) Insert a line break. ANSWER: C) *Insert a page break.* D) Insert a column break.

SmartArt consists of the graphic and which of the following? PowerPoint

A) Layout pane B) Style pane C) Shape pane ANSWER: D) *Text pane*

Aliya needs her footnotes to be listed as I, II, III... instead of as 1,2,3... She should do which of the following to achieve this? Word

A) Leave the numbering as is. Word does not support Roman numeral numbering in footnotes. B) Manually replace the footnote numbering as needed. ANSWER: C) *Change the Number Format in the Footnote and Endnote dialogue box.*

If you want to add a note to a slide to remind you to mention a fact that is related to the slide, where do you place the note? PowerPoint

A) Normal pane B) Thumbnails pane C) Reading pane ANSWER: D) *Notes pane*

Which of the following factors can affect processor performance of a CPU? Word

A) Number of peripheral devices connected B) Benchmark C) Hard drive space ANSWER: D) *Clock speed* ((Clock speed is the measure of speed at which the processor executes instructions. Bus width determines the speed at which data travels. These two factors impact the CPU performance.))

A slide in Olivia's presentation has the Title and Content layout applied. The bulleted list on the slide contains 14 items and each item is only one or two words, so Olivia thinks the Two Content layout would work better than the Title and Content layout. How does she change the slide's layout? PowerPoint

A) On the Insert tab, click the New Layout button. ANSWER: B) *On the Home tab, click the Layout button, and then click Two Content.* C) On the Home tab, click the New Slide button arrow, and then click Two Content. D) On the Home tab, click the Reset button.

If you want to add the date to every slide in the presentation and you want the date to update to show the current date every time the presentation is opened, which of the following actions would you take? PowerPoint

A) Open the Header and Footer dialog box, click the Slide tab, click the Date and time checkbox, and then click the Fixed option button. B) Type the date in a placeholder on every slide. C) Type the date on the title slide so that it appears on all of the slides. ANSWER: D) *Open the Header and Footer dialog box, click the Slide tab, click the Date and time checkbox, and then click the Update automatically option button.*

Which of the following refers to a printed line that surrounds the outer part of a page? Word

A) Page Margin B) Page Boundary ANSWER: C) *Page Border* D) Page Edge

Remus is an art student who wants to start creating digital artwork on his computer. He wants to be able to create images that retain their quality in all sizes. Which type of app should he use? Word

A) Photo editing app ANSWER: B) *Drawing app* ((Drawing apps let you create vector graphics that can be modified and resized without losing on image quality.)) C) Video editing app D) Paint app

Rafael has to type a report about a class trip to the museum. Which of the following apps should he use to write the report? Word

A) Presentation B) Messaging C) Spreadsheet ANSWER: D) *Word processor* ((Word processing software is used to create documents and reports.))

Which of the following methods causes the next slide to be displayed during a slide show? Select all the options that apply. PowerPoint

A) Press ESC. ANSWER: B) *Press SPACEBAR.* ANSWER: C) *Click the left mouse button.* D) Click the right mouse button.

To remove space after a paragraph, do which of the following? Word

A) Press the Decrease Indent button. ANSWER: B) Press the Line and Paragraph Spacing button and then select Remove Space After Paragraph. C) Delete the last line of text in the paragraph. D) Press the Justify button.

Shane is reading through a document that has comments from his editor. He needs to respond to one of the comments. He should do which of the following? Word

A) Resolve the comment. ANSWER: B) *Reply to the comment.* C) Delete the comment.

Lab accidentally deleted a shape from a SmartArt graphic. Which of the following commands will put the shape back on his slide? PowerPoint

A) Reverse B) Redo ANSWER: C) *Undo* D) Exit

Which of the following can you drag to reposition on a slide? PowerPoint

A) Ruler B) Smart Guides ANSWER: C) *Guides* D) Gridlines

Pierre has entered marks obtained by the students in all the classes he teaches in a spreadsheet. Now he wants to highlight some data according to his specifications. Which spreadsheet feature should he use? Word

A) Run macros B) Sorting and filtering ANSWER: C) *Conditional formatting* ((Conditional formatting is used to highlight cells that meet the specified criteria.)) D) What-if analysis

Which key or keys do you press to change a second-level item in a list to a first-level item? PowerPoint

A) SHIFT B) SPACEBAR C) TAB ANSWER: D) *SHIFT+TAB*

Gabrielle accidentally deleted several paragraphs in her document. To restore her work, she should do which of the following? Word

A) Save the document, close it, and then reopen it. ANSWER: B) *Recover unsaved changes using the Info screen of the File tab.* C) Inspect the document. D) Retype the missing paragraphs.

If you want to change the fill color of a shape, what must you do first? PowerPoint

A) Select the slide thumbnail. B) Move the pointer on top of the shape. ANSWER: C) *Select the shape.* D) Press and hold ESC.

Which of the following should Tim use to italicize text? Word

A) Select the text that needs to be italicized, press the Format Painter button in the Clipboard group of the Home tab, then select some italicized text in the document. ANSWER: B) *Select some italicized text in the document, press the Format Painter button, then select the text to be italicized.* C) Select the text to be italicized, then press the Text Effects button in the Font group of the Home tab. D) Press the Format Painter button in the Clipboard group of the Home tab, press the Italic button in the Font group of the Home tab, then select the text that needs to be italicized.

Jia needs to change the order in which objects on a slide in her presentation animate. Which of the following is the best method to do this? PowerPoint

A) She can change the effect options of each animation. B) After selecting an object with an animation applied to it, she can drag the object before or after the other objects on the slide. C) She can change the duration of each animation. ANSWER: D) *After selecting an object with an animation applied to it, she can click the Move Earlier or Move Later button on the Animations tab.*

Which of the following contains text you type and that appears on all the slides in the presentation? PowerPoint

A) Slide number ANSWER: B) *Footer* C) Header D) Date and time

If a photo on a slide looks somewhat blurry and out of focus, what action can you take to fix this? PowerPoint

A) Soften the photo. B) Change the tone. C) Change the saturation. ANSWER: D) *Sharpen the photo.*

Which slide usually does not require the slide number, date, and footer text on it? PowerPoint

A) Summary slide B) Title of contents slide ANSWER: C) *Title slide* D) Definitions slide

If you want to shade every other row in a PowerPoint table, which of the following options do you select on the Table Tools Design tab? PowerPoint

A) Total row ANSWER: B) *Banded rows* C) Colored rows D) Header row

Katlyn needs to remove all tab characters from a document. She should locate the tab characters by doing which of the following? Word

A) Use Go To to locate the desired text. ANSWER: B) *Use the Find and Replace dialogue box to locate the tab characters.* C) Manually locate tab characters by scrolling through the document.

Jaylen needs a shape in her document to have the same formatting as another shape in her document. She should do which of the following? Word

A) Use the Tell Me box. B) Use Smart Lookup. ANSWER C) *Use the Formatting Painter.* D) Use the Clipboard.

Where on a computer is the operating system generally stored? Word

A) Virtual memory B) RAM ANSWER: C) *Internal hard drive* ((Internal hard drives can store data for an extended period of time. The OS is stored on this to be accessed by ROM.)) D) Flash drive

Which type of chart compares values over a period of time? Select all the options that apply. PowerPoint

A) X Y (Scatter) ANSWER: B) *Line* ANSWER: C) *Column* D) Pie

Which type of chart shows values as a percentage of the whole? PowerPoint

A) X Y (Scatter) B) Line C) Column ANSWER: D) *Pie*

Jennifer turns on her laptop and hears a series of beeps. What do they probably indicate? Word

A) low battery B) out-of-date device driver ANSWER: C) *internal hardware problem* ((When computers run low on available hard drive space, performance can quickly deteriorate.)) D) operating system error

To move a slide in Normal view, what do you drag in the pane on the left? PowerPoint

A) the slide tab B) the slide number ANSWER: C) *the slide thumbnail* D) the slide title

Which of the following is a series of data points on a line that represents the general direction in a series of data? PowerPoint

A)Data table B) Gridline C) Line chart ANSWER: D) *Trendline*

When you add a picture to a slide background, which of the following actions can you take to modify the image? PowerPoint

ANSWER: A) *Change the brightness and contrast.* ANSWER: B) *Change the tone and saturation.* answer? C) Change the dimensions. ANSWER: D) *Change the transparency.*

To resize a shape nonproportionally, which of the following should be done? Word

ANSWER: A) *Click and drag a middle sizing handle.* B) Select the Lock aspect ratio check box and then enter values. C) Click and drag the corner sizing handle. D) ALT+SHIFT-Click and drag the corner sizing handle.

Cameron needs to brighten and increase the contrast of a picture. He should do which of the following? Word

ANSWER: A) *Click the Corrections button and select the desired option.* B ) Click the Artistic Effects button and select the desired option. C) Click the Change Picture button and select the desired option. D) Click the Color button and select the desired option.

Which of the following is not one of the ways you can switch from one slide to another in Normal view? PowerPoint

ANSWER: A) *Click the View tab, and then click the button that corresponds to the slide number you want to switch to.* B) Click the Previous Slide button at the bottom of the vertical scroll bar. C) Click the thumbnail of the slide you want to switch to in the pane on the left. D) Click the Next Slide button at the bottom of the vertical scroll bar.

To right-align text using a tab character, which of the following should be done? Word

ANSWER: A) *Create a tab stop and set the alignment option to Right.* B) Click the Orientation button and select the desired option. C) Click the Align Right button in the Paragraph group. D)Click the Align button and select Align Right.

Which of the following commands found on the Align menu evenly space objects horizontally or vertically relative to each other or the slide? PowerPoint

ANSWER: A) *Distribute* B) Arrange C) Space D) Align

What printer is commonly used to produce high-quality professional drawings such as architectural blueprints? Word

ANSWER: A) *Plotter* ((Plotters can draw continuous lines on large rolls of paper and hence are used to produce professional drawings.)) B) Laser printer C) Ink-jet printer D) Mobile printer

If you need to move an object on a slide a very small distance to the left, which of the following actions is the best method for accomplishing this? PowerPoint

ANSWER: A) *Press CTRL+LEFT ARROW.* B) Press LEFT ARROW. C) Press SHIFT+ALT+LEFT ARROW. D) Drag the picture to the left.

Which button do you click to see a transition in Normal view? PowerPoint

ANSWER: A) *Preview* B) Review C) Watch D) Rewind

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first? Word

ANSWER: A) *Select the table.* B) Select a row in the table. C) Select a column in the table.

If one of your slides contains multiple objects that are placed on top of each other, which of the following commands can you use to move the objects through the layers on the slide? Select all the options that apply. PowerPoint

ANSWER: A) *Send to Back* ANSWER: B) *Send Backward* ANSWER: C) *Bring to Front* ANSWER: D) *Bring Forward*

Kennedy needs to rotate a picture by 45 degrees. She should do which of the following? Word

ANSWER: A) *Specify the amount of rotation in the Layout dialogue box.* B) Flip the picture horizontally. C) Flip the picture vertically.

When you format text on a slide as WordArt, which of the following can you change? Select all the options that apply. PowerPoint

ANSWER: A) *Text outline* ANSWER: B) *Special effects, such as adding shadows, bevels, and reflections* ANSWER: C) *The shape using Transform options* ANSWER: D) *Text fill*

To find text in a document, start by using which of the following methods? Select all that apply. Word

ANSWER: A) *Use the search box in the Navigation pane.* ANSWER: B) *Press CTRL+F.* C) Use the Tell Me box in the ribbon. Answer D) *Press the Find button in the Editing group of the Home tab.*

If you want to change text in a text box by changing the text fill and outline and the shape of the text, which of the following should you change it to? PowerPoint

ANSWER: A) *WordArt* B) Table C) SmartArt D) Bold text

If you want to rotate a selected shape by a specific number of degrees, which of the following is the best option? PowerPoint

ANSWER: A) Click the Rotate button on the Drawing Tools Format tab, and then select one of the Rotate commands. B) Click the Rotate button on the Drawing Tools Format tab, and then select one of the Flip commands. C) Drag the Rotate handle on the shape. D) Drag the adjustment handle on the shape.

John needs to start a new page in a document. The best way for him to achieve this is by pressing ENTER until a new page is created. (T/F) Word

FALSE

Jordan consistently misspelled a name in a document. The most efficient way to correct his error is to manually locate each instance of the misspelled word, and then retype the word with the correct spelling. (T/F) Word

FALSE

To add a shadow to a shape, apply a shape outline. (T/F) Word

FALSE

To create a duplicate of a picture in a document, first click the Cut button. (T/F) Word

FALSE

To find a word in a document, use the Go To command. (T/F) Word

FALSE

To find a word in a document, use the Smart Lookup feature. (T/F) Word

FALSE

To insert a picture from your desktop, click the Online Pictures button. (T/F) Word

FALSE

To rename a form, open the form, and then use the Rename command on the Home tab. (T/F) Final

FALSE

When you double-click an Access database icon, you have the choice of opening a database or creating a new one. (T/F) Final

FALSE

When you import Excel data, you create a link to the data in the Access database. (T/F) Final

FALSE

You can format an object even when it is not selected. (T/F) PowerPoint

FALSE

You cannot change a shape to a different shape. (T/F) PowerPoint

FALSE

You should carefully edit notes you add to a slide because your audience will be able to see them. (T/F) PowerPoint

FALSE

Every slide in a PowerPoint presentation has a background, which is the area behind the text and graphic. (T/F) PowerPoint

TRUE

In order to format all the text in a text box at the same time, you must select the text box first. (T/F) PowerPoint

TRUE

Jasmine needs a double underline to appear beneath a word. She should change the underline style. (T/F) Word

TRUE

Jeremiah needs to organize information in his document using rows and columns. He should insert a table. (T/F) Word

TRUE

One way to make a list on a slide more interesting is to convert the list to a SmartArt graphic. (T/F) PowerPoint

TRUE

The Import Spreadsheet Wizard helps you import Excel data into Access. (T/F) Final

TRUE

The linking field on the "many" side of a one-to-many relationship is called the foreign key field. (T/F) Final

TRUE

To copy formatting from one selection of text to another, use the Format Painter. (T/F) Word

TRUE

To provide emphasis to text, you can apply bold. (T/F) Word

TRUE

When a record from one table is related to several records in another table, the tables have a one-to-many relationship. (T/F) Final

TRUE

When you use the Redo command, you redo the action that was just completed. (T/F) Word

TRUE

You can assign most but not all data types to a field in Table Datasheet view. (T/F) Final

TRUE

You can change a slide's layout after the slide is created. (T/F) PowerPoint

TRUE

You can choose a layout before you insert a slide. (T/F) PowerPoint

TRUE

You can create a new presentation when PowerPoint is running. (T/F) PowerPoint

TRUE

You can insert columns and rows into an existing table. (T/F) PowerPoint

TRUE

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database. (T/F) Final

TRUE

You can use the Mini toolbar to apply bullets to paragraphs. (T/F) Word

TRUE