Question 1

If you were to type the following into a cell, what would be the result in Excel?

Accepted Answer

B

Question 2

Spreadsheets can be used to

Accepted Answer

Spreadsheets can perform all of the functions listed in options A, B, and C, making D the correct choice.

Question 3

Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9?

Accepted Answer

The AVERAGE function is used to calculate the mean value of a range of cells in Excel. None of the other options (AVG, AVE, MEAN) are valid Excel functions for calculating the mean.

Question 4

The intersection of a single row and a single column is called a

Accepted Answer

The intersection of a single row and a single column in a spreadsheet is known as a cell.

Question 5

Which of the following Excel functions will correctly calculate the square root of the value in cell A1?

Accepted Answer

The SQRT function in Excel is used to calculate the square root of a given number. Therefore, the correct function to calculate the square root of the value in cell A1 is SQRT(A1). Option A, B, and C are not valid Excel functions.

Question 6

In a spreadsheet, rows are marked with letters (A, B, C, etc.) while columns are marked with numbers (1, 2, 3, etc.)

Accepted Answer

Rows are marked with numbers (1, 2, 3, etc.) while columns are marked with letters (A, B, C, etc.) in a spreadsheet.

Question 7

Active cell refers to a specific selected cell.

Accepted Answer

The active cell is the cell that is currently selected in a spreadsheet or worksheet. It is denoted by a bold outline around the cell.

Question 8

Which of the following is the correct entry for an absolute cell reference?

Accepted Answer

Absolute cell references are indicated with a dollar sign before the column letter and row number, such as $C$4, to indicate that the reference should not change when the formula is copied to other cells. The other options either use an asterisk, which is not a valid symbol for absolute references, or only partially show the absolute reference with a dollar sign in front of the column letter but not the row number.

Question 9

Which of the following is the correct entry for a relative cell reference?

Accepted Answer

A relative cell reference is indicated using only the column letter and row number, without any dollar signs or asterisks.

Question 10

What are the three ways that you can refer to a cell address in a formula?

Accepted Answer

The answer of What are the three ways that you...

Question 11

A worksheet is a spreadsheet file that you create and save whereas a workbook represents the rows and columns where you input information.

Accepted Answer

The statement is reversed. A workbook is a file that contains one or more worksheets. Each worksheet has its own rows and columns where you input information.

Question 12

In Excel, a formula always begins with

Accepted Answer

In Excel, a formula always begins with an equal sign (=) to indicate that what follows is a command or expression that needs to be evaluated by Excel.

Question 13

The mixed cell reference could be done in one of two ways: (1) You can keep the column as absolute (unchanged) and have a relative row, or (2) you can keep the row as absolute and have a relative column.

Accepted Answer

This is correct, as a mixed cell reference can have either the column or the row as absolute and the other as relative.

Question 14

If you were to type the following into a cell, what would be the result in Excel?

Accepted Answer

Excel will interpret the given string of characters as text and display the entire string in the cell. All of the characters are alphanumeric and do not correspond to any mathematical operations or functions in Excel.

Question 15

Which is the correct way to enter the following mathematical operation into Excel?

Accepted Answer

The order of operations in math is parentheses, exponents, multiplication/division (from left to right), and addition/subtraction (from left to right). Using this order, option C is the correct way to enter the mathematical operation into Excel as it groups the subtraction of 3 from 8 first, before dividing the result by 6, and then adds 2 to the result.

Question 16

Visual Basic for Applications (VBA) is a programming language that allows you to use Excel more effectively.

Accepted Answer

VBA allows users to create automated processes and customized functions in Excel, enhancing efficiency and productivity.

Question 17

A spreadsheet is divided into

Accepted Answer

A spreadsheet is divided into rows and columns, allowing for data to be organized and manipulated in a two-dimensional grid format. While there may be lines and spaces visible on the screen, these are not the fundamental divisions that define a spreadsheet. Inputs and outputs are related to the data being entered and extracted from the spreadsheet, rather than the structure of the sheet itself. Problems and solutions are not relevant to the organization of the sheet, but rather the task or analysis being performed using the data within the sheet.

Question 18

A number of cells that are selected simultaneously is called a

Accepted Answer

The term used for selecting multiple cells at the same time is called a range. A range is a selection of two or more cells on a worksheet that have been highlighted or selected. This is different from a group, which refers to a collection of objects that have been grouped together for formatting purposes in a program like Microsoft Word or PowerPoint. A multi-cell could also refer to a range, but it's not commonly used in this context. A cartel is a group of businesses or organizations that work together to control the supply and prices of a particular product or service, so it's not relevant to this question.

Question 19

In a spreadsheet, the _________ contains the name of the current active workbook.

Accepted Answer

The title bar is located at the top of the spreadsheet and displays the name of the current active workbook. The active cell refers to the current selected cell within the workbook. The column header refers to the lettered columns at the top of the spreadsheet, and the status bar usually displays information such as cell contents, formula results, and other information related to the spreadsheet.

Question 20

The Excel functions are grouped into various categories, including mathematical and trigonometric, engineering, statistical, financial, and logical functions.

Accepted Answer

This statement is true. Excel functions are grouped into various categories, including mathematical and trigonometric, engineering, statistical, financial, and logical functions.

Quiz 14: Computational Engineering Tools: Electronic Spreadsheets

If you were to type the following into a cell, what would be the result in Excel?

Spreadsheets can be used to

Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9?

The intersection of a single row and a single column is called a

Which of the following Excel functions will correctly calculate the square root of the value in cell A1?

In a spreadsheet, rows are marked with letters (A, B, C, etc.) while columns are marked with numbers (1, 2, 3, etc.)

Active cell refers to a specific selected cell.

Which of the following is the correct entry for an absolute cell reference?

Which of the following is the correct entry for a relative cell reference?

What are the three ways that you can refer to a cell address in a formula?

A worksheet is a spreadsheet file that you create and save whereas a workbook represents the rows and columns where you input information.

In Excel, a formula always begins with

The mixed cell reference could be done in one of two ways: (1) You can keep the column as absolute (unchanged) and have a relative row, or (2) you can keep the row as absolute and have a relative column.

If you were to type the following into a cell, what would be the result in Excel?

Which is the correct way to enter the following mathematical operation into Excel?

Visual Basic for Applications (VBA) is a programming language that allows you to use Excel more effectively.

A spreadsheet is divided into

A number of cells that are selected simultaneously is called a

In a spreadsheet, the _________ contains the name of the current active workbook.

The Excel functions are grouped into various categories, including mathematical and trigonometric, engineering, statistical, financial, and logical functions.