Question 1

MS Access is a ............ application
A)spreadsheet
B)word
C)slide presentation
D)dbms

Accepted Answer

MS Access is a database management system (DBMS) application designed for creating, managing, and manipulating databases.

Question 2

Which of the following is an object in MS Access
A)query
B)forms
C)report
D)any of the above

Accepted Answer

In MS Access, queries, forms, and reports are all considered objects. Each serves a different purpose in managing and interacting with data in a database. Queries are used to search and retrieve data, forms are used for data entry and interaction, and reports are for formatting, calculating, and printing data in a specific layout.

Question 3

.............. is a series of commands that is recorded so it can be played back, or executed later.
A)query
B)goal seek
C)macro
D)scenario manager

Accepted Answer

A macro is a series of commands or instructions that are recorded so they can be executed later as a single command, often used to automate repetitive tasks.

Question 4

A ............. is a predetermined formula in Excel.
A)module
B)function
C)macro
D)none of these

Accepted Answer

A function in Excel is a predefined formula designed to perform specific calculations or tasks, such as SUM, AVERAGE, or VLOOKUP.

Question 5

Which of the following is "What-if-analysis in excel?
A)goal seek
B)scenario manager
C)both of these
D)none of these

Accepted Answer

What-if analysis in Excel includes tools like Goal Seek and Scenario Manager, both of which are used to forecast and plan according to different assumptions and criteria.

Question 6

Ms Offdice is a................
A)shareware
B)firmware
C)open software
D)an application suit

Accepted Answer

Ms Office is an application suite that includes various productivity applications like Word, Excel, and PowerPoint.

Question 7

Which of the following is a financial function in excel?
A)correl
B)max
C)d- count
D)npv

Accepted Answer

NPV (Net Present Value) is a financial function in Excel used to calculate the net present value of an investment based on a series of periodic cash flows and a discount rate.

Question 8

Which of the following is a statistical function in excel?
A)st dev
B)correl
C)covar
D)any of the above

Accepted Answer

All the options listed (st dev, correl, covar) represent statistical functions in Excel, albeit with slight modifications to their names. "STDEV" is used for calculating standard deviation, "CORREL" for correlation coefficient, and "COVAR" for covariance, making all of them statistical functions.

Question 9

In Excel, More than one data can be entered in a single cell by using............. facility
A)solver
B)goal seek
C)consolidation
D)scenario

Accepted Answer

The Scenario Manager in Excel allows users to input multiple sets of data in a single cell, enabling the comparison of different scenarios or outcomes.

Question 10

Questions can be raised in Ms Access by using............
A)queries
B)form
C)report
D)find

Accepted Answer

Queries in MS Access are used to ask questions about the data stored in the database. They can retrieve and manipulate data according to specific criteria set by the user.

Question 11

Data storage in Ms Access is as.............
A)table
B)diagram
C)chart
D)commands

Accepted Answer

Data in Microsoft Access is organized and stored in tables, which are the fundamental building blocks for storing data in the database.

Question 12

In MS Access rows are technically called..........
A)record
B)attributes
C)tuples
D)field

Accepted Answer

The answer of In MS Access rows are technically called..........
A)record
B)attributes
C)tuples
D)field...

Question 13

In MS Access columns are technically called..........
A)record
B)attributes
C)tuples
D)field

Accepted Answer

The answer of In MS Access columns are technically called..........
A)record
B)attributes
C)tuples
D)field...

Question 14

In Ms Access, actions can be automated by using...........
A)arguments
B)macro
C)query
D)all of these

Accepted Answer

Macros in MS Access are used to automate tasks and add functionality to forms, reports, and controls.

Quiz 8: Microsoft Office Applications and Functions

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

Which of the following is an object in MS Access

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

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

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

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

Which of the following is a financial function in excel?

Which of the following is a statistical function in excel?

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

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

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

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

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

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