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 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?
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
Which button allows you to copy cell formats from one cell to another?
Format Painter
What is the area that shows a reference of 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
How do to specify a company in Excel?
File -> Info -> Properties -> Company
What is an example of a Range address
A. A1:B3
B. A1-B3
C. A1;B3
D. A1=B3
A. A1:B3
What sign must you always use to begin a formula?
= Equal Sign
What is a tool used in Excel to organize data?
Table
True/False. If you choose a larger font size, the height of the row is automatically made taller.
True
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, Select This PC
Which of the following is an absolute cell reference?
A. $A$2
B. #A2
C. A:2
D. A2
A. $A$2