120 likes | 194 Views
CS 101 Attendance. Present Present too. 0. If cell D18 contains =$A13+B$15, and the formula is copied to cell E15, what does it change to?. =$A13+B$15 =$A10+C$15 =$B10+B$12 =$A10+B$13. Who wrote Visicalc?. 1. Steve Jobs and Bill Gates 2. Dan Bricklin and Bob Frankston
E N D
CS 101 Attendance • Present • Present too
0 If cell D18 contains =$A13+B$15, and the formula is copied to cell E15, what does it change to? • =$A13+B$15 • =$A10+C$15 • =$B10+B$12 • =$A10+B$13
Who wrote Visicalc? 1. Steve Jobs and Bill Gates 2. Dan Bricklin and Bob Frankston 3. George Bush and Dick Chaney 4. Bill Gates and Steve Ballmer
A formula =C5+1 if located in cell C5 would be • a way to make the sheet calculate • a circular reference • a #NAME error • a precedence error
Which is larger? • 5 Mbs is smaller than 50 Kbs • 1 Tb is smaller than 30 Gb • 100 Kb is smaller than 1 Mb • 512 Mb is smaller than 0.5 Gb
The formula =sum(a3:a7) is the same as • =a3 + a7 • =a3 * a7 • =a3 + a4 + a5 + a6 + a7 • = a7-a3
This formula =5 * 3 + 8 / 2 would have the value 1. 27.5 2. 19 3. 55 4. none of the answers
0 What unit is used to measure printer resolution? • pixels • Characters per second • Dots per inch • pages per minute
A boot device is 1. an icon shaped like a boot 2. a drive that is expected to have an operating system on it 3. a floppy drive 4. 2 and 3
0 Which one is software? • Computer chip • Operating system • Hard drive • Optical scanner
0 Dvorak relates to what device? • A mouse. • A keyboard. • An optical scanner. • A display screen.
The indexing problem is about 1. too little information 2. too much information 3. incorrect information 4. slow hard drives