ISM3004 Exam 2 (with Complete Solutions)

Lotus 1-2-3 correct answers Spreadsheet Graphics Data Management Killer app that ignited the personal computer revolution - CFO magazine Gave competitive advantage Microsoft Excel correct answers First on macintosh VisiCalc correct answers 1979 Apple 2 computer XLSX correct answers Excel workbook 2007+ XLS correct answers Excel Workbook format Cells correct answers Boxes in the program Columns and rows Refer to cell as address Column letter & row number Name Cells correct answers Highlight cells Top left- address box and type in name Sheets correct answers 3D - Columns, Rows, Sheets Excess of a million rows of data XFD - Column 16,384 Double click name and call it anything Ranges correct answers Simply a rectangular group of sales that is uninterrupted For example C5:C9 Function - Move to boundary - End of block of data correct answers Windows Ctrl + up, down, or side(Left or Right) arrows End + up, down, or side(Left or Right) arrows Function - Move to ... (Home = top left) or (End = bottom right) correct answers Windows Ctrl Home Ctrl End Function - Move up / down one sheet correct answers Windows Ctrl PgUp Ctrl PgDn