MOE100r3 Unit 2 Flashcard

Front

Which tab in the Page Setup dialog box allows you to set the print area to a specific range of cells?

Back

Sheet

Front

What is the maximum number of rows and columns in an Excel worksheet?

Back

Over 16,000 columns and 1 million rows

Front

Which command adjusts the text to fit within a cell without changing the cell size? Options: Split, Merge & Center, Wrap Text, Shrink to fit

Back

Shrink to fit

Front

Which of the following is used to enter a formula in a spreadsheet? Cell, Range, Formula bar, Name box

Back

Formula bar

Front

Which of the following statements is true about the Synchronous Scrolling feature?
Synchronous Scrolling is always enabled and cannot be turned off.
Synchronous Scrolling allows you to scroll two documents independently.
Synchronous Scrolling can be enabled or disabled from the View tab.
Synchronous Scrolling is only available in the Print Layout view.

Back

Synchronous Scrolling can be enabled or disabled from the View tab.

Front

Which key combination is used to cancel an entry in a cell?

Back

Esc

Front

Which of the following cell addresses will remain constant when it is copied? G3, $G$3, $G3, G$3

Back

$G$3

Front

Which of the following has an answer of 20? 5+3*5, (5+3)*2, 4+4*4, (4+1)*4

Back

(4+1)*4

Front

Which of the following statements about cell references is incorrect? A relative cell reference changes when a formula is copied to another cell. An absolute cell reference remains constant, no matter where it is copied. A mixed cell reference is a combination of relative and absolute references. A relative cell reference is a cell located in another worksheet in the same workbook.

Back

A relative cell reference is a cell located in another worksheet in the same workbook.

Front

Which feature allows you to manage and edit the names assigned to cell ranges in a spreadsheet?

Back

Name Manager