Microsoft Excel Examination
This is a 30-minute exam (approximately 1 minute per item) which assesses your knowledge in using Microsoft Excel. You may open an Excel Workbook to help you answer some of the questions on this exam. Goodluck!
- 1.
Labels are aligned at the ________ edge of the cell.
- A.
Left
- B.
Right
- C.
Top
- D.
Bottom
- E.
None of the above
Correct Answer
A. LeftExplanation
Labels are aligned at the left edge of the cell. This means that the labels are positioned on the left side of the cell, ensuring that they are aligned with the left border of the cell.Rate this question:
-
- 2.
Outlining data in an Excel spreadsheet will organize the sheet and make it easier to view. Provide the path on how to create an outline using Microsoft Excel. Kindly separate your answers with either > or , (no extra spaces please). Example: a>b>c or a,b,c
Correct Answer
Data > Group and outline > Group
Data>Group and outline>Group
Data,Group and outline,Group - 3.
You can complete a cell entry by pressing
- A.
Enter
- B.
Tab
- C.
Shift+tab
- D.
An arrow key
- E.
Another cell
- F.
All of the above
- G.
None of the above
Correct Answer
F. All of the aboveExplanation
You can complete a cell entry by pressing Enter, Tab, shift+tab, an arrow key, or another cell. These are all valid ways to finish inputting data into a cell in a spreadsheet or data entry program.Rate this question:
-
- 4.
It is possible to print multiple sheets or tabs in Microsoft Excel, all at the same time.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
In Microsoft Excel, it is indeed possible to print multiple sheets or tabs at the same time. This can be done by selecting the sheets or tabs that need to be printed, and then choosing the print option. This feature is helpful when there is a need to print multiple sheets or tabs together, saving time and effort.Rate this question:
-
- 5.
The default font keyed in a new work book is -
- A.
Verdana
- B.
Calibri
- C.
Ariel
- D.
Times New Roman
- E.
None of the above
Correct Answer
B. CalibriExplanation
The default font in a new workbook in Microsoft Excel is Calibri at size 11.Rate this question:
-
- 6.
We can create range names by simply defining names in Excel. Provide the path on how to define names using Microsoft Excel: Kindly separate your answers with either > or , (no extra spaces please). Example: a>b>c or a,b,c
Correct Answer
Insert>Name>Define
Insert,Name,Define - 7.
If you choose a larger font size, the height of the row is automatically made taller.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
If you choose a larger font size, the height of the row is automatically made taller. This statement is true because when you increase the font size, the text takes up more space vertically, which in turn increases the height of the row to accommodate the larger text.Rate this question:
-
- 8.
For tips and warnings in “Defining Names”, we can use spaces or special characters in the names.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
In "Defining Names", it is not recommended to use spaces or special characters in the names. This is because spaces and special characters can cause errors or confusion in the program. It is best to use alphanumeric characters and underscores (_) in the names to ensure clarity and avoid any potential issues.Rate this question:
-
- 9.
Which button allows you to copy cell formats from one cell to another?
- A.
Enter
- B.
Autofit
- C.
Format Painter
- D.
Esc
Correct Answer
C. Format PainterExplanation
The Format Painter button allows you to copy cell formats from one cell to another. This feature is useful when you want to apply the same formatting, such as font style, color, and border, to multiple cells without manually adjusting each one. Simply select the cell with the desired format, click on the Format Painter button, and then click on the cell(s) where you want to apply the same format.Rate this question:
-
- 10.
The Excel IF function checks to see if a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The explanation for the given correct answer is that the Excel IF function is indeed used to check whether a certain condition is true or false. If the condition is true, the function will execute one set of instructions, and if the condition is false, it will execute a different set of instructions. Therefore, the statement "The Excel IF function checks to see if a certain condition is true or false" is true.Rate this question:
-
- 11.
A_______ is a group of cells that form a retangle on the screen
- A.
Label
- B.
Workbook
- C.
Worksheet
- D.
Column
- E.
Range
- F.
None of the above
Correct Answer
E. RangeExplanation
A range is a group of cells that form a rectangle on the screen. It can include multiple rows and columns, allowing for the selection and manipulation of a specific area of a spreadsheet. Ranges are commonly used for performing calculations, formatting data, and applying formulas or functions to a specific set of cells.Rate this question:
-
- 12.
The following formula show “Fair”, “Good” or “Excellent” depending on the value of A1 but there is an error in the logic. What value produces an incorrect result? =IF(A1<500,”Fair”,IF(AND(A1>500,A1<1500),”Good”,”Excellent”))
- A.
A value of 0 will display “Good”
- B.
A value of 500 will display “Excellent”
- C.
A value of 1500 will display “Fair”
- D.
A value of -500 will display “Excellent”
- E.
None of the above
Correct Answer
B. A value of 500 will display “Excellent”Explanation
The correct answer is that a value of 500 will display "Excellent". This is because the logic in the formula is incorrect. The first condition checks if A1 is less than 500, and if true, it displays "Fair". The second condition checks if A1 is greater than 500 and less than 1500, and if true, it displays "Good". However, if A1 is exactly 500, it does not meet the first condition but also does not meet the second condition, so it falls into the default else case and displays "Excellent". This is an error in the logic of the formula.Rate this question:
-
- 13.
How do you know a range is active?
- A.
It is highlighted on the screen.
- B.
It has a marquee around it.
- C.
The data changes to Bold to let me know it's active
- D.
I'm psychic & I just Know!!
- E.
All of the above except "I'm psychic & I just Know!!"
- F.
None of the above
Correct Answer
A. It is highlighted on the screen.Explanation
The correct answer is "It is highlighted on the screen." This means that when a range is active, it will be visually distinguished from other elements on the screen, such as by being highlighted or having a different color or shading. This visual cue helps the user identify which range is currently active and allows them to interact with it accordingly.Rate this question:
-
- 14.
A range has an address called an range address.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A range in this context refers to a group or collection of cells in a spreadsheet. Each range is assigned a unique address, known as a range address, which helps to identify and locate the specific range within the spreadsheet. Therefore, the statement that a range has an address called a range address is true.Rate this question:
-
- 15.
An example of a range address.
- A.
A1;B3
- B.
A1-B3
- C.
A1:B3
- D.
A1*B3
- E.
A1&B3
Correct Answer
C. A1:B3Explanation
The correct answer is A1:B3 because it represents a range of cells in a spreadsheet, starting from cell A1 and ending at cell B3. The colon (:) is used to indicate the range between the starting and ending cells.Rate this question:
-
- 16.
When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________
- A.
Cell selector
- B.
Cell cross
- C.
Selection Pointer
- D.
Range Selector
- E.
None of the above
Correct Answer
C. Selection PointerExplanation
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a Selection Pointer. This pointer helps you visually indicate the range of cells you want to select or manipulate.Rate this question:
-
- 17.
A fast way to add up this column of numbers is to click in 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.
All of the above
- E.
None of the above
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.Explanation
The correct answer is "Click the AutoSum button on the Standard toolbar, then press ENTER." This is the fastest way to add up the column of numbers. By clicking the AutoSum button, Excel automatically selects the range of cells above the active cell and inserts the SUM function in the formula bar. Pressing ENTER then calculates and displays the sum in the active cell. The other options mentioned in the question are not the fastest methods for adding up the column of numbers.Rate this question:
-
- 18.
Say that 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...
- 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.
All of the above
- E.
None of the above
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 without the underlying formula itself, you would first copy the cell with the formula. Then, you would place the insertion point in the cell where you want to paste the result. Finally, you would click the arrow on the Paste button on the Standard toolbar and select "Values" from the options. This will paste only the calculated value of the formula into the destination cell, without including the formula itself.Rate this question:
-
- 19.
How do you change 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.
All of the above
- E.
None of the above
Correct Answer
B. Double-click the boundary to the right of the column heading.Explanation
To change the column width to fit the contents in Excel, you can double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to accommodate the widest content within it. Single-clicking the boundary to the left of the column heading or pressing ALT and single-clicking anywhere in the column will not achieve the desired result. Therefore, the correct answer is to double-click the boundary to the right of the column heading.Rate this question:
-
- 20.
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. TrueExplanation
Every new workbook in Excel comes with three default worksheets. However, if desired, the user has the ability to change the automatic number of worksheets. Therefore, the statement is true.Rate this question:
-
- 21.
###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
- D.
All of the above
- E.
None of the above
Correct Answer
C. The cell is not wide enough.Explanation
The correct answer is "The cell is not wide enough" because the use of "######" in a cell is a formatting feature in Excel that indicates the cell is not wide enough to display the entire content of the cell. When a cell contains a long number or text, Excel will display "######" to indicate that the content is too wide for the cell. This can be resolved by widening the cell or adjusting the column width to accommodate the content.Rate this question:
-
- 22.
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. FalseExplanation
To add a new row in a table, you need to click a cell in the row immediately below where you want the new row. Therefore, the statement "To add a new row, click a cell in the row immediately above where you want the new row" is false.Rate this question:
-
- 23.
Which key do you press to group two or more nonadjacent worksheets?
- A.
CTRL
- B.
SHIFT
- C.
ALT
- D.
ENTER
- E.
None of the above
Correct Answer
B. SHIFTExplanation
To group two or more nonadjacent worksheets, you would press the SHIFT key. Pressing the SHIFT key allows you to select multiple worksheets that are not next to each other in the worksheet tab bar. This feature is useful when you want to perform an action, such as formatting or entering data, on multiple worksheets simultaneously.Rate this question:
-
- 24.
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. FalseExplanation
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 CTRL, and then drag the selected sheet along the row of sheet tabs. The statement in the question is incorrect as it mentions holding down SHIFT instead of CTRL.Rate this question:
-
- 25.
Which formula can add the 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.
None of the above
Correct Answer
C. SumExplanation
The formula that 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 is the "Sum" formula. This formula is specifically designed to add up numerical values and exclude non-numeric values from the calculation. By using the "Sum" formula, you can easily calculate the total sum of a range of cells without having to manually filter out non-numeric values.Rate this question:
-
- 26.
Is it possible to insert an image from a file into an Excel spreadsheet ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
Yes, it is possible to insert an image from a file into an Excel spreadsheet. Excel allows users to insert various types of objects, including images, into cells or as floating objects on the spreadsheet. This feature is useful for adding visual elements to enhance the presentation or to provide additional information in the spreadsheet. By selecting the appropriate option in the Excel menu, users can easily import an image from a file and position it within the spreadsheet according to their requirements.Rate this question:
-
- 27.
A Formula and a function are the same thing.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
False. A formula and a function in Excel are not the same thing.
A formula is an expression that you create inside a cell. It can be as simple or as complex as you need it to be, and it performs calculations or tasks you set up. Formulas must start with an equal sign when inserted into a cell. For example, =1+2 and =A1+D3 are formulas.
A function, on the other hand, is a predefined formula already available in Excel. Functions allow you to make calculations, formatting, and similar tasks without needing to know operators or programming languages. For example, =SUM(A1:A10) is a function.
So, while a cell in Excel can only have one formula, the formula itself can consist of multiple functions.Rate this question:
-
- 28.
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)
=(A1+A2+A3+A4+A5)/5
=average(a1:a5)
=(a1+a2+a3+a4+a5)/5Explanation
The correct answer is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5. Both formulas will give the average of the values in cells A1 to A5. The AVERAGE function calculates the average directly, while the second formula manually adds up the values and divides by the count of values (in this case, 5). The third and fourth options are the same as the first two, just written in lowercase.Rate this question:
- 29.
The formula = ((A2+B5)*5% is valid
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given formula is not valid because it is missing a closing parenthesis. The correct formula should be = ((A2+B5)*5%).Rate this question:
-
- 30.
#VALUE! means:
- A.
An empty cell
- B.
Wrong formula
- C.
Has one or more space characters
- D.
None of the above
Correct Answer
C. Has one or more space charactersExplanation
The value #VALUE! indicates that a cell contains one or more space characters. This means that the cell appears empty, but it actually contains spaces.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Nov 09, 2023Quiz Edited by
ProProfs Editorial Team -
Aug 30, 2012Quiz Created by
PRST_GY