NEW
Font size
WorksheetsIBM Course 2-Excel Basics
Total questions: 18
Worksheet time: 14mins
All Formulas in Excel must start with:
# sign
@ sign
+ sign
= sign
Which of the following actions will “select” all cells in a sheet:
Clicking on a column’s letter (e.g. A, B, C…)
Selecting the first cell in column A and, while holding Shift, selecting the last cell in column A.
Clicking on the space between the first row (marked as number 1) and first column (marked as letter A).
Clicking on row number 1
What is the function “Wrap Text” used for?
Left-aligning contents of a cell.
Center-aligning contents of a cell.
Adding a border around a cell.
Breaking long content into multiple lines in a cell.
Assume you are copying cell A1 to cell C3. If cell A1 contains the formula =$B1+$C$1, how would this formula change when copied to cell C3?
=$D3+$E$3
=$B3+$C$1
=$D3+$E1
=$B3+C$1
Which of the following formulas has a syntax error / is incorrect:
=IFS(A1 = 5, "Excellent", A1 = 4, “Very Good”, “Good”)
=IF(A1 = 5, “Excellent”, IF(A1 = 4, “Very Good”, “Good”))
=IFS(A1 = 5, "Excellent", A1 = 4, “Very Good”, A1, “Good”)
=IF(A1 = 5, “Excellent”, IF(A1 = 4, “Very Good”, IF(A1, “Good”, )))
When a cell is cut and pasted into a new cell, what will be pasted in the destination cell?
Any content (e.g. text, numbers, formula) of the original cell.
Any content (e.g. text, numbers, formula) and formatting of the original cell.
Only text or number content of the original cell.
Only formatting of the original cell.
Only conditional formatting rules of the original cell.
How would you select non-contiguous cells?
Hold Ctrl → left-click on each cell
Hold Shift → left-click on each cel
Right-click on each cell
Hold Alt → left-click on each ce
Which of the following commands doesn't affect the text font?
Bold
Underline
Borders
Italics
How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?
=A1X6/4
=A1X6%4
=A1*6/4
=A1*6%4
Fill Handle will generate content based on the following:
Mathematical Series
Alignment Pattern
Design Pattern
All of the Above
The Conditional Formatting feature is used to:
Set the default cell format
Format conditional statements
Format cells conditional on the text size
Change the style of cells meeting a condition
When a formatted number does not fit within a cell, it displays
#####
#DIV/0
#DIV@
None of these
What symbol is used to enter number as text?
"
=
+
'
Data can be arranged in ascending or descending order by using
Sort command from Table menu
Sort command from Data menu
Sort command from Tools menu
None of these
Cell E23 has a date value and you wish to place that date on an invoice prefaced with the text located in B15. What is the command to do that?
=B15&E23
=proper(B15)&" "&text(E23,"mmmm dd, yyyy")
B15&" "&E23
=join(B15&E23)
Which of the following component displays the contents of active cell?
Name box
Status bar
Menu bar
Formula bar
The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called
Freezing
Fixing
Selecting
Locking
If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort?
zip codes (ascending), then last name (ascending), then first name (ascending) b.
last name (ascending), then first name(ascending), then last name (ascending)
zip codes (descending), then last name(ascending), then first name(ascending)
last name (descending), then first name (descending), then last name (descending)
