EL1 C3

Question 1

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

Answer 1

existing numbers only

Question 2

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

Answer 2

the row below where the row is to be inserted

Question 3

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…

Answer 3

pressing ALT + ENTER

Question 4

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

Answer 4

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

Question 5

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

Answer 5

Merge Workbooks

Question 6

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

Answer 6

Exponents

Question 7

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

Answer 7

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

Question 8

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

Answer 8

applies currency formatting to the number

Question 9

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

Answer 9

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

Question 10

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

Answer 10

Format

Question 11

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

Answer 11

adjacent to one another

Question 12

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

Answer 12

boarders

Question 13

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

Answer 13

applying a theme

Question 14

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

Answer 14

Exponents

Question 15

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

Answer 15

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

Question 16

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

Answer 16

immediately to the left of the column containing the active cell

Question 17

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

Answer 17

Orientation

Question 18

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.

Answer 18

Wrap text

Question 19

How is clearing cell contents different from deleting cells?

Answer 19

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

Question 20

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

Answer 20

Select All button

Question 21

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

Answer 21

are automatically adjusted

Question 22

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

Answer 22

format printer

Question 23

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.

Answer 23

entire row

Question 24

You can specify the formatting for numbers in a cell…

Answer 24

(?)

Question 25

What does the Orientation button in the Alignment group do?

Answer 25

rotates data in a cell

Question 26

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

Answer 26

at the right side of the cell

Question 27

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.

Answer 27

double click

Question 28

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

Answer 28

all selected column widths change

Question 29

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

Answer 29

fill color

Question 30

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.

Answer 30

shrink to fit

Question 31

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

Answer 31

effects theme

Question 32

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

Answer 32

alignment

Question 33

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

Answer 33

accounting

Question 34

The gridlines that display in a worksheet..

Answer 34

do not print by default

Question 35

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.

Answer 35

double headed arrow pointing up and down

Question 36

Using the Delete key to delete cells...

Answer 36

only deletes the cell contents

Question 37

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

Answer 37

live preview

Question 38

Approximately how many points are contained in a vertical inch?

Answer 38

72

Question 39

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

Answer 39

points

Question 40

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

Answer 40

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

Question 41

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

Answer 41

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

Question 42

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

Answer 42

Number Format

Question 43

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

Answer 43

on the column boundary line

Question 44

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

Answer 44

points; characters

Question 45

Right-clicking in a cell will display the...

Answer 45

mini toolbar

Question 46

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

Answer 46

superscript

Question 47

By default, all columns in a worksheet...

Answer 47

are all the same width

Question 48

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

Answer 48

Special

Question 49

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

Answer 49

Scientific

Question 50

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

Answer 50

Cells; HOME

Question 51

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

Answer 51

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

Question 52

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?

Answer 52

to print row and column titles on multipage worksheets