Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.
, MS (Computer Science)
Approved & Edited byProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Do you think you know the basics of Microsoft Excel very well? Take is Microsoft Excel quiz and test your knowledge! Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it a try and ensure you read up on the parts you don't get correctly. Along with practice, you will learn new things too. If you find this quiz a good one and informative, share it with others also.
Questions and Answers
1.
A fast way to add up the column of numbers is to click on the cell below the numbers and then:
A.
Click Subtotals on the Data menu.
B.
View the sum in the formula bar.
C.
Click the AutoSum button on the Standard toolbar, then press ENTER.
D.
Click the Sum button on the Standard toolbar.
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.
Explanation The fastest way to add up the column of numbers is by clicking the AutoSum button on the Standard toolbar and then pressing ENTER. This button automatically selects the range of cells above it and adds them up, providing the sum in the selected cell. This method eliminates the need to manually select the range or go through additional steps, making it the most efficient option.
Rate this question:
2.
If you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
A.
Click the Paste button on the Standard toolbar.
B.
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
C.
Click the arrow on the Paste button on the Standard toolbar, then click Values.
D.
Click the arrow on the Copy button on the Standard toolbar.
Correct Answer
C. Click the arrow on the Paste button on the Standard toolbar, then click Values.
Explanation To paste only the result of a formula to another cell, you need to copy the cell with the formula and then place the insertion point in the destination cell. Next, you should click the arrow on the Paste button on the Standard toolbar and select "Values" from the options. This will paste only the calculated result of the formula into the new cell, without including the underlying formula itself.
Rate this question:
3.
How do you change the column width to fit the contents?
A.
Single-click the boundary to the left of the column heading.
B.
Double-click the boundary to the right of the column heading.
C.
Press ALT and single-click anywhere in the column.
D.
Press Fn and double-click anywhere in the column.
Correct Answer
B. Double-click the boundary to the right of the column heading.
Explanation To change the column width to fit the contents, you need to double-click the boundary to the right of the column heading. This action automatically adjusts the column width to accommodate the widest content within it.
Rate this question:
4.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
A.
True
B.
False
Correct Answer
A. True
Explanation By default, every new workbook in Excel comes with three worksheets. However, it is possible to change this automatic number of worksheets if desired.
Rate this question:
5.
###### means:
A.
You've entered a number wrong.
B.
You've misspelled something.
C.
The cell is not wide enough.
D.
The cell has the wrong data.
Correct Answer
C. The cell is not wide enough.
Explanation The given answer suggests that the reason behind the issue is that the cell is not wide enough. This means that when entering the number, it exceeds the width of the cell, causing it to display incorrectly. The other options, such as entering a wrong number or misspelling something, are not applicable in this case. The answer implies that the width of the cell needs to be adjusted to properly display the entered number.
Rate this question:
6.
To add a new row, click a cell in the row immediately above where you want the new row.
A.
True
B.
False
Correct Answer
B. False
Explanation In most spreadsheet applications, to add a new row, you usually click on the row number on the left-hand side of the screen (which corresponds to the row immediately below where you want the new row) and then insert a new row. Clicking a cell in the row immediately above where you want the new row typically does not directly add a new row.
Rate this question:
7.
Which key do you press to group two or more nonadjacent worksheets?
A.
CTRL
B.
SHIFT
C.
ALT
D.
TAB
Correct Answer
A. CTRL
Explanation To group two or more nonadjacent worksheets in Microsoft Excel, you typically use the CTRL key. Here's how you can do it:
Click on the first worksheet tab that you want to include in the group.
Hold down the CTRL key on your keyboard.
While holding down the CTRL key, click on the other worksheet tabs you want to include in the group. Each clicked worksheet tab will be added to the selection group.
Release the CTRL key when you've selected all the desired worksheets.
The worksheets you selected will now be grouped together, and any action you perform on one of them will also apply to the others in the group.
Rate this question:
8.
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
A.
True
B.
False
Correct Answer
B. False
Explanation To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. This statement is false because to copy a worksheet, you should right-click on the worksheet tab, select "Move or Copy," choose the location where you want to copy the worksheet, and then click OK.
Rate this question:
9.
Which of the following Excel functions can be used to calculate the average of a range of numbers?
A.
SUM()
B.
COUNT()
C.
AVERAGE()
D.
MAX()
Correct Answer
C. AVERAGE()
Explanation In Microsoft Excel, the AVERAGE() function calculates the mean of a set of numbers. For example, =AVERAGE(A1:A10) computes the average of values in cells A1 through A10. In contrast, SUM() adds up values, COUNT() counts the number of cells with numbers, and MAX() identifies the highest value. Using AVERAGE() helps quickly determine the central tendency of data.
Rate this question:
10.
Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
A.
Count
B.
Average
C.
Sum
D.
Addition
Correct Answer
C. Sum
Explanation The formula that can add all the numeric values in a range of cells, excluding non-numeric values, and place the result in a different cell is the "Sum" formula. This formula calculates the sum of all the numbers in the specified range and ignores any non-numeric values, providing the total sum as the result.
Rate this question:
11.
Is it possible to insert an image from a file into an Excel spreadsheet?
A.
Yes
B.
No
Correct Answer
A. Yes
Explanation Yes, it is possible to insert an image from a file into an Excel spreadsheet. Excel allows users to add images to a worksheet by using the 'Insert' tab and selecting the 'Picture' option. This enables users to browse their computer for the desired image file and insert it directly into the spreadsheet.
Rate this question:
12.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge?
A.
Yes
B.
No
Correct Answer
A. Yes
Explanation Yes, an Excel spreadsheet can be used as the "data source" for a Word Mail Merge. Excel allows users to store and organize data in a tabular format, making it a suitable source for merging data with Word documents. By linking the Excel spreadsheet to a Word document, users can easily import and merge the data from specific columns into the desired locations within the Word document, saving time and effort in creating personalized documents.
Rate this question:
13.
On an Excel sheet, the active cell is indicated by ____.
A.
A wide dark border
B.
A dotted border
C.
A blinking border
D.
None of the above
Correct Answer
A. A wide dark border
Explanation The active cell on an Excel sheet is indicated by a wide dark border. This border helps to visually distinguish the currently selected cell from the rest. It is wider and darker compared to the borders of other cells, making it easier to identify. The wide dark border serves as a visual cue for users to know which cell they are currently working on, allowing them to input or edit data accurately.
Rate this question:
14.
Formula and function are the same things.
A.
True
B.
False
Correct Answer
B. False
Explanation Formulas and functions are not the same things. In Excel, a formula is an expression that performs calculations using cell references, values, and operators. A function, on the other hand, is a predefined formula that performs specific calculations. Functions are built-in to Excel and are used to simplify common calculations.
Rate this question:
15.
To multiply items in Excel, you would use:
A.
^
B.
@
C.
*
D.
#
Correct Answer
C. *
Explanation To multiply items in Excel, you would use the asterisk symbol (*). This symbol is used as the multiplication operator in Excel formulas. By placing the asterisk between two or more cell references or numbers, Excel will perform the multiplication operation and provide the result.
Rate this question:
16.
The formula = ((A2+B5)*5% is valid.
A.
True
B.
False
Correct Answer
B. False
Explanation The given formula is not valid because it is missing a closing parenthesis. The correct formula should be ((A2+B5)*5%).
Rate this question:
17.
If cells:
A1=90
A2=85
A3=80
A4=75
A5=75
What will be your formula if you are going to get the average?
Correct Answer =AVERAGE(A1:A5)
Explanation The formula to calculate the average of the given cells would be =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5 or =average(a1:a5) or =(a1+a2+a3+a4+a5)/5.
Rate this question:
18.
If cells:
A1=90
A2=85
A3=80
A4=75
A5=75
What will be your formula if you are going to get the total?
Explanation The formula to calculate the total of the cells A1 to A5 is =SUM(A1:A5) or =A1+A2+A3+A4+A5 or =sum(a1:a5) or =a1+a2+a3+a4+a5.
Rate this question:
19.
Get the remarks in cell E10 that valued 75, which noted that if the remarks are higher than 74, the remarks will be "PASSED" or else "FAILED."
Correct Answer =IF(E10 > 74, "PASSED", "FAILED")
Explanation To determine if a value in cell E10 should be marked as "PASSED" or "FAILED," use the formula =IF(E10 > 74, "PASSED", "FAILED"). This formula checks if the value in E10 is greater than 74. If it is, the formula returns "PASSED"; if it's 74 or less, it returns "FAILED." This helps quickly categorize values based on the given threshold.
Rate this question:
20.
Get the remarks in cell A1 that valued 75, which noted that if the remarks are higher than 74, the remarks will be "PASSED" or else "FAILED".
Correct Answer =IF(A1>74,"PASSED","FAILED")
Explanation The given answer is a formula that uses the IF function in Excel. It checks if the value in cell A1 is greater than 74. If it is, the formula returns "PASSED". If it is not, the formula returns "FAILED". This formula is used to determine if the remarks for a certain value are either "PASSED" or "FAILED" based on the condition given.
Rate this question:
Godwin Iheuwa |MS (Computer Science)|
Database Administrator
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.