Office Automation Tools Set 8

Bachelor of Commerce (B Com)

Practice Mode Previous Next
On This Page

This set of Office Automation Tools Multiple Choice Questions & Answers (MCQs) focuses on Office Automation Tools Set 8

Q1 | In Excel, we can use --------- function to calculate EMI of loan.
  • ipmt
  • pmt
  • goal seek
  • correl
Answer: pmt
Q2 | Which of the following is not a statistical function in excel?
  • average
  • correl
  • stdev
  • sum
Answer: sum
Q3 | Which of the following coming under “What-If –Analysis” in excel?
  • goal seek
  • scenario manager
  • data table
  • all the above
Answer: all the above
Q4 | ---------- is a method to find a specific value of cell by adjusting the value ofanother cell.
  • goal seek
  • scenario manager
  • data table
  • macro
Answer: goal seek
Q5 | Which of the following is not a logical function in excel?
  • and
  • false
  • or
  • none of these
Answer: none of these
Q6 | By default an excel work book displays--------- work sheets
  • 1
  • 2
  • 3
  • 5
Answer: 3
Q7 | “Auto fill” is a unique feature of:
  • ms word
  • ms excel
  • ms powerpoint
  • all of these
Answer: ms excel
Q8 | Which of the following is not a basic mathematical function in Excel?
  • addition
  • division
  • exponential
  • none of these
Answer: none of these
Q9 | In Excel row’s heading is known as
  • field
  • tupple
  • domain
  • attributes
Answer: tupple
Q10 | In email, addresses separate the user name from the ISP using the __________symbol.
  • &
  • @
  • %
  • $
Answer: @
Q11 | The mail server as defined in the text uses the __________ protocol.
  • http
  • ftp
  • pop
  • smtp
Answer: pop
Q12 | News servers utilize __________ to distribute documents to readers.
  • nntp
  • news
  • http
  • ftp
Answer: nntp
Q13 | To search FTP archives for a file, you should use the __________ tool.
  • gopher
  • jughead
  • archie
  • jalopy
Answer: jughead
Q14 | __________ is often referred to as “the CB of the Internet.”
  • irc
  • ftp
  • e-mail
  • http
Answer: irc
Q15 | Discussion groups may have a __________ who monitors the postings andenforces the site’s rules.
  • judge
  • sysop
  • narrator
  • censor
Answer: sysop
Q16 | A message with replies on a newsgroup is often called a __________.
  • post
  • list
  • thread
  • comment
Answer: thread
Q17 | Internet is governed by_____________.
  • microsoft corporation.
  • adobe.
  • dish net.
  • none of these.
Answer: none of these.
Q18 | Which of the following is not a web browser?
  • internet browser
  • netscape communicator.
  • netscape navigator
  • adobe pagemaker.
Answer: adobe pagemaker.
Q19 | HTML means_______.
  • hyper text mark-up language.
  • hyper testing mark-up language.
  • hardware text mark-up language.
  • hyper testing mapping language.
Answer: hyper text mark-up language.
Q20 | WWW means_______________.
  • world wide wan.
  • world wide web.
  • world wan web.
  • world wan web.
Answer: world wide web.
Q21 | WWW uses the following protocol?
  • http.
  • ftp
  • wwwc
  • smtp.
Answer: http.
Q22 | FTP is acronym of____________.
  • file transfer protocol
  • file transmission protocol.
  • free transfer protocol.
  • file terminal protocol.
Answer: file transfer protocol
Q23 | Website is a collection of__________.
  • audio files.
  • video files.
  • image files.
  • html files.
Answer: html files.
Q24 | When you open Internet, the first page is referred to as_________.
  • master page.
  • home page.
  • first page.
  • title page.
Answer: home page.
Previous Next