CIS 110 Final Review (ALL)

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

$A$5

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?

'=COUNT(B1:B20)

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

'=IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good"))

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

'=IF(B2>=60, "Pass", "Fail")

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?

*NOT '=COUNT(B1:B20)*

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

*NOT =DATE(DAY(A1))*

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

*NOT =IF(B2>=60, C2>=60)*

Ben has added a source for a quotation. To insert a citation using this source, he can click the Insert Citation button and then click which option?

*NOT Add New Source*

Elise is preparing to print a worksheet that displays the worksheet name centered at the bottom of every page. She also wants to display the current date next to the worksheet name. Which of the following should she do?

*NOT Add a header to display the date*

How can you add a drop shadow to a picture?

*NOT Apply a Picture Border*

Before you can align pictures with each other, what do you need to do?

*NOT Bring all the pictures to the front*

Hailey wants to resize a picture using percentages of its original size. She should do which of the following?

*NOT Clear the Lock aspect ratio check box and then use the Scale option*

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

*NOT Column chart*

Which of the following is a way to format a paragraph?

*NOT Header*

Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?

*NOT Horizontal axis*

Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?

*NOT Modified Percent*

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

*NOT Page Layout View*

If you mistakenly undo an action, how do you correct your mistake?

*NOT Press CTRL+Z*

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas. She does not want to update the data tables on the worksheet, but she does want to update the other formulas. Which of the following is the most efficient way for her to do so?

*NOT Retype each formula*

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

*NOT Select Chart Element button*

You can change the color of a data series by selecting the series and then clicking the _____ button.

*NOT Series Color*

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

*NOT Shape Effects*

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

*NOT Trendline*

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data. How can he work more efficiently?

*NOT Use the Quick Analysis tool to control calculations*

When should you use relative cell references?

*NOT When you want to enter sequential values in a range of cells*

Which of the following is true about moving cell contents?

*NOT You cannot move cells from one worksheet to another*

You double-click the Format Painter button when you want to _____.

*NOT copy a cell's data to another cell*

The default worksheet text is _____-point Calibri.

11

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

4

How many bits make a byte?

8

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

=AND(B2>=70, C2>=80)

What is the correct formula to insert the date January 12, 1998 into a cell?

=DATE(1998,1,12)

Which of the following formulas can you use to find the serial number of the date January 1, 2017?

=DATEVALUE(''01/1/2017'')

Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?

=HOUR(A1)

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

=MONTH(TODAY(2016,7,0))

A student's scores in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

=OR(B2>=60, C2>=60)

The Apple II is an example of what type of device?

A computer designed for personal use

Which of the following stories can be said to be in the public domain?

A copyrighted story whose copyright has expired

What could cause an external drive, like a USB flash drive, to not be recognized when plugged into a computer?

A faulty port

The teachers in the Mathematics Department want to increase student retention and success rates in all the math courses. They are interested in looking for something that will allow students to check their progress, take practice tests, and message instructors with questions. What would you recommend they consider?

A learning management system

When the title slide is the current slide, what happens when you click the New Slide button?

A new slide with the Title and Content layout is added after the title slide.

Google is an example of which type of website?

A search site

In PowerPoint, what is a screen recording?

A video that shows what happened on a computer screen

When a word is marked as misspelled, how does it look different from correctly spelled words?

A wavy, red line appears underneath it.

In the formula =B6*$B$2, which of the following describes $B$2?

Absolute cell reference

What happens when you run a query from Query Design view?

Access displays a datasheet containing the query results.

When David tries to connect to his home Wi-Fi network, he finds that the router's default Wi-Fi password isn't working even though it worked earlier that day. He resets the device so all the default settings are restored. Two days later, the same problem happens again. What should he change so attackers can't keep reconfiguring his router?

Access password

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Access removes all changes to the record.

The _____ number format adds dollar signs and two decimal places to numeric data.

Accounting

Marianna wants to make the legend stand out on a chart. Which of the following can she do?

Add a border.

Jasmine needs to crop a group photo to show only her face so she can use it as a headshot for a job application. Which of these programs is the best fit for this task?

Adobe Photoshop

You use the _____ button in the Sort & Filter group to use features such as Save As Query and Clear All Filters.

Advanced

Which of the following people will benefit the most from using a B2B website?

Akiko, who helps smaller businesses establish themselves in the market

What happens in a table if you change the font color of the primary key field for the first record to red?

All of the records appear in red.

When you insert a chart on a slide using the Charts button in a content placeholder or the Charts button on the Insert tab, which of the following opens so that you can enter the data for the chart?

An Excel worksheet

How can an attacker execute malware through a script?

An add-on might allow your computer to download a "script" or series of instructions that commands the browser to perform specific actions. An attacker could exploit a security weakness in the add-on to download and execute malware on the user's computer.

How can you control an IoT-connected smart device?

An associated app

For an interview, Sean needs to familiarize himself with database software but cannot afford to purchase any software. Which of these app suites should he download?

Apache OpenOffice

To quickly change the fill, outline, and effect of a shape, which of the following should be done?

Apply a Shape Style.

Alyssa needs a paragraph to have a dotted border. She should do which of the following?

Apply a paragraph border and change the line style of the border.

A document contains a list of items that appear in no particular order. Which of the following is the best way to format the list?

Apply bullets to the list.

If you want to quickly resize the windows of two open presentations and place them side by side, which command could you use?

Arrange All

Which of the following lets you fill a cell with only specific elements of a copied cell?

Auto Fill Options button

What feature inserts a function that totals the cells above or to the left of the selected cell?

AutoSum button

How will technology help people with disabilities become more transportation independent?

Automated vehicles will be developed.

Which of the following options should you select to have Excel update all formulas as you edit a worksheet?

Automatic calculation

If you type the wrong character, which key can you press the remove the incorrect character?

BACKSPACE

What should you do if you want to make a copy of a database in a secure location?

Back up the database.

Aimee wants to display labels as white text on a dark blue background. While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

Background Color

When Jack takes a class, he saves all his work for that class with the name of the course. What is most likely happening to his saved files?

Because he is using the same name, each time he saves he is overwriting his previous work.

Which of the following companies is most likely to use CAM technology?

Bellevue Carpet Manufacturing

Cassidy is a medical assistant in a hospital and has access to many medical files. When she brings patients to the examining room, she can be observed swiping a card, typing in a password, and staring into what appears to be a camera, all attached to the computer. After completing her check-in, Cassidy leaves the patient in the examining room waiting on the doctor. It is important that she logs out of the system so the patient does not have access to the information stored in the hospital's database. Based on Cassidy's actions what systems do you think the hospital has in place to protect the patient medical records?

Biometrics

Which of the following templates lets you create a database from scratch?

Blank desktop database

One of the pictures in Destiny's document is covered up by another picture. To make the obscured picture visible, she should do which of the following?

Bring the obscured picture to the front.

Suppose you inserted a circle on a slide, then inserted a rectangle on top of the circle, and finally inserted a triangle on top of the rectangle. Which of the following commands would you use to have the circle move to the top layer on top of the triangle?

Bring to Front

What determines the speed at which data travels?

Bus width

In a table, what is the intersection of a row and a column called?

Cell

To accept a suggested spelling for that instance only, which of the following would you click?

Change

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?

Change the Number Format in the Footnote and Endnote dialogue box.

Dawn wants to make a column chart look three dimensional. How can she do so?

Change the chart type.

If you want to change the direction of a transition, which of the following should you do?

Change the direction using the Effect Options button.

Enrique applied the Split entrance animation to a picture on a slide in his presentation. The picture appears on the slide starting from the left and right edges until the two sides meet in the middle. He wants to change this so that the center of the picture appears first and then builds out to the sides. Which of the following actions should he take?

Change the effect option to Vertical Out.

How can you display the title of a report in green?

Change the font color of the label in the Report Header.

Charlie created a pie chart that displays number values in data labels. How can he change the values to show dollar amounts?

Change the number format of the data labels to Currency.

Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?

Change the number format of the vertical axis.

Nevaeh needs a paragraph border to be very thick. He should do which of the following?

Change the width of the border in the Borders and Shading dialogue box.

Marina is giving a presentation to a client about real estate the client is interested in buying. However, the text on the slides is small, and thumbnails of the slides appear along the side of the screen, which is distracting. How can Marina fix this problem?

Change to slide show view.

Which of the following buttons lets you remove chart elements?

Chart Elements button

Ariel is shopping for a laptop. He's having trouble deciding among between three options that all have good reviews and fall within his budget. How can Ariel compare the performance potential for each of his top three options?

Check benchmarking information online.

Jasmine is working on a research paper that needs to be in MLA format. To ensure her bibliography is formatted properly, she should do which of the following?

Check to ensure the bibliography style is MLA in the Citations & Bibliography group of the References tab.

To return cell contents to its default font and style, you can use the _____ command.

Clear Formats

What should you do before applying a new filter to a datasheet?

Clear all previous filters.

Gabrielle opened a document that has a large number of tab stops in undesired locations. She wants the tab stops removed. She should do which of the following?

Clear all tab stops from the document.

To clear all formatting from a picture, which of the following should be done?

Click Reset Picture.

To create a cycle diagram in a document, which of the following should be done?

Click SmartArt and select the desired option.

If selected text is bold, how do you change it so that it is no longer bold?

Click the Bold button on the Home tab on the ribbon.

Alyssa needs to center the text of a paragraph on the page. Which of the following can she do?

Click the Center button in the Paragraph group.

To recolor a picture with a green tint, which of the following should be done?

Click the Color button and select the desired option.

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

Click the Insert Date and Time button and select the desired option.

Hannah wants to position a picture in the middle and center of a page and let the text wrap around the picture. She should do which of the following?

Click the Position button and select Position in Middle Center with Square Text Wrapping.

In Form view, how can you navigate to the previous record in the form?

Click the Previous record button on the navigation bar.

Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?

Click the Repeat button nine times.

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

Click the Rotate button on the Drawing Tools Format tab, and then select one of the Rotate commands.

David needs an oval to appear in his document. He should do which of the following?

Click the Shapes button and select the desired option.

To create two simultaneous views of a document, do which of the following?

Click the Split button.

To quickly change the colors, fonts, and effects in a document, which of the following should be done?

Click the Themes button and select the desired option.

After editing sources using the Source Manager, do which of the following to ensure the bibliography reflects the changes?

Click the Update Citations and Bibliography button in the content control tab for the bibliography.

Kenny is about to sign into his bank's website when he notices the layout looks different from the last time he was on this site. The URL begins with HTTPS, but Kenny is still not convinced this site is safe. Knowing that anyone can create a secure website that uses HTTPS, how can Kenny find the digital certificate to check that his bank actually owns this website?

Click the name of the organization next to the address bar

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

Color

What type of chart is a Clustered Column - Line chart?

Combo chart

Adrian has made a list of his family's grocery expenses over the past year. He wants to highlight all the weeks where expenses exceeded the grocery budget so he can budget more accurately for the coming year. Which spreadsheet tool will allow him to do this automatically?

Conditional formatting

Ronald maintains a website that focuses on travel-related information. He gathers adventure posts from various travel blogs and shares them to his site. What type of a website does Ronald maintain?

Content aggregator site

After shopping for a used Jeep, Nichole starts noticing a lot of ads on her Instagram feed for Jeeps. How did Instagram know she's interested in buying a Jeep?

Cookies on her computer

When Florence joins her father's construction business, she realizes all the transactions are still done and maintained on paper. What should she do to establish a system where any data can be looked up immediately and transparency can be maintained?

Create a database of company projects, customers and vendors.

To indent the first line of every paragraph in a document, do which of the following?

Create a first line indent.

Tiana needs each line after the first line in a paragraph to be indented. She should do which of the following?

Create a hanging indent.

How can you protect personal information gathered by legitimate organizations?

Create a separate email account for receiving information from websites.

Kyle inserted a photo of a dog on a slide. In the photo, the dog is on the right, and an empty street is on the left. What can Kyle do to remove the part of the photo that contains the empty street?

Crop the photo.

Eric's brother, Simon, recently posted a YouTube video talking about Eric's low science grades due to spending too much time playing video games. The video explains how Eric got in trouble with their parents and has been grounded. Which of the following is the best description of Simon's behavior?

Cyberbullying

When editing a record, what key can you use to navigate to the next record?

DOWN ARROW

Jackson just saved his research paper on his USB flash drive so he can take it to school and work on it in the library's computer lab. What kind of data is the file on his flash drive?

Data at rest

_____ view is a spreadsheet-like view of the data in a table.

Datasheet

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

Date/Time

_____ are standard settings that control how the screen is set up and how a document looks when you first start typing.

Default settings

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Delete

When a comment is no longer useful, you should do which of the following?

Delete the comment.

Which computer type will take up the most space in a workspace?

Desktop computer

Which of the following devices is the easiest to upgrade, such as by adding RAM?

Desktop computers

Which of the following is the fastest way to open an Access database?

Double-click its file or shortcut icon.

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

Double-click the cell or click in the formula bar.

To have text appear at the bottom of each page in a document, do which of the following?

Double-click the footer region of the page and enter the desired text.

How do you display the results of a query listed in the Navigation Pane?

Double-click the query.

Raul needs to create a slide that will contain similar information and have the same format as Slide 3 in his presentation. Which of the following should he do?

Duplicate Slide 3.

Which of the following do you change if you want to change the speed of a transition?

Duration

If each item in a bulleted list is animated separately, what is displayed in the animation tags for each line of text?

Each tag displays different number.

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

Edit mode

To correct an error in a comment, do which of the following?

Edit the comment.

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Edit the conditional formatting rule.

Brianna needs to correct the year of publication in one of her sources. She should do which of the following?

Edit the source to correct the error in the Source Manager.

Claudia added a rectangle to a slide and now wants to resize the shape to a height of 2.3 inches and a width of 3.4 inches. Which of the following is the best way for her to do this?

Enter the dimensions in the Shape Height and Shape Width boxes.

Sydney wants to resize a picture to exact dimensions. She should do which of the following?

Enter the height in the Shape Height text box and enter the width in the Shape Width text box.

During a slide show, Luis wants a picture to appear on one of his slides after the slide appears on the screen. Which type of animation should he use?

Entrance

Tristan just downloaded a new game he wants to play on his computer. What kind of file should he open in order to install and run the game?

Executable file

Which of the following keys should you press to have Excel calculate all open workbooks manually?

F9

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?

Faulty power or video cable

Juana needs to open a document. To access the Open dialog box, which tab should she use?

File tab

The easiest way to filter the records for an exact match is to use the _____ feature.

Filter By Selection

If you want to create a mirror image of a shape to the left or right of the shape, you should duplicate or copy and paste the shape, and then use which of the following commands?

Flip Horizontal

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

Font

Which of the following contains text you specify and appears on all the slides in the presentation ?

Footer

Shelle wants to design her database so it's easy for the receptionist or another assistant to enter client information. What object should she create to accomplish this goal?

Form

To change the starting and ending values on a chart axis, use the _____ pane.

Format Axis

What should you do before you turn on a laptop for the first time?

Fully charge the battery.

What technology helps delivery truck drivers route around construction delays and traffic accidents?

GPS

To move to a specific page, section, line, or graphic, you can use the _____.

Go To tab in the Find and Replace dialog box

Which of the following is a valid app source for Android users?

Google Play Store

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Gridlines View

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

Guides

Kiaan wants to give people who attend his presentation a printed copy of the slides. Instead of printing one slide on each piece of paper, he wants to print six slides on each piece of paper. Which setting should he select on the Print tab in Backstage view to do this?

Handouts

Marcus recently had his cell phone stolen. All of the following are security features that should help him locate his stolen phone EXCEPT which one?

He can use remote tracking to retrace the thief's steps.

Emma tried to explain to her mother that computers are everywhere. Her mother does not believe her, and challenges Emma to find a computer in their home, as she knows she does not own a computer. Which of the following examples do you think Emma would show her mother as example of computer?

Her coffeemaker that she has set to turn on and make coffee every morning at the same time.

Which of the following chart types shows the distribution of data grouped in bins?

Histogram chart

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Home

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?

Hyperlink to the web page

Reginald's son has cerebral palsy and needs a keyboard with large keys to complete his schoolwork. Which law requires the school to provide funding for this equipment?

IDEA

If a word is marked as misspelled, which of the following does not change how that word is spelled?

Ignore

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?

Ignore All

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

Ignore All

Ben moved a chart to a chart sheet, but now the axis labels are too small. What can he do to make them easier to read?

Increase the font size.

Juan is interested in getting a job in the technology field. He is interested in protecting data from threats, and stopping hackers and viruses. Which job would should Juan apply for?

Information security

_____ is data and instructions entered into the memory of a device.

Input

Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source of a quotation. What is the best way for him to achieve this?

Insert a citation.

Jada needs to create a note at the bottom of a page that references text in the body of the document. She should do which of the following?

Insert a footnote.

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

Insert a page break.

Isaiah needs to insert a copyright symbol (©). He should do which of the following?

Insert a symbol from the Symbol gallery.

What is the recommended solution if a computer performs slowly?

Install additional RAM.

To find employee records that do not contain an entry in the Email field, use the _____ criterion in the Email field.

Is Null

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations.

What does the operating system do if you try to save a file with the same name into the same folder?

It overwrites the original file unless you add a number, date, or initials to differentiate the files.

You and your friend both send documents to the printer, but the printer can only print one document at a time. What does it do with the other document?

It places the document in a buffer.

LensForAll is a company that sells affordable contact lenses on its website. The CEO of the company realizes that an app must be developed that would allow customers to virtually try on colored lenses to find out what best suits them. Which of these features should the app have?

It should have responsive design so that it is easy to use on mobile devices.

What was significant about the introduction of the microprocessor in the 1970s?

It was faster, smaller, and less expensive than integrated circuits.

Which formatting command changes text so it is slanted?

Italic

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance. He should use which of the following paste options?

Keep Source Formatting

Which of the following is not a hardware device that controls the movement of the pointer on a computer screen?

Keyboard

Kevin is a hotel manager and has noticed long lines of impatient customers at the front desk. What IoT technology can Kevin use to help solve this problem?

Kiosks

Eric just signed up for his first college class after being out of school for nearly a decade. He goes to the bookstore the week before class starts to get his book, and he's surprised to learn that he only needs an access card. How will Eric be accessing the course material for his college class?

LMS

Which of the following is not a common element in a desktop window?

Launchpad button

In _____ view, you can make some design changes to a report while you are displaying the data.

Layout

Which of the following elements uses colors to identify how the data is represented in a chart?

Legend

Steve has built an online shopping website and he would like to increase his website ranking in the search results. You are his consultant. Which of the following would you recommend for him to help achieve his goal?

Link his website to other popular websites

Sami is about to graduate with her IT degree and needs to post her resumé online to help with her job search. Which website should she use to post her qualifications?

LinkedIn

Which of these operating systems could a developer copy, give to others, and sell to the public?

Linux is distributed under the terms of a General Public License (GPL), which allows you to copy the OS for your own use, to give it to others, or to sell.

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?

Make the program available as a web app.

If you want to combine two or more shapes to create an entirely new shape, which of the following commands would you use to do this?

Merge

What are "hits" that search engines list on the first page?

Most relevant results

In Query Design view, how can you add a field to the query design grid?

NOT Click the field in the field list, and then click the Add to Grid button.

Which type of chart compares individual values to the whole?

NOT Column

You can use the _____ to apply the same formatting to multiple controls in a report.

NOT Conditional Formatter

When you are entering data in a table, which key can you press to move to the next cell to the right or to the first cell in the next line if the current cell is the last cell in a row?

NOT ENTER

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

NOT Null OR Not "New York"

If you add Is Null as the criterion for the Advisor field in the Students table, what are the results?

NOT Students with advisors

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

NOT You can switch to Report view.

You can add fields to a form in Design view or _____.

NOT datasheet view

If you change the font size of a report control in Report _____ View, you can see the effects of the change immediately.

NOT design

After you enter text in a placeholder, what does the placeholder become?

NOT object

When you remove a control layout from a report, Access _____.

NOT removes the controls from the report

When you create a report using the _____, Access includes all the fields in the selected table.

NOT report wizard

You can use a _____ to insert text or objects such as charts, videos, or pictures.

NOT selection box

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

NOT switch to Form view

To change the background color of a form control in Form Design view, you use the _____ button.

NOt form color

What should you do the first time you save a file?

Name the file.

In what part of the Access window do you rename a form?

Navigation Pane

Which view do you choose if you want to add a picture to a slide?

Normal

In which view can you preview an animation?

Normal view

Cody opened a presentation named October Sales. Then he saved the October Sales presentation with the new name November Sales. What happened to the October Sales presentation?

Nothing; the October Sales presentation is still available.

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?

On the Home tab, click the Layout button, and then click Two Content.

Rajesh is considering whether to use a web app to collaborate with a group of friends on a project. What is one reason he should avoid using a web app for the project?

One friend has an unreliable, slow Internet connection.

Which of the following is not a task the operating system performs?

Operating systems process data, manage memory, control hardware, and provide a user interface.

Why is it advisable to look beyond search engines like Google and Bing while conducting online research for assignments and projects?

Other search engines provide more reliable research.

Which of the following is a text effect you can select from the Text Effects and Typography gallery?

Outline

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

Page Break Preview

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

Page Layout

Which of the following tabs lets you set worksheet print options?

Page Layout

Which worksheet view shows headers, footers, and rulers?

Page Layout view

Ricky's social media account was recently hacked. His bank accounts and email accounts use the same password as his social media account, and within a week, they were also hacked. What could Ricky have used to prevent the original attack from affecting so many accounts?

Password manager

Leslie is traveling for a business trip. The first night in her hotel room , she plugged her phone's power cable into the USB outlet on the bedside lamp. The next morning when she tries to turn on her phone, the screen is blank. What is the best next step to address this problem?

Plug the phone into a wall outlet to recharge the phone.

To switch between two open windows, do which of the following?

Point to the Word icon on the taskbar and then click a document.

When you have a second monitor attached to your computer, which view provides you with additional tools, such as a timer, to help you as you give your presentation?

Presenter view

Jeremiah inserted a table and needs to fill it with data. After entering a value, he should do which of the following to move the insertion point to the next cell in the row?

Press TAB.

When editing a record using a form, how can you move from field to field in the same record?

Press TAB.

How would you proportionally resize a text box that contains WordArt?

Press and hold SHIFT as you drag a corner sizing handle.

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

Preview

Nancy is about to give a presentation to her school's advisory board about some upcoming changes to their Nursing program. She wants to display the presentation from her laptop to the large screen in the conference room. What does she need to show the presentation?

Projector

Which of the following is an example of green computing?

Purchase and use products with an ENERGY STAR label.

You can create conditional cell formats using either the Home tab or the _____.

Quick Analysis tool

Lyle is working online when a message appears warning that his personal files have been encrypted so he cannot access them. He has 72 hours to pay hundreds of dollars to receive a key to decrypt the files. What type of malware is infecting Lyle's computer?

Ransomware

Rihanna wants to display document text so that it is easy to read on screen. Which of the following views should she use?

Read Mode

Walter selected data on a worksheet to show in a chart. Which button on the Insert tab can he click to display charts appropriate for the selected data?

Recommended Charts button

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

Recover unsaved changes using the Info screen of the File tab.

Sean drifted off while riding the bus home from work. When he woke up, he realized his smartphone was not in his jacket pocket where he usually carries it. However, he's not certain he picked it up off his desk when he left work. What security feature would ensure that no one who might have taken it can access Sean's email while he looks for his phone?

Remote lockout

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

Remove Layout

Chloe notices that when she inserts a tab character, her insertion point moves to the right side of the page and the text she enters is right-justified. She does not want tab characters to behave this way. She should do which of the following?

Remove the tab stop.

What types of activities are ideal for a robot to perform?

Repetitive tasks

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

Replace

The _____ button creates a new, blank report in Report Design view.

Report Design

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

Report Layout view

Andrew accidentally misspelled a word. To correct the error, he can do which of the following?

Right-click the word and select the desired suggested spelling.

In SQL view, a select query starts with the SQL keyword _____.

SELECT

To select more than one object at a time on a slide, which key do you press while you click the objects?

SHIFT

Which of the following functions inserts the total of a range?

SUM

You've just signed a document for an insurance settlement, and you need to mail it back to the insurance company. However, you want to keep an electronic copy of it for yourself. Which device would best help you do this?

Scanner

Hector is creating a presentation that teaches people how to use software that he developed. He wants to include a video that shows his screen as he performs some of the steps. Which of the following commands will allow him to do this?

Screen Recording

Joe wants to use an engaging image as a hook in his presentation, but he's afraid of violating any copyright laws. What should he do?

Search for an image on Creative Commons

Ashley needs to find an underlined word in a 100-page document. Which of the following is the most efficient way to find the word?

Search for underline formatting.

Jasmine needs to select the first sentence of a paragraph and the last sentence of a paragraph simultaneously. The text is nonadjacent. Which of the following should she do?

Select the first sentence, then press and hold CTRL while selecting the second sentence.

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

Select the label and then click the Remove Layout button.

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

Select the shape.

If you want to apply a special effect to a shape, such as a beveled edge, a shadow, or a glow, which of the following buttons would you click on the Drawing Tools Format tab?

Shape Effects

Which button on the Drawing Tools Format tab would you click to change the color, weight, or style of the border of a shape?

Shape Outline

To add a border to a shape, you click the _____.

Shape Outline arrow

Gertie wants to buy a smartwatch by making an electronic payment. She is not willing to divulge her financial information, and her only bank account is not linked to any online payment service. Which of the following most aligns to what Gertie feels comfortable doing?

She should use a virtual account number to make the payment.

Charley likes to have everything organized and she is bothered by the long list of documents on her flash drive. She wants to create folders by semester, then by course. How can you help her?

Show her how to use File Manager.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Shutter Bar Open/Close button

Which of the following tools can you use to create a query?

Simple Query Wizard

What are the small squares that appear in the corners and in the middle of the sides of a selected object's border called?

Sizing handles

Which view do you choose if you want to see a thumbnail of each slide in a presentation arranged in a grid?

Slide Sorter

Using the Reuse Slides pane, you can insert slides from another presentation in a network location called a _____.

Slide library

Ashleigh wants to add her company's logo to all of the slides in her presentation. Which software feature should she use to do this most efficiently?

Slide master

If you have more than one picture on a slide, you can align them using _____.

Smart Guides

To make your presentation more interesting, you should consider converting lists to which of the following?

SmartArt graphic

What performance specification does 2 GHz refer to?

Speed at which the processor executes instructions

_____ is a standardized language that all major relational database software uses.

Structured Query Language (SQL)

Marina needs some information about how a carburetor works in an aircraft. She used Google to search for information on the web and now wants to refine the results to show videos only. Which of the following tools on the search engine results page (SERP) would you recommend to Marina?

Subject filter

Nicholas is complaining there's not enough space on his slides to include all the text he needs. What advice should you give him to solve this problem?

Suggest that he use less text and stick to the main points.

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Sum

Andy is designing an app that he plans to post only in Apple's App Store. He doesn't plan on posting the app to any other app store. What development tool will he most likely use?

Swift

If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

TIME

Which of the following is a grid of columns and rows used to present information on a slide?

Table

The upper pane of _____ view shows field names and data types.

Table Design

_____ is the default name for a new table in an Access database.

Table1

Reggie works for a health insurance company and spends many hours each day entering data into a database. Recently he complained to his doctor about pain and stiffness in his neck and shoulders. Which of the following is his doctor most likely to recommend?

Take more frequent brakes.

Which of the following is true when you copy and paste formulas using the fill handle?

The AutoFill Options button lets you fill cells with specific elements of the copied cell.

Which of the following statements is true about COUNT functions?

The COUNT function returns the number of cells in a range that contain numeric data.

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

The Paste Options button then lets you paste specific elements of the copied cells.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

The Undo button on the Quick Access toolbar

What happens when you close a module?

The Visual Basic window closes.

Kay is researching the health benefits of avocados. She finds an article on the website tracyshealthproducts.com. Which of the following can assure Kay that the content is credible?

The article's author has been a nutritionist for the last three years.

In the 1980s movie, Wargames, the computer was taught to play chess, checkers, tic tac toe, and other strategy games. How would you describe the developers' goal in teaching the computer these games?

The developers were using artificial intelligence.

_____ is the gap between those who have access to technology and its resources and information, especially on the Internet, and those who do not.

The digital divide

Ricky's computer keeps freezing when he's running several apps or webpages simultaneously. What resource does his computer probably need more of?

The more RAM (random access memory) a device has, the more efficiently it runs. If several programs or apps are running simultaneously, the device might use up its available RAM and freeze or run slowly.

Ms. Lawson, a primary school teacher, told her students that a photograph of the president is in the public domain. What does she mean by this?

The photo is free of copyrights.

To format a picture with preset formatting options, which of the following should you change?

The picture style

If you press SHIFT while you drag a sizing handle on a shape, what happens?

The proportions of the shape are maintained as you resize the shape.

What happens when you run a query with the Is Null criterion in the Product Type field?

The results include only records with no Product Type value.

Which of the following describes the relationship between the web and the Internet?

The web is part of the Internet.

You can monitor and protect your financial data in all of the following ways EXCEPT _____.

There are laws to help U.S. users monitor and protect their financial information that is stored by a credit reporting agency. You can request one free credit report annually and you can also "freeze" your credit information.

How do delivery companies track packages?

They use code-scanning technology.

Which of the following layouts is best for the slide that contains the title of the presentation?

Title Slide

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

Title slide

Why would you use the Line and Paragraph Spacing arrow on the Home tab?

To add or remove space between paragraphs

Which of the following is true about deleting a worksheet row?

To delete a row, you can select the row, then use the Delete button in the Cells group.

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

To paste the value's number formatting only.

Which of the following is a pointing device you can use instead of a mouse?

Touchpad

Alicia often shows short, engaging videos to her fifth-grade science students. She has more success using RhythmOne instead of Google to find appropriate videos. Which of the following most likely explains why?

Unlike Google, RhythmOne uses speech recognition to match the audio part of the video with the search term.

How is an executable file different from a data file?

Unlike a data file, you cannot open and read executable files.

To ensure your bibliography accurately reflects the sources in your source list, do which of the following?

Update the bibliography.

How can you protect a computer from electrical spikes and surges?

Use a surge protector.

Emma is working on a new resumé so she can apply for her first full-time job after college. She thinks her design is looking plain, though, and is worried she's missing important information. What advice can you give Emma to help her spruce up her resumé and make it look more professional?

Use a template

Alessandro wants to use his desktop computer to video chat with his mother. What hardware does he need to accomplish this?

Use his webcam and speakers so that he and his mother can both see and hear each other.

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?

Use the Format Painter.

What is the most efficient way to navigate to the last record in a table containing 100 records?

Use the Last record button on the navigation bar.

Which of the following do you use to change the document margins?

Use the Margins button in the Page Setup group of the Layout tab to select the desired option.

Joanne needs each page in her document to be numbered. She should do which of the following?

Use the Page Number button.

Gregory is researching the use of certain drugs for treating anemia in women living in a developing country. Which of the following approaches is the most focused on his research?

Use the web directories created by health research institutions.

Sammy created a new logo for his client to use on the company website and office stationery. However, the logo became a blur when it was enlarged to use on a billboard ad. Now Sammy needs to redo the logo. What should he do to avoid this problem in the future?

Use vector images because they retain their clarity even when enlarged or shrunk.

Which of the following is a necessary step in maintaining computer hardware?

Using a UPS or a surge processor

How could a thief get your credit card statement sent to his address instead of yours?

Using a standard change-of-address form from the post office, an attacker can divert your mail to his own P.O. box.

Which one of the following applies several formatting options at once to videos?

Video styles

Gabriella plans to print her slides on a printer that does not print in color. Which of the following actions should she do before she prints the entire presentation?

View the presentation in grayscale.

Logan is considering web app development as a career option. Which of the following languages does he not need to master?

Visual Basic

What type of app runs in a browser?

Web app

An organization has its employees working from home. Which type of software most likely includes collaboration features to help the employees work together online?

Web apps

Which of the following is classified as input device?

Webcam

Debra tracks her business finances in a spreadsheet. She wants to figure out how much she could increase profits if she raises prices on some products. What feature should she use to find the answer?

What-if analysis

When you start an app on your computer, the app's instructions are _____.

When you start an app on your computer, the app's instructions are transferred from the hard drive to RAM.

Rylie is trying to save a file named Rylie:Portfolio.docx, but she keeps getting an error message. How can she fix the problem?

Windows file names contain up to 255 characters, but cannot include some symbols, such as asterisks or slashes.

With a _____, you can emphasize one data point by exploding it.

With a _____, you can emphasize one data point by exploding it.

Andy is writing an article and wants to verify a few facts. Which of the following websites is designed to provide answers to factual questions?

Wolfram Alpha

Skyler needs to print mailing labels for a fundraising campaign her company is hosting. Which type of software should she use?

Word processing

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?

WordArt

Which of the following is true of the Excel spell checker?

You can change all instances of a flagged word to a selected suggestion.

Amanda is used to buying clothes from physical stores. Her friend, Stuart, prefers online shopping and wants to persuade her to shop online as well. Which of the following arguments can Stuart make to convince Amanda without painting a false picture?

You can shop online at any time of day and in any weather conditions.

Which of the following is an advantage to saving a file to a flash drive?

You can take it with you and then work on it on another computer.

Which of the following statements about browser security settings is false?

You must keep your accumulated web history as long as you use the browser.

How is the font set for a table in Table Datasheet view?

You use the Font box on the Home tab.

What can you use to enlarge the document in the document window so you can focus on a detail?

Zoom slider

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

a column

When you underline cell content, you are using _____.

a font style

When you double-click a field in a field list in Query Design view, you _____.

add the field to the query design grid

Clicking in the vertical ruler in Report Design view selects _____.

all the controls that intersect with the selection line

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

argument

What technology can collect information to make decisions, reach conclusions, and combine information in new ways?

artificial intelligence (AI)

Which of the following do you do to select text?

click and drag across the desired text

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

click the Advanced button, and then click Clear All Filters

In Report Design view, you can remove a control from a control layout by selecting the control and then _____.

clicking the Remove Layout button on the Arrange tab

To rename a field in Table Datasheet view, you change the text in the _____.

column heading

When you _____ a database, you make more storage space available and enhance the performance of the database.

compact and repair

Each item on a form is called a _____.

control

There are various risks from attacks on Wi-Fi networks. These include all of the following EXCEPT _____.

creating malware

After Penny broke up with her boyfriend, he texted some teammates from the track team about some private and intimate moments he and Penny had shared while they were dating. He even lied about their breakup, creating rumors about her behavior. Penny started getting inappropriate looks and advances from the team whenever she was at practice and felt completely humiliated. Penny is a victim of ________.

cyberbullying

Creating a(n) _____ means copying files from a computer's hard drive and storing them in a remote location.

data backup

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

data bars

Microsoft Access can best be described as ____ software.

database

File details such as the document title and author name are called _____.

document properties

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

does not reuse the value

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

field

The _____ refers to the data you would edit if you started typing.

focus

Samantha plans to self-publish her book on her website. Which of the following apps should she use to design the cover?

graphics app

Which of the following helps you more easily locate the files and folders you need?

grouping similar subfolders together in a folder

You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is _____.

hidden

Technology can lead to all of the following behavioral risks EXCEPT _____.

higher satisfaction with life

Which of the following window elements displays the left and right document margins?

horizontal ruler

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

icon sets

Query Design view presents the fields you can use for a query in small windows called field _____.

lists

When you select a control in Form Design view and then press an arrow key, you _____ the control.

move

If you used D*n as the criterion in a Short Text field called FirstName, what would appear in that field in the query results?

names that start with D and end with n, such as Dean

Tables, queries, and forms are examples of Access ____.

objects

Martha has been appointed as the Data Security Manager of her organization. The company wants her to develop a customized app to remove viruses from the infected systems without connecting to the network. What type of app should she focus on developing?

portable app

To select more than one control in Form Design view, you _____ and then click each control.

press and hold the SHIFT key

Field _____ are the characteristics that describe each field, including Field Name and Data Type.

properties

You can create an Access report by selecting fields from one or more tables or _____.

queries

A group of related fields, such as all the demographic information for one customer, is called a _____.

record

Each row in a table datasheet displays a _____.

record

In a datasheet, what do you click to select a record for deletion?

record selector button

When you enter data in the rows of a table datasheet, you are entering _____.

records

Besides reducing file size, what other benefit does compacting an Access database provide?

repairing the database

Alex needs to email his graduation certificate to a prospective employer. He has only physical copies of the certificate. What device could he use to create an electronic copy of the certificate?

scanner

Akira has a mobility impairment that makes it difficult to type on a keyboard. What technology can she use to create written documents without using a keyboard?

speech recognition software

A _____ is a point on the horizontal ruler that indicates where to align text.

tab stop

In which object can you rename a field?

table

When you apply a style to a table, which of the following is likely to change?

table colors

Jack needs a convenient way to browse the Internet, read emails, and store basic data when he travels. Which of the following would be the best option for him?

tablet

Which of the following is a presentation that has a theme applied and also contains text, graphics, and placeholders to help you create your presentation?

template

You can create a database by using an Access _____ or by starting with a blank database.

template

Austin needs to emphasize text by applying a transparent color to the text. Which of the following tools should he use?

the Text Highlight Color button

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

the slide thumbnail

A _____ is a set of unified design elements for a document, including colors, fonts, and effects.

theme

A file manager is used for all of the following except ____.

to change the contents of files

When would you explode a slice in a pie chart?

to emphasize one data point

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

to the right of the City field

A(n) _____ protects your device against unauthorized access.

user account

Compressing a file is also called _____ the file.

zipping