Practice Quizzes on Spreadsheet

1. In a spreadsheet, letters are used to represent______

• Cell

• Row

• Columns

• Blocks

2. A numeric data analysis tool that allows us to create a computerized ledger

• a) Word processing package

• b) Spreadsheet package

• c) Graphics package

• d) Mathematical Package

3. Which of the following isn't a part of a spreadsheet?

• a) row number

• b) column number

• c) column letter

• d) cell address,

5. help us to see patterns.

• a) Spreadsheets

• b) Calculations

• c) Charts

• d) Graphs

6. An easier way to set up complicated calculations.

• a) Decimals

• b) Fractions

• c) Booleans

• d) Functions

 7.In a worksheet you can select

• a. The entire worksheet

• b. Rows

• c. Columns

• d. a, b, and c

8. 8. Which of the following describes how to select all the cells in a single column?

• a. Right click on column and select Pick from list

• b. Use data – text to columns menu item

• c. Left click on the gray column title button

• d. Pressing Ctrl + A on the keyboard

9. You can activate a cell by

• a. Pressing the Tab key

• b. Clicking the cell

• c. Pressing an arrow key

• d. All of above

10. To drag a selected range of data to another worksheet in the same workbook, use the

• a. Tab key

• b. Alt key

• c. Shift key

• d. Ctrl key

11. 11. you can use the formula palette to

• a. format cells containing numbers

• b. create and edit formulas containing functions

• c. entered assumptions data

• d. copy a range of cells