Microsoft Excel for Beginners
First Name
Click to add
(?)
Last Name
Click to add
(?)
Department ID
Click to add
(?)
Email
Click to add
(?)
1. How do you insert a new worksheet in Excel?
Select a choice
A. Right-click on a sheet tab and choose "Insert"
B. Go to the "Home" tab and click "Insert Sheet"
C. Press Ctrl + N
D. Both A and B
2. In Excel, what does the function COUNTA() do?
Select a choice
A. Counts the number of cells in a range that are not blank
B. Counts the number of cells in a range that are greater than zero
C. Counts the number of cells in a range that contain text
D. Counts the total number of cells in a range
3. What does the term "cell" refer to in Microsoft Excel?
Select a choice
A. A group of worksheets
B. The intersection of a row and column
C. A type of chart
D. A formatting option
4. Which function is used to sum a range of cells in Excel?
Select a choice
A. AVG ( )
B. MAX ( )
C. SUM ( )
D. TOTAL ( )
5. How do you change the width of a column in Excel?
Select a choice
A. True
B. False
6. How do you remove duplicate values in a column in Excel?
Select a choice
A. Use the "Remove Duplicates" feature
B. Apply a filter
C. None of the above
7 To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text
Select a choice
A. True
B. False
8. How can you merge cells in Excel?
Select a choice
A. Use the "Merge & Center" button
B. Apply a cell style
C. Use the "Merge Cells" option in the Format menu
D. Both A and C
9. What is the purpose of the IF function in Excel?
Select a choice
A. To perform mathematical calculations
B. To create conditional statements
C. To generate random numbers
D. To format cells
10. What is the purpose of the function UPPER() in Excel?
Select a choice
A. Converts text to uppercase
B. Counts the number of uppercase letters in a cell
C. Rounds a number to the nearest integer
D. Multiplies a range cell
11. A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
Select a choice
A. Click in cell C6, and then press CTRL+SHIFT.
B. Click in cell C6, and then press CTRL
C. Click in cell C6.
D. None of the Above
12. To divide 1234 by .89 in a formula in Excel, you would use what math operator?
Select a choice
A. +
B. =
C. %
D. /