Y9 Assessment 2 - Spreadsheets

What is the most popular spreadsheet program?

• LibreOffice Calc

• Microsoft Office Excel

• OpenOffice Calc

• Google Docs

What is a spreadsheet file made up of?

• Only one workbook

• Only one worksheet

• Multiple workbooks and one worksheet

• One workbook and multiple worksheets

What does a unique cell reference consist of?

• A symbol and a number

• A letter and a number

• A number and a symbol

• A letter and a symbol

What does this mouse pointer represent?

• Selecting a cell

• Adding a cell

• The Fill Handle

• Moving cells

What are the three types of data you can enter into a cell?

• Numbers, text, and symbols

• Data, labels, and formulas

• Images, charts, and graphs

• Headers, footers, and comments

What does the A-Z feature do?

• Orders data in ascending or descending order

• Duplicates data

• Deletes data

• Formats data

What is the function of the fill handle?

• Deletes a cell’s contents

• Highlights a cell

• Duplicates a cell’s contents or fills a series

• Formats a cell

Where can data be typed directly into?

• The status bar

• The toolbar

• A cell or the formula bar

• The menu bar

What does the name box show?

• The selected cell

• The worksheet name

• The workbook name

• The formula used

What happens when referenced data in a formula changes?

• The formula updates automatically

• The formula needs to be re-entered

• The formula deletes

• The formula becomes inactive