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
A text function sued to remove spaces from a string leaving a single space between words is the ______________________ fuction.
TRIM
A tool used with a tables to filter data based on distinct values as a visual button is a _____________________.
Slicer
The ______________________function returns a specified number of characters, starting from the right side of the data.
RIGHT
_____________________rules place restrictions on the types of data that can be entered into cells and allows you to create a drop down list.
Data Validation
The _______________________function returns the characters starting from the left side of the string.
LEFT
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
Which button allows you to copy cell formats from one cell to another?
Format Painter
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 (the cell is not big enough)
Which of the following is an absolute cell reference? (lock cells)
A. $A$2
B. #A2
C. A:2
D. A2
A. $A$2
What value would Excel return for this formula?
=(12-2)/5+6*2
14
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