Info Processing Excel 1-4

1.

1 point

The formula =B$4+C$9 contains mixed cell references.

True

False

2.

1 point

If you are pasting a range of cells, you must select the entire range to which you want to paste.

True

False

3.

1 point

Columns in a spreadsheet are identified by numbers.

True

False

4.

1 point

The Freeze Panes command will freeze rows below the selected cell.

True

False

5.

1 point

Excel recognizes the contents of a cell as a formula when a minus sign (-) is the first character in a cell.

True

False

6.

1 point

When a calculating error occurs, Excel will display a series of number signs (#######) in the cell.

True

False

7.

1 point

The cell reference $C$5 is

absolute.

relative.

mixed.

multiple.

8.

1 point

F4 is a shortcut to make a cell reference absolute.

True

False

9.

1 point

You just realize that you deleted a column you wanted to keep. What should you do?

use the Redo command

Use the Undo command

retype the data in the column

use the Undelete command

10.

1 point

A relative cell reference will change if the formula is copied or moved.

True

False

11.

1 point

Data cannot be added, removed, or edited from a worksheet that is protected until the protection is removed.

True

False

12.

1 point

An absolute cell reference is indicated by using the $ symbol.

True

False

13.

1 point

Unless a different alignment is specified, all numbers in Excel are

centered.

left aligned.

justified.

right aligned.

14.

1 point

The Fill Color will change the color of the text or numbers in the cell.

True

False

15.

1 point

If you are clever, you can open a protected worksheet even if you forget the password.

True

False

16.

1 point

The Protect Sheet function is located on the _________ Ribbon.

Review

View

Page Layout

Home

17.

1 point

One reason to rotate text in a worksheet is to

create a title across the top of a worksheet.

create a subheading below a primary heading.

turn the text so that it might be displayed in a narrower column.

move text to a new line when it is longer than the width of the cell.

18.

1 point

In a complex formula, subtraction will be performed before multiplication.

True

False

19.

1 point

The Paste command can be used for both copying and moving data.

True

False

20.

1 point

By typing the cell address (like M18) in the Name Box, you can quickly jump to that specific cell.

True

False

21.

1 point

You can place a border around the entire cell or only on certain sides of the cell.

True

False

22.

1 point

Which key must you hold down while copying data using the drag-and-drop method?

Ctrl key

Enter key

Shift key

Alt key

23.

1 point

The intersection of a row and column is called a

range.

highlight.

cell reference.

cell.

24.

1 point

A spreadsheet is a grid of rows and columns containing numbers, text, and formulas.

True

False

25.

1 point

Unlike the Copy command, the Cut command does not copy data to the Clipboard.

True

False