6th Formatting Spreadsheets

How can you add emphasis to important information in a spreadsheet?

• By deleting unnecessary data

• By reducing the font size

• By moving it to the last row

• By adding color to the cells

What is the purpose of formatting cell data as currency?

• To make the spreadsheet look colorful

• To ensure mathematical operations are correct

• To increase the font size of the data

• To easily identify financial data

How can you organize data alphabetically in a spreadsheet?

• By adding borders to cells

• By using the alphabetical sort function

• By inserting new rows

• By using the summation function

What is the result of merging cells in a spreadsheet?

• It sorts the data numerically

• It creates a larger cell by combining multiple cells

• It adds color to the merged cells

• It automatically formats the data as currency

Why would you insert rows in a spreadsheet?

• To add titles and organize the spreadsheet

• To change the color of the spreadsheet

• To merge cells across columns

• To sort the data numerically

Adding column headings allow for data to be easily read.

• True

• False

Centering the title across your data makes your spreadsheet looks professional.

• True

• False

The icon shown represents which alignment?

• Right

• Left

• Centre

• Justified

Before editing data in a spreadsheet, what first must be done?

• Highlight the cells

• Block the cells

• Add the cells

• Delete the cells

Which of the following best describes descending order sort?

• Data orders from A to Z

• Data orders from Z to A

• Data orders from left to right

• Data orders from right to left