Exam 8: Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Case 7-1 Laura, in Personnel, needs to create a new payroll workbook each month. The formatting and formulas are the same in each new workbook; only the payroll data is different. During a conversation at lunch, she asks if you have any suggestions for ways she can save time with this workbook setup task. -You suggest to Laura that she get a high level of confidence in the workbooks that she creates. You tell her that one way to do this is to test the workbook extensively, including selecting dummy data that tests the ____ of the formulas.

(Multiple Choice)

4.9/5

(31)

Question 41

Excel allows you to import formatting from a number of types of sources.

(True/False)

4.7/5

(33)

Question 42

You should not credit the source of an image unless you can specifically name the image creator.

(True/False)

4.9/5

(32)

Question 43

All of the following are formats accepted for picture files EXCEPT ____.

(Multiple Choice)

4.7/5

(29)

Question 44

The Import Data dialog box allows you to choose whether to import the data into a ____.

(Multiple Choice)

4.9/5

(37)

Question 45

Only images that are ____ are free for anyone to use without permission.

(Multiple Choice)

4.9/5

(28)

Question 46

Which of the following is the path to the Insert WordArt button?

(Multiple Choice)

4.9/5

(30)

Question 47

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term for copying formulas.

(Multiple Choice)

4.8/5

(32)

Question 48

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

(Multiple Choice)

4.8/5

(29)

Question 49

When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.

(True/False)

4.9/5

(32)

Question 50

Which of the following is a SmartArt graphic category?

(Multiple Choice)

4.8/5

(33)

Question 51

Importing ____ provides greater flexibility to manipulate text in Excel.

(Multiple Choice)

4.8/5

(21)

Question 52

The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.

(True/False)

4.8/5

(35)

Question 53

A ____ file contains data fields separated by a selected character.

(Multiple Choice)

4.9/5

(31)

Question 54

The ____________________ Wizard is a powerful tool for manipulating text data in columns.

(Short Answer)

4.8/5

(31)

Question 55

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A text file with data fields of equal length and spaces between the fields.

(Multiple Choice)

4.9/5

(29)

Question 56

In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.

(Multiple Choice)

4.8/5

(39)

Question 57

Which of the following is the path to the Format Painter button?

(Multiple Choice)

4.7/5

(35)

Question 58

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

(Multiple Choice)

4.9/5

(31)

Question 59

Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

(Multiple Choice)

4.7/5

(28)

Question 60

Showing 41 - 60 of 112

Excel allows you to import formatting from a number of types of sources.

You should not credit the source of an image unless you can specifically name the image creator.

All of the following are formats accepted for picture files EXCEPT ____.

The Import Data dialog box allows you to choose whether to import the data into a ____.

Only images that are ____ are free for anyone to use without permission.

Which of the following is the path to the Insert WordArt button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term for copying formulas.

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.

Which of the following is a SmartArt graphic category?

Importing ____ provides greater flexibility to manipulate text in Excel.

The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.

A ____ file contains data fields separated by a selected character.

The ____________________ Wizard is a powerful tool for manipulating text data in columns.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A text file with data fields of equal length and spaces between the fields.

In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.

Which of the following is the path to the Format Painter button?

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters