QUIZ of the Ms-Excel

This set contains 10 multiple choice questions from MS Excel. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________

1. To protect a worksheet, you can choose Protection and the Protect Sheet from the - menu

A) Edit
B) Format
C) Tools
D) Data

2. To copy cell contents using drag and drop, press the

A) End key
B) Shift key
C) Esc key
D) None of above

3. If you press …., the cell accepts your typing as its contents.

A) Enter
B) Ctrl + Enter
C) TAB
D) Insert

4. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

A) G1-G10
B) B1.G10
C) B1;G10
D) B1:G10

5. Excel is a

A) Graphic program
B) None of these
C) Word processor
D) A spreadsheet

6. Which of the following is not a valid Zoom percentage in Excel?

A) 10 
B) 100 
C) 300 
D) 500

7. What is entered by the function =today()

A) The date value for the day according to system clock
B) The time value according to system clock
C) Today’s date as Text format
D) All of above

8. Merge cells option can be applied from

A) Format Cells dialog box Alignment Tab
B) Formatting toolbar
C) Both of above
D) None of above  

9. How can you remove borders applied in cells?
A) Choose None on Border tab of Format cells 
B) Open the list on Border tool in Formatting toolbar then choose first tool (no border) 
C) Both of above 
D) None of above
  

10. Which of the following is invalid statement?

A) Sheet tabs can be colored 
B) Some picture can be applied as a background of a sheet 
C) You can set the column width automatically fit the amount of text 
D) The width of a row and be specified manually or fit automatically

__________________________________________
>> Back to Quiz of All Computer Courses
___________________________________________________________________________________