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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
A) record 
B) attributes 
C) tuples 
D) field

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

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

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

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

Which of the following is an object in MS Access

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

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

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

Which of the following is a statistical function in excel?

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

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

Which of the following is a financial function in excel?

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

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

Information Systems and Components

Information Systems and Management: Exploring Concepts and Applications

Information Systems and Technology

Computer Hardware, Software, and Information Systems

Information Systems and Technology

Information Systems and Database Management: Part 1

Information Systems and Database Management: Part 2

Filters

Exam 8: Microsoft Office Applications and Functions

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

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

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

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

Which of the following is an object in MS Access

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

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

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

Which of the following is a statistical function in excel?

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

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

Which of the following is a financial function in excel?

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

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

Information Systems and Components

Information Systems and Management: Exploring Concepts and Applications

Information Systems and Technology

Computer Hardware, Software, and Information Systems

Information Systems and Technology

Information Systems and Database Management: Part 1

Information Systems and Database Management: Part 2

Filters