Question 1

Select all that apply . Which of the following are uses for spreadsheets to help people organize personal information?

Accepted Answer

A)  saving emails 
B)  documenting expenses for income tax purposes 
C)  setting up an expense budget 
D)  tracking performance in an exercise regimen 
A)  saving emails 
B)  documenting expenses for income tax purposes 
C)  setting up an expense budget 
D)  tracking performance in an exercise regimen B, C, D

Question 2

If a cell points to cell $F$3, this is an example of a(n)

Accepted Answer

A)  absolute cell reference 
B)  a reference to a cell on another spreadsheet 
C)  incorrect attempt at a cell reference 
D)  relative cell reference 
A)  absolute cell reference 
B)  a reference to a cell on another spreadsheet 
C)  incorrect attempt at a cell reference 
D)  relative cell reference A

Question 3

The rows of a spreadsheet are labeled with ________ .

Accepted Answer

numbers

Question 4

If a cell points to cell G5, this is an example of a(n)

Accepted Answer

A)  absolute cell reference 
B)  incorrect attempt at a cell reference 
C)  relative cell reference 
D)  a reference to itself 
A)  absolute cell reference 
B)  incorrect attempt at a cell reference 
C)  relative cell reference 
D)  a reference to itself

Question 5

If a cell points to cell $M3, this is an example of a(n)

Accepted Answer

A)  relative cell reference 
B)  absolute cell reference 
C)  an absolute reference to the column and a relative reference to the row 
D)  an absolute reference to the row and a relative reference to the column 
A)  relative cell reference 
B)  absolute cell reference 
C)  an absolute reference to the column and a relative reference to the row 
D)  an absolute reference to the row and a relative reference to the column

Question 6

Select all that apply . Which of the following function is(are) available to use in normal spreadsheets?

Accepted Answer

A)  finding the maximum value in a range of values 
B)  finding the second-to-lowest value in a range of values 
C)  finding the sum of a range of values 
D)  finding the average of a range of values 
A)  finding the maximum value in a range of values 
B)  finding the second-to-lowest value in a range of values 
C)  finding the sum of a range of values 
D)  finding the average of a range of values

Question 7

Spreadsheets normally import foreign data as

Accepted Answer

A)  text files 
B)  tab-delimited text 
C)  ASCII files 
D)  All of these 
A)  text files 
B)  tab-delimited text 
C)  ASCII files 
D)  All of these

Question 8

You cannot mix absolute and relative references in one cell reference .

Accepted Answer

A) True 
 B)False

Question 9

To select a range of cells

Accepted Answer

A)  click Select on the Edit menu 
B)  click the Add icon 
C)  drag the cursor across the cells 
D)  double-click the first and last cells 
A)  click Select on the Edit menu 
B)  click the Add icon 
C)  drag the cursor across the cells 
D)  double-click the first and last cells

Question 10

A group of cells in a spreadsheet is called a range .

Accepted Answer

A) True 
 B)False

Question 11

The manner in which time is displayed in a spreadsheet is always in military format (for example, 21:00:00) .

Accepted Answer

A) True 
 B)False

Question 12

A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n)

Accepted Answer

A)  series fill 
B)  conditional fill 
C)  auto-increment 
D)  date copy 
A)  series fill 
B)  conditional fill 
C)  auto-increment 
D)  date copy

Question 13

What is the most common use for a spreadsheet?

Accepted Answer

A)  to draw pie charts 
B)  as a journal 
C)  to process text 
D)  to process numerical data 
A)  to draw pie charts 
B)  as a journal 
C)  to process text 
D)  to process numerical data

Question 14

In a spreadsheet, a cell ________ is a naming scheme that allows the user to refer to a group of cells by naming the first cell, then placing a colon (:), and then naming the last cell .

Accepted Answer

The answer of In a spreadsheet, a cell ________ is...

Question 15

Suppose cell B4 has an entry . If the data in cell A4 is too wide to fit in its cell

Accepted Answer

A)  only part of the data will be visible but the rest of the data still exists 
B)  all the data will be accepted but the part that doesn't fit will overwrite the contents of cell B4 
C)  the data will not be accepted 
D)  only the part of the data that fits will be accepted 
A)  only part of the data will be visible but the rest of the data still exists 
B)  all the data will be accepted but the part that doesn't fit will overwrite the contents of cell B4 
C)  the data will not be accepted 
D)  only the part of the data that fits will be accepted

Question 16

Data from another application to be imported into a spreadsheet is called ________ data .

Accepted Answer

The answer of Data from another application to be imported...

Question 17

If the first character in a cell is the equals sign (=)

Accepted Answer

A)  the cell can only contain cell references and not data 
B)  the cell must reference at least two other cells 
C)  the cell contains a formula 
D)  None of these 
A)  the cell can only contain cell references and not data 
B)  the cell must reference at least two other cells 
C)  the cell contains a formula 
D)  None of these

Question 18

Hidden columns cannot be referenced in a formula .

Accepted Answer

A) True 
 B)False

Question 19

Because there are two dimensions in a spreadsheet (columns and rows), there are actually two ways a formula can be relative .

Accepted Answer

A) True 
 B)False

Question 20

A text file is the same thing as a tab-delimited file .

Accepted Answer

A) True 
 B)False

Exam 13: The Basics of Spreadsheets

Select all that apply . Which of the following are uses for spreadsheets to help people organize personal information?

If a cell points to cell $F$3, this is an example of a(n)

The rows of a spreadsheet are labeled with ________ .

If a cell points to cell G5, this is an example of a(n)

If a cell points to cell $M3, this is an example of a(n)

Select all that apply . Which of the following function is(are) available to use in normal spreadsheets?

Spreadsheets normally import foreign data as

You cannot mix absolute and relative references in one cell reference .

To select a range of cells

A group of cells in a spreadsheet is called a range .

The manner in which time is displayed in a spreadsheet is always in military format (for example, 21:00:00) .

A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n)

What is the most common use for a spreadsheet?

In a spreadsheet, a cell ________ is a naming scheme that allows the user to refer to a group of cells by naming the first cell, then placing a colon (:), and then naming the last cell .

Suppose cell B4 has an entry . If the data in cell A4 is too wide to fit in its cell

Data from another application to be imported into a spreadsheet is called ________ data .

If the first character in a cell is the equals sign (=)

Hidden columns cannot be referenced in a formula .

Because there are two dimensions in a spreadsheet (columns and rows), there are actually two ways a formula can be relative .

A text file is the same thing as a tab-delimited file .

Defining Information Technology

Exploring the Human-Computer Interface

The Basics of Networking

A Hypertext Markup Language Primer

Locating Information on the World Wide Web

An Introduction to Debugging

Representing Information Digitally

Representing Multimedia Digitally

Principles of Computer Operations

Algorithmic Thinking

Social Implications of IT

Privacy and Digital Security

Advanced Spreadsheets for Planning

Introduction to Database Concepts

A Case Study in Database Organization

Fundamental Concepts Expressed in Javascript

A Javascript Program

Programming Functions

Iteration Principles

A Case Study in Algorithmic Problem Solving

Limits to Computation

A Fluency Summary

Filters