Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ETM 1030 > EL1 C7 > Flashcards

EL1 C7 Flashcards

1
Q

A chart is a picture of numeric data and is sometimes referred to as a…

A

Graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Shapes can be formatted with options on the _____ tab.

A

Drawing Tools Format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The left side of a column chart created by Excel is referred to as the…

A

vertical axis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Use an IF function to create a logical test that performs different actions if the answer is _____ or _____.

A

true; false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the first step in creating a chart?

A

Select the cells that contain the data to be charted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Options for inserting shapes into a chart are provided in which of the following?

A

the Insert Shapes group on the Chart Tools Format tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A question that can be answered true or false is considered a…

A

logical test

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A(n) _____ chart emphasizes the magnitude of change rather than the rate of change.

A

area

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A(n) _____ chart displays values in vertical bars and is useful for comparing items or showing how values vary over time.

A

column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

To move a chart created in an existing worksheet, first select the chart and then perform which of the following steps?

A

Position the mouse pointer on a border until it becomes a four-headed arrow and then click and drag the chart to the location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Selecting a chart and then pressing the Delete key will delete which of the following?

A

only the chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

To increase the height and width of a chart at the same time, drag _____ sizing handles.

A

the corner

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Click the _____ button to return the formatting of a chart element back to the original style.

A

Reset to Match Style

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

To include text in an IF statement, you must do which of the following?

A

Put quotation marks around the text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Display the Function Arguments dialog box by clicking the Logical button in the Function Library group on the _____ tab and then clicking IF at the drop-down list.

A

Formulas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

To move a chart element, select it, _____, click and hold down the left mouse button, and then drag the element to the desired location.

A

move the mouse pointer over the border until it turns into a four-headed arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

To change the data for a chart, edit the data in the specific cells and the corresponding sections of the chart will _____ automatically.

A

update

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A _____ is a type of chart that provides a hierarchical view of data and compares proportions within the hierarchy.

A

treemap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

You can delete a chart element by _____ it and then clicking Delete at the shortcut menu.

A

right-clicking

20
Q

The condition and the action in an IF function are separated by which of the following?

A

comma

21
Q

When a chart has been created in the same worksheet as its data cells, you can change the size of the chart using the _____ on the chart’s border.

A

white circles

22
Q

Excel’s _____ feature provides in one location buttons and options for inserting charts, sparklines, and conditional formatting plus common formulas.

A

Quick Analysis

23
Q

Which of the following types of charts is useful in comparing values and showing categories across geographical regions?

A

map

24
Q

Which of the following is not one of the options on the Quick Analysis Toolbar?

A

Photos

25
Q

In a column chart created by Excel, the horizontal axis runs along the _____ of the chart.

A

bottom

26
Q

What appears around a chart when it is selected?

A

boarder with sizing handles

27
Q

To change how data are grouped along the bottom and left side of a chart, make the chart active and then click the _____ button in the Data group on the Chart Tools Design tab.

A

(?)
NOT Change Chart Type
NOT Axes

28
Q

Which of the following options is not provided at the Function Arguments dialog box when creating an IF function?

A

Value_test

29
Q

Suppose that you are writing a formula with an IF statement using the Function Arguments dialog box. If you type YES in the Value_if_true text box and then press the Enter key, what will happen to the word YES?

A

(?)
NOT Nothing
NOT It will be deleted

30
Q

When a chart on Sheet1 is moved to a new sheet, the default name for that new sheet is…

A

Chart1

31
Q

Which of these keyboard shortcuts will create a chart from the selected cells?

A

Alt + F1

32
Q

If a worksheet contains rows or columns of data that you do not want to chart, Chapter 7 suggests that you _____ them.

A

hide

33
Q

How can you delete a chart element?

A

Click the element and then press the Delete key

34
Q

To write a formula with an IF function, type the _____ followed by what is evaluated in the Logical_test text box.

A

(?)
NOT Function

35
Q

When you select a chart and then display the Print backstage area, the first gallery in the Settings category is automatically changed to…

A

Print Selected Chart

36
Q

You can change the chart type of an existing chart by selecting the chart and using buttons and options…

A

on the Chart Tools Design tab

37
Q

Which of the following is not one of the chart formatting buttons that displays at the right of a chart border?

A

Change Chart

38
Q

Two options for changing the chart location are provided in the Move Chart dialog box: _____ and _____.

A

New sheet; Object in

39
Q

By default, Excel creates the legend for a chart using the…

A

column headings

40
Q

To insert a new chart in a separate worksheet, not the same worksheet that contains the chart’s data, you should press which of the following?

A

the F11 function key

41
Q

A variety of formatting changes can be made to a chart or chart element with options on the Chart Tools Format tab. Which of the following is not one of them?

A

changing the data range

42
Q

To print only the chart in a worksheet (not also the data in cells), first _____ and then display the Print backstage area.

A

click the chart to select it

43
Q

The _____ tab provides options for applying WordArt formatting to data in a chart.

A

Chart Tools Format

44
Q

When a shape has been selected for insertion into a chart, the mouse pointer turns into a…

A

thin black plus symbol (crosshairs)

45
Q

A _____ chart shows overall change over time at even intervals and emphasizes the rate of change rather than the magnitude of change.

A

line

46
Q

Which of the following types of charts plots the interception points between x and y values and is commonly used for scientific data?

A

XY (scatter)

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions