Pt. 1 - Midterm Review INF 101

The Form app: Requires the users to have a desktop version of Excel to be used. Returns the results in a Word file. Allows Forms to be sent to more than one person. Requires Form recipients to have a Microsoft account.

Allows Forms to be sent to more than one person.

Word: Does not allow editing the Table of Contents after it is created. Allows editing the Table of Contents after it is created.

Allows editing the Table of Contents after it is created.

The Online version of Word: Does not permit adding tables. Does not work well with the desktop version. Allows the user to use the desktop version of Word. Does not require Internet access.

Allows the user to use the desktop version of Word.

Using the Online Microsoft apps: Allow you to work directly with them offline with a web browser. Works only with the Microsoft Edge browser. Do not require a browser at all. Allows working with the corresponding desktop application.

Allows working with the corresponding desktop application.

Tables of Contents: Must be entered manually. Are not easy to place into a document. Ignore text using built-in formatting. Are automatic when using built-in formatted text.

Are automatic when using built-in formatted text.

MAX and MIN: Are found in the Engineering functions in Excel. Are found in the Statistical functions in Excel. Must be used with the dialog boxes. Are functions with two arguments.

Are found in the Statistical functions in Excel.

Excel tables: Are inserted using the Layout tab. Are inserted using the Insert tab. Must have user-supplied headers. Are static and cannot be changed.

Are inserted using the Insert tab.

In the MLA style: Author references are included in the text. Should have the word Bibliography for all of the sources cited. There are long citations included in the text. Page numbers are located in the footnotes.

Author references are included in the text.

Select the correct answer about bullet points: Bullet points are applied one by one. Bullet points can have different shapes. Bullet points are right-justified. Bullet points are part of the Styles group.

Bullet points can have different shapes.

Select the correct answer. The citation format depends on the type of style (APA, MLA, Chicago). The information required for different sources is the same. Word does not keep a record of the sources entered. There is no way to use sources entered in a new document.

The citation format depends on the type of style (APA, MLA, Chicago).

Which are examples of conditional formatting. Data Bars Tables Data Extracts Using the if function to change values

Data Bars

In using this online text (Great River Learning): Assignments are uploaded into the Resources area. Files used for assignments are often found in the Resources area. Projects to be turned in weekly are uploaded into the Resources area. The syllabus is located in the Assignments area.

Files used for assignments are often found in the Resources area.

When you create a table by the insert table command and dragging the mouse over a matrix: Word automatically centers the table. Word autofits the content into the cells. Word bolds the entries in the top row. Word creates cells of the same size.

Word creates cells of the same size.

In using filters in Excel (select all that apply): You can select all of the item types at once. You can deselect all of the items and then pick one. You can filter once, and then select a new filter to filter the data again.

You can select all of the item types at once. You can deselect all of the items and then pick one. You can filter once, and then select a new filter to filter the data again.

You can adjust the size of a column in a table by: using the tab key. using the ctrl-tab keys. displaying the ruler and dragging a mesh-looking icon on the ruler. right-clicking the right border of a cell.

displaying the ruler and dragging a mesh-looking icon on the ruler.

Excel tables: allow only one sort. allow only one filter. do not allow removing the table after it is applied to data. do have an option to remove the table features while leaving the data.

do have an option to remove the table features while leaving the data.

Word: does not permit creating a table directly below another table. does not permit creating a table directly beside another table. does not allow splitting a table horizontally allows splitting a table vertically.

does not permit creating a table directly beside another table.

When creating a macro in Word: you can save the macro without stopping it first. there is an option to use a keyboard shortcut to initiate it. after saving it, you cannot delete it. there is only one way to stop recording the macro.

there is an option to use a keyboard shortcut to initiate it.

Word: requires use of a dialog box for creating tables. displays only printable borders. disallows merging cells in tables. uses ctrl-tab to tab within cells.

uses ctrl-tab to tab within cells.

The resume: is a document that stands alone and should be submitted alone. is a type of one-size-fits-all document. should be as generic as possible. should be targeted to the position.

should be targeted to the position.

The cover letter: is often nonessential. should be generic. should target one's skills to the position. should only concentrate on one's skills.

should target one's skills to the position.

The paragraph marker (show/hide) button shows the following characters except: the tab character. the paragraph character. the underscore character. the end of cell character.

the underscore character.

Files (check all that apply): Can be compressed by Macs and PCs. Can only be compressed singly. Are actually slightly larger when compressed. Are compressed when they have the .zip extension.

Can be compressed by Macs and PCs. Are compressed when they have the .zip extension.

Bookmarks: Can be found by clicking the Bookmark icon under the Insert tab. Must be found only by using the Find icon under the Home tab. Cannot be deleted. Bookmark names cannot be edited.

Can be found by clicking the Bookmark icon under the Insert tab.

Bookmarks: Must always be linked to text. Are found using the Replace function. Are not shared with others. Can be linked to location.

Can be linked to location.

OneDrive files: Can be synced with desktop files. Always require Internet access. Use a save button when working with the Online versions of Office. Can be saved in only one format for each of the Online Office applications.

Can be synced with desktop files.

OneDrive files: Can be viewed as tiles or as lists. Are difficult to download. Cannot be compressed. Cannot be shared with others easily.

Can be viewed as tiles or as lists.

Frequency Distribution functions: Count the number of items based on the intervals between numbers. Are not done in Excel. Must be done with the countifs formula. Can only be done one way in Excel.

Count the number of items based on the intervals between numbers.

Select the correct answer. Adding new sheets to a spreadsheet is difficult. You must leave the default names on the tabs of the new sheets. Moving data from one sheet to a new sheet is difficult. Creating new sheets can help organize and display data in a more effective way.

Creating new sheets can help organize and display data in a more effective way.

In using filters in Excel (select all that apply): Once you apply a filter you cannot undo it (except by using the Quick Access Toolbar). Filters can be used in order to find a count of items. Filters can be used to increase the number of items seen. There is a remove filter option (clear filter).

Filters can be used in order to find a count of items. There is a remove filter option (clear filter).

Word: Only has a manual option for aligning text vertically on a page. Has an option to align text vertically on a page.

Has an option to align text vertically on a page.

Microsoft Office (check all that apply): Has no advantage over Google because both Microsoft and Google have only online versions of applications. Has more features than Google Apps because of the desktop versions of the software. Has no advantage over Google because Google has online storage and Microsoft does not. Has one big advantage because the desktop versions work off-line.

Has more features than Google Apps because of the desktop versions of the software. Has one big advantage because the desktop versions work off-line.

The Form app: Requires survey creators to know how to use Excel. Does not permit any long answers. Includes a short text answer. Is not shareable.

Includes a short text answer.

The frequency function (select all of the correct answers): Is an array function. Is a CSE function. Works with numbers in ascending order.

Is an array function. Is a CSE function. Works with numbers in ascending order.

OneDrive (check all that apply): Is free (although one can pay for additional storage). Requires a Microsoft account. Requires a login for access and can be accessed with an app on your desktop, laptop, or smart device.

Is free (although one can pay for additional storage). Requires a Microsoft account. Requires a login for access and can be accessed with an app on your desktop, laptop, or smart device.

The Microsoft Office desktop version(s): Has the same features as the online version. Can be run by an iPad. Can be run by a Chromebook. Is the full-featured version of Office.

Is the full-featured version of Office.

Captions: All have the same format. Are always above the item (figure, image, or table). May properly be placed below or above the item depending on the type of item (figure, image, or table). Are not required for research papers or journal articles.

May properly be placed below or above the item depending on the type of item (figure, image, or table).

Pick the correct answer: When using headers the first page has to be just like all the other pages. Page numbers can be placed in various places in headers and footers. Filenames can be placed in footers but not headers. Footers typically have different information on different pages.

Page numbers can be placed in various places in headers and footers.

The frequency function (select all of the correct answers): Requires selecting a single cell and then it fills in the range of cells. Requires selecting multiple cells in order to insert the formula into all cells at once. Requires the bins numbers to be the mid-range of the intervals chosen. Requires the bins numbers to be the maximum numbers in the intervals chosen.

Requires selecting multiple cells in order to insert the formula into all cells at once. Requires the bins numbers to be the maximum numbers in the intervals chosen.

To enter the frequency function from the dialog box: Requires using the enter key or clicking on OK. Requires using ctrl, alt, enter. Requires using ctrl, windows key, enter. Requires using ctrl, shift, enter.

Requires using ctrl, shift, enter.

Concerning resumes: Academic resumes are modeled after business resumes. Business resumes are typically long. Business resumes are uniform. Specialty resumes (such as for grants) have specific requirements.

Specialty resumes (such as for grants) have specific requirements.

(T/F) The spacing before and after paragraphs is adjusted using a dialog box.

TRUE

(T/F) Word supports multiple research papers styles.

TRUE

(T/F) You can add a row to a table by placing the cursor in the last cell in the last row and press the tab key.

TRUE

Select the correct answers. Data Bars work primarily with text in cells. Data Bars display little pie charts. The Highlight Cells Rules Between option reformats cells based on text in the cells. The Highlight Cells Rules Between option reformats cells based on numeric values.

The Highlight Cells Rules Between option reformats cells based on numeric values.

Select the correct answers: The count function only works with numbers. The countif function can work with numbers as well as text. The countif function takes two arguments.

The count function only works with numbers. The countif function can work with numbers as well as text. The countif function takes two arguments.

When you Convert a table to a Range (select all that apply) Some of the table functions still can be used. All added formatting is removed. Used with an extracted table, all of the data returns to view. Is quite useful in keeping the new formatting that has been applied to the table.

Used with an extracted table, all of the data returns to view. Is quite useful in keeping the new formatting that has been applied to the table.

The MLA style: Uses a font size of 11 pts. Uses a font size of 10 pts. Uses Calibri. Uses Arial.

Uses Arial.

Word: Uses the hyperlink function to enter email addresses. Allows hyperlinked email addresses but requires manual entry.

Uses the hyperlink function to enter email addresses.

When you set a right tab: after tabbing over to the right tab the text moves to the right when you type. after tabbing over to the right tab the text moves to the left when you type.

after tabbing over to the right tab the text moves to the left when you type.

If you decrease the indent for a paragraph: that is the same as resetting the tab. all of the text in the paragraph will be moved to the left.

all of the text in the paragraph will be moved to the left.

Word: allows merging and splitting cells in a table. never uses the tab key to create new rows. uses the alt-tab keys to create new rows. does not permit having bulleted text in a cell.

allows merging and splitting cells in a table.

MLA-style Footnotes: have a different font size from the body of the text. are double-spaced. are single-spaced. do not have a first line indent.

are single-spaced.

Quick Parts: are created by recording one's keystrokes. are used by clicking on tiny icons on the Quick Access Toolbar. are typically a block of formatted text you often reuse. require knowing a programming language to create.

are typically a block of formatted text you often reuse.

Paragraphs of text: are typically left-justified (left-aligned) for readability. are typically left and right-justified. are typically only right-justified. always include more than one line of text.

are typically left-justified (left-aligned) for readability.

Hyperlinks: are removed in research papers. are typically underlined and blue. have no particular formatting. are difficult to remove.

are typically underlined and blue.

The format painter: copies content from one place to another. only copies bold, underline, and italicize types of formatting. can be used to copy the same format multiple times. mainly paints different colors of text.

can be used to copy the same format multiple times.

The Screenshot option in Word: is only used to take a screenshot of whole screens. can be used to take a screen clip (a selected part of a screen). requires a program running in the background to be minimized. requires the desired program running in the background to be the first one displayed.

can be used to take a screen clip (a selected part of a screen).

The Works Cited page: includes all references used while researching a topic. is static and cannot be changed. is difficult to insert into a document. changes when a reference is deleted in a document and the page is updated.

changes when a reference is deleted in a document and the page is updated.

Keyboard shortcuts help users be much more efficient. What combination cuts texts and then pastes it?

ctrl-x, ctrl-v

Standard business letters: have the date after the inside address. have the date after the return address. have the inside address directly below the return address. have the body directly below the inside address.

have the date after the return address.

Macros: always require learning a programming language. are always difficult to create but easy to use. always work for only the document in which they were created. in Word can be created by recording keystrokes.

in Word can be created by recording keystrokes.

Hanging indents: indent the first line of a paragraph but leave the other lines alone. right-align the lines of a paragraph following the first line. indent all the lines of a paragraph except the first line. left-align all the lines of a paragraph except the first line.

indent all the lines of a paragraph except the first line.

Decrease indent: is used to move selected text to the left. is used to move selected text to the right.

is used to move selected text to the left.

Section breaks: have no special functions in Word. make it possible to apply different formatting to different parts of a document. always use the same style of page numbering as the main body of the document. should not be used to separate a title page from the rest of the document.

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