Question 1

An Excel 2013 workbook has the file extension .xml.

Accepted Answer

An Excel 2013 workbook has the file extension .xlsx. It is a zipped XML-based file format.

Question 2

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

Accepted Answer

False

Question 3

To open an Excel file, click Open Other Workbooks on the navigation bar, click Computer, and then click Browse to open the Open dialog box.

Accepted Answer

This is the correct sequence of steps to open an Excel file.

Question 4

You can use a named range instead of a cell address in a formula.

Accepted Answer

This statement is true. A named range can be used in formulas to refer to a group of cells, rather than typing out individual cell addresses.

Question 5

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

Accepted Answer

In an electronic spreadsheet, calculations are done automatically and do not require manual recalculation when entries are changed.

Question 6

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

Accepted Answer

Edit mode is the mode in which you are able to enter or change the contents of a cell. It is indicated by the cursor being inside the cell and the formula bar displaying the contents of the cell.

Question 7

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

Accepted Answer

This is true. Formulas in Excel can be used for a variety of mathematical operations such as addition, multiplication, division, and more. These formulas can be entered into individual cells or used to create complex calculations across multiple cells.

Question 8

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

Accepted Answer

The electronic spreadsheet in Excel is called a worksheet, as it is a grid of cells where you can enter and manipulate data. The other answer choices (tablet, databook, and numericsheet) are not commonly used terms in Excel.

Question 9

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

Accepted Answer

Templates are pre-designed formatted files that are used to create new worksheets quickly. Options A, B, and D are not commonly used terms in spreadsheet software.

Question 10

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 allows you to change the view of the worksheet window, so the statement is true.

Question 11

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 12

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

Accepted Answer

The term described in the statement corresponds to a spreadsheet, which is a software application designed to perform calculations and organize data in rows and columns. A spreadsheet allows users to perform mathematical operations with the data, such as addition, subtraction, multiplication, and division, and to create graphs and charts to visualize the information in a meaningful way. Examples of spreadsheet software include Microsoft Excel, Google Sheets, and Apple Numbers.

Question 13

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

Accepted Answer

The answer of You can change header and footer information...

Question 14

Charts are updated automatically in Excel whenever data changes.

Accepted Answer

Charts in Excel are linked to the data they are based on and will automatically update when the data changes.

Question 15

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

Accepted Answer

The answer of Reference operators compare values for the purpose...

Question 16

Printing gridlines makes data easier to read.

Accepted Answer

Printing gridlines can help users to differentiate between cells and rows/columns, thus making the data easier to read.

Question 17

A named range can begin with a letter or number.

Accepted Answer

The answer of A named range can begin with a...

Question 18

Arguments are Excel's built-in formulas.

Accepted Answer

The answer of Arguments are Excel's built-in formulas....

Question 19

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

Accepted Answer

Excel does include a Scenario Manager where users can name and save different what-if versions of their worksheet.

Question 20

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

Accepted Answer

A worksheet is a single page or sheet within a workbook, which is a file containing multiple worksheets. Therefore, the correct term for the file is a workbook.

Quiz 11: Excel 2013 Getting Started With Excel 2013