Get Stronger: Microsoft Excel Basic Skills

1. What is the first step to create a new workbook in Excel?

A) Open the File menu and select Open
B) Open the File menu and select New
C) Open the Home menu and select New Workbook
D) Right-click on the desktop and select New Workbook

2. Which key can be used to quickly move to the next cell after entering data?

A) Enter
B) Tab
C) Arrow keys
D) All of the above

3. How can you adjust the width of a column to fit the content?

A) Double-click the right boundary of the column header
B) Right-click the column header and select AutoFit
C) Drag the right boundary of the column header
D) Both A and C

4. What feature in Excel can be used to apply a predefined set of formatting options to a table?

A) Conditional Formatting
B) Table Styles
C) Cell Styles
D) Format Painter

5. Which tab contains the Cell Styles feature in Excel?

A) Home
B) Insert
C) Page Layout
D) Formulas

6. Which of the following is NOT a cell format option in Excel?

A) Number
B) Alignment
C) Font
D) Margin

7. What does applying the Comma Style to a cell do?

A) Adds a comma at the end of the text
B) Formats the number with a thousands separator
C) Changes the cell color to red
D) Rounds the number to the nearest whole number

8. How can you quickly start a new blank workbook?

A) Press Ctrl + N
B) Click on the Open button
C) Click on the Save button
D) Right-click and select New

9. What is the file extension for an Excel workbook?

A) .docx
B) .xlsx
C) .pptx
D) .txt

10. What action should you take if the data entered into a cell exceeds the column width?

A) Ignore it
B) Delete the cell
C) Adjust the column width
D) Adjust the row height