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
(78)

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

(True/False)
5.0/5
(64)

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

(Multiple Choice)
4.8/5
(75)

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
(86)
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
(84)

The keyboard shortcut to move to cell A1 is ________.

(Multiple Choice)
4.9/5
(82)

The height of rows is defined in ________.

(Short Answer)
4.9/5
(77)

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

(True/False)
4.9/5
(82)

The Merge & Center button is located in the ________.

(Multiple Choice)
4.9/5
(80)

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
(80)

To select noncontiguous rows,you ________.

(Multiple Choice)
4.8/5
(94)

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

(Short Answer)
4.8/5
(83)

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

(True/False)
4.8/5
(75)

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

(Short Answer)
4.9/5
(96)

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

(True/False)
4.8/5
(77)

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

(Short Answer)
4.9/5
(85)

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

(True/False)
4.7/5
(77)
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
(82)

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

(Short Answer)
4.8/5
(77)

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

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

Filters

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