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
B. descending order ( Answer)
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
C. Re-format the spreadsheet
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
D. spreadsheet (Answer)
4. The Cancel and Enter buttons appear in the:
A. Sheet tabs
B. Formula bar (Answer)
C. Title bar
D. Menu bar
5. MS-EXCEL can be used to automate
A. Transaction registers, inventory control
B. Accounts receivable, accounts payable
C. Financial statements, Business forecasting
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
B. formula ( Answer)
C. field
D. table
8. NOT, AND, OR and XOR are
A. Relational operators
B. Arithmetic operators
C. Logical Operators ( Answer)
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
D. Save As ( Answer)
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.
A. left ( Answer)
B. right
C. top
D. bottom
12) You can complete a cell entry by pressing
A. enter (Your Answer)
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
B. 10 pt. Arial (Answer)
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.
A. True ( Answer)
B. False
15) Which button allows you to copy cell formats from one cell to another?
A. enter
B. autofit
C. format painter (Your Answer)
D. esc
16) A_______ is a group of cells that form a retangle on the screen.
A. label
B. workbook
C. worksheet
D. column
E. range ( Answer)
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.
A. True ( Answer)
B. False
19) An example of a range address.
A. A1:B3 ( Answer)
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
C. selection pointer (Answer)
D. range selector