BG-5

Q1. Excel documents are stored as files called

A. Workgroups

B. Worktables

C. Worksheets

D. Workforce

Q2. To displays the Find and Replace dialog box, with the Find tab selected press

A. Alt + F

B. Tab + F

C. Esc + F

D. Ctrl + F

Q3. Press ______ to saves the active file with its current file name, location, and file format.

A. Ctrl + S

B. Alt + S

C. Ctrl + Alt + Esc

D. Alt + Tab + Esc

Q4. In Excel, Columns are labelled as ___

A. A, B, C, etc

B. 1,2,3 etc

C. A1, A2, etc.

D. $A$1, $A$2, etc.

Q5. In Excel, Rows are labelled as ______

A. A, B, C, etc

B. 1,2,3 etc

C. A1, A2, etc.

D. $A$1, $A$2, etc

Q6. In Excel, which one denoted a range from B1 through E5

A. B1 - E5

B. B1 to E5

C. B1$E5

D. B1:E5

Q7. The extension of database file in excel is

A. .doc

B. .xls

C. bmp

D. .dbf

Q8. Which of the following formulas will Excel Not be able to calculate?

A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

Q9. How are data organized in a spreadsheet?

A. Rows and Columns

B. Boxes

C. Tables

D. None of the above

Q10. What is the intersection of a column and a row on a worksheet called?

A. Column

B. Value

C. Address

D. Cell