Deck 1: Getting Started With Excel

Question 1

The AutoComplete feature automatically completes an entry based on previous entries in a column.

Answer 1

True

Question 2

Microsoft Excel 2010 stores spreadsheets in files called workbooks.

Answer 2

True

Question 3

Scrolling through sheet tabs does not change the active sheet in the workbook window.

Answer 3

True

Question 4

To create a line break within a cell,press Alt + Enter.

Question 5

Referring to the figure above,the cell that is shown with the thick border,is called the primary cell.

Question 6

Referring to the figure above,the intersection of each row and column is called a cell.

Question 7

A spreadsheet is a collection of numbers,not text.

Question 8

Text is right-aligned in cells,like number data.

Question 9

The figure above shows part of a worksheet.

Question 10

Excel workbooks can contain two kinds of sheets.

Question 11

You can use the Go To dialog box to navigate to a specific worksheet.

Question 12

A documentation sheet is a valuable element if you intend to share the workbook with others.

Question 13

Text is truncated when the cell that it resides in is not wide enough to display all of it.

Question 14

If you click the Print Active sheet(s)option button in the Print tab,the entire workbook will be printed.

Question 15

The name of the active workbook appears in the status bar of the Excel window.

Question 16

Charts can be embedded into worksheets.

Question 17

Referring to the figure above,the Zoom control is set at 100%.

Question 18

Referring to the figure above,the row headings are the letters along the top of the worksheet window that identify the different rows in the worksheet.

Question 19

The formula bar displays the value or formula of the active cell.

Question 20

Referring to the figure above,column heading K is orange because the entire row is selected.

Question 21

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Displays contents of a spreadsheet

Question 22

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
A named operation that returns a value

Question 23

A(n)nonadjacent range is comprised of two or more distinct adjacent ranges._________________________

Question 24

Expressions are used in a formula to combine different values,returning a single value that is then displayed in the cell._________________________

Question 25

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Multiplication before addition

Question 26

A newly inserted sheet is inserted to the left of the active sheet._________________________

Question 27

Autofitting eliminates space by matching the column to the width of its longest cell entry._________________________

Question 28

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
When you copy a range of cells,you must press this key while you drag the selection to its new location

Question 29

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points._________________________

Question 30

A group of cells is called a group reference._________________________

Question 31

In the formula,=2+6*2,addition would be calculated after multiplication._________________________

Question 32

The range reference for nonadjacent ranges separates each adjacent range reference by a colon._________________________

Question 33

When you work in Edit mode,some keyboard shortcuts will only apply to the text in the selected cell._________________________

Question 34

In landscape orientation,the page is wider than it is tall._________________________

Question 35

When you insert a new column,the existing columns are shifted to the left._________________________

Question 36

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
A group of worksheet cells

Question 37

Page Layout view displays the location of the different page breaks within the worksheet._________________________

Question 38

Clearing data from a worksheet removes the data and the cells._________________________

Question 39

To move a cell,select it,then place the mouse over the bottom border of the cell before dragging it to a new location._________________________

Question 40

A newly inserted row has the same height as the row above it._________________________

Question 41

The name given to an Excel workbook before you rename it is ____.

A) Document1
B) Book1
C) Workbook1
D) Untitled1

Question 42

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Shows the contents of the worksheet

Question 43

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Displays the cell reference of the active cell

Question 44

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Press Ctrl + ` to switch to this view

Question 45

To make A1 the active cell,you should press which of the following keys?

A) Page Up
B) Page Down
C) Home
D) Ctrl+Home

Question 46

A chart can be displayed ____.

A) in a worksheet
B) in a chart sheet
C) in a cell range
D) both a and b are correct

Question 47

To go to column A of the current row,click ____.

A) Ctrl + Home
B) Home
C) Shift + Tab
D) Tab + Enter

Question 48

The contents of an active cell are displayed in the ____.

A) toolbar
B) menu bar
C) name box
D) formula bar

Question 49

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Quickly inserts Excel functions

Question 50

By default,Excel starts with a ____ maximized to fill the Excel window.

A) sample workbook with calculations
B) sample workbook with formulas
C) sample workbook with text,formulas,can calculations
D) blank workbook

Question 51

By default,an Excel workbook is made up of ____ worksheets.

A) two
B) three
C) four
D) five

Question 52

Row headings identify each row using a different ____.

A) operator
B) number
C) letter
D) number and letter combination

Question 53

The intersection of a row and column is known as a ____.

A) cell
B) range
C) reference
D) border

Question 54

An Excel worksheet can have a maximum of ____ columns in a worksheet.

A) 156
B) 256
C) 16,385
D) 17 million

Question 55

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Where spreadsheets are stored

Question 56

Excel stores its documents as files called ____.

A) worksheets
B) sheet tabs
C) workbooks
D) books

Question 57

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Displays the name of the sheets in the workbook

Question 58

"AD" is an example of a ____.

A) column heading
B) row heading
C) cell reference
D) Name box

Question 59

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.function
g.Ctrl
b.workbook
h.Normal view
c.worksheet
i.AutoSum button
d.range
j.what-if analysis
e.order of precedence
k.formula view
f.Name box
l.sheet tabs
Allows you to use Excel to change one or more values in a spreadsheet and
then assess the effect those changes have on the calculated values

Question 60

Excel is an electronic version of a(n)____.

A) database
B) spreadsheet
C) expression
D) formula

Question 61

To select a nonadjacent range,select an adjacent range,press and hold ____ and then select other adjacent ranges.

A) Home
B) Shift
C) Ctrl
D) ` (grave key)

Question 62

Excel provides the ability to create new worksheets and new ____ sheets

A) documentation
B) chart
C) workbook
D) reference

Question 63

Text data is any combination of ____.

A) letters and numbers
B) letters,numbers,and dates
C) only letters
D) letters,numbers,and symbols

Question 64

The active cell has a ____ border.

A) dotted
B) red
C) thick
D) dashed

Question 65

The characters +,-,*,and / are examples of ____.

A) formulas
B) values
C) arithmetic operators
D) calculations

Question 66

To view formulas,rather than the resulting values in a worksheet,switch to ____.

A) formula view
B) normal view
C) editing mode
D) AutoSum view

Question 67

In the figure above,the row headings are the ____ of the worksheet window that identify the different rows in the worksheet.You click a row heading to select the entire worksheet row.

A) letters along the top
B) numbers along the left side
C) tabs at the bottom
D) none of the above

Question 68

Removing the contents of a cell is known as ____ a cell.

A) clearing
B) emptying
C) editing
D) deleting

Question 69

A(n)____ is a group of cells.

A) cluster
B) adjunct
C) selection
D) range

Question 70

Which describes the nonadjacent range shown in the figure above?

A) A6:A9;C6:C9
B) A6:A9-C6:C9
C) A6:C9
D) A6;C9

Question 71

The expression used to calculate values displayed in a worksheet is called a(n)____.

A) formula
B) equation
C) operator
D) relation

Question 72

To divide the value of a cell by some number,use the ____ operator.

A) +
B) =
C) /
D) *

Question 73

In the figure above,"Documentation" and "Customer Orders" are names of ____.

A) worksheets
B) files
C) workbooks
D) folders

Question 74

None of the data shown in the figure above is ____.

A) aligned
B) truncated
C) formatted
D) formulated

Question 75

To complete a cell entry,press the ____ key.

A) Enter
B) Home
C) Backspace
D) Delete

Question 76

In the figure above,the formula shown SUM(H6:H9)appears in the ____.

A) address box
B) address bar
C) formula box
D) formula bar

Question 77

Text is ____-aligned in cells.

A) right
B) left
C) center
D) justify

Question 78

You can also move to the previous or next sheet by pressing the ____ keys.

A) Alt+Page Up or Alt+Page Down
B) Ctrl+Page Up or Ctrl+Page Down
C) Tab+Page Up or Tab+Page Down
D) F4+Page Up or F4+Page Down

Question 79

The formula used to multiply cell A1 by cell C1 is ____.

A) =A1*C1
B) C1*A1
C) =A1/C1
D) A1*C1

Question 80

An Excel formula always begins with a(n)____.

A) parentheses
B) equals sign
C) plus sign
D) colon