Computer concepts Final Exam

Which of the following is true about margins in Word 2019? A. the default top and bottom margins are 1" B. Margins are only on the left and right edge of the paper C. The default left and right margins are 1.25" D. Margins are only at the top and bottom edge of the paper.

A.

The default zoom level for viewing a document is ________. A. 100% B. 25% C. 200% D. 75%

A. 100%

All excel formulas begin with a(n) A. = sign B. # sign C. + sign D. % sign

A. = sign

Which of the following is a keyboard shortcut to Cut? A. Control + X B. Control + V C. Control + P D. Control + C

A. Control + X

Which of the following is not a default setting of Word 2019? A. Default spacing after paragraphs of 12 points B. Calibri, 11 point font, with 1.08 line spacing C. Print Layout View D. Left, Right, Top, and bottoms page margins of 1 inch

A. Default spacing after paragraphs of 12 points

If you want to send and receive email messages containing images and formatted text, you need to ensure that your email program is configured to read ________ email messages. A. HTML B. text C. advanced D. important

A. HTML

where is the fill handle located? A. In the lower right corner B. On the Quick Access Toolbar C. On the Home tab D. In the top right corner of an active cell

A. In the lower right corner of a selected sell

Use the ____ command to search a document for hidden data or potentially person data that should not be shared. A. Inspect Document B. Check Compatibility C. Check Accessibility D. Check Properties

A. Inspect Document

The manner in which text displays around an object A. Live Layout B. alignment guides C. text wrapping D. formatting marks

A. Live Layout

________ is a technology that shows the result of applying an editing or formatting changes as you point to possible results, before you actually apply. A. Live preview B. Style preview C. Print preview D. Theme preview

A. Live preview

A ______ is a list of commands within a category A. Menu B. Ribbon C. Navigation Pane D. Scroll Box

A. Menu

A USB flash drive is an example of a ______ storage device to transfer information from one computer to another A. Removable B. Transferable C. Collaborative D. Wireless

A. Removable

The ______ command reverse your last action. A. Undo B. Replace C. Delete D. Repeat

A. Undo

Microsoft Word is an example of which type of computer application? A. Word processing B. Database C. Accounting D. Spreadsheet

A. Word Processing

What does the text pane of a SmartArt graphic offer? A. A location where you can type text B. A place where you can change the font and font size C. A location where you can change the color of typed text D. A place where you can insert an object

A. a location where you can type text

When you set up a new email account, you may have to enter a distorted series of letters and numbers, called a ________, to ensure that you are a human and not a computer. A. captcha B. password C. signature D. catchmeifucan

A. captcha

OneDrive is Microsoft's ________ storage product. A. cloud B. internal C. shared D. removable

A. cloud

In a Word document, a(n) ______ is a graphic that can be moved independently of the surrounding text characters. A. floating object B. object anchor C. drawing object D. in-line object

A. floating object

A(n) _____ is prewritten in Excel to look at it one or more values, perform an operation, and then return a value. A. function B. displayed value C. underlying value D. formula

A. function

An email contains a virus hoax is dangerous because ______. A. it causes people to search for and delete important files B. it can send copies of itself through the email program. C. it contains a virus D. sends your password to a criminal

A. it causes people to search for and delete important files

An email supposedly from your IT department asking for your password so that it can troubleshoot your account is a form of ________. A. phishing B. pharming C. cyber bullying D. cyberstalking

A. phishing

a(n) _____ is a set of instructions that a computer uses to accomplish a task. A. program B. operating system C.platform D. website

A. program

To select a series of adjacent files, you should use the following on the keyboard: A. shift B. control C. alt D. delete

A. shift

Unwanted or junk e-mail is called ________. A. spam B. spyware C. software D. adware

A. spam

In order to have an updated copy of a file in more than on location, you can _______ the files so that updates in one location can be reflected in another based on a set of rules. A. Sync B. auto-save C. copy D. duplicate

A. sync

The type of e-mail that is managed by your browser and enables you to access your e-mail from anywhere you have Internet access is __________ e-mail. A. web-based B. client-based C. local-based D. inventory-based

A. web-based

The ______ displays the columns and rows that intersect to form the worksheet's cells. A. worksheet grid area B. Quick Access Toolbar C. Formula Bar D. Name Box

A. worksheet grid area

Which of the following is not a task available in Slide Sorter View?

Add text to multiple placeholders

Which of the following is not a Powerpoint presenter view element?

Animation tools

Where does a header print?

At the top of each sheet of slide handouts or notes pages

Which of the following is the widescreen format of Powerpoint 2019?

16:9

Which of the following is not an arithmetic operator?

>=

Which of the following does not open when the lower portion of a split button is clicked?

A Layout

When you click through to the end of a presentation, _____ displays

A black slide

A chart value that originates in a worksheet cell is referred to as ________.

A data point

_____ is a collection of formatting options that can be applied to a picture, text, or an object.

A style

When you copy a file from one folder to another, the original file: A. is duplicated and the second copy is placed into a destination folder B. is removed and placed into the destination folder C. The file exists in neither location

A.

When you move a file from one folder to another, the original file: A. is duplicated and the second copy is placed into a destination folder B. is removed and placed into the destination folder C. The file exists in neither location

B.

When you are sending one email to all of your friends in your address book, you should use the _____ field to keep their addresses private. A. Cc: B. Bcc: C. To: D. Pcc:

B. Bcc:

The default font in a Word document is ________. A. Times New Roman B. Calibri C. Arial D. Comic Sans

B. Calibri

When dragging a file into a folder, you can hold down which of the following buttons on the keyboard to engage the Copy command to place a copy of the file at the location where you release the mouse button? A. shift B. control C. alt D. delete

B. Control

Which of the following is a keyboard shortcut to Paste? A. Control + X B. Control + V C. Control + P D. Control + C

B. Control + V

Any email that you send is private, and it cannot be read by anyone other than the person to whom it is addressed. A. True B. False

B. False

________ are pictures composed of straight and curved lines. A. Graphics B. Icons C. Shapes D. Symbols

B. Icons

Which of the following is not true about email? A. copies of your email may exist on several servers even after the recipient deletes it. B. It cannot be accessed by hackers C. Email can be used for targeted marketing. D. Your employer may read your email at your work

B. It cannot be accessed by hackers

which option is not a part of Windows 10 Start Menu A. settings button B. My computer icon C. signed-in user D. Apps list

B. My computer icon

How many spaces should be inserted at the end of a sentence? A. Two B. One C. It does not matter; all are correct D. Three

B. One

Which of the following can be described as graphics? A. 3D Rotation, reflections, glow B. Online pictures and charts C. Shadowed or mirrored text and text glow D. Underlined text

B. Online pictures and charts

To see and switch between open apps, on the taskbar click the ________ button. A. Current view B. Task View C. Start menu D. Live view

B. Task view

It is a good idea to obtain an email account that is not tied to your ISP, so that when you change service providers you won't lose your email account. A. False B. True

B. True

When you send an email to your professor, a server holds onto that email until the professor requests it A. false B. True

B. True

Word used wrap, so if a word does not fit at the end of a line, what happens to the word? A. automatically hyphenated B. automatically moved to the next line C. depends if the word has more than two syllables D. Nothing

B. automatically moved to the next line

A cell address is also referred to as a(n) ________. A. value B. cell reference C. active cell D. label

B. cell reference

An email claiming that you have won a lottery might be an example of ________. A. hacktivism B. computer fraud C. cyberbullying D. cyberstalking

B. computer fraud

A tab added to the ribbon automatically when a specific object is selected and that contains commands relevant to the selected object is known as a ________ tab. A. hidden B. contextual C. home D. Dynamic

B. contextual

To select a series of non-adjacent files, you should use the following on the keyboard: A. shift B. control C. alt D. delete

B. control

When you type text in a cell it is ________. A. right-alighned B. left- aligned C. fully justified D. centered

B. left- aligned

Paragraph layout in Word includes all of the following EXCEPT ________. A. indents B. margins C. line spacing D. tabs

B. margins

You can mark all of the following changes to a theme font except ______. A. colors B. orientation C. fonts D. alignment

B. orientation

Which of the following alignment options is true about right alignment ? A. text is spaced out evenly between the margins B. text lines up only on right margins C. text lines up on both left and right margins D. text lines up only on the left margin

B. text lines up only on right margin

The manner in which text displays around an object. is A. alignment guides B. text wrapping C. formatting marks D. Live Layout

B. text wrapping

At the top of a window in an Office application, the ________ bar displays the name of the file and the name of the program. A. Status B. Title C. Ribbon D. Menu

B. title

Once a computer is infected, a virus can use the email program to send out copies of itself A. false B. true

B. true

One way to access email is to read it online through a webmail interface. A. false B. true

B. true

Where does a dot leader display in a document? A. Before and after an inserted object B. Only before an inserted object C. On the Word 2019 ruler D. Between the columns of a list

D. Between the columns of a list

Which of the following is a keyboard shortcut to Copy? A. Control + X B. Control + V C. Control + P D. Control + C

D. Control + C

Which of the following shortcut keys enables you to select everything in a document? A. Ctrl + End B. Ctrl + down or up arrow key C. Ctrl + Home D. Ctrl + A

D. Ctrl + A

You can use the ______ command to place a copy of a selection o. the clipboard and remove the selection from the original location. A. Copy B. Delete C. Insert D. Cut

D. Cut

The search feature in Microsoft Office helps you with an Office Command in the ______ feature A. Teach me B. Guide me C. Show me D. Tell me

D. Tell me

A(n) _____ file is smaller in size than the original file, takes up less storage space, and can be transferred to other computers quickly. A. blocked B. shared C. extracted D. compressed

D. compressed

A GUI typically includes all of the following except ________. A. a pointer B. icons C. a desktop D. hardware

D. hardware

A text value in Excel is also referred to as a ________. A. constant B. formula C. cell address D. label

D. label

I'm Windows, a hamburger is an icon that, when clicked, displays a (n) ______. A. live tile B. program C. app bar D. menu

D. menu

In Excel, row headings are identified by ________. A. Roman numberals B. lowercase letters C. uppercase letters D. numbers

D. numbers

When you press Enter and formatting marks are turned on, you will see a _________ at the point where you pressed enter A. page break B. soft return C. section break D. paragraph symbol

D. paragraph symbol

Glow is a type of ________. A. picture style B. graphic C. rich media D. picture effect

D. picture effect

All of the following except _____ turns a numbered or bulleted list off. A. clicking the numbering or bullets button B. pressing the Backspace key C pressing Enter two times D. pressing the Esc Key

D. pressing the Esc key

____ mark specific locations on a line of text in a document. A. leader lines B. placeholders C. anchors D. tab stops

D. tab stops

Line spacing refers to ____ A. the number of line on a page B. number of lines that can be ready on a computer screen C. the number of lines of text in a paragraph D. the distance between lines of text in a paragraph

D. the distance between lines of text in a paragraph

Which of the following is the default line spacing of Word 2019? A. Multiple 1.15 spacing B. Multiple 1.08 C. Single Spacing D. distance between lines of texts in a paragraph

D. the distance between lines of text in a paragraph

A conversation that takes place on a discussion board is called a ________. A. sequence B. dialog C. debate D. thread

D. thread

All of the following are tips for professional e-mail etiquette, EXCEPT _______. A. include a meaningful subject line B. be concise and to the point C. use spell- checker and proofread before sending D. use abreviations such as "u", "r", and "BRB" to keep e-mail messages shorter.

D. use abreviations

_____ is the process of modifying a presentation by adding and deleting slides or by changing the contents of individual slides.

Editing

Press ________ to start a slide show from the beginning of a presentation.

F5

E-mails are completely private. T/F

False

What are two contextual tabs that display under Chart Tools when a chart is selected?

Format and Design

_____ refers to changing the appearance of the text, layout, and design of a slide.

Formatting

The default number format for cells is the ____ number format.

General

Which of the following is false about Normal view in Powerpoint.

It displays slide thumbnails on the right.

which of the following does not display to the right side of a selected chart?

Move Chart button

The Notes pane is an area of the ______ that displays below the _______.

Normal View; Slide Pane

Which of the following is not part of a Powerpoint theme?

Pictures

The _____ visually displays which cells are included in a formula calculation.

Range Finder

______ is a procedure that determines which digit to the right of a number will be the last to be displayed.

Rounding

You can use the _____ key to choose a group of contiguous slices.

Shift

Tint charts embedded in a cell that display a visual trend summary alongside your data are called _____.

Sparklines

____ is used to display the contents of a cell on multiple lines.

The Wrap Text command

Which of the following display when the scroll box is moved with the left mouse button?

The slide number and title

A variant offers variations to which of the following?

The theme style and color

In powerpoint, facet is a(n)____

Theme

Where does a presentation outline display on the screen when in Outline View?

To the left of the Slide pane

Which of the following is not an element of a slide layout?

Transitions

With a client-based e-mail account, such as Microsoft Outlook, you are able to view your e-mail only from the computer on which the client program is installed. T/F

True

Which is the following controls the look of the presentation window with a set of commands?

View Buttons

When a cell is part of an active formula, it is surrounded with ________.

a blue border with small boxes on each corner

By default, Word formats bulleted items with a first line indent of ________ and a hanging indent of ________. A. 0.5", 0.5" B. 0.35", 0.5" C. 0.5", 1.0" D. 0.25", 0.5"

D

Paint brush is a a. drawing object b. picture effect c. artistic effect d. picture style

c. artistic style

To create a new Microsoft account, you must provide a(n) ________. A. mailing address B. credit card C. email address D. product key

c. email address

one disadvantage to using a webmail interface is that you can only access your email from your home computer. T/F

false

The Slide pane _____.

is located on the right side of the PowerPoint window when you start a new file.

Which of the following is not part of a list level on a slide?

justification

A(n) _____ tab displays on the ribbon when a picture or image on a slide is selected

picture tools

Text alignment refers to ________.

the horizontal placement of text within a placeholder

Comma Style format displays a number with ________.

two decimal places

When preparing a document for printing, a _______ indicates that only the columns to the left will be printed on the first page.

vertical dotted line between columns

The value axis is also known as the ________.

y-axis

The Percent Style formats selected cells as a percentage with ____.

zero decimal places

You can use the _____ key to choose a group of non contiguous slides.

Ctrl

Picture styles include all of the following EXCEPT ________. A. shadows B. frames C. 3D rotation D. borders

C. 3D rotation

You must click the ________ button to change the active window to fill the entire screen. A. Restore B. Resize C. Maximize D. Expand

C. Maximize

When you receive an email, and you want to reply back to the sender and all of the addresses that were included in the original message, you should use ________. A. Reply B. Bcc: C. Reply All D. Forward

C. Reply all

_____ is a program within Windows 10 that you can use to capture images of all or a portion of your computer screen. A. Cortana B. Snag It Tool C. Snipping Tool D. Freeze Screen Tool

C. Snipping Tool

If the rulers do not display on your Word 2019 screen, click the ________ tab, and select the Ruler check box in the Show group. A. Design B. Layout C. View D. Insert

C. View

When the body of a document is active, the footer or header text is ________. A. bolded B. underlined C. dimmed D. dark blue

C. dimmed

From Backstage view, you can view the document ________ including document title, author name, and subject. A. options B. control panel C. properties D. settings

C. properties

The _____ displays the current cell mode, the page number, and the zoom buttons A. Formula Bar B. Quick Access Toolbar C. Formula Bar D. Name Box

C. status bar

When you type data in a cell and press Enter, what cell becomes the active cell? A. the insertion point does not move B. the cell to the right C. the cell below D. the cell above

C. the cell below

Hold down the ________ key to select nonadjacent cells.

Ctrl