Module 2 - Lesson 1 Recap

What is the maximum number of columns and rows in MS Excel®?

• 16,483 columns and 1,004,576 rows

• 16,384 columns and 1,044,567 rows

• 16,384 columns and 1,048,576 rows

• 16,388 columns and 1,048,566 rows

The ________ displays the address of the "active cell" on the worksheet.

• Formula Bar

• Name box

• Quick Access Toolbar

• Workbook Name

What is the default alignment if the entered data in a cell is a text/string?

• Right aligned

• Left aligned

• Center aligned

Below are the different approaches in entering data in MS Excel®, EXCEPT:

• Directly typing the data/information into the cell of the worksheet

• Highlighting the cells then press CTRL + Enter

• Selecting the cell then typing into the formula bar

• Using a Data Entry Form

__________ are small windows that pop up when you select or highlight certain cells.

Note: this applies when you point to a command to display the command’s function.

• Tooltips

• Input Message in Data Validation

• Error Alert

There are two ways of encoding a negative number in MS Excel®

• TRUE

• FALSE

This is the keyboard shortcut in editing the contents of a cell in MS Excel®

• Alt + Enter

• Ctrl + 9

• Ctrl + Shift + 9

• None of the above

Answer explanation

The correct answer is F2

This is the keyboard shortcut for unhide column using the ALT button

• Alt + houc

• Alt + huec

• Alt + hocu

• None of the above

Answer explanation

The correct shortcut is Alt + houl

________ is commonly used in data management specifically for cell content transfer, and formulas and functions.

• Ribbon Tabs

• Data Entry Form

• Transposing

• Referencing

Data validation in MS Excel® is the most secure and efficient way to ensure the correctness of data during data encoding.

• TRUE

• FALSE

Answer explanation

Data validation overrides when a cell without data validation is copy pasted.