NEW
Font size
WorksheetsAES "Excel Skills Project" Unit 1 Quiz
Total questions: 24
Worksheet time: 24mins
Why would you add borders to cells?
To use space in the worksheet
To show how a formula is used
To group the cells
To align the columns and rows
How can you make a large amount of text visible in a cell without changing the width of the cell? Select the best answer.
Delete the text
Increase the cell height
Change the font style
Wrap the text.
Where would you click to add a fill color to a cell?
A
B
C
D
Which alignment option would you click to center the text in the middle of the selected cell?
A
B
C
D
Where would you click in the drop-down menu to change the border tool from a solid to a dashed line?
A
B
C
D
If a cell has a DARK fill color, then the text color should be:
A DARK color to create contrast
A LIGHT color to create contrast
A LIGHT color to keep the same look and feel
A DARK color to keep the same look and feel
Which tab would you click to find the command for importing data from a text file?
A
B
C
D
Which tab would you click to find the command that changes the page orientation?
A
B
C
D
Which image shows a landscape orientation?
A
B
Which page orientation displays more worksheet rows?
Portrait
Landscape
Which Page View shows where the worksheet is split into separate pages for printing?
Page Layout
Normal
Page Break Preview
Which command would you click to remove the decimal place from the currency in the selected cells?
A
B
C
D
If you choose a "Thick Bottom Border" for the selected cells, which option shows how the border would appear in the cells?
A
B
C
What is the delimiter for the data shown in the image?
Comma
Semicolon
Tab
Space
How can you rename a worksheet?
Use the "Save As" command
A worksheet cannot be renamed
Double-click the worksheet tab.
Right-click the first cell in the worksheet
Where is the "Merge & Center" command on the ribbon?
A
B
C
D
What is the delimiter for the data shown in the image?
Comma
Semicolon
Tab
Space
Where would you click and drag to change the width of column B so the data in cell B6 is visible?
A
B
C
D
Which of the following files can be used to import data into Excel?
Movie file
Audio file
Image file
Text file
Which border option(s) can be selected before drawing a border?
Fill Color
Line Color
Line Style
Both Fill & Line Color
Both Line Color & Style
Which menu item would you click to access the "wrap text" feature for the selected cells?
A
B
C
D
Which column needs to be expanded to make the data in the spreadsheet easier to read?
Column A only
Column B only
Column C only
Columns A and B
Columns B and C
Based on the alignment selections, which option correctly shows how the content would appear in the cells?
A
B
C
Which Page View shows how a worksheet will appear on a printout?
Page Break Preview
Page Layout
Normal
