Homework answers / question archive / Chapter 13: Creating a Workbook   TRUE/FALSE       1)   In a what-if analysis, you change one or more values in a spreadsheet and then assess how those changes affect the calculated values

Chapter 13: Creating a Workbook   TRUE/FALSE       1)   In a what-if analysis, you change one or more values in a spreadsheet and then assess how those changes affect the calculated values

Computer Science

Share With

---

 

TRUE/FALSE

 

    1)   In a what-if analysis, you change one or more values in a spreadsheet and then assess how those changes affect the calculated values.

 

 

     2.   Excel stores spreadsheets in files called worksheets.

 

 

     3.   The formula bar displays the contents of the active cell.

 

     4.   If an integer is longer than its cell size, you see only some of the numbers in the cell.

 

 

     5.   A group of cells is called a field.

 

 

     6.   To delete a range, select the range and then click the Delete button in the Cells group on the Home tab.

 

 

     7.   A function is a named operation that returns a value.

 

 

     8.   Page Layout view shows how a sheet will look when printed.

 

 

     9.   Code view displays the formulas used in a worksheet instead of the resulting values.

 

 

   10.   To scale something means to change its size proportionately.

 

 

MODIFIED TRUE/FALSE

 

     1.   A(n) chart sheet contains a visual representation of spreadsheet data.

 

 

     2.   The cell in which you are currently working is known as the live cell.

 

 

     3.   Text data is often referred to as a(n) text string.

 

 

     4.   In Excel, numbers can be integers, decimals, or fractals.

 

 

     5.   You find the Cells group on the Home tab.

 

 

     6.   A range spotter indicates the location and size of a range.

 

 

     7.   A(n) operand is a mathematical symbol used to combine values.

 

     8.   Order of precedence is a set of predefined rules used to determine the sequence in which operators are applied in a calculation.

 

 

     9.   Content view simply shows the contents of a worksheet.

 

 

   10.   By default, Excel displays pages in portrait orientation.

 

 

MULTIPLE CHOICE

 

     1.   Excel is ____ software used to enter, analyze, and present ____ data.

a.	application, qualitative	c.	application, quantitative
b.	operating system, qualitative	d.	operating system, quantitative

 

 

 

     2.   Excel stores spreadsheets in files called ____.

a.	workbooks	c.	relational databases
b.	worksheets	d.	comma-delimited RTF

 

 

 

     3.   In the figure above, box ____ points to the active cell.

a.	A	c.	G
b.	D	d.	H

 

 

     4.   In the figure above, box ____ indicates the formula bar.

a.	B	c.	E
b.	C	d.	J

 

 

     5.   In the figure above, box E points to ____.

a.	open documents	c.	the cell reference
b.	sheet tabs	d.	the range reference

 

 

 

     6.   In the figure above, the active sheet is ____.

a.	Sheet1	c.	Sheet3
b.	Sheet2	d.	can’t tell

 

 

 

     7.   In the figure above, the visible row headings run from ____ to ____.

a.	A, O	c.	A1, O25
b.	1, 25	d.	A, 1

 

 

 

     8.   A cell ____ indicates the cell’s column and row location.

a.	range	c.	tab
b.	reference	d.	report

 

 

 

     9.   New workbooks contain ____ sheets by default.

a.	1	c.	3
b.	2	d.	4

 

 

 

   10.   The following are all steps in the basic process of building a complete and accurate workbook, as listed in the text, EXCEPT ____.

a.	insert a documentation sheet	c.	distribute the final workbook
b.	enter formulas for calculated values	d.	crosslink appropriate records and fields

 

 

 

   11.   To copy rather than move a sheet, press and hold the ____ key as you drag and drop the sheet tab.

a.	Ctrl	c.	Shift
b.	Windows	d.	Alt

 

 

 

   12.   The ____ bar displays the contents of the active cell.

a.	control	c.	formula
b.	status	d.	closeup

 

 

 

   13.   Text data can contain ____.

a.	letters only	c.	letters, numbers, and symbols
b.	letters and numbers only	d.	characters, images, and audio tracks

 

 

 

   14.   In Excel, ____ are actually numbers formatted to appear as text.

a.	equations	c.	dates
b.	strings	d.	all of the above

 

 

 

   15.   If you see ###### instead of a value in a cell, the reason is most likely that ____.

a.	the cell is a Hidden Password data type
b.	the value is an integer that is too long to fit in the cell
c.	the cell is a formula
d.	the author has added special formatting to the row in which the cell resides

 

 

 

   16.   You can edit cell contents directly in a cell by ____.

a.	double-clicking the cell
b.	selecting the cell, double-clicking the formula bar, and then right-clicking in the cell
c.	selecting the cell, and then pressing the F1 key
d.	any of the above

 

 

 

   17.   To select an entire column, you ____.

a.	double-click a cell
b.	drag the mouse to select at least three cells in the column, then double-click the selection
c.	click its column heading
d.	click Select under Columns in the Page Layout tab

 

 

 

   18.   Text that Excel cuts off from display in a cell is said to be ____.

a.	cropped	c.	deleted
b.	truncated	d.	demarcated

 

 

 

   19.   You should set column widths based on ____.

a.	pixel size
b.	computer monitor size
c.	the maximum number of characters you want to display in cells
d.	point size

 

 

 

   20.   When you insert a new column, the existing columns ____.

a.	shift to the left	c.	shift to the top
b.	shift to the bottom	d.	shift to the right

 

 

 

   21.   A group of ____ is called a range.

a.	sheets	c.	workbooks
b.	tabs	d.	cells

 

 

 

   22.   A(n) ____ is a single rectangular block of cells.

a.	adjacent range	c.	mini-sheet
b.	nonadjacent range	d.	workbook

 

 

 

   23.   The term A1:A5 is a(n) ____.

a.	cell reference	c.	range reference
b.	array block	d.	range block

 

 

 

   24.   A blinking border around a range indicates that ____.

a.	the cell values in that range need to be updated
b.	errors exist somewhere in that range
c.	the selection has been stored on the Clipboard
d.	none of the above

 

 

 

   25.   When you paste, you can select only the ____ cell of the range in the new location.

a.	middle	c.	center-left
b.	upper-right	d.	upper-left

 

 

 

   26.   If you select a range and then click Insert in the Cells group on the Home tab, the selected range shifts ____.

a.	down
b.	right
c.	left
d.	either a or b, depending on whether the range is wider than long or longer than wide

 

 

 

   27.   The main reason for using Excel is to display ____.

a.	well-formatted columns of text data
b.	static numbers and symbols in a rigid format
c.	values calculated from data
d.	raw data

 

 

 

   28.   A formula is a mathematical expression that ____.

a.	returns a value
b.	does not return a value
c.	can only be calculated by a computer
d.	derives exclusively from calculus algorithms

 

 

 

   29.   Of the following, ____ comes second in the order of precedence.

a.	*	c.	^
b.	/	d.	-

 

 

 

   30.   To add the values in cells B1, B2, and B3, the formula would be ____.

a.	ADD B1-B3	c.	=B1+B2+B3
b.	=B1-B2-B3	d.	=B1+2+3

 

 

 

   31.   All Excel formulas begin with the ____ symbol.

a.	=	c.	+
b.	^	d.	|

 

 

 

   32.   After a formula has been entered into a cell, the cell displays ____.

a.	the formula	c.	the word FORMULA
b.	the results of the formula	d.	the = sign

 

 

 

   33.   A(n) ____ is a named operation that returns a value.

a.	formula	c.	form
b.	function	d.	equation

 

 

 

   34.   Excel supports more than ____ functions. (Choose the number given in the text.)

a.	30	c.	300
b.	100	d.	1000

 

 

   35.   The AutoSum command will automatically choose from the most likely of ____ common functions.

a.	2	c.	20
b.	5	d.	300

 

 

 

   36.   ____ view simply shows the contents of a sheet.

a.	Normal	c.	Layout
b.	Template	d.	Standard

 

 

 

   37.   ____ view shows how a sheet will look when printed.

a.	Print	c.	Layout
b.	Print Layout	d.	Page Layout

 

 

 

   38.   By default, Excel displays pages in ____ orientation.

a.	sheet	c.	portrait
b.	landscape	d.	cascading

 

 

 

   39.   You can view the formulas in a worksheet by switching to ____ view.

a.	code	c.	Backstage
b.	formula	d.	details

 

 

 

   40.   To ____ something means to change its size proportionately.

a.	crop	c.	spatialize
b.	truncate	d.	scale

 

 

 

Case-Based Critical Thinking Questions

 

Case 13-1

In the following questions, use your knowledge of operators and the order of precedence to find the solution.

 

   41.   (7-3) * 4

a.	-5	c.	256
b.	16	d.	8

 

 

 

   42.   (12/4) * (7-5)

a.	6	c.	16
b.	5	d.	1.5

 

 

 

   43.   10 - 3 + 4 - 1 * (10 - 3 - 4 - 1)

a.	9	c.	6
b.	20	d.	13

 

 

 

   44.   18 + (5*2) * ((6/2) - (2+1))

a.	38	c.	18
b.	16	d.	52

 

 

 

Case-Based Critical Thinking Questions

 

Case 13-2

Decide whether each of the following questions describes truncation, deletion, or clearing—using those terms as defined in this chapter.

 

   45.   Your spreadsheet has 10 rows and you only need the top 8. You want to completely remove the last two rows.

a.	truncation	c.	clearing
b.	deletion	d.	none of the above

 

 

 

   46.   You have put together a spreadsheet with sales figures for your company. Your spreadsheet contains four rows: Northeast - John; Southeast - Alexa; Midwest - Ryan; West Coast - Michelle. You just learned that Alexa’s sales figures were erroneous. You need to remove her data and start again.

a.	truncation	c.	clearing
b.	deletion	d.	none of the above

 

 

 

   47.   You typed long blocks of text into various cells in column E when column F was empty. When you start adding values to column F, the text in the cells of column E seems to be disappearing.

a.	truncation	c.	clearing
b.	deletion	d.	none of the above

 

 

 

Case-Based Critical Thinking Questions

 

Case 13-3

For each of the following questions, determine how Excel would present the data.

 

   48.   You type: 08-08-18

a.	Aug 8, 2018	c.	8/8/2018
b.	Aug 18, 2008	d.	08/08/18

 

 

 

   49.   You type: October 2, 2012

a.	Oct-2-12	c.	2-Oct-12
b.	2012-2-Oct	d.	Oct 2, 2012

 

 

 

   50.   You type: $125.23

a.	125.23	c.	$125
b.	125	d.	none of the above

 

 

 

COMPLETION

 

     1.   In a(n) ____________________ analysis, you change one or more values in a spreadsheet and then assess how those changes affect the calculated values.

 

 

     2.   A(n) ____________________ contains a visual representation of spreadsheet data.

 

 

     3.   The cell reference for the active cell appears in the ____________________ box in the upper-left corner of the worksheet.

 

 

     4.   When you finish typing data into a cell, you press the Enter or ____________________ key to complete the data entry and move to the next cell.

 

 

     5.   If you enter the date May 2, 2013 into Excel, it will change the date to ____________________.

 

 

     6.   Column widths may be expressed in terms of the number of characters a column can contain or the size of the column in ____________________.

 

     7.   ____________________ the bottom border of a row to AutoFit the row to the height of its tallest cell entry.

 

 

     8.   ____________________ data removes the data from a worksheet but leaves the blank cells.

 

 

     9.   A(n) ____________________ range consists of two or more distinct adjacent ranges.

 

 

   10.   When you cut or copy a range, the selected cells are surrounded by a(n) ____________________ border.

 

 

   11.   You find the Delete button in the Cells group on the ____________________ tab.

 

   12.   ____________________ is a set of predefined rules used to determine the sequence in which operators are applied in a calculation.

 

 

   13.   After a formula has been entered into a cell, the cell displays ____________________.

 

 

   14.   =SUM(A1:A9) is an example of an Excel ____________________.

 

 

   15.   In formula view, the columns containing formulas temporarily ____________________ so that you can see the entire formulas.

 

 

MATCHING

 

 

a.	formula bar	g.	active
b.	clear	h.	truncate
c.	what-if analysis	i.	delete
d.	range	j.	text string
e.	operator	k.	function
f.	worksheet	l.	cell reference

 

 

     1.   combines different values, returning a single value that is displayed in a cell

 

     2.   displays the contents of the active cell

 

     3.   contains data, laid out in a grid of rows and columns

 

     4.   a named operation that returns a value

 

     5.   a group of cells

 

     6.   indicates a cell’s column and row location

 

     7.   removes both data and cells from a worksheet

 

     8.   the cell you are working in or the sheet you are viewing

 

     9.   removes data from a worksheet but leave the blank cells

 

   10.   changes a value and assesses the impact on calculated values

 

   11.   cuts off

 

   12.   a combination of letters, numbers, and symbols that form words and sentences

 

ESSAY

 

     1.   Learning to use navigation keys rather than the mouse will save you a good deal of time when working with Excel. The chapter listed several keyboard shortcuts and their associated actions for navigating around a worksheet. List six of those here.

 

 

     2.   Name and briefly describe the three rules listed in the chapter for creating effective formulas.

 

 

     3.   Name and briefly describe the five functions listed in the chapter that you can insert with AutoSum. Explain briefly the general steps to use AutoSum with a function other than SUM.