AnswersLHS Business ManagementCumulative Exam

Cumulative Exam — Cumulative exam Answers

50 verified answers1 views
1
Free Preview

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.
2
Free Preview

Which option is used to collaborate with other authors by comparing different versions of the same document?

A
Sections
B
Comments
C
Revisions
D
Track Changes
3

Which option in PowerPoint allows users to configure the number of columns and rows manually, using numerical values?

A
Insert Table dialog box
B
Draw Table option
C
Insert Table drop-down menu
D
Excel spreadsheet
4

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
5

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

A
worksheet
B
tab
C
cell
D
range
6

What is the name for the individual sections of the ribbon in PowerPoint 2019?

A
commands
B
command groups
C
menus
D
tabs
7

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.
8

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.
9

Before he buys a new smartphone, Tim can best use data to

A
evaluate which phone he should get.
B
convince himself he wants a phone.
C
discredit others’ opinions on his phone choice.
D
recognize problems that all phones have.
10

Which best describes what databases do?

A
They guarantee users find needed data.
B
They create categories for data.
C
They identify important data.
D
They enable users to search for data.
11

Which feature refers to a combination of colors, fonts, and effects that a user can define and apply to slides, slide masters, and slide layouts?

A
Custom Theme
B
Format Painter
C
Default Theme
D
Slide Master
12

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
13

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
14

Tina has taken the time to modify font sizes and colors in a text box and would like to duplicate those settings on other text boxes within her presentation. What should she do to be able to duplicate those settings numerous times?

A
Duplicate the object.
B
Double-click the Format Painter command.
C
Single-click the Format Painter command.
D
Create a theme.
15

Which view is most often used to reorder slides in a presentation that has already been created?

A
Outline view
B
Reading view
C
Slide Sorter view
D
Normal view
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 tab group is used to modify the background of a chart that is contained in a PowerPoint presentation?

A
Chart styles
B
Data
C
Type
D
Chart layouts
18

Which feature should be used prior to finalizing a presentation to ensure that audience members with disabilities will be able to understand the message that a presenter is trying to get across?

A
Compatibility Checker
B
Accessibility Checker
C
Insights
D
AutoCorrect
19

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])
20

What is used to accurately position objects on the slide using a single horizontal and vertical line that intersects in the center of the slide?

A
guides
B
gridlines
C
ruler
D
border

Did you find these answers helpful?

More from this Course

Assignment
13 verified answers

Adding Graphical Elements to Your Presentation

Assignment
10 verified answers

Performing Advanced Text Editing Operations

RC
25 verified answers

Cumulative Exam

Cumulative Exam — Cumulative exam Answers — LHS…