Exam 16: Introduction to Microsoft Excel 2013

In Excel, the FORMULAS tab is used for creating complex formulas.

The portion of the spreadsheet to be printed can be specified using margins.

Explain the process of inserting rows and columns in Microsoft Excel.

In Excel, which of the following tabs is used for filtering and sorting information in a spreadsheet?

In Excel, the wide bar of tools and selections that appears just under the tabs is called the ________.

In Excel, the most frequently used tools and selections appear under the ________ tab.

Selecting the $ English (U.S.)option displays numbers with a dollar sign and two decimal places.

In Excel, to insert new rows, click the number of the row above which new rows need to be added, and then select the number of rows to be added.

Excel creates multiple worksheets when a new workbook is created.

Which of the following keys is used to edit the value in a cell without retyping the whole entry?

What are the different ways of entering data into an Excel worksheet?

In Excel, the intersection of a row and a column is called a ________.

In Excel, the PAGE LAYOUT tab is used to format a page, often for printing.

The real power of Excel lies in its amazing computational capability.Explain.

The tools and selections in the PAGE LAYOUT ribbon determine how a document will be arranged as a printed document.

While copying a formula, Excel can adjust the terms of the formula to refer to the cells, in the row to which it is copied.

For general work in Excel spreadsheets, the tools and selection under the DATA tab are most useful.

Data can be imported to Excel from other programs.

The ________ section of the ribbon in Excel enables selected text to be centered both horizontally and vertically in a cell.

An Excel workbook is a collection of one or more worksheets.