Computer Applications Cumulative Exam (90%)

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

=CD*D4

Which formula represents the correct arguments for the SUMIF function?

=SUMIF(range, criteria, [sum_range])

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?

Adjust

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?

All items that have been formatted as Headings 1, 2, or 3 and Title will be added.

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

All of the options listed are correct.

Which statement is true regarding the Quick Access toolbar?

All the above statements are true.

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

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

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

Clear the rule she created by going to the Conditional Formatting Rules Manager dialog box and deleting the rule?

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

Field names can be any size.

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

Hide

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

Home tab Paragraph group

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

It is used to search for specific functions using keywords and descriptions.

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?

Merge

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

Orientation

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?

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?

Table Tools Design tab, Merge group, Alignment group

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

The word that is double-clicked will be selected.

What are the benefits of building blocks?

They allow you to create custom content that can be easily inserted into Word documents.

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

Under the Review tab on the ribbon in the Language group, click the Language button and select Set Proofing Language.

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?

Use the Sort function to organize the data based on date order.

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

View Tab

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?

Yes, click the Select Data button in the Data group under the Design tab to extend or reduce the data range.

How can templates be made available to other users?

a shared network location

Which phrase is the best definition of a PivotTable?

a tool used to summarize data

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

create multiple columns add section breaks add line numbers

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

double-click format painter

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

drag and drop

What is the proper name for C4:D5?

range

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

small caps

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

using References tab, Table of Contents group, Update Table