Deck 8: Excel Functions, What-If Analysis, and Internet Basics

Question 1

In Excel, we can use --------- function to calculate EMI of loan.

A) ipmt
B) pmt
C) goal seek
D) correl

Answer 1

pmt

Question 2

Which of the following is not a statistical function in excel?

A) average
B) correl
C) stdev
D) sum

Answer 2

sum

Question 3

Which of the following is not a logical function in excel?

A) and
B) false
C) or
D) none of these

Answer 3

none of these

Question 4

By default an excel work book displays--------- work sheets

A) 1
B) 2
C) 3
D) 5

Question 5

"Auto fill" is a unique feature of:

A) ms word
B) ms excel
C) ms powerpoint
D) all of these

Question 6

Which of the following is not a basic mathematical function in Excel?

A) addition
B) division
C) exponential
D) none of these

Question 7

In Excel row's heading is known as

A) field
B) tupple
C) domain
D) attributes

Question 8

In email, addresses separate the user name from the ISP using the __________ symbol.

A) &
B) @
C) %
D) $

Question 9

The mail server as defined in the text uses the __________ protocol.

A) http
B) ftp
C) pop
D) smtp

Question 10

News servers utilize __________ to distribute documents to readers.

A) nntp
B) news
C) http
D) ftp

Question 11

To search FTP archives for a file, you should use the __________ tool.

A) gopher
B) jughead
C) archie
D) jalopy

Question 12

__________ is often referred to as "the CB of the Internet. "

A) irc
B) ftp
C) e-mail
D) http

Question 13

Discussion groups may have a __________ who monitors the postings and enforces the site's rules.

A) judge
B) sysop
C) narrator
D) censor

Question 14

A message with replies on a newsgroup is often called a __________.

A) post
B) list
C) thread
D) comment

Question 15

Internet is governed by_____________.

A) microsoft corporation.
B) adobe.
C) dish net.
D) none of these.

Question 16

Which of the following is not a web browser?

A) internet browser
B) netscape communicator.
C) netscape navigator
D) adobe pagemaker.

Question 17

HTML means_______.

A) hyper text mark-up language.
B) hyper testing mark-up language.
C) hardware text mark-up language.
D) hyper testing mapping language.

Question 18

WWW uses the following protocol?

A) http.
B) ftp
C) wwwc
D) smtp.

Question 19

FTP is acronym of____________.

A) file transfer protocol
B) file transmission protocol.
C) free transfer protocol.
D) file terminal protocol.

Question 20

Website is a collection of__________.

A) audio files.
B) video files.
C) image files.
D) html files.

Question 21

When you open Internet, the first page is referred to as_________.

A) master page.
B) home page.
C) first page.
D) title page.