Exam 1: Navigate, manipulate, and Print Worksheets

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Which of the following data types is NOT automatically right-aligned by Excel?

(Multiple Choice)
4.8/5
(32)

When you insert a new worksheet,it is inserted to the right of the active worksheet.

(True/False)
4.9/5
(31)

Formulas and functions begin with a(n)________ sign.

(Multiple Choice)
4.7/5
(27)

You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.

(Multiple Choice)
4.8/5
(35)
Match the following keyboard shortcuts to the movement of the active cell.
Tab
Column A of the current row
Ctrl + Home
Up one row
Home
One column to the right
Correct Answer:
Verified
Premises:
Responses:
Tab
Column A of the current row
Ctrl + Home
Up one row
Home
One column to the right
Shift + Enter
Cell A1
Enter
Down one row
(Matching)
4.8/5
(37)

The keyboard shortcut to move to cell A1 is ________.

(Multiple Choice)
4.9/5
(32)

The height of rows is defined in ________.

(Short Answer)
4.9/5
(38)

The AutoFill property adjusts the height of a row so that its cell contents fit in the row.

(True/False)
4.8/5
(42)

The Merge & Center button is located in the ________.

(Multiple Choice)
4.9/5
(37)

A formula is a built-in program that would be used to find the average of a series of numbers.

(True/False)
4.8/5
(43)

To select noncontiguous rows,you ________.

(Multiple Choice)
4.9/5
(43)

After selecting a column,pressing the shortcut key ________ will insert a new column.

(Short Answer)
4.8/5
(42)

In Excel,date and time data are special forms of numeric data.

(True/False)
4.7/5
(33)

When collecting data in a spreadsheet,each ________ is a field in a record.

(Short Answer)
4.9/5
(38)

When printing a workbook,the default print range is Print Active Sheets.

(True/False)
4.9/5
(41)

Documentation such as the author and modification history are contained a separate documentation ________.

(Short Answer)
4.9/5
(41)

To move up one screen,you use the Ctrl + Page Up keyboard shortcut.

(True/False)
4.7/5
(34)
Match the following terms to their definition.
AutoFill
Combination of a column letter and a row number
Cell range
File with at least on worksheet
Workbook
Selected worksheet cells
Correct Answer:
Verified
Premises:
Responses:
AutoFill
Combination of a column letter and a row number
Cell range
File with at least on worksheet
Workbook
Selected worksheet cells
Cell reference
Document representation standard
PDF
Copies information from a cell or cells to contiguous cells
(Matching)
4.9/5
(29)

The white spaces at the edges of a printed page are called ________.

(Short Answer)
4.8/5
(30)

To insert a line break or hard return in a cell,you would press ________.

(Multiple Choice)
4.8/5
(38)
Showing 61 - 80 of 106
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)