M.S.Excel QUIZ-06

In order to perform a calculation in a spreadsheet, you need to use a:
table
formula 
data
variable

\In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
calendar
photograph of rainfall
chart showing rainfall amounts 
database of rainfall

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 ……………
ascending order
descending order 
alphabetical order
random order

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:
word processing
spreadsheet 
database
graphics

If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Re-format the spreadsheet
Insert a row 
Increase the column width
Use the space bar

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?
New
Save As 
Edit
Save

NOT, AND, OR and XOR are
Logical Operators
Arithmetic operators
 Relational operators
None of the above

B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9 
Cell B8 only
None of the above