Brainscape's Knowledge GenomeTM

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


See full index

ETM 1030 > EL1 C5 > Flashcards

EL1 C5 Flashcards

1
Q

Specify how cells are pasted in a worksheet with options at which of the following?

A

the Paste Options button drop-down list

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

Display a shortcut menu with options for managing worksheets by…

A

right-clicking a worksheet tab

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

Instead of using the sheet tab shortcut menu, you can copy a worksheet by doing which of the following?

A

pressing and holding down the Ctrl key while dragging the worksheet tab from one location to another

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

One method of moving to a range of cells is by using options at the _____ dialog box.

A

Go To

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

After selecting cells to be moved and clicking the Cut button, how do you move them to their new location?

A

Click the cell where the first selected cell should be inserted and then click the Paste button

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

The moving dashed line border that surrounds cells after you have selected them and clicked the Copy button is called a…

A

marquee

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

A group of selected cells is referred to as a…

A

range

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

You can move to a different worksheet in a workbook by…

A

clicking the desired worksheet tab

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

The Define Name button is in the Defined Names group on the _____ tab.

A

Formulas

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

When pasting cells that contain a value and a formula, you can use options at the Paste Option button drop-down list to insert all the following except…

A

the formula as a value

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

Use the _____ and _____ buttons in the upper right corner of the active workbook to change the size of the active workbook in the screen.

A

Maximize; Minimize

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

Where are the tab scroll buttons that allow you to navigate the worksheet tabs?

A

left of the sheet tabs

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

To see which workbooks are open, hover the mouse pointer over the _____ to display thumbnails of the workbooks.

A

Excel button on the taskbar

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

By clicking the Hide button in the Window group on the View tab, you can…

A

hide the active workbook

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

Which of the following is not a formatting option when pasting Excel data in a Word document?

A

embed text

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

Excel allows linking data between which of the following?

A

worksheets in the same or different workbooks

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

Arrange the display of _____ at the Arrange Windows dialog box.

A

multiple workbooks that are open at the same time

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

Excel’s split window feature is useful for displaying…

A

(?)

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

To link data between worksheets, begin by doing which of the following?

A

making active the cell(s) containing the data to be linked

20
Q

The _____ button provides a variety of options for pasting data in a worksheet, another workbook, or a document created in another program.

A

Paste Options

21
Q

Use _____ to collect and paste multiple items.

A

the Clipboard task pane

22
Q

In a workbook with multiple worksheets, which worksheet will Excel print by default?

A

the worksheet that is currently displayed

23
Q

How can you see a list of what workbooks are currently open?

A

by clicking the View tab and then clicking the Switch Windows button in the Window group

24
Q

Which of the following is not one of the options at the Arrange Windows dialog box?

A

Diagonal

25
Q

When a worksheet window is split, each section is referred to as a…

A

pane

26
Q

Use keyboard command Ctrl + _____ to copy selected data.

A

C

27
Q

A range of cells cannot be…

A

given a name containing a space

28
Q

You can copy and paste data between Excel and…

A

Word

29
Q

Which of the following is not one of the options for moving data from one section of a worksheet to another?

A

the Format Cells button in the Cells group on the Home tab

30
Q

When data in Excel is linked, the worksheet that contains the original data is referred to as the _____ worksheet.

A

source

31
Q

Which of the following tasks cannot be performed at the sheet tab shortcut menu?

A

format a worksheet

32
Q

Select nonadjacent worksheet tabs by clicking the first sheet tab, pressing and holding down the _____ key, and then clicking other tabs to be selected.

A

CTRL

33
Q

You can name a range by selecting the cells and then typing a name into…

A

the Name box

34
Q

Split lines display in a worksheet as….

A

thick light grey lines

35
Q

When you move a worksheet by dragging it, what icon appears next to the mouse pointer?

A

a page icon

36
Q

What happens when you select cells in a worksheet and then click the Copy button?

A

a moving dashed line border appears around the cells

37
Q

A new Excel workbook contains _____ worksheet(s) by default, but additional worksheets can be added.

A

one

38
Q

What should you do first to copy cells?

A

Select the cells to be copied

39
Q

Use the Delete button in the _____ group on the _____ tab to delete a worksheet.

A

Cells; Home

40
Q

How do you display the Clipboard task pane?

A

Click the Clipboard group task pane launcher in the Clipboard group on the Home tab

41
Q

You can open nonadjacent workbooks at one time at the Open dialog box by clicking the name of the first workbook, pressing and holding down the _____ key, and then clicking the names of the other workbooks.

A

CTRL

42
Q

You can print multiple worksheets in a workbook with options…

A

at the Print backstage area

43
Q

A worksheet window can be split in which of the following ways?

A

horizontally and vertically

44
Q

What happens when you freeze the window panes?

A

Only one active cell is displayed when you cross a pane boundary

45
Q

The combining of data from files created by two or more programs (e.g., Excel and Word) into one file is referred to as…

A

integration

ETM 1030 (18 decks)

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