Quiz : MS Excel Multiple Choice Questions(MCQs) - Objective Question - Set 1

 
There are 23 questions. Each questions have 23 points. 23 minutes to complete this quiz.
Total 15 Minutes to complete this quiz.
Total 23 Points
 
1.

Which keyboard shortcut opens the Go To dialog box?

 
1) Ctrl + B
2) F2
3) Ctrl + Shift + B
4) F5
Marks: 1
2.

If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort?

 
1) zip codes (ascending), then last name (ascending), then first name (ascending)
2) last name (ascending), then first name(ascending), then last name (ascending)
3) last name (descending), then first name (descending), then last name (descending)
4) zip codes (descending), then last name(ascending), then first name(ascending)
Marks: 1
3.

 The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called

 
1) Locking
2) Freezing
3) selecting
4) fixing
Marks: 1
4.

The accounting style shows negative numbers in

 
1) Quotes
2) Parenthesis
3) bold
4) bracket
Marks: 1
5.

A quick way to return to a specific area of a worksheet is to type in the _____

 
1) Zoom Box
2) Name box
3) Formula Box
4) None of these
Marks: 1
Show questions per page
1 to 5 of 23 (5 Pages)