Computer Applications, all tests (WIP)

How can the Column settings be accessed?

a. Layout tab, Page Setup group

Which extension is appropriate for Word document templates?

b. .dotx

Stephen needs to insert a field into a building block that will contain variable data. Which keyboard shortcut can he use to toggle between data and the field codes?

b. ALT+F9

What is the quickest way to remove all filters that have been applied to a worksheet?

b. Click the Filter button in the Sort & Filter group.

Kari needs to change the brightness and contrast on an image she has inserted into a Word document. Which group should she use to do this?

(63%) a. Adjust

Which step ensures that the page margins are not too narrow?

(63%) a. Always preview your document or print a test page first to ensure the margins are not too narrow.

Jesse would like to modify the table that he has inserted into a Word document by making the first row a single header cell. Which action should Jesse do?

(63%) a. Merge

What are the different options in a page layout feature? Select three options.

(63%) a. create multiple columns c. add section breaks e. add line numbers

Naomi would like to reorder the worksheets in a workbook. What is the easiest method of doing this?

(63%) a. drag and drop

Which command suppresses the visibility of a particular row or column in a worksheet?

(63%) b. Hide

Raj needs to apply sorting to a current list in his Word document. Where should he go to apply the sort?

(63%) b. Home tab Paragraph group

Which statement describes what the Conditional Formatting option in Excel 2016 allows users to do?

(63%) b. It automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.

Which option can be used to access more settings than are available in the Backstage view?

(63%) b. Orientation settings

Which step is first in changing the proofing language of an entire document?

(63%) b. Select the whole document by pressing Ctrl+A.

How can templates be made available to other users?

(63%) b. a shared network location

Leena needs to manually update the TOC and would prefer not to change the styles in the document. What should she do?

(63%) b. using References tab, Table of Contents group, Update Table

Which formula represents the correct arguments for the SUMIF function?

(63%) c. =SUMIF(range, criteria, [sum_range])

David has created a lot of styles and now his Quick Style Gallery contains styles he no longer uses. How can he remove the unwanted styles?

(63%) c. Right-click the style in the Quick Styles Gallery, and select the Remove from Quick Style Gallery option.

Shreya has combined all the cells in a single leftmost column in a table. Instead of identifying the category multiple times, she would like to combine these cells and then structure the word "Appliances" vertically in the cell. Where will Shreya find these options?

(63%) c. Table Tools Design tab, Merge group

Seneca has just applied conditional formatting and realizes that she has made a mistake. Which action should she take to fix the mistake?

(63%) c. Use the Undo button or Ctrl+Z.

After a chart has been inserted and formatted, is it possible to change the data range it refers to or to add new rows of data?

(63%) c. Yes, click the chart, select the additional rows or columns of data to add, and press Enter on the keyboard.

Which phrase is the best definition of a PivotTable?

(63%) c. a tool used to summarize data

What is the proper name for C4:D5?

(63%) c. range

Which command is not one of the available Change Case options?

(63%) c. sentence case

Beth needs to multiply the values of two cells in her worksheet. What should she enter into the formula bar?

(63%) d. =(CD)(D4)

Priya has created a document and will now create a table of contents. Which statement describes the items that will automatically be added into the table of contents?

(63%) d. All items that have been formatted as Headings 1, 2, or 3 and Title will be added.

Which statement is true regarding the Quick Access toolbar?

(63%) d. All the above statements are true.

Which statement is NOT a rule for the data source for the mail merge?

(63%) d. Field names should start with a letter.

Which statement best describes the purpose of the Insert Function dialog box?

(63%) d. It is used to put all types of Excel functions in alphabetical order.

What option in the alignment settings for a cell should be used to put text in a diagonal fashion?

(63%) d. Orientation

What will happen when a text in a paragraph in Word is double-clicked?

(63%) d. The word that is double-clicked will be selected.

What are the benefits of building blocks?

(63%) d. They allow you to create content that cannot be edited by mistake and inserted into Word documents.

Keisha has a worksheet with a range of cells using the following columns: Name, Score, Group, Study Group, and Date. Keisha needs to sort the worksheet on the Date field. Which option should she use to most efficiently complete this task?

(63%) d. Use the Sort function to organize the data based on date order.

Robert needs to apply formatting from one set of text to multiple other sets of text throughout the document. Which option should he use?

(63%) d. double-click Format Painter

Which phrase is a comparison operator for inserting a not equal to argument in an IF, COUNTIF or SUMIF function?

(85%) b. <>

What is the first step to creating a PivotTable?

(85%) b. Create or select data that needs to be analyzed.

How can a user change the range of cells that a Conditional Formatting rule applies to?

(85%) b. In the Conditional Formatting Rules Manager dialog box, edit the cell range for the rule in the Applies To section.

Alex needs to create a function capable of counting item reference numbers that he is inserting into a spread sheet. The purpose of this function will be to keep track of inventory. How would Alex go about finding a function to do this?

(85%) c. Press Shift + F3 to access the Insert Function dialog box to look for a function that counts items.

Which option represents the method for inserting a title or heading for a chart?

(85%) c. Under Chart Tools, click the Layout tab, select Chart Title, and choose the relevant option for where to insert the title.

Which type of chart is most useful when a user is trying to visually represent sets of data as parts of a whole, such as product categories within total sales?

(85%) c. pie chart

Where are the options to add or remove the background color of a chart located in Excel 2016?

(85%) c. under the Format tab in the Shape Styles group

Which method is used to edit a function that has been created and inserted into a cell?

(85%) d. All of the above methods can be used to edit a function that has already been inserted into a cell.

How can a user remove or delete a PivotTable?

(85%) d. All of the options described are correct.

Which argument is not a valid filter?

(85%) d. All of these are valid filter arguments.

Walt has selected data in a worksheet and inserted a chart. However, the chart is inserted right on top of the data set, and he cannot see the data. How should Walt most efficiently fix this situation?

(85%) d. Click View and zoom into the worksheet so the chart is easily visible.

What is not an option in the PivotTables Fields list?

(85%) d. Formulas

Top/Bottom Rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow the user to include in the rule?

(85%) d. any logical number of items or percentages in top or bottom value frames

When a user inserts a PivotTable, where will it be inserted?

(85%) d. depends on whether the PivotTable is inserted into the current worksheet or a new worksheet and the current location of the cursor

Which function is used to add a range of cells?

a. =SUM

Which statement describes how to insert the IF, COUNTIF, or SUM function into a cell?

b. Type an = sign in the cell, followed by the name of the function and the relevant arguments.

Which item is used in Excel to identify the row of a particular cell?

b. number

Which ribbon tab is home to the Function library used to insert functions into worksheets?

c. Formulas

Where is the option to set Conditional Formatting rules found?

c. Home tab in the Styles group

Where are the Add Level and Delete Level buttons located?

c. Sort dialog box

Which formatting option(s) can be set for Conditional Formatting rules?

d. Any of these formatting options as well as number, border, shading, and font formatting can be set.

Which function category is not in Excel 2016?

d. Conditional Formatting

Which function can NOT be performed using the Conditional Formatting option?

d. Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.

Which formatting group would commonly be used for monetary figures?

d. currency

Where is the SUBTOTAL function located?

d. under the Data tab on the ribbon in the Outlining group

Ryan is applying a sort to the data in a table that you have inserted in Word. Which option is important for most tables that have column headings?

(80%) c. Select the option "My List has Header Row."

Katie needs to apply styles to titles and headings in a document that she has created. What is the easiest way to do this?

(80%) c. Use the Quick Styles Gallery.

Which wildcard characters will return a single character when using the Find dialog box?

(84%) a. ?

What are building blocks? Select three options.

(80%) a. content that has been formatted b. content that is stored in galleries c. content that is editable and then stored

Which steps are needed for Word to create an Index? Select two options.

(80%) c. Insert Index. d. Insert Table of Contents.

Don is creating a very long document, and he would like to create an introductory page that contains the title of the document and the name of the author along with the date. What kind of page is Don looking to create?

(80%) ??? c. Cover Page

Which option ensures that different parts of the document can have different page layouts?

(80%) ??? c. section breaks

Which option lists the correct steps to apply a style?

(80%) a. Select the text, click the Home tab, and in the Styles Gallery, click to select a style to apply.

What is the first step to apply the line and page breaks options to groups of paragraphs in a Word document?

(80%) a. accessing the Paragraph dialog box

Which of these functions may be used with positional arguments? Select four options.

a. AVERAGE c. COUNT d. SUM e. MAX

Which setting is used to determine the order of printing pages?

(94%) a. Collation Settings

Which character is used to create an absolute reference to a cell?

(94%) b. $

Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

(94%) b. =SUM(F2:F5,Sheet2!A10)

Which key(s) will launch the Spelling Checker dialog box?

(94%) b. F7

Which characters in the function shown represent the arguments? =MAX(B2:B6,C4,100)

(94%) c. (B2:B6,C4,100)

Which combination of options is the keyboard shortcut to access the Find dialog box and search a worksheet for particular values?

(94%) c. Ctrl+F

Which keyboard shortcut will create a hyperlink in an Excel document?

(94%) c. Ctrl+K

Liam would like to duplicate the formatting of cells in an easy fashion. Which option should he use?

(94%) c. Format Painter

Ismael would like to insert a question mark symbol in his document. What steps will he need to follow to do that?

(84%) b. Hold down the Shift key

Zubair needs to change some of the data in a table that he has created. How should he go about selecting a row in the table?

(84%) b. Move the mouse pointer to the blank space at the left of the desired row

Samantha was working on a Word document and the horizontal and vertical margins disappeared. Which solution will fix the problem?

(84%) b. click on the view ruler button located at the top of the vertical scroll bar on the right- hand side of the screen.

Which of these graphic elements combine text, illustrations, and color?

(84%) b. smart art

Adam has decided to add a table in a Word doc to organize the information better. Where will he find this option?

(84%) c. Insert tab, Tables group

Rupa would like to quickly insert a table into her document without having to worry about formatting the data in the table. Which step should Rupa take?

(84%) c. Insert tab, Tables group, Quick Tables option

Which step needs to be done before changing the font type, size, and color of a particular set of text?

(84%) c. Select the text that needs changing.

Which option is not a tab type?

(84%) c. hanging tab

What is the correct name for the words Home, Insert, Design, Layout, References, etc. in the ribbon in Word 2016?

b. tabs

Which of these options are the correct sequence of actions for content to be copied and pasted?

(84%) c. select the content, click the copy button, move the insertion point to where the content needs to be inserted, and click the paste button

Which shortcut key aligns text to the center of a page?

d. Ctrl+E

Which of these is not the correct method for moving text in a document in Word 2016?

(84%) a. select the text, press ctrl+c, move the insertion point to desired location, and press ctrl+v

Which option ensures that a page break is automatically inserted ahead of a specific paragraph or heading?

(84%) a. the page breaks

Naseer has inserted an image into his document but needs the image to appear on its own line. Which option should he choose?

(84%) a. top and bottom

Sarah is having a hard time finding a template for her advertising business that she may be able to use at a later date and also make it available to her colleagues. What is her best option?

(80%) a. creating a custom template

Ron is creating building blocks in Word. How can he make the building blocks that he created available?

(80%) a. store those building blocks in the Normal template

Which option ensures that a page break is automatically inserted ahead of a specific paragraph or heading?

(80%) a. the Page Breaks Before option in the Paragraph dialog box

How many fields can be sorted when sorting data in Word tables?

(80%) a. up to 3 fields

What is the easiest way to create a diverse set of cover pages?

(80%) a. using the cover page gallery

Byron wants to use Quick Parts to insert reusable content into a company Word document. Where will he access this option?

(80%) b. Insert tab

What is the easiest way to create a resume in Word with predefined content that can be replaced with your information?

(80%) b. Search for resume templates.

What is one way that cell merging is used?

(80%) b. center the title

Section breaks are powerful tools in document design and formatting. Which option is NOT a good reason to use a section break?

(80%) b. using section breaks to insert new pages where needed

Which option keeps two paragraphs together for the purpose of comparing or contrasting?

(80%) c. Keep Lines Together option

How can the font type of an existing style named No Spacing be changed?

(80%) c. Manually change the font type of the style in any place in the document it has been applied, right-click, and select Styles and Update No Spacing to Match Selection.

How can the various templates that are available for new Word documents be accessed?

(80%) c. clicking File to enter Backstage View

Which of these is a placeholder in a document into which variable data is inserted during the process of a mail merge?

(80%) c. merge field

Which formatting elements can be included in a style Terry created?

(80%) d. All of the options listed above can be used to create a new style.

To which of these options does the style in Word apply? Select three options.

a. lists b. tables c. headings

What are the features of the Outline view in Word? Select three options.

a. making it easier to deal with larger documents b. manipulating headings c. displaying text with Heading styles

What options does the Table Tools Layout contextual tab contain? Select three options.

a. modify text direction c. insert rows and columns e. split table

Elan needs to ensure that he can control the order of operations in his formulas. Which characters are used to provide the highest precedence?

a. parentheses

Chris has received an email that was entirely written using capitalization. He needs to paste this text into another document but also ensure that the capitalization is removed. What should Chris do?

d. All of the above steps are correct.

Which method deletes a footer from a document?

d. All the above are methods for deleting a footer from a document

Which margin is at the very bottom of the page when printing worksheets?

d. footer margin

Where is the option to insert a PivotTable in Excel 2016 located?

a. Insert tab in the Tables group

Where are the mail merge options located in Word 2016?

a. Mailings tab, Start Mail Merge group

Zoe needs to ensure that a larger spreadsheet fits on a single page. How can she achieve this?

a. Orientation settings

In addition to the format commands that are found in the ribbon, which option is available for more extensive formatting?

(94%) b. Format Cells dialog box

Abdul has applied styles to a line of text in his Word document and he would like to revert it to the Normal style.

(80%) d. all of the above

Adam has to write a paper where the margins need to be set to these measurements:

(84%) a. Launch the page setup dialog box from the page setup group; in the margins section...

Which keyboard shortcut is used to move the cursor one cell to the right of the insertion point?

(84%) a. Tab

Audra has applied formatting to text in her document. She would like to copy this formatting to one other value in the document. Which option should she use?

(84%) a. format painter

How will using ascending order on a field that contains dates sort a list?

(84%) a. from the earliest to the latest date in chronological order

Which way is the quickest to access the Find and Replace dialog box?

(84%) b. Ctrl+H

Katherine would like to insert specific words at the top of every page on a multipage essay. Which way is the easiest to do this?

(84%) c. type the words onto the first page after selecting...

Which character is often used to identify registered trademarks and is available on the Insert tab and Symbols group?

(84%) c.™ tm

Which method will successfully launch the Spelling and/or Grammar Checker dialog box?

(84%) d. All the above

Which option describes how to apply a left indent to a selected paragraph?

(84%) d. all the above options are correct

What happens in Word 2016 when the Home ribbon tab is clicked on?

(84%) d. it will open an area of your ribbon that contains functions associated with the Home tab.

Which shortcut key in Microsoft Word 2016 will launch spellchecker?

(84%) d. none of the above

William would like to sort a list of items after the data is already entered. Which method is NOT an available sort option?

(84%) d. symbol

Other than the New Sheet button, which method can be used to add an additional worksheet to a workbook?

(94%) a. Backstage view

Which source is NOT a valid data source for a mail merge?

(80%) d. PDF document

David needs to apply a sort to a table that he has inserted into Word. He would like to sort by Category and then Price. Where should David access the sort options for the table?

(80%) d. Table Tools Layout tab, Data group

On which tab are the print commands in Excel 2016 accessed?

(94%) b. File (Backstage)

Xavier wants to ensure that if he scrolls down through a worksheet that contains numerous rows of data that the initial column headings are not scrolling, making it easier to read the information in the spreadsheet. Which step should Xavier follow?

(94%) b. Freeze the column heading rows.

Which character will always precede an Excel formula?

(94%) c. =

What is required to utilize Excel Online?

(94%) c. Office 365 user account

Donte needs to print specific sections in the workbook, as opposed to the entire workbook. Which feature should he use?

(94%) c. Print Area

Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?

(94%) c. The worksheets that are hidden will retain their data, and references will continue to function as normal

Where are commonly accessed commands located by default in Excel 2016?

(94%) d. Quick Access tool bar

Lisa intends to use the Hide command on a column in her spreadsheet. How are the cells in this column affected by this command?

(94%) d. The cells can still be referenced in functions or formulas.

Excel 2016 is primarily what type of program?

(94%) d. spreadsheet

Which method is an easy way to find a short description of a function?

a. In the Insert Function dialog box, click the function name to get a short description.

Tara needs to select all of the text in a Word document. Which keyboard shortcut will achieve this goal?

a. Ctrl+A

Chris needs to modify the default bullets that are used in a nonnumbered list in Word. Which method should he use?

a. Select the arrow next to the bullet list option in the Paragraph group.

Karen would like to apply a group of colors, fonts, effects, and styles very quickly to a document that she has created. Which of these styles should she use?

b. Document theme

Where are options to add a border around the outside of a chart found?

b. Format tab in the Shape Styles group

Jin needs to add a row into his spreadsheet, but he does not want to remove any existing data. Which combination of options should he use?

b. Insert > Entire Row

Nadia would like to find text in her current document that differentiates CompanyABC from companyabc. Which option should she use?

b. Match Case

Ryan has inserted an image into a Word document, but the image is too large. There are sections of the image that he would like to eliminate to decrease the overall size of the image. Which option should Ryan use?

c. Crop

Seneca needs to combine multiple cells into a single column heading. Which option should she use?

c. Merge and Center

Grace would like to calculate a field in a Word table and add up values from a list of regional sales data. Which function should she use?

c. SUM

Carla needs to be able to quickly switch back and forth between open worksheets. Which option should she use?

c. Switch Windows

When running a spelling and grammar check, which of these buttons does Nora need to press when she wants to fix an error after selecting the correct option in the Not in Dictionary/Suggestion area?

d. Click the Change button to accept the change.