WorksheetsImporting and Exporting Spreadsheet Data Review
Total questions: 24
Worksheet time: 12mins
Merging cells
moves them over one cell
combines multiple cells into one
adds a cell in the middle of a row
adds the cell contents
When you are merging several worksheets, what do you need to have before merging?
A blank worksheet
A separate Excel document
Charts
A pivot table
What tab do you click on to merge spreadsheets?
Home
Data
Page Layout
Insert
What function feature must be selected when merging spreadsheets in Excel, so you can consolidate from the Data tools section?
Count
Average
Product
Sum
When merging spreadsheets in OpenOffice Calc you need to open an new worksheet and click on what from the menu?
Insert
Edit
Tools
Format
Can you view more than one spreadsheet at the same time in OpenOffice Calc?
Yes
No
When embedding a file in a worksheet, what happens to that file?
It decreases in size
It increases in size
It stays the same size
It disappears
What is an advantage to embedding a file in a workbook?
You know that the file will be available
It deletes the original file
You don't have to save the file
The file will no longer be available
What is an advantage of linking files in a worksheet?
It increases the disk space used
It decreases the disk space used
It saves disk space because it doesn't affect disk space
Anyone can access the files
Is it possible to add files from other types of programs into your Excel workbook?
Yes
No
What does exporting an Excel workbook do?
Transports data from one workbook to another program such as Word
Removes data from Excel and puts it in another program such as Word
Changes an Excel Workbook from an Excel file to another type of file, such as a Word file
Moves data from one Excel workbook to another Excel workbook
How can you import a chart into Excel?
Click on the Insert -> Chart command
Click on "File" then "Import" and find the PowerPoint file
Copy the chart in PowerPoint and paste it into Excel
You can't do this
Which file format is used for a Portable Document Format?
XPS
DOCX
XLSX
What are the commonly used text file formats for Excel?
.docx and .csv
.csv and .txt
.xlsx and .csv
.xlsx and .txt
How do you convert an Excel worksheet to a text file?
Use the Save As command
Use the Copy command
Use the Merge command
Use the Save command
When importing text file data into an OpenOffice Calc worksheet, which file format is recommended?
.txt
.rtf
.xlsx
.csv
Who developed the XPS file format?
Apple
Microsoft
OpenOffice
How should you save your workbook if you are going to need to access it without using Excel?
Save it as a Word document
Save it as a PDF file
Save it in protected format
Save it as a rich text format
__________________ data is separated at the same place in each cell.
Delimited
Protected data
Read only
Fixed width
When importing text data into Excel, you should create a new workbook and click on which tab?
Data
Insert
Developer
Page Layout
How much does Adobe Reader cost?
$25 per year
$99 per year
$25 one time
Zero
_____________ data added to your workbook is automatically updated when changes are made in the original document.
Embedded
Imported
Protected
Linked
Is there a limit to the number of spreadsheets you can merge into one worksheet?
Yes
No
