Excel Formatting

How can you adjust the row height in a spreadsheet?

• Drag your mouse horizontally between the letters at the top of the columns.

• Drag your mouse vertically between the numbers at the left of the rows.

• Right-click on the top of the sheet and choose Column Width.

• Double-click on any cell in the row.

Where do you find the Borders option in a spreadsheet application?

• Insert Tab > Font Group

• Home Tab > Font Group

• Page Layout Tab > Font Group

• Formulas Tab > Font Group

Which of the following is a correct method to insert a cell in a row?

• Right click, Delete, Shift cells up

• Right click, Insert, Shift cells right

• Right click, Insert, Shift cells left

• Right click, Delete, Shift cells down

What happens when you choose "Shift cells up" while deleting a cell?

• Cells move to the right

• Cells move to the left

• Cells move upwards

• Cells move downwards

Where can you find the "Wrap Text" option in spreadsheet software?

• Insert Tab

• Home Tab

• View Tab

• Data Tab

What happens to the text in a cell when "Wrap Text" is applied?

• It is deleted

• It is hidden

• It is wrapped to fit within the cell

• It is moved to another cell

How is the number 0.12 displayed in Percentage format?

• 12%

• 0.12%

• 120%

• 1.2%

Which number format would display 1200 as 1200.00?

• General

• Number

• Text

• Currency

What is the effect of clicking the decrease decimal places icon?

• Decreases the number of decimal places

• Increases the number of decimal places

• Adds a percentage symbol

• Converts to currency

Which icon is used to increase decimal places?

• Icon with two zeros and an arrow pointing right

• Dollar sign

• Percentage sign

• Comma