Excel 1
What is the name of an Excel Document?
Workbook or Book
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
What do formulas always start with?
An Equals Sign (=)
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
If you wanted to find the largest value in a range of cells, what formula would you use?
MAX
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.
True
What key shortcut can you use to Find something in a document?
Ctrl F
What is one formula that might help you make a drop down list?
XLOOKUP
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