Excel 1
What is the name of an Excel Document?
What is the name of a page or tab in Excel?
A worksheet
What Heading designate the rows?
Numbers
What Heading designates the columns?
Letters
True or False. A cell you are actively working in is surrounded by a border.
True
What Formula do you select to add together a list of numbers?
Sum
On the home ribbon, what do you use to change the text color?
The Font
On the home ribbon, what do you use to change the height or width of a cell?
The Format tab
Excel is most widely used for
a. accounting
b. word processing
c. photo editing
d. video editing
a. accounting
What allows you to copy cell formats from one cell to another?
Format Painter
What is the area that shows a what is in the active cell?
The Formula Bar
How do you add a column?
Highlight the column, right click, and select insert.
The intersection of a row and column is called a ____.
Cell
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
What is an example of a Range address
A. A1:B3
B. A1-B3
C. A1;B3
D. A1=B3
A. A1:B3
What is the extension of saved file in MS Excel?
.xls
Miranda notices that the data in cell E4 reads #####. What command could she use to correct this problem?
AutoFit
True/False. If you choose a larger font size, the height of the row is automatically made taller.
False
What key shortcut can you use to Find something in a document?
Ctrl F
What value would Excel return for this formula?
=(82-32)/5+8*2
26
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
Merge and Center
How do you Hide and unhide rows or columns?
Select the rows/columns that need to be hidden, right click, and select Hide.
To unhide you will need to select the Headings before and after the rows/columns you have hidden, right click, select unhide.
What steps do you follow to save your Excel Sheet ?
Select File, Select Save As, One Drive
Which of the following is an absolute cell reference?
A. $A$2
B. #A2
C. A:2
D. A2
A. $A$2