Question 1

Explain the way by which you can Insert and Delete Cells in Microsoft Excel 2016.

Accepted Answer

Answers will vary. If you click the Inse

Question 2

In Microsoft Excel, the data entered in a worksheet appears in the _____.

Accepted Answer

A) status bar 
B) formula bar 
C) name box 
D) dialog box 
A) status bar 
B) formula bar 
C) name box 
D) dialog box

Question 3

One of the ways to get more characters to fit into a cell is by:

Accepted Answer

A) using the Cell Styles button on the Home tab to specify cell width. 
B) dragging the left-hand side border of the cell. 
C) reducing the font size. 
D) increasing the row height of the cell. 
A) using the Cell Styles button on the Home tab to specify cell width. 
B) dragging the left-hand side border of the cell. 
C) reducing the font size. 
D) increasing the row height of the cell.

Question 4

Text is not accepted in a cell unless you press the Enter or Tab key.

Accepted Answer

A) True 
 B)False

Question 5

A _________ is a group of values and other data organized into rows and columns. 
A)dataset 
B)spreadsheet 
C)log 
D)list

Accepted Answer

The answer of A _________ is a group of values...

Question 6

Which of the following happens when you insert a new row into a worksheet?

Accepted Answer

A) The new row is added at the end of the sheet. 
B) The new row is added at the beginning of the sheet. 
C) The new row is added and the remaining rows shift down to accommodate it. 
D) The new row is added and the remaining rows shift up to accommodate it. 
A) The new row is added at the end of the sheet. 
B) The new row is added at the beginning of the sheet. 
C) The new row is added and the remaining rows shift down to accommodate it. 
D) The new row is added and the remaining rows shift up to accommodate it.

Question 7

Rajiv has been working on a file containing numerical data up to three decimal places. He changes the number format in cell B1 from Accounting to Currency format and reduces the number of decimal places by one. The value in the cell was originally $115.34. The new value displayed after the format change Rajiv has made will be _____.

Accepted Answer

A) 115.34 
B) $115.34 
C) #115.34 
A) 115.34 
B) $115.34 
C) #115.34

Question 8

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4? ​
 
​

Accepted Answer

A) =D6*E4 
B) =D4*E4 
C) =D3*E4 
D) =D4*D6 
A) =D6*E4 
B) =D4*E4 
C) =D3*E4 
D) =D4*D6

Question 9

A _____ indicates the cell's column and row location.

Accepted Answer

A) cell range 
B) cell tab 
C) cell reference 
D) cell report 
A) cell range 
B) cell tab 
C) cell reference 
D) cell report

Question 10

When a number is too large to be entered into a cell, Microsoft Excel:

Accepted Answer

A)  replaces the numbers with a series of pound (#) signs. ​ 
B) merges the cell next to it to create more space. 
C) increases the row height to fit the data. 
D) rounds off the number to fit it in the cell. 
A)  replaces the numbers with a series of pound (#) signs. ​ 
B) merges the cell next to it to create more space. 
C) increases the row height to fit the data. 
D) rounds off the number to fit it in the cell.

Question 11

Caroline is creating a worksheet to find the sum of different cell values such as A1, E1, and F1 and display it in cell G1. Which of the following formulas should Caroline enter into cell G1?

Accepted Answer

A) =A1+E1+F1 
B) A1+E1+F1 
C) A1+E1+F1= 
D) A1;E1;F1= 
A) =A1+E1+F1 
B) A1+E1+F1 
C) A1+E1+F1= 
D) A1;E1;F1=

Question 12

Which of the following is a reason why there is a space between the dollar sign and the left edge of the cell in the accounting format?

Accepted Answer

A) To format numbers in the default number format for Microsoft Excel 
B) To ensure that there is space for decimal points 
C) To leave space on either side for the parentheses that surround negative numbers 
D) To make sure that all the cells are aligned with the numbers 
A) To format numbers in the default number format for Microsoft Excel 
B) To ensure that there is space for decimal points 
C) To leave space on either side for the parentheses that surround negative numbers 
D) To make sure that all the cells are aligned with the numbers

Question 13

Detail how you can view sheets before printing, the orientations you can print in and the process by which you can print a workbook.

Accepted Answer

Answers will vary. You can view a worksh

Question 14

Roger is using Microsoft Excel 2016 for the first time, and he needs to enter data in the third column of the worksheet. In this scenario, which of the following would be the column name of the cell that Roger enters data in?

Accepted Answer

A) The number "3" 
B) The Roman numeral "III" 
C) The letter "C" 
D) The term "third" 
A) The number "3" 
B) The Roman numeral "III" 
C) The letter "C" 
D) The term "third"

Explain the way by which you can Insert and Delete Cells in Microsoft Excel 2016.

In Microsoft Excel, the data entered in a worksheet appears in the _____.

One of the ways to get more characters to fit into a cell is by:

Text is not accepted in a cell unless you press the Enter or Tab key.

A _________ is a group of values and other data organized into rows and columns. A)dataset B)spreadsheet C)log D)list

Which of the following happens when you insert a new row into a worksheet?

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4?

A _____ indicates the cell's column and row location.

When a number is too large to be entered into a cell, Microsoft Excel:

Caroline is creating a worksheet to find the sum of different cell values such as A1, E1, and F1 and display it in cell G1. Which of the following formulas should Caroline enter into cell G1?

Which of the following is a reason why there is a space between the dollar sign and the left edge of the cell in the accounting format?

Detail how you can view sheets before printing, the orientations you can print in and the process by which you can print a workbook.

Roger is using Microsoft Excel 2016 for the first time, and he needs to enter data in the third column of the worksheet. In this scenario, which of the following would be the column name of the cell that Roger enters data in?

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Working With Formulas and Functions

Creating an Advanced Workbook

Inserting and Formatting Charts

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

Exam 13: Creating a Workbook

Explain the way by which you can Insert and Delete Cells in Microsoft Excel 2016.

In Microsoft Excel, the data entered in a worksheet appears in the _____.

One of the ways to get more characters to fit into a cell is by:

Text is not accepted in a cell unless you press the Enter or Tab key.

A _________ is a group of values and other data organized into rows and columns. A)dataset B)spreadsheet C)log D)list

Which of the following happens when you insert a new row into a worksheet?

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4? ​ ​

A _____ indicates the cell's column and row location.

When a number is too large to be entered into a cell, Microsoft Excel:

Caroline is creating a worksheet to find the sum of different cell values such as A1, E1, and F1 and display it in cell G1. Which of the following formulas should Caroline enter into cell G1?

Which of the following is a reason why there is a space between the dollar sign and the left edge of the cell in the accounting format?

Detail how you can view sheets before printing, the orientations you can print in and the process by which you can print a workbook.

Roger is using Microsoft Excel 2016 for the first time, and he needs to enter data in the third column of the worksheet. In this scenario, which of the following would be the column name of the cell that Roger enters data in?

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Working With Formulas and Functions

Creating an Advanced Workbook

Inserting and Formatting Charts

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4?