Exam 13: Creating a Workbook

In the following snippet of a Microsoft Excel 2016 worksheet, consider that a formula is applied to column F. If the formula applied to cell F6 is D6*E6, which of the following is the formula reflected in cell F7?

(Multiple Choice)

4.9/5

(73)

Question 41

The _________ located on the right edge of the status bar allow you to change the outlook of a worksheet. A)trailer buttons B)adjustment buttons C)view buttons D)swift buttons

(Short Answer)

4.9/5

(74)

Question 42

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the correct range reference for selected cells?

(Multiple Choice)

4.7/5

(86)

Question 43

The _________ feature tries to anticipate what you are about to enter by displaying text that begins with the same letters as a previous entry in the same column. A)AutoFit B)AutoComplete C)AutoCheck D)AutoMatch

(Short Answer)

4.8/5

(70)

Question 44

Samir is working on a worksheet he received from his colleague. His colleague has forced text to fit within cells using a button on the Home tab, causing the file to look disjointed. In order to bring the cells to their default sizes, Samir should select all the cells and:

(Multiple Choice)

4.7/5

(89)

Question 45

When entering text data in a cell, pressing the Alt+Enter keys:

(Multiple Choice)

4.9/5

(79)

Question 46

Case 13-1 Matt, a financial consultant, is auditing a friend's document. Matt wants to select the largest value of a column in a worksheet. Which of the following AutoSum functions should Matt use?

(Multiple Choice)

4.8/5

(80)

Question 47

In Excel, _____ are actually numbers that are formatted to appear as text.

(Multiple Choice)

4.8/5

(75)

Question 48

Marion has been working on a worksheet in Microsoft Excel 2016. She needs to delete certain data in a column. She selects the data in the column and presses the Delete key. Which of the following is the result of Marion's action?

(Multiple Choice)

4.9/5

(83)

Question 49

The cell in which you are currently working is known as the function cell.

(True/False)

4.7/5

(87)

Question 50

Which of the following happens when you rename a sheet from Sheet1 to Inventory?

(Multiple Choice)

4.7/5

(70)

Question 51

Which of the following can you do to edit cell contents directly in a cell?

(Multiple Choice)

4.8/5

(74)

Question 52

When you paste a copied formula, Microsoft Excel 2016 adjusts the cell references in the formula to reflect the new location of the formula.

(True/False)

5.0/5

(65)

Question 53

The quickest way to move a sheet is to copy and paste them in the new location.

(True/False)

4.8/5

(63)

Question 54

Which of the following features in Microsoft Excel 2016 makes entering repetitive text easier?

(Multiple Choice)

4.9/5

(82)

Question 55

Case 13-1 Matt, a financial consultant, is auditing a friend's document. Matt wants to calculate the amount of loan payments his friend needs to make on certain loans. He enters the data regarding interest and total principal in the worksheet. Which of the following functions should Matt use to calculate this?

(Multiple Choice)

4.7/5

(78)

Question 56

You can select an entire column in Microsoft Excel 2016 by:

(Multiple Choice)

4.8/5

(74)

Question 57

Lucy enters large amounts of numerical and text data into every cell in a worksheet. She has to keep clicking the previous cells to refer to data in other cells. Which of the following would make it easier for Lucy to view the contents of all cells simultaneously?

(Multiple Choice)

4.9/5

(82)

Question 58

Kim creates a worksheet that contains data about students in her class and their achievements in the previous year. She wants the achievements to stand out from the rest of the data. Kim can achieve this by:

(Multiple Choice)

4.7/5

(74)

Question 59

Text data is usually aligned to the center of the cell unless you change it.

(True/False)

4.8/5

(85)

Question 60

Showing 41 - 60 of 74

Exam 13: Creating a Workbook

In the following snippet of a Microsoft Excel 2016 worksheet, consider that a formula is applied to column F. If the formula applied to cell F6 is D6*E6, which of the following is the formula reflected in cell F7?

The _________ located on the right edge of the status bar allow you to change the outlook of a worksheet. A)trailer buttons B)adjustment buttons C)view buttons D)swift buttons

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the correct range reference for selected cells?

The _________ feature tries to anticipate what you are about to enter by displaying text that begins with the same letters as a previous entry in the same column. A)AutoFit B)AutoComplete C)AutoCheck D)AutoMatch

Samir is working on a worksheet he received from his colleague. His colleague has forced text to fit within cells using a button on the Home tab, causing the file to look disjointed. In order to bring the cells to their default sizes, Samir should select all the cells and:

When entering text data in a cell, pressing the Alt+Enter keys:

Case 13-1 Matt, a financial consultant, is auditing a friend's document. Matt wants to select the largest value of a column in a worksheet. Which of the following AutoSum functions should Matt use?

In Excel, _____ are actually numbers that are formatted to appear as text.

Marion has been working on a worksheet in Microsoft Excel 2016. She needs to delete certain data in a column. She selects the data in the column and presses the Delete key. Which of the following is the result of Marion's action?

The cell in which you are currently working is known as the function cell.

Which of the following happens when you rename a sheet from Sheet1 to Inventory?

Which of the following can you do to edit cell contents directly in a cell?

When you paste a copied formula, Microsoft Excel 2016 adjusts the cell references in the formula to reflect the new location of the formula.

The quickest way to move a sheet is to copy and paste them in the new location.

Which of the following features in Microsoft Excel 2016 makes entering repetitive text easier?

You can select an entire column in Microsoft Excel 2016 by:

Lucy enters large amounts of numerical and text data into every cell in a worksheet. She has to keep clicking the previous cells to refer to data in other cells. Which of the following would make it easier for Lucy to view the contents of all cells simultaneously?

Kim creates a worksheet that contains data about students in her class and their achievements in the previous year. She wants the achievements to stand out from the rest of the data. Kim can achieve this by:

Text data is usually aligned to the center of the cell unless you change it.

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