Question 1

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

Accepted Answer

False

Question 2

In Excel, the electronic spreadsheet you work in is called a ____.
A) workbook
B) databook
C) numericsheet
D) worksheet

Accepted Answer

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

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

Accepted Answer

One of the main features of spreadsheets is their ability to create what-if scenarios. By using variable values, users can investigate and sample different outcomes to see how they would affect the overall results. While spreadsheets can also be used for organizing data, performing calculations, and representing values graphically, none of these options fully capture the potential for creating what-if scenarios that is unique to spreadsheets.

Question 4

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

Accepted Answer

Formulas in Excel are used for performing 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.

Accepted Answer

The answer of When the paper orientation is portrait ,...

Question 6

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

Accepted Answer

The statement is correct. The Page Layout tab in Microsoft Word includes a Page Setup group, which provides options to adjust the print orientation, paper size, page breaks, margins, and other settings related to the formatting of the document.

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.

Accepted Answer

Page Layout View in Excel shows the worksheet as it will appear when printed, including headers, footers, and tools like rulers and page number indicators.

Question 8

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

Accepted Answer

The View tab on the Ribbon contains various options to change the view of the worksheet window, such as changing the zoom level, splitting the screen, hiding/showing the gridlines, and more.

Question 9

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

Accepted Answer

In an electronic spreadsheet, the calculations are automatically updated when you change the entries.

Question 10

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

Accepted Answer

The answer of Labels are numbers, formulas, and functions that...

Question 11

Arguments are Excel's built-in formulas.

Accepted Answer

The answer of 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.

Accepted Answer

The answer of When the paper orientation is set on...

Question 13

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

Accepted Answer

In Edit mode, you can make changes to the content of the selected cell or range of cells. You can identify the Edit mode when the cursor is inside a cell, and there is a blinking cursor in the cell.

Question 14

You can use predesigned, formatted files called ____ to create new worksheets quickly.
A) formatsheets
B) layouts
C) templates
D) screens

Accepted Answer

Predesigned and formatted files that help to create new worksheets quickly are called templates. Therefore, option C is the correct answer. The other options do not accurately represent the function of these pre-designed files.

Question 15

Charts are updated automatically in Excel whenever data changes.

Accepted Answer

This is one of the main benefits of using a chart in Excel. As data is added, edited or deleted, the chart will automatically update to reflect those changes without any manual effort required.

Question 16

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

Accepted Answer

This statement is true. Excel does indeed include a Scenario Manager where you can name and save different what-if versions of your worksheet. These scenarios allow you to explore different potential outcomes or possibilities based on different sets of input values.

Question 17

In Excel, a worksheet is contained in a file called a ____.
A) workbook
B) workpad
C) notebook
D) datapad

Accepted Answer

A worksheet is one of the sheets contained within a workbook in Excel. The terms "workpad" and "datapad" are not commonly used in Excel, and a "notebook" could refer to a physical notebook or a digital note-taking application.

Question 18

An Excel workbook has the file extension .xml.

Accepted Answer

An Excel workbook has the file extension .xlsx, not .xml. The .xml file extension is used for files that contain XML data.

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

Accepted Answer

A spreadsheet is specifically designed for numeric calculations and analysis of data. Databases are more efficient for storing and accessing large amounts of information, while a dataform and project are more general terms that do not specifically relate to numeric calculations and analysis.

Question 20

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

Accepted Answer

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

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

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

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

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

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

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

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

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

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

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

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

Arguments are Excel's built-in formulas.

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

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

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

Charts are updated automatically in Excel whenever data changes.

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

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

An Excel workbook has the file extension .xml.

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

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