Question 1

Bottom Align is the default vertical alignment.

Accepted Answer

Bottom Align is indeed the default vertical alignment for text in most word processing software and design programs.

Question 2

It is relatively easy to copy Excel cells into other Office programs.

Accepted Answer

Excel cells can be easily copied and pasted into other Office programs like Word or PowerPoint.

Question 3

Right-clicking a column heading,then selecting Insert,will add a new column to the left of the current column.

Accepted Answer

When you right-click a column heading and select Insert, it will add a new column to the left of the current column.

Question 4

Using Alt + Enter is a text wrapping option.

Accepted Answer

Alt + Enter is used in many applications, such as Excel, to create a line break within a cell, effectively wrapping text to a new line within the same cell.

Question 5

You can select a range by using the Name Box.

Accepted Answer

This is true. You can select a range by typing its name into the Name Box at the top left corner of the worksheet.

Question 6

When cells are merged,the merged cell's address becomes the address of the range.

Accepted Answer

When cells are merged, the merged cell's address becomes the address of the top-left cell in the original range before merging.

Question 7

If you want to unmerge cells you click the Unmerge alignment option.

Accepted Answer

The answer of If you want to unmerge cells you...

Question 8

When you copy and paste a range the relative references do not change.

Accepted Answer

When you copy and paste a range in a spreadsheet, relative references adjust based on the new location to maintain the correct relationship with the data they refer to.

Question 9

You cannot hide column A or row 1 because they cannot be unhidden.

Accepted Answer

You can hide column A or row 1 in Excel, and they can be unhidden by selecting the columns or rows surrounding the hidden one and then choosing to unhide from the right-click context menu or the Home tab.

Question 10

You can move a range by using the cut and paste commands.

Accepted Answer

The cut command allows you to remove a range of cells and the paste command allows you to place them elsewhere. Therefore, you can use cut and paste to move a range of cells.

Question 11

Match between columns
                        Premises: Linked Picture
Picture
Paste
Paste Link
Values

Accepted Answer

The Answer of Changes if the content changes and A is...

Question 12

Match between columns
                        Premises: Page Down
End
Home
Ctrl + Home
Right arrow

Accepted Answer

The Answer of This does nothing by itself and Moves is...

Question 13

Match between columns
                        Premises: Formula bar
Status bar
Cancel
Zoom control
Enter

Accepted Answer

The Answer of Shows the contents of the active cell is...

Question 14

Match between columns
                        Premises: Home
File
View
Insert
Data

Accepted Answer

The Answer of Alt + N and Alt + A is...

Question 15

Match between columns
                        Premises: View controls
Page Layout view
Normal view
Sheet tab navigation
Page Break Preview

Accepted Answer

The Answer of Icons that let you change views and is...

Question 16

Match between columns
                        Premises: AutoComplete
Column heading
Enter icon
Auto Fill
Row heading

Accepted Answer

The Answer of The number in the cell reference "F4" is...

Question 17

Match between columns
                        Premises: Flash Fill
Accounting number format
Paste Special,Add
Currency number format
Transpose

Accepted Answer

The Answer of Puts the $ next to the leftmost is...

Question 18

Match between columns
                        Premises: Order of operations
Name Box
Pointing
Formula
Fill handle

Accepted Answer

The Answer of Displays the address of the active cell is...

Question 19

Match between columns
                        Premises: Zoom control
Cell
Sheet tab
Workbook
Worksheet

Accepted Answer

The Answer of The intersection of a column and a is...

Question 20

Match between columns
                        Premises: Range
Value
XFD
Text
Semi-selection

Accepted Answer

The Answer of A group of cells selected at the is...

Quiz 1: Introduction to Excel

Bottom Align is the default vertical alignment.

It is relatively easy to copy Excel cells into other Office programs.

Right-clicking a column heading,then selecting Insert,will add a new column to the left of the current column.

Using Alt + Enter is a text wrapping option.

You can select a range by using the Name Box.

When cells are merged,the merged cell's address becomes the address of the range.

If you want to unmerge cells you click the Unmerge alignment option.

When you copy and paste a range the relative references do not change.

You cannot hide column A or row 1 because they cannot be unhidden.

You can move a range by using the cut and paste commands.

Match the following Paste options with their description:

Match the following navigation shortcuts with their actions:

Match the following Excel Elements with their description or action:

Match the following Ribbon tabs with their keyboard shortcuts:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description: