Digital Skills for Work Quiz 1

The area circled in red is called the "Zoom Slider". What does it do?

• Adjusts the font size

• Adjusts the size that the sheet appears on the screen

• Adjusts the size of the sheet when printing

The area circled in red is the name of the sheet. How can you change its name? (Choose all answers that are correct)

• Double Click on the sheet name

• Right Click and choose "Rename"

• File, Save As

• File, Save

Each sheet in an Excel workbook contains a 1000 rows

• True

• False - an Excel worksheet contains more than a million rows

• False - there is no limit to the amount of rows you can store in an Excel worksheet

What is this area of the screen called? (Choose all that apply)

• The Ribbon

• The QAT

• The Quick Access Toolbar

• The Formula Bar

What is this area of the screen called?

• The Formula Bar

• The Quick Access Toolbar

• The QAT

• The Ribbon

The area circled in red is the:

• Name of the Workbook

• Name of the Worksheet

Which is the correct format to use when entering a date into an Excel spreadsheet?

• 1/2/2024

• 1\2\2024

• 1.2.2024

Choose two ways in which you can prevent Excel from removing the leading zero from a telephone number:

• Format the cell as a number

• Precede the number with an apostrophe

• Format the cell as text

• Format the cell as a date

Which of these formats will display your data with a pound sign and two decimal places? (choose all that apply)

• The Text Format

• The Accounting Format

• The Currency Format

• The Number Format

The buttons circled in red are called Increase and Decrease Decimals. What do they do?

• Increase or decrease the number of decimal places visible in the selected cell(s)

• Round the number up or down

• Round the number to two decimal places