Excel 1
What is the name of an Excel Document?
What is the name of a page or tab in Excel?
A worksheet
Numbers
What symbol designates the columns?
Letters
True or False. A cell you are actively working in is surrounded by a border.
True
What button do you select to add together a list of numbers?
The Sum Button
On the home ribbon, what do you use to change the text color of characters in a cell?
The Font Color Drop Down List
On the home ribbon, what do you use to change the cell color?
The theme color drop down list
Excel is most widely used for
a. accounting
b. word processing
c. photo editing
d. video editing
a. accounting
True or False. You cannot export your Excel document as a PDF.
False
What is the area that shows a reference of the active cell?
The Formula Bar
How can you add a column?
Highlight the column, right click, and select insert.
In the web version of Excel, what is the feature that allows you to view the previous state of your spreadsheet?
List 3 different types of charts that you can create in Excel.
Bar/Column
Line/Area
Scatter/Bubble
Pie/Doughnut
Waterfall/Funnel/Stock/Surface/Radar
Hierarchy
Statistic
Combo
What are the predesigned workbooks called and where can they be found?
Templates can be found in the Backstage View
Column B in a spreadsheet contains Frank's grocery costs by month. Which formatting would be most appropriate for the data in Column B.
Currency
Kenny notices that the last two lines of text in cell C8 are not showing up in his spreadsheet. What are two different ways Kenny could format the cell to correct this problem?
1. The Wrap Text Button
2. Expanding the Width of the Cell
Miranda notices that the data in cell E4 reads #####. What command could she use to correct this problem?
AutoFit
The Web version through Outlook
What key shortcut can you use to Find something in a document?
Ctrl F
What workbook view do you select to determine the area that is included on each page when your document is printed?
The Page Break View Button
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
Merge and Center
Rodney created a column on his spreadsheet that tracks items sold versus items not sold. Which feature can he use to view only the items sold?
Filter
What steps do you follow to send your Excel Sheet to someone via email?
Select File, Select Share, Select Attach as an Excel Workbook OR Attach as a PDF
True or False. The Web Outlook version of Excel may show your Excel Workbooks and any Excel Workbooks that may have been emailed to you.