Quiz of the Ms-Excel (Week-22)

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. Shortcut Key of Autosum
A. Ctrl  + =
B. Shift + =
C. Ctrl  + Enter
D. Alt   + =


2. The Name box
a. Shows the location of the previously active cell
b. Appears  the left of the formula bar
c. Appears below the status bar
d. Appears below the menu bar


3. Hyperlinks cannot be
a. Special shapes like stars and banners
b. Drawing objects like rectangles ovals
c. Pictures
d. All can be hyperlinks
 

4. You can use the horizontal and vertical scroll bars to
a. Split a worksheet into two panes
b. View different rows and columns
c. Edit the contents of a cell
d. View different worksheets
 


5. Which of the following setup options can not be set in the page setup dialog box?
a. Printer selection
b. Vertical or horizontal placement
c. Orientation
d. Row and column titles
 

6. You can open the consolidate dialog box byt choosing Consolidate from the ….. Tab.
a. Insert
b. Format
c. Tools
d. Data
 

7. Each excel file is called a workbook because
a. It can contain text and data
b. It can be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it


8.Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts
d. Bar charts and line graphs only


9. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
 

10. What does the VLOOKUP function do ?
a. Looks up text that contain ‘v’
b. Checks whether text is the same in one cell as in the next
c. Finds related records
d. All of above

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of All Computer Courses
>> Back to Notes of C-Language
>> Back to Shortcuts of All Computer Courses
>> Back to Video Tutorials of All Computer Courses
>> Back to Abbreviations

---------------------------------------------------------------------------------------------------------------