CSCI Final

The ____ button allows you to erase recent cell entries.

Undo

With more than ____ predefined color schemes, Word provides a simple way to select colors that work well together.

20

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

26

If you use the ___ template, as opposed to a formatted theme, you must make all design decisions.​

Blank Presentation

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

What effect does the Accounting Number Format have on the selected cells?

Displays cell contents with two decimal places that align vertically

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.

Graphics

Which of the following keys moves the insertion point to the beginning of data in a cell?

HOME

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page Layout

____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point.

Pasting

The Undo button is located on the ____.

Quick Access Toolbar

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

RIGHT ARROW

A ____ is a specific design with coordinating colors, fonts, and special effects.

document theme

As you type, Excel displays the entry in the ____ bar.​

formula

A ____ is a prewritten formula that is built into Excel.

function

​A ____ is a set of choices, often graphical, arranged in a grid or in a list.

gallery

____ is one color shade gradually progressing to another shade of the same color or to another color.

gradient fill

Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.

horizontal ruler

The buttons, arrows, and boxes on the mini toolbar vary, depending on whether you are using Touch mode versus ____ mode.​

mouse

​Microsoft OneNote replaces physical _____, _____, and ______ with a searchable, digital notebook.

notebooks, binders, paper notes

Which of the following techniques will allow Frank to select an entire sentence?

press and hold down the CTRL key and then click the sentence

The basic unit of a PowerPoint presentation is a ____.​

slide

When you open a new presentation, a slide with the default ____ layout appears.

title slide

Press the ____ key(s) to erase one character to the right of the insertion point.

DELETE

The file type ____ identifies a Word 2016 document.

.docx

____ determines the overall lightness or darkness of an entire image.

Brightness

PowerPoint assumes every new slide, except for a blank slide, has ____.

a title

The ____ feature automatically locates specific text and then replaces it with desired text.

find and replace

The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.

font

An accompanying ____ gives audience members reference notes and review material for your presentation.

handout

Using the____, you can choose the arrangement of placeholders on a new slide.

layout gallery

Combining two or more selected cells into one cell is called ____ cells.

merging

​Microsoft OneNote is a __________________ app for your academic and professional life.

notetaking

To increase the font size of selected text, chose the Increase Font Size button, located ____.

on the mini toolbar

Headers print in the top margin ____ inch from the top of every page.

one-half

To enter data in a cell, you must first select the ____.

cell

Which of the following changes you make to your text is an example of paragraph formatting?

centering all of the lines of text on the title page

A document theme sets the ___ for a presentation​

color scheme, font and set layout

PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.

predefined

A word with a meaning similar to that of another word is called a ____.

synonym

A slide ____ is a special effect used to progress from one slide to the next slide in a slide show.

transition

____ allows you to see through the background, so that any text on the slide is visible.

transparency

Frank would like to be able to select a full paragraph. Which of the following techniques will work?

triple-click the paragraph

Press the ENTER key in all of the following circumstances EXCEPT ____.

when the insertion point reaches the right margin

To create a new folder, press ____.​

​CTRL+SHIFT+N

​Consider the Hub in Microsoft Edge as

​one-stop access to all the things you collect on the Web.

​​The Microsoft OneNote mobile app

​​is a lightweight version of OneNote 2016.

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

​Consider the ______in Microsoft Edge as providing one-stop access to all the things you collect on the web.

Hub

​Office Mix will run on which types of operating systems/devices? (select all that apply)

PCs, Macs, iOS devices, Android devices

____ is/are used to place worksheet, column, and row titles on a worksheet.

Text

To right-align a paragraph, use the ____ shortcut keys.

CTRL+R

Which of the following keys do you recommend to your colleague for adding a hanging indent?

CTRL+T

To move up one paragraph, press the ____ key(s).

CTRL+UP ARROW

____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.

Character

​____ in a suite typically use a similar interface and share features.

Apps

Which of the following allows you to remove character formatting?

Press the CTRL+SPACEBAR keys.

When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.

Title and Content

When you decrease the row height to ____, the row is hidden.

0

Excel remembers the last ____ actions you have completed.

100

On most computers, the default font size in Word is ____.

11

When you install PowerPoint, the default setting allows you to reverse up to the last ____ changes by tapping or clicking the Undo button on the Quick Access Toolbar.

20

When you click the ____ button for a selected graphic, Word provides options for changing how a graphic is positioned with text in a document.

Layout Options

By default, the Normal style places ____ points of blank space after each paragraph.

8

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

8.43

Which of the following calculations multiplies 23 by 0.01?

=23%

All of the following are valid Excel arithmetic operators EXCEPT ____.

>

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accounting number format

____ are types of changes that occur when text has been omitted from a document and must be inserted later.

Additions

You can click the ____ button to undo an automatic correction.

AutoCorrect Options

To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items.

CTRL

Press ____ to select the entire worksheet.

CTRL+A

The shortcut keys used to center a paragraph are ____.

CTRL+E

To move to the end of the document, press the ____ key(s).

CTRL+END

You can insert a new slide by pressing the ____ keyboard shortcut keys.

CTRL+M

____ is the difference between the darkest and lightest areas of an image.

Contrast

Which of the following keys moves the insertion point to the end of data in a cell?

END

Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.

ENTER

If you want to remove the AutoCorrect Options button from the screen, you can press the ____ key.

ESC

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

After three months, Anna wants to the know the average distance she runs. What should she do to calculate the average distance?

Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument.

Which of the following happens when you enter the formula =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

You can type comments to yourself in the ____ for a specific slide while working in Normal view.

Notes pane

____ is a powerful communications and scheduling app that helps you communicate with others, among other things.​

Outlook

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.

Shapes

​In Office Mix, the Slide Notes feature works as a ____________, to help you focus on your content instead of memorizing a presentation.

TelePrompTer

___ are the alternate designs that exist for each theme.​

Variants

____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.

Zooming

Which of the following is a standard document property?

author

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

colon (:)

A database management system is software that allows you to use a computer to _____.​

create queries & add, change or delete date & create forms and reports

With ____ editing, Word automatically displays a Paste Options button near the pasted or moved text.

drag-and-drop

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.

presentation

When you use the keyboard to scroll to a different position in the document, the ____ automatically moves when you press the desired keys.

insertion point

By default, slides in a new presentation are in ____ orientation.

landscape

To center a page's contents vertically between the top and bottom margins, click the Page Setup Dialog Box Launcher, click the ____ tab, click the vertical alignment box arrow, click Center in the list, and then click the OK button.

layout

A(n) ____ is a computer program that coordinates all the activities of computer hardware.​

operating system

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

operations

The WordArt ____ is the exterior border surrounding each letter or symbol.

outline

____ adds designs that repeat in rows across a slide.

pattern fill

Formatting text in a shape follows the same techniques as formatting text in a ____.

placeholder

A cell is referred to by its cell ____.​

reference

The adjusted cell references in a copied and pasted formula are called ____ cell references.

relative

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.

rotate

​Each OneNote notebook contains _____, _____, and _____.

sections, pages, other notebooks

Adding a ____ to text adds depth and helps the letters display prominently.

shadow

Footnote text is _____.

single-spaced, left-aligned, and a smaller font size than the text in the research paper

The small squares and circles around a selected graphic are called ____ handles.

sizing

Ellie asks you about the component located at the bottom of the document window. You tell her that it is used to present information about the document, the progress of current tasks, and controls for viewing the document. What is the name of this component?​

status bar

PowerPoint displays many ____ that are varied and appealing and give you an excellent start at designing a presentation.

themes

Word includes a variety of document ____ to assist you with coordinating visual elements in a document.

themes

A(n) ____ is a book of synonyms.

thesaurus

​With Sway, you can (select all that apply)

​Drag content from the search results right into the Storyline. & ​specify the source of the media, so you can add Facebook or OneNote pictures and videos without leaving the app.

Which mode hides all commands and just displays a document?​

​Full Screen mode

____ view shows the document on a mock sheet of paper in the document window.​

​Print Layout

The maximize button changes to the ____ button after you click it.​

​Restore Down

____ indicates the number of pixels that a computer uses to display the letters, numbers, graphics, and background on a screen.​

​Screen resolution

The ____ command exits running apps, shuts down Windows, and then turns off the computer.​

​Shut down

​To add content to Sway from search results, you

​drag the content right into Sway.

​Using Office Mix, you can (select all that apply)

​insert interactive elements sucha as quizzes and live webpages directly into PowerPoint slides. & ​capture still and moving images on your desktop. & ​record yourself on video.

A(n) ____ window is an open window hidden from view but that can be displayed quickly by clicking the window's app button on the taskbar.​

​minimized

The ____ presents information about the document, the progress of current tasks, and the status of certain commands and keys.​

​status bar

​To share an Office Mix presentation,

​upload it to your personal Office Mix dashboard.

​​Microsoft Sway utilizes Responsive Design, which means

​​your content adapts perfectly to any screen size.