Cumulative Exam — Cumulative exam Answers

40 verified answers2 views
23

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

A
lowercase
B
small caps
C
sentence case
D
capitalize each word
24

Nolan attempted to open a Word document that contains a macro and received a security warning stating, "Macros have been disabled.” The warning contains the button "Enable Content.”What should he do?

A
Close it immediately and delete the file.
B
Check where the file originates from, and if it is a trusted source or his own document, click Enable Content.
C
Close the file and right-click and rename it before opening it again.
D
Keep the file open and save it with a different file name, disabling the warnings.
26

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

A
Always preview the document or print a test page first to ensure the margins are not too narrow.
B
Zoom out of the document to ascertain how close to the edges of the document the text is.
C
The user does not have to ensure that margins are correct; Word will warn the user if they are not.
D
In the Page Setup dialog box, ensure that margins are not set to less than 1" for top, bottom, left, and right areas.
28

Which statement does NOT describe what the Conditional Formatting option in Excel 2019 allows users to do?

A
It automatically applies formatting based on specific rules or conditions being met.
B
It automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.
C
It automatically changes the font of selected cell ranges based on specific rules or conditions being met.
D
It automatically sorts the data based on specific rules or conditions being met.
30

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?

A
No, additional data cannot be included in a chart once it has been created; the user should delete the chart and create a new chart.
B
Yes, click the Select Data button in the Data group under the Design tab to extend or reduce the data range.
C
Yes, click the chart, select the additional rows or columns of data to add, and press Enter on the keyboard.
D
Yes, double-click the chart and select Properties from the list; in the Properties box, insert the new data range to include in the chart.
31

Which formula represents the correct arguments for the SUMIF function?

A
=SUMIF(criteria, range, criteria_range)
B
=SUMIF(criteria_range, true, false)
C
=SUMIF(range, criteria, [sum_range])
D
=SUMIF(range, sum_range, [criteria])
32

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?

A
Nothing will be added automatically.
B
Only items that have been manually marked as a Table of Contents entry will be added.
C
All items that have been formatted as Heading 1 or Title will be added.
D
All items that have been formatted as Headings 1, 2, or 3 and Title will be added.
34

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

A
The top line must contain the names of the fields being using in the merge.
B
Each field name in the data source must be unique.
C
Field names can be any size.
D
Field names should start with a letter.
36

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

A
The font of the word becomes larger.
B
The line the word is positioned in will be selected.
C
The character that is double-clicked will be selected.
D
The word that is double-clicked will be selected.
37

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

A
It is used to search for specific functions using keywords and descriptions.
B
It is used to insert a specific function by selecting it from the Insert Function list.
C
It is used to display information related to the arguments that are used in a function.
D
It is used to put all types of Excel functions in alphabetical order.
40

What is the only way to remove a password encryption on an Excel file?

A
Resave the workbook as a new document or make a copy of it.
B
Open the workbook as Read Only and resave it without a password.
C
Open the workbook in Protected View and resave it without a password.
D
Enter the password to open the workbook, and delete the password created in the Encrypt with Password box.
41

Which option represents the location of the Data Table function?

A
Insert Tab and Tables group, select Table
B
Insert Tab and Tables group, select PivotTable
C
Data tab and Forecast group, select Data Table
D
Data tab and Forecast group, select What-If Analysis and Data Table

Did you find these answers helpful?