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

When a number of similar formula need to be created, you can use the ​ (a)   to do this. This can also be used to create a ​ (b)   such as ​ (c)   or numbers such as ​ (d)   . you must first create the ​ (e)   .

• fill-handle
• pattern
• weekdays
• counting in two
• pattern or formula
• auto correct
• function
• group

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