AnswersLHS Computer ApplicationsCumulative Exam

Cumulative Exam — Cumulative exam Answers

40 verified answers2 views
1
Free Preview

What are the benefits of building blocks?

A
They allow the user to create custom content that can be easily inserted into Word documents.
B
They allow the user to create temporary content for one Word document only.
C
They allow the user to create content that can be used to build a whole Word document.
D
They allow the user to create content that cannot be edited by mistake and inserted into Word documents.
2
Free Preview

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

A
Formatting
B
Align Right
C
Align Left
D
Orientation
3

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

A
using References tab, go to Table of Contents group and Add Text
B
using References tab, go to Table of Contents group and Update Table
C
using References tab, go to Captions Group and Insert Caption
D
using References tab, go to Table of Contents group and Customize Table of Contents
4

Which is NOT a valid sparkline type?

A
line
B
column
C
win/loss
D
bar
5

Kari needs to crop an image she has inserted into a Word document.Which group should she use to do this?

A
Size
B
Picture Styles
C
Arrange
D
Adjust
6

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?

A
Go into the Style Set and delete the styles he doesn’t use.
B
Delete the styles in the document by using the Clear Formatting button.
C
Right-click the style in the Quick Styles Gallery and select the Remove from Style Gallery option.
D
Select the style in the Quick Styles Gallery and press the Delete button on the keyboard.
7

Which statement is true regarding the Quick Access toolbar?

A
It can be located at the top left-hand corner of the screen or below the ribbon.
B
It can contain functions that are also in the ribbon.
C
It can be modified to contain any function that you use frequently.
D
All the above statements are true.
8

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

A
Ctrl+F
B
Ctrl+H
C
single-click Format Painter
D
double-click Format Painter
9

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

A
Home tab, Styles group
B
Home tab, Paragraph group
C
Home tab, Editing group
D
Design tab, Sorting group
10

Which task is not possible with VLOOKUP?

A
lookup values located in a different worksheet
B
lookup values located in a column to the right of the column that contains the lookup value
C
lookup values located in a column to the left of the column that contains the lookup value
D
lookup values such as text, numbers, or characters
11

Hasan created a new spreadsheet and is ready to save it to his Documents directory. Which of the following file formats will be used by default?

A
.xls
B
.doc
C
.csv
D
.xlsx
12

What is the term used to describe a singular container in an Excel spreadsheet?

A
worksheet
B
tab
C
cell
D
range
13

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 Jessedo?

A
Merge
B
Split
C
Resize
D
AutoFit
14

How can templates be made available to other users?

A
a user profile directory
B
a shared network location
C
an intranet SharePoint document library
D
a template gallery
15

What are the different options in a page layout feature? Select three options.create multiple columnsadd images and shapesadd section breakscreate table of contentsadd line numbers

A
create multiple columns
B
add images and shapes
C
add section breaks
D
create table of contents
E
add line numbers
16

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?

A
Use the Cut and Paste option to reorganize the data to fit that order.
B
Use the Filter function to organize the data based on the date.
C
Use the Order function to organize the data based on the date.
D
Use the Sort function to organize the data based on date order.
17

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

A
Click the Language button on the Status bar.
B
Select the whole document by pressing Ctrl+A.
C
Under the Review tab on the ribbon in the Language group, click the Language button and select Set Proofing Language.
D
Run a Spelling and Grammar check on the document before changing the language.
18

Which phrase is the best definition of a PivotTable?

A
a table containing data that is organized horizontally
B
a table used to calculate financial pivot values
C
a tool used to summarize data
D
a table containing specific formatting
19

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

A
drag and drop
B
keyboard shortcut
C
Backstage view
D
Format Options
20

Which of the following are numbers and text that do not change unless manually altered?

A
equal sign
B
references
C
constants
D
mathematical operators

Did you find these answers helpful?

More from this Course

Quiz
39 verified answers

Cumulative Exam

RC
25 verified answers

Cumulative Exam

Assignment
10 verified answers

Managing Contacts