computer MCQs - 11th class Chapter 09 Mcqs

1

What is the primary purpose of a Spreadsheet program?

A

To write documents

B

To create presentations

C

To work with sets of numbers

D

To browse the internet

2

What is the intersection of a row and a column in a spreadsheet called?

A

A Box

B

A Cell

C

A Grid

D

A Reference

3

Which of the following is an example of a spreadsheet software mentioned in the text?

A

MS Word

B

LOTUS 123

C

Adobe Photoshop

D

Windows Media Player

4

A text entry in a cell, such as 'Gross Salary', is known as a:

A

Value

B

Formula

C

Function

D

Label

5

What are used to express mathematical relationships between cells?

A

Functions

B

Commands

C

Formulas

D

Labels

6

A collection of related worksheets saved as a single file is called a:

A

Worksheet

B

Document

C

Workbook

D

Database

7

Modern spreadsheets that can contain multiple worksheets are known as:

A

2D-Worksheets

B

Flat-Worksheets

C

Simple-Worksheets

D

3D-Worksheets

8

In a spreadsheet, which bar is used to apply and edit formulas for a selected cell?

A

Menu Bar

B

Toolbar

C

Formula Bar

D

Status Bar

9

What does a bold rectangular border around a cell indicate?

A

The cell is passive

B

The cell is locked

C

The cell is active

D

The cell contains an error

10

Which basic operations, similar to word processors, can be used to move data between worksheets?

A

Find and Replace

B

Cut, copy, and paste

C

Header and Footer

D

Spell Check

11

Which of the following is NOT a common form of data entered in a cell?

A

Labels

B

Values

C

Formulas

D

Operating System files

12

A cell reference that changes when a formula is copied to another cell is called:

A

Absolute referencing

B

Relative referencing

C

Named referencing

D

Mixed referencing

13

How is absolute referencing for a cell like A1 indicated in a formula?

A

A1

B

!A!1

C

&A&1

D

$A$1

14

What is a name that you define to represent a cell or a range of cells called?

A

A Label

B

A Range Name

C

An Address

D

A Title

15

All formulas in a worksheet must begin with which symbol?

A

+

B

-

C

0

D

*

16

What is the format to link a cell from another worksheet named 'Sheet2' in a formula?

A

Sheet2+A2

B

Sheet2.A2

C

Sheet2!A2

D

Sheet2:A2

17

Which built-in function is used to find the sum of a range of cells?

A

AVERAGE

B

SUM

C

MAX

D

COUNT

18

What does the =MAX(C1:C100) function do?

A

Finds the minimum value

B

Finds the maximum value

C

Calculates the average

D

Counts the cells

19

Which function returns the current date?

A

0

B

0

C

0

D

0

20

What tool in MS Excel can be used to view and apply any of the available functions?

A

Formula Bar

B

Function Wizard

C

Chart Wizard

D

Data Tab

21

The default number format assigned to a cell is the:

A

Currency format

B

Number format

C

General format

D

Text format

22

In custom formatting, which symbol is a placeholder that displays insignificant zeros?

A

0

B

#

C

?

D

.

23

In custom formatting, which symbol is a placeholder that does NOT display insignificant zeros?

A

0

B

#

C

?

D

$

24

How many parts can a custom number format consist of, separated by semicolons?

A

Two

B

Three

C

Four

D

Five

25

Which tab in the Format Cells dialog box is used to change the orientation of text?

A

Number

B

Font

C

Border

D

Alignment

26

What is the maximum angle you can rotate text in a cell?

A

90 degrees

B

180 degrees

C

270 degrees

D

360 degrees

27

Which feature allows you to combine several cells into one larger cell?

A

Wrap Text

B

Merge Cells

C

Format Painter

D

Split Cells

28

Which tool helps you create a chart by guiding you through a series of dialog boxes?

A

Function Wizard

B

Chart Wizard

C

Pivot Table

D

Data Validation

29

Which of the following is NOT a chart type mentioned in the text?

A

Pie Chart

B

Line

C

Bar

D

Flowchart

30

In the Page Setup dialog, which option forces a worksheet to print on a single page width?

A

Adjust to

B

Portrait

C

Fit to

D

Scaling

31

Where would you go to add preset headers and footers to your printed page?

A

Page tab

B

Margins tab

C

Header/Footer tab

D

Sheet tab

32

What does the function =MIN(D1:D100) do?

A

Returns the highest number

B

Returns the average

C

Returns the lowest number

D

Returns the median

33

What is a cell reference formed by?

A

Combining the column letter and row number

B

Combining two row numbers

C

Combining two column letters

D

Using the cell's content

34

The specialty of spreadsheet software is working with:

A

Text

B

Images

C

Numbers

D

Videos

35

What can a 'value' in a cell represent?

A

Only a number

B

Only a date

C

A number, a date, or a formula

D

Only text

36

Early spreadsheet programs could contain how many worksheets at a time?

A

One

B

Two

C

Ten

D

Unlimited

37

The command to define a named range is found under which menu?

A

File

B

Edit

C

View

D

Insert

38

If the formula =(A1+B1) in cell C1 is copied to C2, what will the new formula be?

A

0

B

0

C

0

D

0

39

Which function finds the square root of a value in a cell?

A

0

B

0

C

0

D

0

40

The default alignment for text in a cell is typically:

A

Right

B

Center

C

General

D

Justified

41

To view the first Chart Wizard dialog box, you click a button on the:

A

Formatting toolbar

B

Standard toolbar

C

Menu bar

D

Status bar

42

Which option in the Page Setup's Sheet tab allows you to print column titles on every page?

A

Gridlines

B

Print area

C

Rows to repeat at top

D

Page order

43

What does selecting 'Wrap Text' do?

A

Merges the cells

B

Makes text fit in a cell by breaking it into multiple lines

C

Rotates the text

D

Hides the text

44

In custom formatting, the first part of the format code describes:

A

Negative numbers

B

Zero values

C

Positive numbers

D

Text values

45

What would the number 12 display as with a custom format of '0000'?

A

12

B

012

C

0012

D

1200

46

The actual working area in a spreadsheet program where you enter data is the:

A

Workbook

B

Worksheet

C

Formula Bar

D

Menu Bar

47

Which of these functions takes no arguments?

A

SUM()

B

MAX()

C

AVERAGE()

D

TODAY()

48

How can you make a cell active?

A

Double-click it

B

Using the mouse or arrow keys to select it

C

Right-click and select 'Activate'

D

It is always active

49

What is an argument in the context of a spreadsheet function?

A

A debate about the result

B

An error message

C

A value passed to the function for operation

D

The function's name

50

If you want to add values in cells G8 and Y10, the formula would look like:

A

0

B

ADD(G8,Y10)

C

G8 plus Y10

D

G8:Y10