Spreadsheet MCQ

Spreadsheet MCQ - 1. The 30 column in a spreadsheet is...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1. The 30 column in a spreadsheet is identified as column a. 30 b. DD c. AD d. A30 2. Which of the following specifies calculations using cells in a spreadsheet? a. Formulas b. Labels c. The database d. Field formats 3. The two types of cell addressing used in spreadsheets are a. Relative and absolute cell addressing b. Absolute and vector-dependent cell addressing c. Relative and vector-dependent cell addressing d. Offset and fixed-cell address 4. If a cell in a spreadsheet is formatted for currency and contains the value 2345.678, what would be displayed? a. 2345.678 b. $2345.678 c. $2,345.68 d. $2,345.67 5. Once entered in the spreadsheet, formulas may be a. Coped to other cells b. Deleted or revised c. Merged with labels d. Both copied to other cells and deleted or revised 6. A range in a spreadsheet cannot be a. A single cell b. All or part of a column or row c. A rectangular block of cells d. Part of a cell 7. In the spreadsheet formula A4*(B$5$ +L30)/C18, which arithmetic operation is performed first? a.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/19/2010 for the course IT csec taught by Professor Daley during the Spring '10 term at Immaculata.

Page1 / 3

Spreadsheet MCQ - 1. The 30 column in a spreadsheet is...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online