Microsoft Excel Final

What is the default file extension for Excel workbooks?

• XLSM

• XLTX

• XLSX

• XLS

What kind of data should be kept on the same worksheet in Excel?

• Birthday and favorite color

• Financial and research data

• Numerical and text data

• Personal and professional data

What is the purpose of a CSV file extension?

• Used for creating presentations

• Frequently used by spreadsheet programs other than Excel

• Used for storing images

• Specifically designed for audio files

What is a workbook in Excel?

• A single spreadsheet within a workbook

• A file that contains one or more related worksheets

• A document that stores and manipulates data in columns and rows

• A file extension for Excel workbooks

What can you do with Excel?

• All of the above

• Run calculations and import data

• Create and manage workbooks

• Store information and track progress

What type of page orientation has the long edge of the paper located vertically? (see picture to the left)

• landscape

• left aligned

• portrait

• margins

What feature automatically adjusts the width and height of a column, row, cell or header?

(a)  

A (a)   is a set of calculations that are applied to values in a spreadsheet.

What symbols represent an Arithmetic Operator?

• *

• /

• +

• -

• All of the Above

Which cell represents an absolute reference?

• B1

• $B$1

• B$1

• $B1