BG-7

Q1. What is the shortcut for selecting the entire column?

A. Ctrl + Spacebar

B. Ctrl + A

C. Ctrl + Q

D. Alt + Spacebar

Q2. To multiply items in Excel, you would use:

A. /

B. X

C. *

D. _

Q3. In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. ;

Q4. Which of the following you can paste selectively using Paste Special command?

A. Validation

B. Formats

C. Formulas

D. All of above

Q5. Which area in an Excel window allows entering values and formulas?

A. Title Bar

B. Menu Bar

C. Formula Bar

D. Standard Tool Bar

Q6. How do you rearrange the data in ascending or descending order?

A. Data Sort

B. Data Form

C. Data Table

D. Data Subtotals

Q7. Which language is used to create macros in Excel?

A. Visual Basic

B. C

C. Visual C++

D. Java

Q8. Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

D. All of above

Q9. In a worksheet you can select

A. Etire worksheet

B. Rows

C. Columns

D. All of the above

Q10. When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesn't adjust relative cell references

E. None of these