JOIN ADRE 2.0 Telegram Group

Spreadsheet Quiz | Spreadsheet Objective Type Questions and Answers

Questions
21 Which of the following isn’t a part of a spreadsheet?
A row number
B column number
C column letter
D cell address

Answer: column number
2 Spreadsheets cannot:
A do calculations
B create graphics
C plot graphs
D plot charts

Answer: create graphics
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

23 An easier way to set up complicated calculations.
A Decimals
B Fractions
C Booleans
D Functions

Answer: Functions
24 The cell that is in use.
A Active cell
B Highlighted cell
C Main cell
D Formula cell

Answer: Active cell
25 The placement of information within a cell at the left edge, right edge, or centered is :
A Alignment
B Identification
C Indentation
D Placement

Answer: Alignment
26 A change in the appearance of a value or label in a cell.
A Alteration
B Format
C Indentation
D Design

Answer: Format
27 An entry in a spreadsheet cell representing wages or test scores is most likely a
A label
B value
C formula
D calculation

Answer: value
28 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

Answer: charting
29 In a computer, element which is not a part of chart is
A plot area
B fill handler
C series
D chart area

Answer: fill handler
30 In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is
A 7
B 12
C 1.5
D None

Answer: 7
31 In a computer spreadsheet, first part of number format describes
A text values
B negative number
C positive number
D zero values

Answer: positive number
32 Extension of computer MS-Excel file is
A wrd
B xls
C doc
D jpg

Answer: xls
33 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
D range

Answer: resulting display value
34 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

Answer: counting
35 Main window in a computer spreadsheet is called
A work sheet
B work
C account book
D work book

Answer: work book
36 In a computer, fourth part of number format describes
A text values
B positive number
C negative number
D zero values

Answer: text values
37 In a computer spreadsheet, each cell contain a
A formula
B value
C label
D all of these

Answer: all of these
38 In a computer spreadsheet, number of arguments which SUM function require are
A 4
B 3
C 1
D None

Answer: 1
39 In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of
A functions
B calculations
C formulas
D relative addressing

Answer: functions
40 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

Answer: A3:G3

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!
Advertisement
Assam Direct Recruitment Test Series