Deck 9: Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Question 1

Of the following,which makes up the smallest element in a workbook?

A) cell
B) row
C) worksheet
D) column

Answer 1

A

Question 2

Excel 2010 workbooks are saved with a default file extension of ________.

A) .wbk
B) .exc
C) .accdb
D) .xlsx

Answer 2

D

Question 3

All functions must begin with the ________ character.

A) $
B) =
C) >
D) ?

Answer 3

B

Question 4

Which of the following statements is FALSE?

A) Excel 2010 workbooks have xls as their file extension.
B) A spreadsheet is a powerful computer program.
C) Spreadsheets are a grid of rows and columns.
D) Spreadsheets are commonly used to perform what-if analysis.

Question 5

Which of the following statements about workbooks is TRUE?

A) Workbooks must contain three worksheets.
B) New, blank workbooks contain three worksheets, by default.
C) There is a maximum of five worksheets in a workbook.
D) Workbooks have a file extension of .xls.

Question 6

A ________ is found at an intersection in Excel,and might have a name such as C8 or G11.

A) column
B) row
C) worksheet
D) cell

Question 7

A cell in the third row and fourth column has the cell reference ________.

A) C4
B) 3D
C) 4C
D) D3

Question 8

Sheet1 is an example of a default ________ within a workbook.

A) worksheet
B) row
C) cell
D) column

Question 9

Which of the following is least likely to be found in a single cell?

A) operators
B) text
C) charts
D) functions

Question 10

Keyboard navigation can be done using ________ such as pressing the Tab key to move one column right.

A) keyboard shortcuts
B) magic keys
C) active keys
D) keyboard references

Question 11

SUM and AVERAGE are examples of ________.

A) formulas
B) functions
C) cell references
D) records

Question 12

A user wishes to change values in a cell and see what the effects are on calculated values elsewhere in the worksheet.The user has executed a(n)________.

A) AutoFill
B) what-if analysis
C) formula
D) function

Question 13

What-if analysis allows users to ________.

A) create graphs and charts of existing data.
B) insert built-in programs that perform tasks like SUM and AVERAGE.
C) change values in spreadsheet cells to investigate the effects on calculated values of interest.
D) create an equation that produces a result.

Question 14

A ________ is labeled with letters,such as A,B,or C.

A) column
B) row
C) worksheet
D) cell

Question 15

Another word for a spreadsheet is ________.

A) workbook
B) field
C) worksheet
D) record

Question 16

An equation that produces a result is known as a(n)________.

A) function
B) record
C) formula
D) cell reference

Question 17

Which of the following statements is FALSE?

A) Worksheets contain rows and columns.
B) Worksheets contain workbooks.
C) The number of worksheets that be contained in a workbook is a function of the amount of available memory.
D) Another term for worksheets is spreadsheets.

Question 18

A ________ is labeled with a number,such as 1,2,or 3.

A) column
B) row
C) cell
D) worksheet

Question 19

Which of the following is not a valid cell reference?

A) A3
B) J21
C) AA3
D) 4C

Question 20

Microsoft's spreadsheet application is known as ________.

A) Publisher
B) Excel
C) Access
D) Outlook

Question 21

A worksheet contains all of the following EXCEPT ________.

A) columns
B) rows
C) worksheets
D) cells

Question 22

A worksheet is made up of rows and columns.

Question 23

Which of the following represents a cell range?

A) C6-E10
B) $B$6
C) A4 + D14
D) N8:P9

Question 24

A worksheet is a spreadsheet contained in a workbook.

Question 25

Which of the following is FALSE?

A) White space is always white.
B) White space gives a document visual structure.
C) White space is a term for the part of the document that does not contain data or documentation.
D) White space creates a sense of order in the mind of the worksheet user.

Question 26

Text that is too lengthy to fit in one cell can have text wrapping applied,or the user can add a ________ to break up the data inside a cell.

A) date/time
B) range
C) section break
D) hard return

Question 27

Which of the following is an example of portrait dimensions?

A) 8.5 inches wide by 11 inches tall
B) 11 inches wide by 8.5 inches tall
C) 5 inches wide by 5 inches tall
D) All are examples of portrait dimensions.

Question 28

AutoFill allows users to ________ using the fill handle.

A) delete formulas from within cells
B) move content from one cell to another
C) copy information to the office clipboard to paste in to another worksheet
D) copy information from one cell, or a series of cells, in to another set of cells

Question 29

A group of selected cells is also known as a cell ________.

A) cluster
B) range
C) block
D) field

Question 30

The intersection of a row and column is called a cell.

Question 31

Cells can contain text,numbers,formulas,and/or functions.

Question 32

R4:T8 is an example of a ________.

A) row
B) column
C) cell reference
D) cell range

Question 33

In order to see what a worksheet will look like when printed,use the Print ________ feature.

A) Preview
B) Range
C) White Space
D) Setup

Question 34

A workbook must contain at least three worksheets.

Question 35

Which of the following statements is FALSE?

A) Scaling can fit all columns on a single page.
B) Scaling may make data too small to be readable.
C) A worksheet in landscape orientation may be 11 inches wide by 8.5 inches tall.
D) Portrait orientation means a page is wider than it is tall.

Question 36

Excel includes common functions such as SUM and AVERAGE.

Question 37

Printable characters,including letters,numbers,and special characters,are stored as ________ data.

A) text
B) date/time
C) numeric
D) none of the above

Question 38

Worksheet navigation is defined as moving the location of the active ________.

A) column
B) cell
C) row
D) worksheet

Question 39

A worksheet that is not currently visible can be changed to the ________ worksheet by clicking on the worksheet tab in the bottom-left corner of the Excel window.

A) default
B) referenced
C) dormant
D) active

Question 40

A spreadsheet is a computer program.

Question 41

A new Excel workbook contains three worksheets,by default named Book1,Book2,and Book3.

Question 42

The intersection of row 1 and column Q is known as 1Q,

Question 43

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

Question 44

Rows are numbered in ascending sequence from top to bottom.

Question 45

A cell can be made an active cell by clicking on it.

Question 46

Changing values in spreadsheet cells to investigate the effects is known as what-if analysis.

Question 47

If the background of a worksheet is yellow,the area without data or documentation is referred to as yellow space rather than white space.

Question 48

All formulas and functions must start with the equal sign (=).

Question 49

Changing the cell alignment so words fit on to multiple lines is also known as wrapping text.

Question 50

Columns are lettered in descending sequence from left to right.

Question 51

Worksheet navigation refers to scrolling up and down (or left and right)in a worksheet using the scroll bar.

Question 52

J42 is an example of a cell reference.

Question 53

A formula is a built-in program that performs common tasks.

Question 54

Scrolling in a worksheet moves the active cell.

Question 55

Page breaks can NOT be inserted into an Excel worksheet.

Question 56

A cell can also be referred to as a field.

Question 57

A column can also be referred to as a record.

Question 58

There are more rows in an Excel spreadsheet than there are cells.

Question 59

C6 is an example of a cell range.

Question 60

Rows are represented by letters.

Question 61

Worksheets can be hidden from view.

Question 62

A cell in the second row and fifth column would be referred to by the cell reference ________.

Question 63

Worksheet footers appear at the top of the page.

Question 64

A3 and E9 are examples of cell ________.

Question 65

A(n)________ is an intersection of a row and column.

Question 66

A spreadsheet can be used as a basic collection of data where each row is a(n)________.

Question 67

Spreadsheets are used to perform ________,where you can change values in spreadsheet cells to investigate the effect on calculated values of interest.

Question 68

Pressing Alt+Tab allows a user to quickly move between open workbooks.

Question 69

The intersection of column F and row 5 has the cell reference ________.

Question 70

________ are lettered in ascending sequence from left to right.

Question 71

Unused worksheets are a form of clutter in a workbook and generally should be deleted.

Question 72

If data is too wide to fit on a printed page,scaling may solve the problem.

Question 73

Portrait orientation means the page is taller than it is wide.

Question 74

A(n)________ is a powerful computer program with a user interface that is a grid of rows and columns.

Question 75

Worksheets can be renamed,deleted,and moved.

Question 76

A(n)________ is another word for a spreadsheet.

Question 77

Printouts are generally sent to square sheets of paper.

Question 78

Each worksheet contains a number of ________,each of which can contain text,numbers,formulas,and/or functions.

Question 79

A spreadsheet can be used as a basic collection of data where each column is a(n)________.

Question 80

A(n)________ is an equation that produces a result and may contain numbers,text,and other such data.