Question 1

A worksheet contains all of the following EXCEPT ________.

Accepted Answer

It cannot be a worksheet if it is the worksheet itself.

Question 2

A worksheet is made up of rows and columns.

Accepted Answer

A worksheet is indeed made up of rows and columns, which create a grid-like structure for organizing and presenting data.

Question 3

Which of the following represents a cell range?

Accepted Answer

A cell range is a group of cells that are adjacent to each other. In this case, N8:P9 is a cell range that includes the cells N8, O8, P8, N9, O9, and P9.

Question 4

A worksheet is a spreadsheet contained in a workbook.

Accepted Answer

A worksheet is a single spreadsheet contained within a workbook, which can contain multiple worksheets.

Question 5

Which of the following is FALSE?

Accepted Answer

White space can refer to any empty or blank area in a document, regardless of the actual color displayed. It is not necessarily always white.

Question 6

Text that is too lengthy to fit in one cell can have text wrapping applied,or the user can add a ________ to break up the data inside a cell.

Accepted Answer

To break up the data inside a cell, the user can add a hard return (also known as a line break) by pressing the "Enter" or "Return" key. This will move the remaining text to a new line within the same cell, rather than expanding the height of the cell or overlapping with neighboring cells.

Question 7

Which of the following is an example of portrait dimensions?

Accepted Answer

Portrait dimensions refer to a layout where the height is greater than the width, as seen in option A (8.5 inches wide by 11 inches tall).

Question 8

AutoFill allows users to ________ using the fill handle.

Accepted Answer

AutoFill allows users to copy information from one cell or a series of cells into another set of cells using the fill handle. It does not allow users to delete formulas, move content from one cell to another or copy information to the office clipboard.

Question 9

A group of selected cells is also known as a cell ________.

Accepted Answer

A group of selected cells is known as a cell range. This term refers to a group of adjacent cells or a block of cells that are selected together for performing particular operations or calculations. While "cluster" and "block" could be used informally to refer to a group of cells, "range" is the correct term commonly used in spreadsheet software. "Field" typically refers to a single data point within a record or row, rather than a group of cells.

Question 10

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

Accepted Answer

This statement is true. The point where a row and column meet is called a cell in a table or grid system.

Question 11

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

Accepted Answer

Cells in Microsoft Excel can contain a variety of data types, including text, numbers, formulas, and functions. Therefore, the statement is true.

Question 12

R4:T8 is an example of a ________.

Accepted Answer

R4:T8 represents a range of cells from row 4 to row 8 across columns R to T.

Question 13

In order to see what a worksheet will look like when printed,use the Print ________ feature.

Accepted Answer

Preview allows you to see a preview of the worksheet as it will appear when printed, including any formatting and layout adjustments made in the Page Setup option.

Question 14

A workbook must contain at least three worksheets.

Accepted Answer

A workbook in Excel starts with one worksheet, and users can add more worksheets according to their needs. There is no minimum requirement of having at least three worksheets.

Question 15

Which of the following statements is FALSE?

Accepted Answer

Portrait orientation means a page is taller than it is wide.

Question 16

Excel includes common functions such as SUM and AVERAGE.

Accepted Answer

Excel does include common functions such as SUM and AVERAGE, among many others.

Question 17

Printable characters,including letters,numbers,and special characters,are stored as ________ data.

Accepted Answer

Printable characters are commonly used in text data such as letters, numbers, punctuation marks, and symbols. Therefore, printable characters are stored as text data.

Question 18

Worksheet navigation is defined as moving the location of the active ________.

Accepted Answer

Worksheet navigation refers to the movement of the active cell within the worksheet. Therefore, the best choice is B - cell.

Question 19

A worksheet that is not currently visible can be changed to the ________ worksheet by clicking on the worksheet tab in the bottom-left corner of the Excel window.

Accepted Answer

The active worksheet is the worksheet that is currently visible and has the focus. Clicking on a worksheet tab in the bottom-left corner of the Excel window will switch the focus to that worksheet, making it the active worksheet. Therefore, the answer is D, active.

Question 20

A spreadsheet is a computer program.

Accepted Answer

A spreadsheet is a computer program used to organize, analyze, and manipulate data in a tabular format.

Quiz 9: Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010