NEW
Font size
WorksheetsQuiz 3 (Special Quiz in ICT 1)
Total questions: 27
Worksheet time: 14mins
What is the default font in a new Excel workbook?
Times New Roman
Arial
Calibri
Century Gothic
To increase the font size of a cell's content, where can you find the **Font Size command**?
Insert tab
Home tab
View tab
Page Layout tab
What shortcut can be used to apply bold formatting to a selected cell?
Ctrl+U
Ctrl+B
Ctrl+I
Ctrl+E
What does the **Format Painter** command do?
Aligns text in the center
Copies formatting from one cell to another
Changes font size and color
Applies predesigned cell styles
Which of the following is NOT a standard reading font mentioned in the material?
Calibri
Times New Roman
Comic Sans
Cambria
To add a border to a cell, you need to use:
Fill Color command
Borders command
Format Painter
Font Size drop-down
Which alignment option moves text to the top border of a cell?
Bottom Align
Center Align
Middle Align
Top Align
In the example from the material, which font color was chosen to ensure text was readable against a dark gray fill color?
Bright green
Bright pink
White
Dark blue
Where can you find the Number Format drop-down menu in Excel?
Insert tab
Home tab
Page Layout tab
Data tab
Which keyboard shortcut opens the Format Cells dialog box?
Ctrl+1
Ctrl+2
Ctrl+N
Ctrl+F
How does a spreadsheet interpret "March 15th"?
As a date with the current year
As plain text
As a percentage value
As a decimal
Which command would you use to show fewer decimal places in a value?
Number Format
Decrease Decimal
Currency Format
Increase Decimal
What type of format should you apply to store data like phone numbers or zip codes?
Number format
General format
Text format
Currency format
Which of the following will automatically be recognized as a date by a spreadsheet?
October 12th
10/12
2016
All of the above
Which number format is best for values like "02415"?
General
Text
Currency
Percentage
What does the Format Cells dialog box allow you to do with dates?
Delete the year from the date
Change the actual date value in the cell
Choose different display styles, like including the day of the week
Convert dates into percentages
How do you insert a new worksheet in Excel?
Right-click any worksheet tab and select "New Worksheet."
Click the New sheet button near the bottom-right corner of the window.
Use the "Insert" tab on the Ribbon.
Double-click the workbook title.
What must you check in the **Move or Copy** dialog box to duplicate a worksheet?
"Move to end"
"Create a copy"
"Protect sheet"
"Tab Color"
When renaming a worksheet, how do you confirm the name change?
Press Enter.
Click outside the tab.
Either a or b.
Right-click the tab and select "Save Name."
How can you move a worksheet within the same workbook?
Use the **Move or Copy** dialog box.
Drag and drop the worksheet tab to the desired location.
Use the "Insert" tab in the Ribbon.
Both a and b.
What happens to the visibility of a worksheet's tab color when it is selected?
It becomes bold.
It is highlighted with a glowing effect.
The color becomes less noticeable.
The color changes to white.
What is the purpose of grouping worksheets?
To save storage space in the workbook
To apply the same changes to multiple worksheets at once
To prevent the deletion of grouped sheets
To create linked data between worksheets
How can you quickly switch to a worksheet when working in a large workbook?
Use the scroll arrows in the lower-left corner.
Right-click the scroll arrows to see a list of all worksheets.
Use the **Move or Copy** dialog box.
Both a and b.
Which key do you press while selecting worksheets to group them?
Alt
Shift
Ctrl
Tab
How do you ungroup worksheets?
Right-click a worksheet tab in the group and select **Ungroup Sheets.**
Click a worksheet outside of the group.
Both a and b.
Double-click the grouped worksheet tab.
What is a quick way to protect a worksheet from being edited or deleted?
Apply a password to the workbook.
Right-click the worksheet tab and select **Protect Sheet.**
Group the worksheet with others.
Lock the entire workbook from Backstage view.
Which of the following is true about the Currency number format?
a. It always shows three decimal places.
b. It adds currency symbols and displays two decimal places by default.
c. It cannot be applied to an entire column.
d. It removes the value in the formula bar.
