BCIS 2610 TEST PAPER 2026/2027 QUESTIONS AND
SOLUTIONS RATED A+
✔✔____ is a system that maintains a safe driving interval between your car and other
vehicles by changing the gears or by applying the brakes. - ✔✔adaptive cruise control
(ACC)
✔✔The ____ oversees all air traffic control in the United States. - ✔✔Air Traffic Control
System Command Center (ATSCC)
✔✔Who completes the preflight routine, which includes transmitting a flight plan to the
air traffic control tower? - ✔✔the pilot
✔✔What is the purpose of a global distribution system (GDS)? - ✔✔maintain a
database to provide travel providers and consumers information about available flights
and seats and to manage inventory.
✔✔A(n) ____ helps train airline pilots by modeling the experience of being inside the
cockpit of a plane. - ✔✔flight simulator
✔✔A ____________ is a collection of text and numbers laid out in a rectangular grid -
✔✔spreadsheet
✔✔You press the ____________ key to display the Key tips, which are labels that
appear over each tab and command on the ribbon - ✔✔Alt
✔✔In spreadsheet terms, a(n) _____ contains an Excel chart that provides a visual
representation of spreadsheet data. - ✔✔Chart Sheet
✔✔On the ribbon, click the ____________ tab to display Backstage view - ✔✔FILE
✔✔A _____________ reminds you why you created a workbook and what it contains. -
✔✔documentation sheet
✔✔Each cell is identified by a(n) _____, which is based on the cell's column and row
location. - ✔✔cell reference
✔✔What does a green triangle in a cell indicate? - ✔✔A potential error
✔✔______ changes the column width or row height to display the longest or tallest
entry within the column or row - ✔✔AutoFit
✔✔To enter additional lines in a cell, press the ____________. - ✔✔Alt+Enter keys
, ✔✔A ______ is a single point on a computer monitor or printout - ✔✔Pixels
✔✔What is the default column width - ✔✔8.38 standard-sized characters— about 8 or 9
characters
✔✔True/False: If you increase the font size of characters, you can fit more text within a
given cell. - ✔✔False
✔✔To select adjacent ranges, hold down the ___________ key and then select the
range - ✔✔Shift
✔✔True/False: To deselect a range, click in the selected range again. - ✔✔False
✔✔A(n) _____ is a mathematical expression that calculates a value - ✔✔Formula
✔✔True/False: A worksheet can contain the following type of data: text, numeric values,
dates, and calculated values - ✔✔True
✔✔The _____ calculates the total number of values. - ✔✔COUNT
✔✔True/False: Functions are used to simplify formulas. - ✔✔True
✔✔New Excel workbooks contain how many worksheets? - ✔✔Three
✔✔True/False: Worksheets cannot be deleted - ✔✔False
✔✔To edit a cell's contents, you need to work in _____ - ✔✔editing mode
✔✔True/False: You can reverse more than one action by clicking on the Undo button's
list arrow - ✔✔True
✔✔When does Flash Fill work best? - ✔✔When the pattern is clearly recognized from
the values in the data
✔✔True/False: Flash Fill enters formulas, not text - ✔✔False
✔✔To toggle in and out of formula view, press the ________ keys. - ✔✔Ctrl+` keys.
The ` grave accent symbol is usually located above the Tab key on your keyboard
✔✔If you forget to put an = sign at the beginning of a formula, what will appear in the
cell? - ✔✔The actual data you entered, not the calculation
SOLUTIONS RATED A+
✔✔____ is a system that maintains a safe driving interval between your car and other
vehicles by changing the gears or by applying the brakes. - ✔✔adaptive cruise control
(ACC)
✔✔The ____ oversees all air traffic control in the United States. - ✔✔Air Traffic Control
System Command Center (ATSCC)
✔✔Who completes the preflight routine, which includes transmitting a flight plan to the
air traffic control tower? - ✔✔the pilot
✔✔What is the purpose of a global distribution system (GDS)? - ✔✔maintain a
database to provide travel providers and consumers information about available flights
and seats and to manage inventory.
✔✔A(n) ____ helps train airline pilots by modeling the experience of being inside the
cockpit of a plane. - ✔✔flight simulator
✔✔A ____________ is a collection of text and numbers laid out in a rectangular grid -
✔✔spreadsheet
✔✔You press the ____________ key to display the Key tips, which are labels that
appear over each tab and command on the ribbon - ✔✔Alt
✔✔In spreadsheet terms, a(n) _____ contains an Excel chart that provides a visual
representation of spreadsheet data. - ✔✔Chart Sheet
✔✔On the ribbon, click the ____________ tab to display Backstage view - ✔✔FILE
✔✔A _____________ reminds you why you created a workbook and what it contains. -
✔✔documentation sheet
✔✔Each cell is identified by a(n) _____, which is based on the cell's column and row
location. - ✔✔cell reference
✔✔What does a green triangle in a cell indicate? - ✔✔A potential error
✔✔______ changes the column width or row height to display the longest or tallest
entry within the column or row - ✔✔AutoFit
✔✔To enter additional lines in a cell, press the ____________. - ✔✔Alt+Enter keys
, ✔✔A ______ is a single point on a computer monitor or printout - ✔✔Pixels
✔✔What is the default column width - ✔✔8.38 standard-sized characters— about 8 or 9
characters
✔✔True/False: If you increase the font size of characters, you can fit more text within a
given cell. - ✔✔False
✔✔To select adjacent ranges, hold down the ___________ key and then select the
range - ✔✔Shift
✔✔True/False: To deselect a range, click in the selected range again. - ✔✔False
✔✔A(n) _____ is a mathematical expression that calculates a value - ✔✔Formula
✔✔True/False: A worksheet can contain the following type of data: text, numeric values,
dates, and calculated values - ✔✔True
✔✔The _____ calculates the total number of values. - ✔✔COUNT
✔✔True/False: Functions are used to simplify formulas. - ✔✔True
✔✔New Excel workbooks contain how many worksheets? - ✔✔Three
✔✔True/False: Worksheets cannot be deleted - ✔✔False
✔✔To edit a cell's contents, you need to work in _____ - ✔✔editing mode
✔✔True/False: You can reverse more than one action by clicking on the Undo button's
list arrow - ✔✔True
✔✔When does Flash Fill work best? - ✔✔When the pattern is clearly recognized from
the values in the data
✔✔True/False: Flash Fill enters formulas, not text - ✔✔False
✔✔To toggle in and out of formula view, press the ________ keys. - ✔✔Ctrl+` keys.
The ` grave accent symbol is usually located above the Tab key on your keyboard
✔✔If you forget to put an = sign at the beginning of a formula, what will appear in the
cell? - ✔✔The actual data you entered, not the calculation
