Microsoft Excel Final

Front

What is the default file extension for Excel workbooks? Options: XLSM, XLTX, XLSX, XLS

Back

XLSX

Front

What kind of data should be kept on the same worksheet in Excel? Options: Birthday and favorite color, Financial and research data, Numerical and text data, Personal and professional data

Back

Numerical and text data

Front

What is the purpose of a CSV file extension?

Back

Frequently used by spreadsheet programs other than Excel

Front

What is a workbook in Excel?

Back

A file that contains one or more related worksheets

Front

What can you do with Excel?

Back

Run calculations and import data, Create and manage workbooks, Store information and track progress

Front

What type of page orientation has the long edge of the paper located vertically?

Back

portrait

Front

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

Back

autofit

Front

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

Back

Formula

Front

What symbols represent an Arithmetic Operator? Options: *, /, +, -

Back

All of the Above

Front

Which cell represents an absolute reference? Options: B1, $B$1, B$1, $B1

Back

$B$1