Here we have published 10 questions of MS Excel for preparation of computer awareness section asked in IBPS, SBI, banking exams and other exams. MS Excel is one of the most important part of MS Office and used widely for handling data and fast calculations for official and personal record. Good knowledge of Microsoft Excel is must for office jobs.
Computer Knowledge MS Excel MCQs Test Paper- 4
Q.1. What function will you use to insert current time in a cell in MS Excel?
A) = time()
B) = nowTime()
C) = now()
D) = currentTime()
E) None of these
B) = nowTime()
C) = now()
D) = currentTime()
E) None of these
Q.2. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
A) Unfreeze panes command on the window menu
B) Freeze panes command on the window menu
C) Hold titles command on the edit menu
D) Split command on the window menu
E) None of these
B) Freeze panes command on the window menu
C) Hold titles command on the edit menu
D) Split command on the window menu
E) None of these
Q.3. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
A) Use Ctrl to select all three cells, then click the paste button on the standard toolbar
B) Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
C) Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
D) All the above
E) None of these
B) Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
C) Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
D) All the above
E) None of these
Q.4. The default header of worksheet is-
A) Username
B) Date and Time
C) Sheet tab name
D) No default header
E) None of these
B) Date and Time
C) Sheet tab name
D) No default header
E) None of these
Q.5. Which of the following is not an option of the spelling dialog box?
A) Ignore
B) Ignore all
C) Edit
D) Change
E) None of these
B) Ignore all
C) Edit
D) Change
E) None of these
Q.6. How many maximum files you can display on recent file menu?
A) 4
B) 9
C) 12
D) 15
E) None of these
B) 9
C) 12
D) 15
E) None of these
Q.7. The name box appears at the-
A) Left side of formula bar
B) Right side of the formula bar
C) Below the menu bar
D) Above the status bar
E) None of these
B) Right side of the formula bar
C) Below the menu bar
D) Above the status bar
E) None of these
Q.8. Which function in excel counts the numbers of characters in a cell ?
A) LENGTH
B) LEN
C) Lt
D) LGT
E) None of these
B) LEN
C) Lt
D) LGT
E) None of these
Q.9. To edit data in an embedded Excel worksheet object in a Word document-
A) Use the Excel menu bar and toolbars inside the word application
B) Edit the hyperlink
C) Edit the data in a Excel source application
D) Use the Word menu bar and toolbars
E) None of these
B) Edit the hyperlink
C) Edit the data in a Excel source application
D) Use the Word menu bar and toolbars
E) None of these
Q.10. A worksheet can have a maximum of ___ Number of rows?
A) 256
B) 32499
C) 4096
D) 65535
E) None of these
B) 32499
C) 4096
D) 65535
E) None of these
Answers of above questions:
- C
- B
- C
- D
- C
- B
- A
- B
- A
- D
Recommended Posts:
- Microsoft Excel Practice Question Paper- 1 with Answer Key
- Microsoft Excel Practice Question Paper- 2 with Answer Key
- Microsoft Excel Practice Question Paper- 3 with Answer Key
- Click for More Computer Knowledge/ Computer Awareness Question Papers
- List of Best and Recommended Books for Computer Awareness.
- Click to Subscribe and Get Updates of Computer Knowledge Question Papers in your Inbox.
We have tried our best to present only
important computer awareness questions with correct answer key. Any suggestion or update
about any erroneous entry or answer is always appreciable. Please comment your score or any suggestion in comment section below or you can write to us at careerguide.co@gmail.com. We will be glad to help you.
Comments
Post a Comment