Spreadsheet Program Functions MCQs & Quiz Online PDF Book Download

Spreadsheet program functions MCQs, spreadsheet program functions quiz answers to learn computer science courses online. Spreadsheet programs multiple choice questions (MCQs), spreadsheet program functions quiz questions and answers for online information technology degree. 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 online information technology degree. Practice assessment test for scholarships, online learning spreadsheet program functions quiz questions for competitive assessment in computer science major for computer technology certifications.

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