Microsoft Office: Top 1850+ Multiple Choice Questions Answers (MCQs) for all Examination and Interview: MS Office (MS Excel, MS Word, MS PowerPoint, and MS Access) Question Bank by Kanaujia Er. Avnindra

Author:Kanaujia, Er. Avnindra [Kanaujia, Er. Avnindra]
Language: eng
Format: epub
Published: 2020-06-19T16:00:00+00:00

Q.108 In a computer, correct row address is

a) AA

b) 25

c) 3B

d) C5

Q. In a computer, if custom format is #, # # # then 1500 will be displayed as

a) 150,00

b) 15,00

c) 1,500

d) 15,000

Q.109 In a computer spreadsheet, a preprogrammed Formula is basically a

a) function

b) cell

c) graph

d) range

Q.110 In a computer, page orientation is changed through

a) page setup dialog box

b) setup dialog box

c) paper dialog box

d) print dialog box

Q.111 In a computer, graphics representation of data is named as

a) chart

b) graphics

c) picture

d) figure

Q.112 Which of the following isn’t a part of a spreadsheet?

a) row number

b) column number

c) column letter

d) cell address

Q.113 Spreadsheets cannot:

a) do calculations

b) create graphics

c) plot graphs

d) plot charts

Q.114 An easier way to set up complicated calculations .

a) Decimals

b) Fractions

c) Booleans

d) Functions

Q.115 The cell that is in use.

a) Active cell

b) Highlighted cell

c) Main cell

d) Formula cell

Q.116 The placement of information within a cell at the left edge, right edge, or centered is:

a) Alignment

b) Identification

c) Indentation

d) Placement

Q.117 A change in the appearance of a value or label in a cell.

a) Alteration

b) Format

c) Indentation

d) Design

Q.118 An entry in a spreadsheet cell representing wages or test scores is most likely a

a) label

b) value

c) formula

d) calculation

Q.119 Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as

a) decoration

b) data appearance

c) functions

d) charting

Q.120 In a computer, element which is not a part of chart is

a) plot area

b) fill handler

c) series

d) chart area

Q.121 In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is

a) 7

b) 12

c) 1.5

d) None

Q.122 In a computer spreadsheet, first part of number format describes

a) text values

b) negative number

c) positive number

d) zero values

Q.123 Extension of computer MS-Excel file is

e) wrd

f) xls

g) doc

h) jpg

Q.124 Cell in a computer spreadsheet that contain a formula or function will show

a) formula or function

b) cell's address

c) resulting display value

Q.125 In a computer spreadsheet, function which is used to count numbers of entries in given range is called

a) length

b) counter

c) counting

d) count

Q.126 Main window in a computer spreadsheet is called

a) work sheet

b) work

c) account book

d) work book

Q.127 In a computer, fourth part of number format describes

a) text values

b) positive number

c) negative number

d) zero values

Q.128 In a computer spreadsheet, each cell contain a

a) formula

b) value

c) label

d) all of these

Q.130 In a computer spreadsheet, number of arguments which SUM function require are

a) 4

b) 3

c) 1

d) None

Q.131 In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of

a) functions

b) calculations

c) formulas

d) relative addressing

Q.132 In a computer spreadsheet, cell range A3 through G3 should be keyed in as

a) A3:G3

b) A3 to G3

c) A3-G3

d) A3?.G3

Q.133 Actual working area of computer's Microsoft Excel is

a) worksheet

b) workbook

c) notesheet

d) notebook

Q.134 An entry in a spreadsheet cell like "Monthly Wages" or "Final Approval Rating" would most likely to be a

a) calculation

b) value

c) label

d) formula

Q.136 In a computer spreadsheet, number of arguments in SQRT function are

a) equal to column no

b) equal to range

c) one

d) two

Q.137 In a computer spreadsheet, formula that equates to 6 is

a) 9-2x3+4/2

b) 1+2x3-8/2

c) 8-2x3+8/2

d) 2x3-4/2

Q.138 The placement of information within a cell at the left edge, right edge, or centered is :

a) Alignment

b) Identification

c) Indentation

d) Placement

Q.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.