Question 1

.............. is a series of commands that is recorded so it can be played back, or executed later.

Accepted Answer

A) query 
B) goal seek 
C) macro 
D) scenario manager C

Question 2

A ............. is a predetermined formula in Excel.

Accepted Answer

A) module 
B) function 
C) macro 
D) none of these B

Question 3

MS Access is a ............ application

Accepted Answer

A) spreadsheet 
B) word 
C) slide presentation 
D) dbms D

Question 4

In Excel, More than one data can be entered in a single cell by using............. facility

Accepted Answer

A) solver 
B) goal seek 
C) consolidation 
D) scenario

Question 5

Which of the following is an object in MS Access

Accepted Answer

A) query 
B) forms 
C) report 
D) any of the above

Question 6

In MS Access columns are technically called..........

Accepted Answer

A) record 
B) attributes 
C) tuples 
D) field

Question 7

Which of the following is "What-if-analysis in excel?

Accepted Answer

A) goal seek 
B) scenario manager 
C) both of these 
D) none of these

Question 8

In Ms Access, actions can be automated by using...........

Accepted Answer

A) arguments 
B) macro 
C) query 
D) all of these

Question 9

Which of the following is a statistical function in excel?

Accepted Answer

A) st dev 
B) correl 
C) covar 
D) any of the above

Question 10

Data storage in Ms Access is as.............

Accepted Answer

A) table 
B) diagram 
C) chart 
D) commands

Question 11

Questions can be raised in Ms Access by using............

Accepted Answer

A) queries 
B) form 
C) report 
D) find

Question 12

Which of the following is a financial function in excel?

Accepted Answer

A) correl 
B) max 
C) d- count 
D) npv

Question 13

Ms Offdice is a................

Accepted Answer

A) shareware 
B) firmware 
C) open software 
D) an application suit

Question 14

In MS Access rows are technically called..........

Accepted Answer

A) record 
B) attributes 
C) tuples 
D) field

Exam 8: Microsoft Office Applications and Functions

.............. is a series of commands that is recorded so it can be played back, or executed later.