Question 1

Keyboard navigation can be done using ________ such as pressing the Tab key to move one column right.
A)keyboard references
B)keyboard shortcuts
C)magic keys
D)active keys

Accepted Answer

Keyboard shortcuts are key combinations that can be used to perform specific actions, such as moving one column right using the Tab key.

Question 2

________ charts show trends over a period of time.

Accepted Answer

The answer of ________ charts show trends over a period...

Question 3

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

Accepted Answer

Excel 2010 workbooks have the file extension .xlsx, not .xls. The .xls extension was used for older versions of Excel.

Question 4

Microsoft's spreadsheet application is known as ________.
A)Excel
B)Publisher
C)Outlook
D)Access

Accepted Answer

Microsoft's spreadsheet application is known as Excel.

Question 5

Of the following, which makes up the smallest element in a workbook?
A)cell
B)worksheet
C)column
D)row

Accepted Answer

A cell is the smallest element in a workbook. It is the intersection of a row and a column.

Question 6

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

Accepted Answer

Worksheets do not contain workbooks; rather, workbooks contain worksheets.

Question 7

________ charts show proportions that add up to 100%.

Accepted Answer

The answer of ________ charts show proportions that add up...

Question 8

Excel 2010 workbooks are saved with a default file extension of ________.
A).wbk
B).accdb
C).xlsx
D).exc

Accepted Answer

Excel 2010 workbooks are saved with a default file extension of .xlsx, which is the standard format for Excel files starting from Excel 2007.

Question 9

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

Accepted Answer

What-if analysis involves changing values in spreadsheet cells to see how those changes will affect the outcome of formulas in the spreadsheet, allowing users to explore different scenarios and their impacts.

Question 10

All functions must begin with the ________ character.
A)$
B)=
C)>
D)(?)

Accepted Answer

All functions in mathematics must begin with the "=" character to indicate that the expression on the left side of the equation is equal to the expression on the right side.

Question 11

An equation that produces a result is known as a(n)________.
A)cell reference
B)function
C)formula
D)record

Accepted Answer

A formula is an equation used in spreadsheets and other applications to calculate a result.

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)what-if analysis
B)function
C)AutoFill
D)formula

Accepted Answer

What-if analysis allows users to change values in a cell to see how those changes affect the outcome of formulas in the worksheet.

Question 13

A cell in the third row and fourth column has the cell reference ________.
A)4C
B)C4
C)D3
D)3D

Accepted Answer

The answer of A cell in the third row and...

Question 14

Which of the following is least likely to be found in a single cell?
A)functions
B)charts
C)text
D)operators

Accepted Answer

Charts are typically not found within a single cell; they are usually placed on a worksheet and can reference data from multiple cells.

Question 15

Specialty graphics such as list, hierarchy, process, pyramid, and cycle charts are all examples of ________ graphics.

Accepted Answer

The answer of Specialty graphics such as list, hierarchy, process,...

Question 16

SUM and AVERAGE are examples of ________.
A)cell references
B)functions
C)records
D)formulas

Accepted Answer

SUM and AVERAGE are both functions in Excel. Functions are predefined formulas that perform specific calculations on a set of values.

Question 17

Which of the following is not a valid cell reference?
A)4C
B)A3
C)J21
D)AA3

Accepted Answer

The answer of Which of the following is not a...

Question 18

Another word for a spreadsheet is ________.
A)workbook
B)field
C)record
D)worksheet

Accepted Answer

A spreadsheet is often referred to as a worksheet, which is a single sheet within a workbook in spreadsheet software.

Question 19

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

Accepted Answer

By default, new Excel workbooks contain three worksheets, although this can be changed in the settings.

Question 20

Instead of including a large amount of data, users can add a(n)________ to graphically represent data.

Accepted Answer

The answer of Instead of including a large amount of...

Quiz 3: Microsoft Office

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

________ charts show trends over a period of time.

Which of the following statements is FALSE?

Microsoft's spreadsheet application is known as ________.

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

Which of the following statements is FALSE?

________ charts show proportions that add up to 100%.

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

What-if analysis allows users to ________.

All functions must begin with the ________ character.

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

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 cell in the third row and fourth column has the cell reference ________.

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

Specialty graphics such as list, hierarchy, process, pyramid, and cycle charts are all examples of ________ graphics.

SUM and AVERAGE are examples of ________.

Which of the following is not a valid cell reference?

Another word for a spreadsheet is ________.

Which of the following statements about workbooks is TRUE?

Instead of including a large amount of data, users can add a(n)________ to graphically represent data.