Spreadsheet Program Functions MCQs Quiz Online PDF Book Download

Spreadsheet program functions multiple choice questions (MCQs), spreadsheet program functions quiz answers to learn CS courses for online computer science degree. Spreadsheet programs MCQs with answers, spreadsheet program functions quiz questions and answers for information technology programs online. Learn spreadsheet programs basics, spreadsheet program cells, spreadsheet program functions test prep for IT certifications.

Learn spreadsheet programs test MCQs: in a computer spreadsheet, value of formula (7-3)x(1+6)/4 is, with choices 7, 1.5, 2, and 12 for information technology programs online. Practice merit scholarships assessment test, online learning spreadsheet program functions quiz questions for competitive assessment in computer science major .

MCQ on Spreadsheet Program Functions Quiz Book Download

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

  1. 7
  2. 1.5
  3. 2
  4. 12

A

MCQ: In a computer spreadsheet, first part of number format describes

  1. positive number
  2. negative number
  3. zero values
  4. text values

A

MCQ: In a computer spreadsheet, formula that equates to 6 is

  1. 9-2x3+4/2
  2. 1+2x3-8/2
  3. 8-2x3+8/2
  4. 2x3-4/2

C

MCQ: In a computer spreadsheet, cell range A3 through G3 should be keyed in as

  1. A3-G3
  2. A3:G3
  3. A3?.G3
  4. A3 to G3

B

MCQ: In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of

  1. calculations
  2. formulas
  3. functions
  4. relative addressing

C