BIT 200 Module 1, Module 2 And
Module 3 Test Questions with Solved
Solutions 2025\2026 Updated.
Excel makes reading formulas simpler by ____ each cell reference in the formula and its
corresponding cell in the worksheet. - Answer Color Coding
The feature that changes the column width or row height to display longest or tallest entry
within the column or row - Answer AutoFit
To make A1 the active cell, you should press which of the following keys - Answer Control +
home
Normal view shows how the worksheet will appear when printed (T/F) - Answer False
To change the order of operations, enclose part of the formula in ____. - Answer parentheses
Which of the following takes precedence over multiplication? - Answer exponentiation
(PEMDAS)
To switch to ____ mode, you double-click the cell. - Answer Edit Mode
____ makes it easier to enter repetitive text in cells. - Answer Auto-Complete
What is the result of the expression =50+20/10*5? - Answer 60
Every function follows a set of rules, or syntax, which specifies how the function should be
written (T/F) - Answer True
When you insert a new row, the existing rows are shifted down and the new row has the same
WIDTH as the row above it (T/F) - Answer False
, To change a column width, you can click ____ on the Column submenu to make the column(s)
as wide as the longest entry of the cells in the column. - Answer Auto-Fit
____ enters text based on patterns it finds in the data. - Answer Flash Fill
In the formula, =2+6*2, addition would be calculated after multiplication (T/F) - Answer True
displays the location of the different page breaks within the worksheet - Answer Page Break
Preview
mm/dd/yyyy - Answer Date Format
The formula used to multiply cell A1 by cell C1 is - Answer =A1*C1
According to the order of operation in Excel: - Answer Excel performs exponentiation, then
multiplication and division, then addition, and subtraction.
Each range is identified with a range reference that includes the cell reference of the upper-left
cell of the rectangular block and the cell reference of the lower-right cell separated by a ___ -
Answer Colon
What is the syntax for a SUM formula adding the values of cell F6 to F9? - Answer
=SUM(F6:F9)
In ____ orientation, a page is taller than it is wide. - Answer portrait
An Excel formula always begins with a(n) ____ - Answer equals sign
Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the
workbook file is updated to reflect the latest content. - Answer Ctrl + S
By default, numbers appear in the _____ and generally display values exactly as you type them.
- Answer General format
Module 3 Test Questions with Solved
Solutions 2025\2026 Updated.
Excel makes reading formulas simpler by ____ each cell reference in the formula and its
corresponding cell in the worksheet. - Answer Color Coding
The feature that changes the column width or row height to display longest or tallest entry
within the column or row - Answer AutoFit
To make A1 the active cell, you should press which of the following keys - Answer Control +
home
Normal view shows how the worksheet will appear when printed (T/F) - Answer False
To change the order of operations, enclose part of the formula in ____. - Answer parentheses
Which of the following takes precedence over multiplication? - Answer exponentiation
(PEMDAS)
To switch to ____ mode, you double-click the cell. - Answer Edit Mode
____ makes it easier to enter repetitive text in cells. - Answer Auto-Complete
What is the result of the expression =50+20/10*5? - Answer 60
Every function follows a set of rules, or syntax, which specifies how the function should be
written (T/F) - Answer True
When you insert a new row, the existing rows are shifted down and the new row has the same
WIDTH as the row above it (T/F) - Answer False
, To change a column width, you can click ____ on the Column submenu to make the column(s)
as wide as the longest entry of the cells in the column. - Answer Auto-Fit
____ enters text based on patterns it finds in the data. - Answer Flash Fill
In the formula, =2+6*2, addition would be calculated after multiplication (T/F) - Answer True
displays the location of the different page breaks within the worksheet - Answer Page Break
Preview
mm/dd/yyyy - Answer Date Format
The formula used to multiply cell A1 by cell C1 is - Answer =A1*C1
According to the order of operation in Excel: - Answer Excel performs exponentiation, then
multiplication and division, then addition, and subtraction.
Each range is identified with a range reference that includes the cell reference of the upper-left
cell of the rectangular block and the cell reference of the lower-right cell separated by a ___ -
Answer Colon
What is the syntax for a SUM formula adding the values of cell F6 to F9? - Answer
=SUM(F6:F9)
In ____ orientation, a page is taller than it is wide. - Answer portrait
An Excel formula always begins with a(n) ____ - Answer equals sign
Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the
workbook file is updated to reflect the latest content. - Answer Ctrl + S
By default, numbers appear in the _____ and generally display values exactly as you type them.
- Answer General format
