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

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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
apsc complete general studies course