Spreadsheet Modeling with complete
updated solutions 2023-2024
Excel is an electronic version of a(n) ____. - AnswersSpreadsheet
Excel stores its documents as files called ____. - AnswersWorkbooks
The contents of an active cell are displayed in the ____. - AnswersFormula bar
The name given to an Excel workbook before you rename it is ____. - AnswersBook1
By default, an Excel workbook is made up of ____ worksheets. - AnswersThree
Row headings identify each row using a different ____. - AnswersNumber
The intersection of a row and column is known as a ____. - AnswersCell
To go to column A of the current row, click ____. - AnswersHome
To make A1 the active cell, you should press which of the following keys? - AnswersCtrl +Home
To complete a cell entry, press the ____ key. - AnswersEnter
, The characters +, -, *, and / are examples of ____. - AnswersArithmetic Operators
An Excel formula always begins with a(n) ____. - AnswersEquals Sign
The formula used to multiply cell A1 by cell C1 is ____. - AnswersA1*C1
To divide the value of a cell by some number, use the ____ operator. - Answers/
A(n) ____ is a group of cells. - AnswersRange
To view formulas, rather than the resulting values in a worksheet, switch to ____. - AnswersFormula
View
To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other
adjacent ranges. - AnswersCtrl
To select a large range of cells, click the first cell in the range, press and hold ____, and then click the
last cell in the range. - AnswersShift
What is the result of the expression =50/(10*5)? - Answers1
Excel makes reading formulas simpler by ____ each cell reference in the formula and its
corresponding cell in the worksheet. - Answerscolor coding
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. - AnswersAutoFit
Which of the following takes precedence over multiplication? - AnswersExponentiation
In ____ orientation, a page is taller than it is wide. - Answersportrait
According to the order of precedence in Excel: - AnswersExcel performs exponentiation, then
multiplication and division, then addition and subtraction.
updated solutions 2023-2024
Excel is an electronic version of a(n) ____. - AnswersSpreadsheet
Excel stores its documents as files called ____. - AnswersWorkbooks
The contents of an active cell are displayed in the ____. - AnswersFormula bar
The name given to an Excel workbook before you rename it is ____. - AnswersBook1
By default, an Excel workbook is made up of ____ worksheets. - AnswersThree
Row headings identify each row using a different ____. - AnswersNumber
The intersection of a row and column is known as a ____. - AnswersCell
To go to column A of the current row, click ____. - AnswersHome
To make A1 the active cell, you should press which of the following keys? - AnswersCtrl +Home
To complete a cell entry, press the ____ key. - AnswersEnter
, The characters +, -, *, and / are examples of ____. - AnswersArithmetic Operators
An Excel formula always begins with a(n) ____. - AnswersEquals Sign
The formula used to multiply cell A1 by cell C1 is ____. - AnswersA1*C1
To divide the value of a cell by some number, use the ____ operator. - Answers/
A(n) ____ is a group of cells. - AnswersRange
To view formulas, rather than the resulting values in a worksheet, switch to ____. - AnswersFormula
View
To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other
adjacent ranges. - AnswersCtrl
To select a large range of cells, click the first cell in the range, press and hold ____, and then click the
last cell in the range. - AnswersShift
What is the result of the expression =50/(10*5)? - Answers1
Excel makes reading formulas simpler by ____ each cell reference in the formula and its
corresponding cell in the worksheet. - Answerscolor coding
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. - AnswersAutoFit
Which of the following takes precedence over multiplication? - AnswersExponentiation
In ____ orientation, a page is taller than it is wide. - Answersportrait
According to the order of precedence in Excel: - AnswersExcel performs exponentiation, then
multiplication and division, then addition and subtraction.