5.2.6 workbook management facts

How can you duplicate a worksheet in the software described?

• Select the worksheet and press the duplicate button

• Right-click the worksheet tab, select Move or Copy, check Create a Copy, and click OK

• Drag the worksheet to a new location with the mouse

• Copy and paste the entire worksheet into a new file

What must you do to color-code a worksheet tab?

• Go to the Page Layout tab and select Colors

• Right-click the worksheet tab, select Tab Color, and choose a color

• Double-click the worksheet tab and choose a color

• Use the paint bucket tool on the worksheet tab

What do you click on to create a new blank workbook in Excel?

• File tab > Open

• File tab > Save As

• File tab > New > Blank Workbook

• New tab > Blank Workbook

What is the name of the workbook pictured in Image 2?

• Workbook2

• Book2

• Book1

• ExcelBook1

Which tabs are used to save an existing workbook?

• New and Open tabs

• Save and Print tabs

• Save and Save As tabs

• Export and Publish tabs

What file formats can you save an Excel workbook as, besides the default .xlsx?

What is the disadvantage of saving an Excel file as a PDF?

• The file cannot be accessed on any computer.

• The file size becomes too large.

• Further edits are difficult to make.

• The formatting of the original document is lost.

What is the purpose of the 'Print' feature in Excel as described in the image?

• To open and edit CSV files

• To import data from a web browser

• To print a workbook with page orientation and margin settings

• To import data from a database

What does the 'From Text/CSV' feature do in Excel?

Which feature in Excel is used for importing bank statements, bills, and credit card transactions for analysis?

• From Text/CSV

• Print

• From Database

• From Web