LATEST NEWS
Subscribe to Generalknowledgetoday's Dialy Free NewsLetter !
Published On: Fri, Dec 12th, 2014

# EXCEL QUIZ Series 1

1. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………

A. ascending order
C. random order
D. alphabetical order

2. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

A. Insert a row (r Answer)
B. Use the spacebar
D. Increase the column width

3.You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

A. database
B. graphics
C. word processing
4. The Cancel and Enter buttons appear in the:

A. Sheet tabs
C. Title bar

5. MS-EXCEL can be used to automate

A. Transaction registers, inventory control
B. Accounts receivable, accounts payable
D. Any of the above ( Answer)

6. B7:B9 indicates:

A. Cell B8 only
B. Cells B7 through B9 ( Answer)
C. Cells B7 and cell B9 only
D. None of the above
7. In order to perform a calculation in a spreadsheet, you need to use a:

A. variable
C. field
D. table

8. NOT, AND, OR and XOR are

A. Relational operators
B. Arithmetic operators
D. None of the above
9. You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?

A. Edit
B. Save
C. New
10. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

A. database of rainfall
B. photograph of rainfall
C. calendar
D. chart showing rainfall amounts ( Answer)

11) Labels are aligned at the ________ edge of the cell.

B. right
C. top
D. bottom

12) You can complete a cell entry by pressing

B. tab (Missed)
C. shift+tab (Missed)
D. an arrow key (Missed)
E. another cell (Missed)

all are correct

13) The default font keyed in a new work book is.

A. 12 pt. Times New Romans
C. 12 pt. Bradley Hand ITC
D. 10 pt. Times New Roman

14) True or False. If you choose a larger font size, the height of the row is automatically made taller.

B. False

15) Which button allows you to copy cell formats from one cell to another?

A. enter
B. autofit
D. esc

16) A_______ is a group of cells that form a retangle on the screen.

A. label
B. workbook
C. worksheet
D. column

17) How do you know a range is active?

A. It is highlighted on the screen. ( Answer)
B. It has a marquee around it.
C. The data changes to Bold to let me know it’s active
D. I’m psychic & I just Know!!

18) True or False. A range has an address called an range address.

B. False

19) An example of a range address.

B. A1;B3
C. A1-B3
D. A1=B3
E. A1*B3

20) When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________.

A. cell selector
B. cell cross
D. range selector

### Laptops@Heavy Discount Prices !

``` <br /> <br /> <br /> <br /> <br /> <br /> <br /> ```

``` <br /> <br /> <br /> ```
``` ```
``` ```
``` #sharebox{ float:left; margin-left:20px; background:#DBDBDB; position:fixed; top:145px;left:0; padding:5px 0; -moz-border-radius:5px; border-radius:5px;border:1px solid #CDCDCD} #sharebox:hover{background:#eee;-moz-transition:all 0.3s ease-in-out 0s;-webkit-transition:all 0.3s ease-in-out 0s;transition:all 0.3s ease-in-out 0s} #sharebox .wdt{ text-align:center; clear:left; padding:2px 4px} Tweet (function() { var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true; po.src = 'https://apis.google.com/js/plusone.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s); })(); Pin It ```
``` ```
``` amzn_assoc_ad_type ="responsive_search_widget"; amzn_assoc_tracking_id ="keralabrands-21"; amzn_assoc_marketplace ="amazon"; amzn_assoc_region ="IN"; amzn_assoc_placement =""; amzn_assoc_search_type = "search_widget";amzn_assoc_width ="auto"; amzn_assoc_height ="auto"; amzn_assoc_default_search_category ="Books"; amzn_assoc_default_search_key ="";amzn_assoc_theme ="light"; amzn_assoc_bg_color ="FFFFFF"; ```