College Computing6

51) (Excel) This function adds all the numbers given in a range of cells. A - SUM B - ADD C - INC D - DEC

A - SUM

100) (Word) It is possible to merge the cells in an entire row together into a single merged cell. True or False? A - True B - False

A - True

26) (Excel) To save an Excel workbook using a different format, location, or filename click the File tab from the Excel ribbon and choose: A - Save B - Save As C - New D - Open

B - Save As

99) (Word) If you've applied a column setting that you do not like, what is an easy way to reverse the procedure and go back to what you had before? A - click the redo button in the Quick Access Toolbar B - click the undo button in the Quick Access Toolbar C - hit the backspace key on the keyboard D - choose "Edit" and "Clear all formats"

B - click the undo button in the Quick Access Toolbar

4) Which protocol allows for the dynamic translation of a domain name into the correct IP address? A - SMTP B - IP C - DNS D - HTTP

C - DNS

41) (Excel) Applying Excel's Percent Style number format to the decimal value 0.17 will result in which of the following being displayed in the cell? A - 0.0017% B - $17.00 C - 17% D - $17

C - 17%

48) (Excel) All formulas begin with the ____________ sign. A - + (plus) B - - (minus) C - = (equal) D - * (asterisk)

C - = (equal)

83) (Word) What feature from the Word References tab tell the reader what source(s) you used in coming up with the information you just typed? A - quotes B - comments C - revisions D - citations

D - citations

58) (Excel) To make a cell reference absolute, ____________ are inserted into the cell reference. A - exclamation marks B - parenthesis C - brackets D - dollar signs

D - dollar signs

70) (Excel) Items such as a chart title, gridlines, data labels, and so on that can be added to a chart are commonly referred to as chart _____. A - events B - attributes C - documentation D - elements

D - elements

75) (Word) A typeface variation, such as Times New Roman or Calibri, that defines how text appears is referred to as a _____. A - superscript B - style C - hidden character D - font

D - font

91) (Word) Phrases and punctuation that differ from Word's grammar rules are marked with a(n)? A - purple underline. B - red wavy underline. C - underline. D - green wavy underline.

D - green wavy underline.

88) (Word) Which of the following terms refers to a connection to a location in the current document, another document, or to a Web site? A - hotlink B - HTM C - URL D - hyperlink

D - hyperlink

54) (Excel) The mathematical rule that Excel follows to perform calculations in a formula in the proper order is called the: A - order of the exponents B - order of expressions C - order of functions D - order of operations

D - order of operations

49) (Excel) A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell ____ . A - square B - border C - block D - range

D - range

55) (Excel) Which operation in the formula =B5/(C6+C7)*2 will be processed first? A - addition B - multiplication C - division D - exponentiation

A - addition

57) (Excel) Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2? A - =A2*B2 B - =B1*C1 C - =A1*B1 D - =B2*C2

A - =A2*B2

60) (Excel) Which of the following functions could be used in finding the largest value from cells C2 through C25? A - =MAX(C2:C25) B - =MIN(C2:C25) C - =HIGHEST(C2:C25) D - =SUM(C2:C25)

A - =MAX(C2:C25)

15) (Excel) Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of the worksheet whose cell reference is given by: A - A1 B - 1A C - 0A D - A0

A - A1

25) (Excel) By clicking the File tab from the Excel ribbon, you have entered the _________ view. A - Backstage B - Compatibility C - Print Layout D - Presentation

A - Backstage

13) (Excel) The default name for an Excel file is _______. A - Book1 B - Document1 C - Presentation1 D - DefaultDoc

A - Book1

19) (Excel) If you wish to DUPLICATE the contents of a range of cells to another portion of the worksheet, which command will you use: Copy or Cut? A - Copy B- Cut

A - Copy

36) (Excel) ____________ is used to copy the formatting of one cell to other cells. A - Format Painter B - Fill color C - AutoFit D - Format theme

A - Format Painter

17) (Excel) This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell. A - Formula B - Format C - Standard D - Title

A - Formula

6) (Word) Word uses what style to create a table of contents? A - Heading B - Normal C - Header D - Body

A - Heading

32) (Excel) Which Excel ribbon tab contains the Font group which allows you to change the font type, size, and color? A - Home B - Insert C - Page Layout D - Formulas

A - Home

8) (Word) Of the three standard paper sizes in the US, which one is 8.5" wide by 11" inches tall in size? A - Letter size B - Legal size C - Tabloid size D - none of the above

A - Letter size

7) (Word) A powerful tool that lets you create letters, e-mails, or address labels for many different recipients, pulling information from a customer list or a database is called: A - Mail Merge B - Letter Wizard C - Reference List D - Citation Sources

A - Mail Merge

43) (Excel) Suppose you enter the date 4/12/14 in cell A1 and choose the Long Date number format from the Number group of the Home ribbon tab. What will be displayed in cell A1? A - Saturday, April 12, 2014 B - 04/12/2014 C - 4/12/2014 D - 41741.00

A - Saturday, April 12, 2014

96) (Word) Click the _______ button from the Paragraph group of the Home tab in Word to turn on the display of nonprinting formatting characters such as the Paragraph Mark. A - Show/Hide B - Line Spacing C - Sort D - Borders

A - Show/Hide

5) (Word) Table of contents commonly make use of hyperlinks to allow readers to quickly jump to various sections of a large document. True or False? A - True B - False

A - True

76) (Word) Word allows you to save files in a PDF format. True or False? A - True B - False

A - True

40) (Excel) Use the ____________ command to display text on two lines within a cell and to keep the contents of a cell from extending beyond the its column width and running over into the cells next to it. A - Wrap Text B - Insert Row C - Align Text D - Merge and Center

A - Wrap Text

46) (Excel) Flash Fill is: A - an Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data. B - a command in Microsoft Office applications that enables users to search for instances of specific text or numerical data in workbooks or documents. C - the action of locking rows and columns in place so that they remain onscreen as the viewer scrolls through a workbook. D - an Excel method that lets you gather data from multiple worksheets or workbooks into a master worksheet that acts as a summary.

A - an Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data.

69) (Excel) Prior to creating a chart, it is important to: A - select/highlight the data you wish to chart B - format all of the data in the worksheet as a table C - create a separate worksheet for the chart D - save the worksheet in an HTML format

A - select/highlight the data you wish to chart

34) (Excel) Cell ________ such as Heading and Title allow you to apply multiple formats to a cell at once. A - styles B - borders C - themes D - groupings

A - styles

84) (Word) When you create a new document in Word, you can either create a new blank document or you can choose to pick one of the pre-formatted documents, known as______, that may already include headings and titles formatted in particular fonts and colors. A - templates B - recipes C - forms D - placeholders

A - templates

9) (Excel) An Excel file is referred to as a: A - workbook B - document C - database D - presentation

A - workbook

18) (Excel) If you wish to MOVE the contents of one cell to another cell, which command will you use: Copy or Cut? A - Copy B - Cut

B - Cut

21) (Excel) Excel 2016 files have names that end with a default file extension of ____ . A - .docx B - .xlsx C - .html D - .txt

B - .xlsx

50) (Excel) Which of the following formulas is written in the correct syntax? A - =SUM(A1=B1) B - =SUM(A1:D1) C - SUM(D2-A2)

B - =SUM(A1:D1)

97) (Word) The ____ can be automatically generated from the document's citation sources. A - Table of Contents B - Bibliography C - Title Page D - Caption

B - Bibliography

65) (Excel) To automatically add row and column headers and analyze a group of related data independently from other cells in the worksheet, you can convert a range of cells to a(n): A - grouped workbook B - Excel table C - data bar D - data filter

B - Excel table

39) (Excel) Once a set of cell's in Excel have been combined (or merged), they can never be split apart. True or False? A - True B - False

B - False

63) (Excel) What is the result of the Excel formula =AND(4=4, 15<=9)? A - True B - False

B - False

66) (Excel) Once data has been formatted as a table in Excel, the tabular format cannot be deleted or removed. True or False? A - True B - False

B - False

72) (Word) Once a table is drawn, you cannot alter its dimensions by inserting/deleting rows or columns. True or False? A - True B - False

B - False

73) (Word) Page numbering is done automatically in Word and there is no way to manually adjust the page number for a given page. True or False? A - True B - False

B - False

77) (Word) Paragraph spacing settings apply globally to the entire document. You are not allowed to have different line spacing settings for different paragraphs in the same document. True or False? A - True B - False

B - False

85) (Word) When creating a table in Word, you must use one of pre-formatted table templates and have very few options in customizing the structure and look of the table. True or False? A - True B - False

B - False

3) (Windows) You have configured your Windows devices at home as a HomeGroup on the network. Which Windows 10 system utility would best be used to share files on your computer with the other HomeGroup devices? A - Internet Explorer B - File Explorer C - the Settings gear cog D - the Device Manager

B - File Explorer

45) (Excel) In Excel, a black symbol in the lower right-hand corner of the active cell. Users can click and drag the fill handle to copy cell contents or create a series. A - Copy handle. B - Fill handle. C - Range handle. D - Entry handle.

B - Fill handle.

30) (Excel) The date and page number of an Excel workbook are commonly placed in a: A - File B - Header or footer C - Margin D - Text box

B - Header or footer

87) (Word) Which Word ribbon tab contains the most commonly used command functions such as copying and pasting, changing fonts, and setting paragraph formatting options? A - View B - Home C - File D - Page Layout

B - Home

74) (Word) Which page orientation turns the paper on its side and prints as 11 inches wide by 8.5 inches tall? A - Portrait B - Landscape C - Mirrored D - Legal

B - Landscape

28) (Excel) Which page orientation prints the worksheet on paper that is wider than it is tall? A - Portrait Orientation B - Landscape Orientation

B - Landscape Orientation

79) (Word) This Word command will save the active file using the same file name by replacing the contents of the existing file with the document as it appears on the screen. A - Save and Replace B - Save C - Save Only D - Save As

B - Save

81) (Word) The act of changing a font's color, italicizing it, applying bold, or changing its size is called ______. A - highlighting B - formatting C - proof reading D - aligning

B - formatting

52) (Excel) Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally referred to as: A - calculators B - functions C - commands D - summations

B - functions

37) (Excel) By default, textual data is ____ aligned within Excel cells. A - center B - left C - right D - top

B - left

38) (Excel) Combining two or more cells into a single cell creates a: A - combination box B - merged cell C - grouping D - combined cell

B - merged cell

56) (Excel) Which symbol represents the amperand sign and is used to concatenate two or more values or cell contents? A - ^ B - * C - & D - @

C - &

23) (Excel) If you're sharing your data with someone who does not have Excel or any sort of spreadsheet software on their computer, you may want to save your workbook in this format: A - .ods B - .xlsx C - .pdf D - .xls

C - .pdf

14) (Excel) If you begin typing in Excel, the characters will appear in the cell of the worksheet known as the ________ that has its border bolded with a green color. A - Dominant cell B - Adjacent cell C - Active cell D - Reference cell

C - Active cell

1) (Windows) What option in the Network & Internet Settings will allow you to disable all Wi-Fi cards in the device, along with any other device that emits radio signals, such as Bluetooth chips, or the device cellular network should it have one? A - Status B - Ethernet C - Airplane Mode D - VPN

C - Airplane Mode

68) (Excel) What is a visual representation of data used to convey information in an easy-to-understand and attractive manner called? A - Data label B - Legend C - Chart D - Object

C - Chart

27) (Excel) From the Backstage view Print options, select ____________ under Settings to print all sheets in a workbook. A - Selection B - Active sheet C - Entire workbook D - Range

C - Entire workbook

93) (Word) Which Word feature is used when you want to save, print, or open a document? A - View ribbon tab B - Home ribbon tab C - File tab menu D - Page Layout ribbon tab

C - File tab menu

82) (Word) What tool can be used to best apply formatting from one part of a document to another? A - Office Clipboard B - Find and Replace C - Format Painter D - SmartArt

C - Format Painter

62) (Excel) Which of the following is a logical operator and not a comparison operator? A - = B - <> C - Not D - <=

C - Not

89) (Word) Which Paste Special option would be best used if you've copied strangely formatted text and wish to paste it in your draft document where it will be formatted at a later time? A - Pasting as Formatted Text B - Paste in HTML format C - Pasting as Unformatted Text

C - Pasting as Unformatted Text

95) (Word) Suppose you have a Word 2016 document and want to send it to a friend in the old Word 97-2003 format. Which File menu option will help you accomplish this? A - Export B - Save C - Save As D - Print

C - Save As

16) (Excel) Press the ______ key to move the active cell one position to the right on the worksheet. A - Backspace B - Shift + Enter C - Tab D - Ctrl + Home

C - Tab

86) (Word) Which of the following is NOT TRUE regarding Word's Track Changes feature found on the Review Ribbon? A - Changes from multiple different people can be tracked and displayed. B - Changes can be accepted or rejected. C - The Track Changes feature is limited to a one year time frame for each document's lifespan. D - Changes can be tracked over the entire lifespan of a document.

C - The Track Changes feature is limited to a one year time frame for each document's lifespan.

78) (Word) When inserting a footnote into a document, where does the footnote text get added to the document? A - The top of the page B - The cursor location C - The bottom of the page D - The end of the line

C - The bottom of the page

35) (Excel) The edges or lines around a cell are referred to as the cell's: A - membrane B - fill color C - border D - fencing

C - border

11) (Excel) In Excel, a ____ is referenced by a column letter and row number such as C5. A - grid B - field C - cell D - box

C - cell

33) (Excel) The background of a cell is called the: A - border B - highlight C - fill color D - paint

C - fill color

47) A linked object, such as a word, phrase, symbol, or image, that you can click to move to a different place in the same workbook, another workbook, or a web site; or to open an e-mail message window is known as a: A - calculation B - function C - hyperlink D - summation

C - hyperlink

53) (Excel) Symbols such as +, -, and * that are used to specify the calculations to be performed in a formula are called: A - addends B - functions C - operators D - values

C - operators

67) (Excel) To automatically apply several formatting options to a table all at once, choose one of Excel's predefined table: A - filters B - sorting options C - styles D - formulas

C - styles

12) (Excel) An Excel workbook can consist of multiple _______ or "pages" each referenced by a tab at the bottom of the Excel program window. A - scrapbooks B - documents C - worksheets D - templates

C - worksheets

98) (Word) The edge of a table or table cell in which different styles and colors can be applied is called a: A - line marker B - cell skin C - grid box D - border

D - border

22) (Excel) To save a workbook in a format compatible with Excel 97-2003 versions, the file extension should be: A - .docx B - .xlsx C - .html D - .xls

D - .xls

44) (Excel) The ____________ feature can complete a series of values into adjacent cells based on the value of other cells and can also be used as a shortcut to copying and pasting. A - Auto Correct B - Auto Recovery C - Auto Format D - Auto Fill

D - Auto Fill

42) (Excel) If you have a column of data in Excel that represents the cost of different items, then you will likely format that data using either an Accounting number format or a ______ number format. A - Time B - Percent C - Scientific D - Currency

D - Currency

80) (Word) The default Word 2016 file format (or file type) is: A - EXLX B - HTML C - TXT D - DOCX

D - DOCX

2) (Windows) Which Windows 8 feature can automatically back up files in the Documents, Music, Video, and Pictures libraries, and in the Contacts, Desktop, and Favorites folders as well as providing a new file versioning feature? A - Windows Backup B - File Explorer C - Storage Spaces D - File History

D - File History

31) (Excel) ____________ is the process of changing the appearance of cells and the overall layout of the worksheet. A - Justifying B - Printing C - Editing D - Formatting

D - Formatting

61) (Excel) Which Excel ribbon tab contains the Function Library command group? A - File B - Home C - Insert D - Formulas

D - Formulas

94) (Word) I am reviewing a Word document on information technology and wish to use Word's Advanced Find and Replace options to find all occurrences of "IT" while skipping any results such as "It" or "it". Which Search Option would I want to use from the Find and Replace dialog box? A - Match prefix B - Match suffix C - Ignore white-space characters D - Match case

D - Match case

59) (Excel) Which of the following choices could be used in creating a named cell range? A - C1 B - $ C - Total Earnings D - MonthlyExpenses

D - MonthlyExpenses

64) (Excel) Suppose cell D5 has a value of 17. What will be the value of cell E5 if it contains the formula =IF(D5<=10,"OK","Not Good")? A - True B - False C - OK D - Not Good

D - Not Good

71) (Excel) The area within the X- and Y-axis boundaries where the chart appears is referred to as: A - Legend B - Chart title C - Data series D - Plot area

D - Plot area

90) (Word) Which Word screen element allows you to use your mouse to place, move, or even remove tab stops for the selected paragraph(s)? A - Status bar B - Vertical scroll bar C - Ribbon D - Ruler

D - Ruler

20) (Excel) A new Blank Workbook in Excel 2016 contains one worksheet named: A - File 1 B - Current sheet C - Tab 1 D - Sheet1

D - Sheet1

24) (Excel) In Excel, the program name and name of the open file are displayed in the: A - Format bar B - Window bar C - Standard bar D - Title bar

D - Title bar

29) (Excel) The keyboard shortcut for the Print command is: A - [Alt] + [V] B - [Ctrl] + [X] C - [Ctrl] + [V] D - [Ctrl] + [P]

D - [Ctrl] + [P]

92) (Word) What do you call the area at the top of Word's window that contains contextually-distinct tabs with groups of buttons to access the application's features that pertain to the document or item? A - frame B - backstage C - menu D - ribbon

D - ribbon

10) (Excel) When you start the Excel program, you can choose to start with a new blank workbook or one of many pre-formatted workbooks called _______. A - scrapbooks B - documents C - databases D - templates

D - templates