WorksheetsExcel Formatting Quiz - Dr. Yu - 1/23/19
Total questions: 25
Worksheet time: 17mins
Which item on the Excel screenshot, when you click on it, will allow you to easily rename a file?
A
B
C
none
What happens if you double click the line between columns B and C?
Column B will automatically widen to accommodate the largest cell in the column
Column C will automatically widen to accommodate the largest cell in the column
Column B automatically shrinks down to the default size
Column C automatically shrinks down to the default size
Item B on the Excel screenshot refers to:
The ribbon
The waffle
The waffle
The tab
What does the presence of item E refer to?
The top row has been frozen so it will not scroll off of the screen
The top column has been frozen so it will not scroll off of the screen
It's an extra line for no good reason
I don't see an extra line
What is item C called?
Formula bar
Cell
Column
Row
What is the address of item G?
B8
8B
B4
C3
What do I have to do to create a new spreadsheet?
Press the button in Item K
Doubleclick on Item C
Right-click on Item J
None of the above
If I click on item D, what happens?
The entire column is selected
The entire row is selected
Item B1 is selected
Item B7 is selected
Let's say I click on item F, then change the font color to red. What will the ultimate result be?
All of the cells' contents in row 8 will be red.
All of the cells' contents in column B will be red
Just the content in B8 will be red
The content in cell A8 will be red.
Identify the range for the data shown in the screenshot
A1:B7
1A to 7B
A1 to B7
A1, B7
What website do you go to in order to submit your Excel formatting activity?
FOCUS
Email it to Dr. Yu
Print it out and put it in Dr. Yu's box
Share it to Dr. Yu
In this screenshot, what is the type of chart displayed?
column
pie
scatter
plot
On this chart, the blue bars indicate:
the number of instances each snack was selected
types of snacks available
the meaning of life
which snack had the most carbohydrates
Which option do I select to change the x-axis title?
B
A
C
D
E
The title of charts in Excel pulls content in from where?
The top row labels
It assumes the title is something different
The column B content
Other spreadsheets
What is one of the formulas we practiced in class?
Averaging a row of ages
Sum of the votes for pizza
Nothing
Sum the votes of burgers
In this screenshot, what is the alignment of the cell containing the words "After school snacks?"
Centered and middle
Left and bottom
Right and upper
Bottom and right
What is the alignment of the cell containing the text "Number of students"?
centered, bottom
centered
right-aligned
left-aligned
What is the content in A5?
pizza
burgers
cotton candy
buckeyes
True/False: You can turn in late bellringers now.
False
True
What is the correct file extension for Excel documents?
.xlsx
.docx
.pptx
.html
