Brainscape's Knowledge GenomeTM

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


See full index

ETM 1030 > EL1 C3 > Flashcards

EL1 C3 Flashcards

1
Q

The Increase Decimal and Decrease Decimal buttons change decimal places for…

A

existing numbers only

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

To insert a new row in a worksheet, select _____ and then click the Insert button.

A

the row below where the row is to be inserted

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

If you want to enter data on more than one line in a cell, you can enter the data on the first line and then move the insertion point to the next line in the cell by…

A

pressing ALT + ENTER

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

What does the Merge & Center button in the Alignment group on the HOME tab do?

A

merges the selected cells and centers the data within the merged cells

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

Which of the following is not one of the options at the Merge & Center button’s drop-down list?

A

Merge Workbooks

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

Which of the following number formatting categories is not found in the Format Cells dialog box?

A

Exponents

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

By default, numbers typed in a cell are formatted to…

A

right-align, with no decimals or commas unless they are typed in the cell

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

If you enter the value $45.50 into a cell with default formatting, Excel automatically…

A

applies currency formatting to the number

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

The column width number in the Column Width dialog box represents…

A

the average number of characters in the standard font that will fit in a cell

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

Which button do you click to display the Column Width dialog box?

A

Format

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

You can use your mouse to change the height of multiple rows at the same time if the rows are…

A

adjacent to one another

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

The name of this button in the Font group changes depending on the most recent option it was used to apply.

A

boarders

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

To give your worksheet a professional look, you can apply a predefined set of colors, fonts, lines and fill effects by…

A

applying a theme

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

Which of the following number formatting categories is not found in the Format Cells dialog box?

A

Exponents

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

What happens if you select three columns in a worksheet, click the Insert button arrow, and then click Insert Sheet Columns?

A

Three columns are inserted immediately to the left of the selected columns

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

By default, when inserting a column in a worksheet, the new column is placed…

A

immediately to the left of the column containing the active cell

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

Which of the following changes in text format can you not make on the Font tab of the Format Cells dialog box?

A

Orientation

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

When text is too long to fit in a cell, it normally overlaps into the next cell to the right. If you want data to remain in a cell and wrap to the next line within the same cell, select the _____ option at the Format Cells dialog box.

A

Wrap text

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

How is clearing cell contents different from deleting cells?

A

Clearing cell contents gives you the option of removing both contents and formatting from a cell

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

To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position.

A

Select All button

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

When you insert rows into a worksheet, all references affected by the insertion…

A

are automatically adjusted

22
Q

The Clipboard group on the HOME tab contains the _____ button, which can be used to copy formatting to different locations in the worksheet.

A

format printer

23
Q

You can insert a new row in a worksheet by clicking the Insert button arrow, clicking Insert Cells, and then clicking this at the Insert dialog box.

A

entire row

24
Q

You can specify the formatting for numbers in a cell…

A

(?)

25
Q

What does the Orientation button in the Alignment group do?

A

rotates data in a cell

26
Q

If you enter numbers into a cell, they will be automatically aligned…

A

at the right side of the cell

27
Q

If you want to copy formatting to several different locations in a worksheet, select the cell that contains the desired formatting and then _____ the Format Painter button.

A

double click

28
Q

What happens if you select multiple columns and then drag one of the selected column boundaries?

A

all selected column widths change

29
Q

To add a background color to a selected cell, use the _____ button in the Font group on the HOME tab.

A

fill color

30
Q

To reduce the size of the text font so that all selected data fits within a column, click the _____ option on the Alignment tab in the Format Cells dialog box.

A

shrink to fit

31
Q

Which component of a theme consists of a set of line and fill effects?

A

effects theme

32
Q

On which tab in the Format Cells dialog box can you choose the degrees to rotate text?

A

alignment

33
Q

Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column?

A

accounting

34
Q

The gridlines that display in a worksheet..

A

do not print by default

35
Q

To change the height of a row using your mouse, position the mouse pointer on the boundary line in the row header until the mouse pointer turns into a _____, then drag the boundary to the desired height.

A

double headed arrow pointing up and down

36
Q

Using the Delete key to delete cells…

A

only deletes the cell contents

37
Q

You can see how a theme will affect your worksheet before you apply it by using the _____ feature.

A

live preview

38
Q

Approximately how many points are contained in a vertical inch?

A

72

39
Q

When a row height is being changed, the row height number that displays represents a measurement in…

A

points

40
Q

What happens if you select and merge a block of cells that contain data?

A

Only the data in the upper left cell of the block will be retained.

41
Q

Select the rows or columns you do not want to display on the screen and point to Hide & Unhide…

A

(?) in the drop-down menu of the Format button in the Cells group on the HOME tab

42
Q

Click this button arrow in the Number group on the HOME tab to display a drop-down list of common number formats.

A

Number Format

43
Q

You can adjust a column width to fit the longest entry in the column by double-clicking…

A

on the column boundary line

44
Q

Excel measures row height in _____ and column width in _____.

A

points; characters

45
Q

Right-clicking in a cell will display the…

A

mini toolbar

46
Q

Which of these formatting options is not found in the Font group on the HOME tab?

A

superscript

47
Q

By default, all columns in a worksheet…

A

are all the same width

48
Q

In which number category can you specify the formatting for Zip codes?

A

Special

49
Q

This number category in the Format Cells dialog box is used for very large or very small numbers.

A

Scientific

50
Q

To delete a row, select the row and then click the Delete button in the _____ group on the _____ tab.

A

Cells; HOME

51
Q

When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?

A

You specify the range in the Rows to repeat at top text box in the Page Setup dialog box

52
Q

At the Page Setup dialog box with the Sheet tab selected, you can specify rows and/or columns to print on every page of the worksheet. How is this feature normally used?

A

to print row and column titles on multipage worksheets

ETM 1030 (18 decks)

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