Exam 7: Create, Navigate, Work With, and Print Worksheets

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

A worksheet is a file containing at least one workbook.

Free
(True/False)
4.7/5
(30)
Correct Answer:
Verified

False

When using Excel,a spreadsheet is also referred to as a(n)________.

Free
(Short Answer)
4.8/5
(29)
Correct Answer:
Verified

worksheet

By default,________ data is left-aligned in a cell.

Free
(Short Answer)
4.8/5
(30)
Correct Answer:
Verified

text

You can copy a worksheet within a workbook,by ________,and then dragging a copy of the worksheet to its new location.

(Multiple Choice)
4.9/5
(36)

Time data is represented as a(n)________ value.

(Short Answer)
4.9/5
(38)

Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse.

(True/False)
4.8/5
(32)

________ data contains numbers and special characters such as the period (.)and hyphen (-).

(Short Answer)
4.8/5
(34)

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

(Multiple Choice)
4.8/5
(36)
Match the following terms with their definition.
Comment
Represented as a decimal value
Numeric data
Can contain any combination of printable characters
Text data
A text box,similar to a sticky note,that is attached to a cell
Correct Answer:
Verified
Premises:
Responses:
Comment
Represented as a decimal value
Numeric data
Can contain any combination of printable characters
Text data
A text box,similar to a sticky note,that is attached to a cell
Date data
Takes the form of a serial number
Time data
Data that contains only the digits 0-9 and possibly a period (.)
(Matching)
4.7/5
(35)

Merge & Center can only be applied to horizontal cell ranges.

(True/False)
4.7/5
(30)

When collecting data in a spreadsheet,each row contains a record.

(True/False)
4.8/5
(30)
Match the following terms with their definition.
Record
Each instance of a spreadsheet
Worksheet
Allows you to examine the outcome of the changes to values in a worksheet
What-if analysis
A horizontal set of cells that encompasses all the columns in a worksheet
Correct Answer:
Verified
Premises:
Responses:
Record
Each instance of a spreadsheet
Worksheet
Allows you to examine the outcome of the changes to values in a worksheet
What-if analysis
A horizontal set of cells that encompasses all the columns in a worksheet
Row
All of the categories of data that are formatted as a row in a worksheet
Spreadsheet
A two-dimensional grid that can be used to model quantitative data
(Matching)
4.8/5
(44)

The Merge & Center button is located in the ________ tab.

(Multiple Choice)
4.9/5
(33)

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

(True/False)
4.8/5
(28)

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

(Multiple Choice)
4.9/5
(29)

Which of the following is NOT a type of data that can be contained in a cell?

(Multiple Choice)
4.7/5
(29)

The base date for date and time data in Excel 2016 is ________.

(Multiple Choice)
4.9/5
(29)

The intersection of each row and column is called a(n)________.

(Short Answer)
4.9/5
(29)

One of the most efficient ways of moving data from oe cell to another is to drag and drop.

(True/False)
4.8/5
(40)

A(n)________ is a built-in program that performs a task such as finding the sum of a series of numbers.

(Short Answer)
4.9/5
(39)
Showing 1 - 20 of 99
close modal

Filters

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