Deck 15: Excel 2007 Unit A: Getting Started With Excel 2007

Question 1

Reference operators compare values for the purpose of true/false results.

Answer 1

False

Question 2

In Excel, the electronic spreadsheet you work in is called a ____.

A) workbook
B) databook
C) numericsheet
D) worksheet

Answer 2

D

Question 3

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

A) represent values graphically
B) organize data
C) create what-if data scenarios
D) perform calculations

Answer 3

C

Question 4

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Question 5

When the paper orientation is portrait , the contents will print across the length of the page instead of across the width.

Question 6

Tools on the Page Layout tab include a Page Setup group, where you can adjust print orientation, paper size, and page breaks.

Question 7

Page Layout View shows the worksheet without including certain details like headers and footers or tools like rulers and a page number indicator.

Question 8

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon .

Question 9

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Question 10

Labels are numbers, formulas, and functions that can be used in calculations.

Question 11

Arguments are Excel's built-in formulas.

Question 12

When the paper orientation is set on landscape, the contents will print across the width of the page.

Question 13

You are in Edit mode any time you are entering or changing the contents of a cell.

Question 14

You can use predesigned, formatted files called ____ to create new worksheets quickly.

A) formatsheets
B) layouts
C) templates
D) screens

Question 15

Charts are updated automatically in Excel whenever data changes.

Question 16

Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet.

Question 17

In Excel, a worksheet is contained in a file called a ____.

A) workbook
B) workpad
C) notebook
D) datapad

Question 18

An Excel workbook has the file extension .xml.

Question 19

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

A) database
B) spreadsheet
C) dataform
D) project

Question 20

In Page Layout view, the dotted line indicates the print area.

Question 21

As shown in the figure above, item 1 points to the ____.

A) insertion point
B) mode indicator
C) Enter button
D) active cell

Question 22

____ are entries that contain text and numerical information not used in calculations.

A) Values
B) Labels
C) Sheet tabs
D) Arguments

Question 23

As shown in the figure above, item 2 points to the ____.

A) sheet tabs
B) status bar
C) mode indicator
D) sheet tab scrolling buttons

Question 24

As shown in the figure above, item 1 points to the ____.

A) sheet tabs
B) status bar
C) cell pointers
D) sheet tab scrolling buttons

Question 25

As shown in the figure above, item ____ points to the formula bar.

A) 1
B) 2
C) 3
D) 4

Question 26

As shown in the figure above, item ____ points to the cell pointer, which outlines the active cell.

A) 1
B) 2
C) 3
D) 4

Question 27

____ consist of the information needed by a function to calculate an answer.

A) Labels
B) Arguments
C) Values
D) Templates

Question 28

To move a screen to the left press ____.

A) [Ctrl][Home]
B) [Alt][Page Up]
C) [Ctrl][Page Left]
D) [Alt][Page Down]

Question 29

All Excel formulas begin with the ____.

A) plus sign (+)
B) asterisk (*)
C) equal sign (=)
D) slash (/)

Question 30

Excel recognizes an entry as a value if it is a number or it begins with ____.

A) +
B) =
C) $
D) All of the above

Question 31

To quickly jump to the first cell in a worksheet press ____.

A) [Alt][Page Up]
B) [Shift][Home]
C) [Page Up]
D) [Ctrl][Home]

Question 32

You can edit the contents of an active cell by ____.

A) pressing the [ ¯] key and starting to type
B) pressing the [Home] key and starting to type
C) just starting to type
D) pressing the [Ctrl] key and the [Home] key and starting to type

Question 33

You can use the ____ key(s) on the keyboard to navigate a worksheet.

A) [Ctrl]
B) Zoom
C) arrow
D) [Enter]

Question 34

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

A) Cell pointers
B) Mode indicators
C) Scroll bars
D) Sheet tabs

Question 35

The Excel operator for exponent is ____.

A) /
B) \
C) %
D) ^

Question 36

As shown in the figure above, item 4 points to the ____.

A) formula button
B) status bar
C) mode indicator
D) Insert Worksheet button

Question 37

The Excel operator for division is ____.

A) /
B) \
C) %
D) ^

Question 38

You can use ____ to move around in a document that is too large to fit on the screen at once.

A) cell pointers
B) mode indicators
C) scroll bars
D) sheet tabs

Question 39

As shown in the figure above, item 3 points to the ____.

A) sheet tabs
B) status bar
C) cell pointers
D) sheet tab scrolling buttons

Question 40

As shown in the figure above, item ____ points to the Name box.

A) 1
B) 2
C) 3
D) 4

Question 41

In the figure above, item 4 points to the ____ button.

A) Close Print Preview
B) Page Setup
C) Zoom
D) Print

Question 42

Describe Excel's built-in recovery feature.

Question 43

In the Sheet Options group of the Page Layout tab, you can ____.

A) turn on and off column/row headings
B) adjust paper size
C) adjust page breaks
D) adjust line spacing

Question 44

Discuss the guidelines for creating calculations in Excel.

Question 45

Any time you use a worksheet to ask the question "what if?" you are performing ____________________.

Question 46

As shown in the figure above, item 2 points to the ____.

A) insertion point
B) mode indicator
C) Enter button
D) active cell

Question 47

The cell in which you are working is called the ____________________ cell.

Question 48

Explain the difference between Normal view and Page Layout view in Excel.

Question 49

Possible paper orientations for printing a worksheet are landscape and ____.

A) preview
B) portrait
C) normal
D) page break

Question 50

Clicking the ____________________ button sums the adjacent range above or to the left.

Question 51

In a worksheet, the ____ is called the formula prefix.

A) minus sign (-)
B) plus sign (+)
C) pound sign (#)
D) equal sign (=)

Question 52

____ operators perform mathematical calculations such as adding and subtracting.

A) Text concatenation
B) Reference
C) Arithmetic
D) Comparison

Question 53

In the figure above, the arrow points to the ____________________ button.

Question 54

Discuss the advantages of using Excel worksheets.

Question 55

In the figure above, item 2 points to the ____ button.

A) Close Print Preview
B) Page Setup
C) Zoom
D) Print

Question 56

As shown in the figure above, item 3 points to the ____.

A) insertion point
B) mode indicator
C) Enter button
D) active cell

Question 57

In the figure above, item 3 points to the ____ button.

A) Close Print Preview
B) Page Setup
C) Zoom
D) Print

Question 58

In the figure above, item 1 points to the ____ button.

A) Close Print Preview
B) Page Setup
C) Zoom
D) Print

Question 59

____________________ are equations in a worksheet.

Question 60

Describe calculation operators, including the different types of calculation operators.

Question 62

You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. Below is the worksheet that you have created so far. Please write a formula for finding the difference between the two test scores for each student and add it in to the spreadsheet.

Question 63

You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company s sales to send to the General Manager. Below is the worksheet that you have created so far. Write the complete formulas for finding the Yearly Sales figures for the three stores.

Question 64

You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. Below is the worksheet that you have created so far. Write formulas for finding the averages of each test.

Question 65

You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. Below is the worksheet that you have created so far. You realize that you have made an error in the spreadsheet. Gary s score for test 2 should be 76, not 67. This error needs to be remedied. Please explain how you would go about fixing this error. Make sure to note what mode Excel would need to be in and how changes to C4 would affect a formula in D4.

Question 66

You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company s sales to send to the General Manager. Below is the worksheet that you have created so far. Write the complete formulas for the Total row, which contains the total sales in all of the three stores in each quarter.