Spreadsheet Formatting and Data Analysis

What is the default formatting for all cell content in Excel?

• Custom formatting

• Same formatting

• No formatting

• Conditional formatting

What is the default font for a new workbook in Excel?

• Arial

• Times New Roman

• Calibri

• Verdana

To change the font size in Excel, you can use the _______ Font Size command.

• Increase

• Decrease

• Both A and B

• Neither A nor B

Fill in the blank: To change the font in a spreadsheet, click on the _______ tab, then select the desired font from the drop-down menu.

• Insert

• Home

• View

• Data

Which of the following fonts is considered a standard reading font?

• A) Calibri

• B) Comic Sans

• C) Papyrus

• D) Wingdings

To change the font color in a workbook, you need to click on the _______ tab.

• Insert

• Home

• Review

• View

Fill in the blank: To access additional color options in the spreadsheet, select ______ at the bottom of the menu.

• More Colors

• Color Picker

• Advanced Colors

• Extra Colors

What is the purpose of the Bold, Italic, and Underline commands in a spreadsheet?

• To change the font size

• To change the font color

• To emphasize text

• To delete text.

What keyboard shortcut can you use to make text bold in a spreadsheet?

• A) Ctrl+B

• B) Ctrl+I

• C) Ctrl+U

• D) Ctrl+S

What is the first step to add a fill color to a cell in a spreadsheet?

• Select the cell(s) you want to modify.

• Click on the Home tab.

• Choose a font color.

• Save the document.