Quiz 2 (Chapter 4,5,6) ADT1A
Authored by Arnold Narte
Computers
University
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
35 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of applying number formats in a spreadsheet?
To change the font style
To improve the spreadsheet’s appearance only
To convert numbers into text
To specify the type of value in a cell
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which number format would you apply to display values like $10.00 or $35.50?
Percentage
Currency
Text
Date
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if you type "15%" into a spreadsheet cell?
It remains as text
It automatically converts to 0.15
The percentage format is applied
Nothing changes
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following entries will not be recognized as a date by default?
3/15/2024
March 15
March 15th
10/12
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What shortcut key opens the Format Cells dialog box for more number format options?
Ctrl + F
Ctrl + Alt + 1
Ctrl + 1
Alt + Shift + F
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What shortcut key opens the Format Cells dialog box for more number format options?
Ctrl + F
Ctrl + Alt + 1
Ctrl + 1
Alt + Shift + F
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which number format is ideal for data such as phone numbers or zip codes?
Currency
Text
Percentage
General
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
