WorksheetsExcel 101
Total questions: 30
Worksheet time: 8mins
1. The intersection of a row and a column is called a ________.
a. cell
b. chart
c. worksheet
d. sum
2. Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?
a. It should use quotation marks instead of parentheses
b. It should have an equal sign (=) at the beginning
c. There is nothing wrong with the formula
d. It should use the COUNT function instead
3. True or False: You can view a formula by double-clicking the cell that contains the formula.
a. True
b. False
4. Which of the following is an absolute cell reference?
a. #A2
b. $A$2
c. A:2
d. A2
6. What value would Excel return for this formula? =(82-32)/5+8*2
a. 36
b. 26
c. 7.69
d. 91.6
6. How do you delete a column?
a. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
b. Select the column heading you want to delete and select Insert Delete from the menu
c. Select the row heading you want to delete and select Edit > Delete from the menu
d. Right click the column heading you want to delete and select delete from the shortcut menu
Which of the following is not a valid data type in excel?
a. Number
b. Character
c. Label
d. Date/Time
How do you select an entire column?
a. Select Edit > Select > Column from the menu
b. Click the column heading letter
c. Hold down the shift key as you click anywhere in the column
d. Hold down the Ctrl key as you click anywhere in the column
Right clicking something in Excel:
a. Deletes the object
b. Nothing the right mouse button is there for left handed people
c. Opens a shortcut menu listing everything you can do to the object
d. Selects the object
You can use the drag and drop method to
a. Copy cell contents
b. Move cell contents
c. Add cell contents
d. Both ‘a’ and ‘b’
How do you insert a row?
a. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b. Select the row heading where you want to insert the new row and select Edit >Row from the menu
c. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d. All of the above
When you copy a formula
a. Excel erases the original copy of the formula
b. Excel edits cell references in the newly copied formula
c. Excel adjusts absolute cell references
d. Excel doesn’t adjust relative cell references
The process of identifying specific rows and columns so that so that certain
columns and rows are always visible on the screen is called
a. Freezing
b. Locking
c. Selecting
d. Fixing
The “Save As” command will NOT allow you to
a. Save as a PDF
b. Save as a template
c. Save as a Word document
d. Save at a specific location
What is the purpose of the two words circled in orange?
a. These represent the names of the individual workbooks you have saved. If you click on the "Sales 2" tab it will open this workbook
b. These reflect a selected range of cells in the worksheet. If you click on "Sales 2" it will take you to the selected cell.
c. These represent worksheets that have been created in the workbook. If you click on them they will take you to the different sheets.
d. This is the Name Box and represents named ranges in the worksheet. If you click on "Sales 2", you can rename the range.
What happens when you press the icon circled in orange in the image below?
a. It moves the worksheet up and hides rows.
b. It minimizes the Ribbon.
c. It opens another part of the Ribbon.
d. It detaches the Ribbon from the worksheet and allow you to move it around.
Where is the zoom control slider located in Excel?
a. bottom right of spreadsheet document
b. bottom left of spreadsheet document
c. top right of spreadsheet document
d. top left of spreadsheet document
What does this symbol represent in MS Excel?
a. Subtract
b. AutoSum
c. formula
d. average
When entering text in Excel, it is automatically (by default):
a. left justified
b. center justified
c. right justified
d. full justified
If you see a series of “######” in a cell, that means the following:
a. you keyed in an incorrect number
b. the row height is too high
c. the text is incorrectly spelled
d. the column width is not wide enough
Order of operation in Excel
a. DASEMP
b.EPSDAM
c. PEMDAS
d. PEMDSA
____ order arranges content in reverse alphabetical order, from Z to A.
a. Reverse
b. Major
c. Ascending
d. Descending
When you copy a formula that contains an absolute reference to a new location, the reference ____.
a. is updated automatically
b. does not change
c. becomes bold
d. has a dotted outline in its cell
What type of chart is useful for comparing
parts of a whole ?
a. Pie Chart
b. Column Chart
c. Line Chart
d. Dot Chart
The image above shows a ____
a. Column Chart
b. Bar Chart
c. Line Chart
d. Pie Chart
You want to change the column width of columns A to G into 25points and row 1, 5 & 7 to 15points. What should you do?
a. Select Columns A to G > Right click in Column A > column width > Enter 25. Select Rows 1 to 7 > Right click in Row 1 > Row Height > Enter 15
b. Select Columns A to G > Right click in Column A > column width > Enter 25. Select Rows 1, 5 and 7 while holding the Ctrl key > Right click in Row 1 > Row Height > Enter 15
c. Select Columns A to G > Drag right border of Column G to the right until it display the value 25. Select Rows 1, 5 and 7 > Drag the border bottom of the row header downwards until it displays the value 15
d. Select Columns A to G > Format tab > Column > Width > Enter 25. Select Rows 1 to 5 > Format tab > Row > Height > Enter 15
When making a graph what's the first thing you need to do?
a. pick the type of graph
b. highlight your data being used
c. use the function = sign
d. double click the active cell
Pls. refer to the image above. The words "Pre-sales" and “Conference Attendance” (located at the bottom of the chart) are called the chart ________________
a. accent
b. key
c. Labels
d. Legend
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
a. Press Ctrl +Home
b. Press Home
c. Press Shift + Home
d. Press Alt + Home
The ____ feature of MS Excel quickly completes a series of data
a. Auto Complete
b. Auto Fill
c. Fill Handle
d. Sorting
