Pt. 3 - Midterm Review INF 101

Chromebooks can run: Office 2016 (Android) Office apps iOS apps Office 365 (full version)

(Android) Office apps

Autosum

A button that gives quick access to the Sum function.

Dialog Box

A dialog box is a temporary window created to retrieve user input.

Compress files

A technique by which the logical size of a file is reduced. Usually the file is much smaller after compression.

In the MLA style how do you enter a page number in a citation?

After clicking the citation in the text (Allen 210 b-c), Word presents the option to Edit the Citation or Edit the Source. Pick Edit Citation. Then a new dialog box appears in which you can add or change page numbers.

What does Word's Inspect document function do?

After inspecting the document, Word will remind you that the author of the document is visible so that you can remove your name. If any comments remain, Word will give you the option of looking at them or removing them all. If any changes need to be accepted or rejected, that will be noted. Word also flags accessibility issues. If you have an image in your document but do not have text (alternate text) associated with the image, that is flagged. Other hidden text is identified.

Define cross-platform.

Applications able to be run on different computers, software applications, or operating systems

How does Word's autocorrect feature work? Can it be customized?

Autocorrect in Word is text replacement or a form of correction as you type You can add your AutoCorrect items.

How do we automate using tables of contents in Word?

By creating headings using the official headings options you can save a lot of time. In this way, Word does the hard work for you. By planning ahead and using Heading 1, Heading 2, and so on, you can have Word create a nicely formatted Table of Contents automatically (References tab)

OneDrive files

Can be shared. · Can have links shared via email

Synched

Changes made by one person on a file (no matter what device is used) changes that file for all who share the file. Also, changes made to a OneDrive file on a local drive create changes on the OneDrive file in the cloud.

Non-printing characters

Characters in the document that do not print. Examples: tab, space, enter (the paragraph symbol, ¶)

The Excel Survey or Form has what options? · Yes/No questions. · Short text · Long text · Other?

Choice, Text, Rating, Date and and down arrow for more options. When you want a yes/no question, use the Choice option and choose the yes, no, maybe option. When you choose the Text option, you can allow a short or a long response.

Creating Zip files

Compresses files. · Can be done by Macs and PCs.

What are the shortcut keys for:

Copying selections, delete selections, pasting selections, centering text, left-aligning text, right-alighning text

What are QuickParts and how are they used?

Create the text that you type repeatedly. Select it. Go to the Insert Tab, Text Group, Quick Parts selection. Give it a name. Save it to the Quick Parts Gallery. When you want to insert the text into your document go to Insert, Text Group, Quick Parts option, and select it from the Gallery.

How can you use the format painter more than once?

Double-click it with the left mouse button.

In Excel is text left-aligned in the cell or right-aligned? Are numbers left-aligned or right-aligned?

Excel displays text as left-aligned in the cell. Numbers are displayed as right-aligned.

In applying conditional formatting the user selects the type of conditional formatting first and then specifies the range.

F

(T/F) The insertion point is a blinking arrow in a document.

False

How does one create a Macro? What is a Macro in Word?

Go to the View Tab and find the Macros group. Click on Macros. Select Record Macro. Create a name for your Macro. Start recording. Then do everything you need to do to accomplish some task. Stop the recording. ***Behind the scenes, Word creates a Visual Basic file that records the keystrokes and attaches it to the document (or document template). Visual Basic is a programming language created by Microsoft

How does Microsoft's OneDrive work? · Only in the cloud? · On the desktop and in the cloud. Explain.

If you download the OneDrive app for Windows or for the Mac OS, you will have a seamless way of saving files to your local computer and to OneDrive.

What are bookmarks in documents? What is their function?

If you have inserted bookmarks in a document, the reader can go to the Insert tab, Links group, Bookmark icon, and click on that. If the reader knows the name of the bookmark, the reader then clicks on the bookmark name and the Go to button to move to that location. Some knowledgeable users (nerdy users?) use bookmarks to navigate long documents by selecting strategic locations to bookmark.

In the MLA style - how does Works Cited differ from a Bibliography?

In Works Cited you only list items you have actually cited. In a Bibliography you list all of the material you have consulted in preparing your essay whether or not you have actually cited the work.

Formula bar

Location in Excel that displays the value or the formula contained in a selected cell.

Name box

Location on the Excel window that displays the name of the selected cell, table, object, or chart.

What is metadata about files?

Metadata is information about the file. The metadata usually has the name of the owner of the computer, the date that a file was created, the date the file was last modified, file size, number of pages, who modified the file, and other information.

The primary version of Office used in the course is

Office 2016 or Office 365

Footnotes

Some style manuals, particularly those based on the Chicago Manual of Style, will use footnotes for citation purposes. The MLA and APA use footnotes to provide additional information.

(T/F) After you save to OneDrive, it will save your file automatically as you type.

T

An advantage in using tables for resumes is the ability to adjust column size easily.

T

Filters reduce the amount of data after being applied.

T

If the person you are sharing the document with does not have a Microsoft account or a desktop version of Office, when they click on the View in OneDrive button the Online version of Word will let them view or edit the document. If they do have a OneDrive account and a desktop version of Word they will have the option to edit the document with the desktop or the online version of Word.

T

In conditional formatting, if a cell meets a certain condition (criteria) then the cell is reformatted.

T

The Forms app takes us through the process of building the form (survey), and it provides the option to look at the results in an Excel spreadsheet. We use this app to create a form that we then send to others to fill out. The results are then viewable instantly either by viewing the responses in the app or by using Excel to view them.

T

Clipboard

The Clipboard is where information is stored temporarily when copying or cutting.

Backstage View

The Office Backstage view is where you manage your files. Click on the File tab to open the backstage view.

Pick all that are correct. The countif function just requires a range. The count function just requires a range. The countif function can count cells that have specified text or specified numbers. The syntax for the countif function requires quotes for words.

The count function just requires a range. The countif function can count cells that have specified text or specified numbers. The syntax for the countif function requires quotes for words.

Pick the correct answer. To insert the frequency function in all of the cells for the distribution, press Enter or OK in the dialog box. The frequency function is a CSE function. The Bins array must be in descending order. In each Bin of the Bin array the number is always the lowest number in each interval.

The frequency function is a CSE function.

The Ribbon

The ribbon is a set of tabs that contain toolbars at the top of the window in Office applications to display graphical representations of tools. The ribbon presents different toolbars depending on the context.

fill handle

The small square in the lower right corner of a selected cell.

What are typical commands or functions on the Quick Access Toolbar?

Undo, redo, save, macros

Choose all the correct answers. Users use Excel tables for filtering data. Users use Excel tables to extract data. Users prefer normal formatting to table formatting. Users use Excel tables for sorting data.

Users use Excel tables for filtering data. Users use Excel tables to extract data. Users use Excel tables for sorting data.

What does track changes do?

Word identifies who makes changes to the text. Word will prompt you to click on Share to see who is editing your document. You will see the original text and the changed text. Distinct colors are used for different authors.

Highlighting: how can you protect your document?

You can password-protect your document and you can share it but only as read-only.

cells

a box at the intersection of a row and a column that holds data.

data series

a row or column of numbers that Excel plots on a chart.

range

a series of two or more adjacent cells in a column, row, or rectangular group of cells

The format painter · How can it be used multiple times? · Does it copy text or copy formatting?

copies formatting double-click on the Format Painter and then click on multiple entries to transfer the format multiple times.

When you share a document with others

it can be edited by the online version of Word or by the desktop version.

Section breaks

make it possible to apply different formatting to different parts of a document.

The Microsoft apps can be used by anyone. They run on all major devices and operating systems. In that way they are cross-_________. Google apps are not cross-___________.

platform

What are the functions of cover letters?

the cover letter helps you to put your resume in context and helps shape the expectations of the reader. In the letter, you should emphasize why you are a good fit for the company and highlight your skills.

To share a link to a document

the document must be saved to OneDrive (or other drive in the cloud).

The name of the cell is

the name of the column followed by the name of the row.

To share a link to a document

the person receiving it need not have a Microsoft account.

relative reference

the reference is adjusted for the position of the cell

category names

the titles identifying the slices of the pie chart. Also, for other charts the category axis of a chart (the x axis for a bar chart) is often contrasted with the value axis (the y axis)

underlying value

the underlying value of a cell is the actual value (as opposed to the formatted value) or the formula that is used to calculate a value

displayed value

the value displayed in a cell after it has been entered in the cell

What can you do in Word table cells?

· Add tab stops · Add new rows by using the tab key in the last cell · Center text vertically and horizontally · Have multiple paragraphs

What all does the paragraph dialog box do?

· Control paragraph spacing between lines · Control first line indent

Who has access to OneDrive?

· Everyone who sets up an account.

What are some similarities and differences between Google Apps and Microsoft Applications (cloud and desktop)?

· Google Apps basically only in the cloud. · Microsoft - both in the cloud and on the desktop. o Advantage: can work off-line, and the desktop applications have many more capabilities

How does one share documents in Word?

· Save to the cloud first. · Share links. · Sharing read only or with edit access.

How does saving files differ using the Microsoft Online apps vs. the desktop apps?

· The Save button · OneDrive synch on the PC or Mac