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.
