Question 1

Worksheet navigation refers to scrolling up and down (or left and right)in a worksheet using the scroll bar.

Accepted Answer

The answer of Worksheet navigation refers to scrolling up and...

Question 2

Changing values in spreadsheet cells to investigate the effects is known as what-if analysis.

Accepted Answer

Changing values in spreadsheet cells to investigate the effects is indeed known as what-if analysis.

Question 3

A cell can be made an active cell by clicking on it.

Accepted Answer

Clicking on a cell selects it and makes it the active cell.

Question 4

All formulas and functions must start with the equal sign (=).

Accepted Answer

All formulas and functions in Excel must start with the equal sign (=) in order for Excel to recognize them as such.

Question 5

A formula is a built-in program that performs common tasks.

Accepted Answer

A formula is an expression that calculates the value of a cell in spreadsheet software like Microsoft Excel or Google Sheets, rather than a built-in program.

Question 6

Rows are numbered in ascending sequence from top to bottom.

Accepted Answer

This is correct as rows are indeed usually numbered in ascending sequence from top to bottom.

Question 7

A spreadsheet is a computer program.

Accepted Answer

A spreadsheet is a type of software program that allows users to organize and analyze data in tabular form.

Question 8

The intersection of a row and column is called a cell.

Accepted Answer

This statement is true.

Question 9

Excel includes common functions such as SUM and AVERAGE.

Accepted Answer

Excel includes many common functions including SUM, AVERAGE, and others that perform various calculations and tasks.

Question 10

J42 is an example of a cell reference.

Accepted Answer

J42 is a specific cell in a spreadsheet, and its reference is used to refer to that cell in formulas and functions.

Question 11

Columns are lettered in descending sequence from left to right.

Accepted Answer

Columns in spreadsheets or tables are typically lettered in ascending sequence from left to right, starting with "A" for the first column, "B" for the second, and so on.

Question 12

Scrolling in a worksheet moves the active cell.

Accepted Answer

Scrolling in a worksheet does not move the active cell. It only changes the view of the worksheet.

Question 13

Cells can contain text, numbers, formulas, and/or functions.

Accepted Answer

Cells in a spreadsheet can contain different types of data such as text, numbers, formulas, and functions.

Question 14

The intersection of a row and column is known as a record.

Accepted Answer

The intersection of a row and column is known as a cell or a field. A record is a collection of related data fields or cells within a table or spreadsheet.

Question 15

A column can also be referred to as a record.

Accepted Answer

The answer of A column can also be referred to...

Question 16

Rows are represented by letters.

Accepted Answer

In spreadsheets such as Microsoft Excel and Google Sheets, rows are represented by numbers, while columns are represented by letters.

Question 17

A cell can also be referred to as a field.

Accepted Answer

In the context of databases or spreadsheets, a cell can indeed be referred to as a field, as both terms are used to describe a single piece of data or an area where data can be entered.

Question 18

There are more rows in an Excel spreadsheet than there are cells.

Accepted Answer

An Excel spreadsheet has more cells than rows because each row contains multiple cells.

Question 19

The intersection of row 1 and column Q is known as 1Q,

Accepted Answer

The answer of The intersection of row 1 and column...

Question 20

A new Excel workbook contains three worksheets, by default named Book1, Book2, and Book3.

Accepted Answer

A new Excel workbook contains three worksheets by default, but they are named Sheet1, Sheet2, and Sheet3, not Book1, Book2, and Book3.

Quiz 3: Microsoft Office