Futureheights Training & Consultant Pvt. Ltd (Set-2)
.PNG "Futureheights Training & Consultant Pvt. Ltd (Set-2) - Quiz")
- 1.Ramesh Ahuja wants to store data of his monthly visits to schools over the last financial year. Which of the Office application is most suitable for this purpose?
- A.
MS word
- B.
Outlook
- C.
MS Excel
- D.
None of the above
- 2.Mention the shortcut key combinations used for navigating to the top of the worksheet
- A.
CTRL + HOME
- B.
CTRL + END
- C.
ALT + HOME
- D.
ALT + END
- 3.Which symbol always comes before an Excel formula?
- A.
,
- B.
=
- C.
-
- D.
%
- 4.Address of first cell in a worksheet is
- A.
A1
- B.
1
- C.
1A
- D.
None of the above
- 5.You can automatically adjust the size of text in a cell if they do not fit in width by
- A.
Double clicking on the right border of column header
- B.
From Format choose Columns and then Autofit Selection
- C.
From Format Cells dialog box mark Shrink to fit check box
- D.
All of above
- 6.
Based on the spreadsheet given below answers the below Questions- Formula for calculating the Total Price as sum of Science, Maths & Computers for each Customer and display them in column F-
- A.
=SUM(A2+B2+C2+D2)
- B.
=SUM(A1:E2)
- C.
=SUM(C2+D2+E2)
- D.
SUM(C2+D1+E2)
- 7.
Based on the spreadsheet given below answers the below Questions
- Formula for calculating the Discount @ 5% for each customer and display them in column G
- A.
F2/ 5% and then drag
- B.
=F2* 5% and then drag
- C.
=G2*5% and then drag
- D.
–AVG(C1:D1)
- 8.Click on the right option to freeze a column-
- A.
View- freeze first column
- B.
Data- freeze column
- C.
Insert- freeze
- D.
Home – freeze
- 9.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
- 10.Long text can be broken down into many lines within a cell. You can do this through
- A.
Wrap Text in Format >> Cells
- B.
Justify in Edit >> Cells
- C.
Text Wraping in Format >> Cells, Layout tab
- D.
All of above
- 11.The file type _____ indicates the file is a Word document
- A.
.msw
- B.
.wor
- C.
.wrd
- D.
.doc
- 12.Using Find command in Word, we can search?
- A.
Word
- B.
Formats
- C.
Story
- D.
All of the above
- 13.By default, on which page the header or the footer is printed?
- A.
on first page
- B.
On alternate page
- C.
On every page
- D.
None of the above
- 14.
Which menu/Ribbon shows paragraph option-
- A.
Home
- B.
View
- C.
Page layout
- D.
None of the above
- 15.Which key should be pressed to start a new paragraph in MS-Word?
- A.
Down Cursor Key
- B.
Enter Key
- C.
Shift + Enter
- D.
Ctrl + Enter
- 16.What is the function of Ctrl + I in Ms-Word
- A.
It converts selected text into the next larger size of the same font
- B.
It adds a line break to the document
- C.
It makes the selected text bold
- D.
It applies Italic formatting to the selected text
- 17.Why headers and footers used in MS –Word
- A.
To enhance the overall appearance of the document
- B.
To mark the starting of a page
- C.
To make large document more readable
- D.
To allow page headers and footers to appear on document when it is printed
- 18.Which menu/Ribbon in MSWord can be used to insert Watermark?
- A.
Insert
- B.
Page layout
- C.
Format
- D.
Data
- 19.There can be many ways to insert page number in a document. Which of the following lets you insert page number
- A.
Page number from Insert menu
- B.
Footnote from Insert menu
- C.
Page Setup from file menu
- D.
Both a & b
- 20.Which is the correct keyboard shortcut for CUT
- A.
CTRL + C
- B.
CTRL + D
- C.
CTRL + V
- D.
CTRL + X
- 21.Before Sending email I should,
- A.
Read mail twice
- B.
Check spellings
- C.
Check Subject
- D.
All of the above
- 22.How Quickly Should I reply to an email?
- A.
As soon as I can
- B.
I don’t have to reply
- C.
When I get around
- D.
Doesn’t matter
- 23.Why shouldn’t I type emails in all CAPS?
- A.
It makes you look lazy
- B.
It shows arrogant
- C.
Its shows you are yelling.
- D.
All of the above
- 24.If you don't want to type your name at the end of every email you send, what you can you do instead?
- A.
Don't sign at all .. people know who the email is from thanks to your return email address
- B.
Only sign emails to business associates, but you can exclude this step with friends and family
- C.
Create a signature that will attach to every email you send
- D.
None of the above
- 25.What is the most important thing I should do with every e-mail?
- A.
Spell check, use full sentence structure and use proper grammar
- B.
Have a nice greeting: Hi, Hello, etc
- C.
Include signature
- D.
All of the above
.PNG "Based on the spreadsheet given below answers the below Questions Formula for calculating the Total Price as sum of Science, Maths & Computers for each Customer and display them in column F-")
Back to top