Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The answer of Explain the process of inserting rows and...

Question 4

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

Accepted Answer

A) DATA 
B) REVIEW 
C) INSERT 
D) HOME

Question 5

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

Accepted Answer

A) menu tab 
B) task pane 
C) gridline 
D) ribbon

Question 6

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

Accepted Answer

A) DATA 
B) HOME 
C) VIEW 
D) REVIEW

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

Excel creates multiple worksheets when a new workbook is created.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) F2 
B) F1 
C) F5 
D) F3

Question 11

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

Accepted Answer

The answer of What are the different ways of entering...

Question 12

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

Accepted Answer

A) node 
B) grid 
C) cell 
D) junction

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of The real power of Excel lies in...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Data can be imported to Excel from other programs.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) font 
B) alignment 
C) styles 
D) editing

Question 20

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

Accepted Answer

A) True 
 B)False

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.