Solution-To encrypt a workbook with a password

To encrypt a workbook with a password

Assignment Help Basic Computer Science

Reference no: EM13926324

Question 1.

Which of the following is one of the most common file types imported into Excel?

Text

PowerPoint

Web

Word

Question 2.

Which of the following is NOT a text file?

Tab-delimited

Comma-separated value

XML

Fixed-width

Question 3.

Which of the following is NOT a method for refreshing data?

Click the Refresh All command.

Save the Excel workbook.

Click the Refresh All arrow, then click Refresh.

Right-click in a range of data and then select Refresh.

Question 4.

The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.

Fixed

Mixed

Divided

Text

Question 5.

(TCO 8) Which of the following is a frequently used function to manipulate txt?

CONCATENATE

PMT

DATE

Question 6.

To change the text string JANE doe to jane doe, use the ________ function.

CONCATENATE

PROPER

UPPER

LOWER

Question 7.

Which of the following will produce the same result as the CONCATENATE function?

=A4&B4

=A4+B4

=A4B4

=A4,B4

Question 8.

If you want to send a letter to all your customers using Mail Merge, and you already have the customers' names and

addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.

Type New List

Use Existing List

Import from Excel

Select from Outlook Contacts

Question 9.

The New Comment command is located on the ________ tab.

View

Review

Data

File

Question 10.

If first and last names are combined in a single column, you can split them into two separate columns using the ________.

Split Names Wizard

PivotTable feature

CONCATENATE function

Convert Text to Columns Wizard

Question 11.

The command to track changes is located on the ________ tab.

File

Data

Review

View

Question 12.

If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.

Gmail

Hotmail

Yahoo

Outlook

Question 13.

Windows can search for files by author name or keywords that have been entered into ________.

a file name

the Trust Center

document properties

cell A1

Question 14.

All EXCEPT ___________ are Excel functions that help you manipulate text.

PROPER

UPPER

SUBSTITUTE

RESPOND

Question 15.

To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.

Check for Issues

Protect Workbook

Manage Versions

Options

Reference no: EM13926324

Questions Cloud

Describe your understanding of why the ifrs was created : Describe your understanding of why the IFRS was created, and how this will affect the accounting profession in terms of business relationships.

Chi-square goodness of fit test-unequal frequencies : An opinion poll was taken to see how people felt about Health Care reform. Previous poll results indicate that within a particular population 34% were for reform, 41% were against reform, and 25% were uncertain.

Redesign of the agency structure to serve : Recommend a redesign of the agency's structure to serve the needs of the department's businesses better without jeopardizing the goals / objectives of the agency. Explain your reasoning for changing the design and explain the change's impact on th..

What is the rate of heat loss through the glass : A glass window of width W = 1 m and height H = 2 m is 5 mm thick and has a thermal conductivity of kg = 1.4 W/m. K if the inner and outer surface temperatures of the glass are 15°C and -20°e, respectively, on a cold winter day, what is the rate of..

To encrypt a workbook with a password : Which of the following will produce the same result as the CONCATENATE function?

Evaluation of agency budgeting and cumulative report : As a consultant, you need to develop an in-depth analysis and evaluation of the selected agency's budgeting and then provide recommendations for improvement. Therefore, you will conduct interviews with agency representatives and research-related a..

How many mm of the ribbon will you require : How many grams of Mg must react with HCl in order to produce 40.0 ml of hydrogen gas at 22 degrees celsius and 1.02 bar?

How many containers of each product to produce tomorrow : Formulate and then solve a linear programming model of this problem, to determine how many containers of each product to produce tomorrow to maximize profits.

Prepare a cost of production summary for each department : Prepare a cost of production summary for each department for the month - Berg Products manufactures one product in two departments on a continuous basis and uses the average method of process cost accounting.

User Account

All Pages

To encrypt a workbook with a password

Reference no: EM13926324

Reference no: EM13926324

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT