Question 1

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon.

Accepted Answer

A ScreenTip is a box with descriptive text that appears when you point to a button on the ribbon.

Question 2

In the formula, =2+6*2, addition would be calculated after multiplication. _________________________

Accepted Answer

This is because multiplication has a higher priority than addition in the order of operations. Therefore, 6*2 will be calculated first, resulting in 12. Then, the addition of 2 to 12 will equal 14.

Question 3

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Accepted Answer

False

Question 4

An adjacent range is a collection of separate ranges.

Accepted Answer

The answer of An adjacent range is a collection of...

Question 5

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. _________________________

Accepted Answer

Yes, it is a common business practice to include a Documentation worksheet in a workbook.

Question 6

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.

Accepted Answer

AutoFit adjusts the column width or row height to fit the longest or tallest entry within the column or row.

Question 7

Numeric data is any number that can be used in a mathematical calculation.

Accepted Answer

Numeric data includes any numbers that can be used in a mathematical calculation, such as integers, decimals, fractions, and percentages.

Question 8

Normal view shows how the worksheet will appear when printed. _________________________

Accepted Answer

Page Layout

Question 9

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell. _________________________

Accepted Answer

operators

Question 10

The AutoComplete feature automatically completes an entry based on previous entries in a column.

Accepted Answer

The AutoComplete feature is designed to automatically complete an entry based on previous entries in a column, making it easier and faster to enter data into a spreadsheet.

Question 11

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. _________________________

Accepted Answer

height

Question 12

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command. _________________________

Accepted Answer

This statement is true. Keyboard shortcuts are commonly used to improve productivity and efficiency when using a computer or software.

Question 13

Cutting moves the selected content, whereas copying duplicates the selected content. _________________________

Accepted Answer

Cutting removes the content from its original location and moves it to another location, while copying creates a duplicate of the content in a new location, leaving the original content unchanged.

Question 14

Speed Fill enters text based on patterns it finds in the data.

Accepted Answer

The answer of Speed Fill enters text based on patterns...

Question 15

The formula bar displays the value or formula of the active cell.

Accepted Answer

The statement is true. The formula bar is located above the worksheet area and it displays the value or formula of the selected or active cell.

Question 16

The worksheet is organized into individual cells.

Accepted Answer

Worksheets are indeed organized into individual cells that can contain data, formulas or functions.

Question 17

The name of the active workbook appears in the status bar of the Excel window.

Accepted Answer

The answer of The name of the active workbook appears...

Question 18

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points. _________________________

Accepted Answer

pixels

Question 19

Every function follows a set of rules, or syntax, which specifies how the function should be written. _________________________

Accepted Answer

Every function has specific syntax rules that must be followed for it to work properly.

Question 20

When text wraps within a cell, the column width increases so that all of the text within the cell is displayed. _________________________

Accepted Answer

row height

Quiz 6: Getting Started With Excel