1. Which is not an advantage of using computerized spreadsheets? (4)
(1) flexibility of moving entries
(2) speed of calculation
(3) ability of generate tables
(4) cost of initial setup
(5) None of the above
2. All formula in Excel start with (3)
(1) %
(2) +
(3) =
(4) –
(5) None of the above
3. What is the AutoSummarize feature used for in Word 2000 (1)
1. It creates a 250 word, 500 word or 1000 word summary of the document
2. It adds Automatic headers, bold and italic characters as well as automatic formatting of the document to give the look of a well summarized document
3. it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs
4. It identifies the key points in a document for your to share with others or quickly scan
5. None of the above
4. To select several cells or ranges that are not touching each other, you would … while selecting (1)
(1) hold down the Ctrl key
(2) hold down the Shift key
(3) hold down the Alt key
(4) hold down Ctrl + Shift key
(5) None of the above
5. A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button….. (4)
(1) nothing will print because some cells with data have been omitted
(2) only the cells with gray background will print
(3) the whole sheet will print
(4) only the cells with white background will print
(5) None of the above
6. The view that puts a blue a blue line around each page that would be printed is the ….. (3)
(1) Print Preview
(2) Normal View
(3) Page Break Preview
(4) Split View
(5) None of the above
7. Auto Calculate will quickly add selected cells if you….. (2)
(1) right click on the status bar and select Sum
(2) click the AutoCalculate button on the toolbar
(3) use the key combination Ctrl+$
(4) Double click the selection
(5) None of the above
8. A constant is another name for this type of data (1)
(1) number
(2) equation
(3) formula
(4) description
(5) None of the above
9. The cell labeled 23. 54 the cell labeled F5 refers to (2)
(1) row F column 5
(2) column F row 5
(3) function available in cells
(4) function key F4
(5) None of the above
10. When you are typing an equation into a cell the first thing that must be entered is (4)
(1) the first cell referenced
(2) parenthesis
(3) quotation marks
(4) an equal sign
(5) None of the above
