NEW
Font size
WorksheetsExcel 2: Fundamentals
Total questions: 37
Worksheet time: 19mins
Which of the following is NOT necessary for organizing data to make it easier to sort?
There must be a blank row and column between the data and other information
The data header information must be bold
The data header must be in a single row
The data you want to sort must be continuous without blank rows or columns.
If D3=30 and D4=20, what is the result of the function =IF(D4<D3, D3-D4, "FULL")?
Full
Unknown
10
-10
When would you use conditional formatting on a cell?
You want to use a formula and function to sum the values in a column.
You want to change the font for every cell in the spreadsheet
You want to highlight negative numbers by using red text
You want to hide the contents of a column
What term refers to mathematical equations used in Excel to perform calculations?
Format
Formulas
Cell
Summations
Where would you click to change a cell format to text?
A
B
C
D
Which set of data is in descending order?
apples, oranges, bananas, grapes
4/1/2018, 4/1/2017, 3/29/2017, 6/18/2018
4, 3, 1, 2
horses, ducks, dogs, cats
You want to enter a series of dates down a column. What would be the best tool for the job?
Spelling Checker
Cut and Paste
AutoFill
Find and Replace
What function would you use to find the least expensive item?
=AVERAGE(B3:B7)
=MIN(B3:B7)
=MAX(B3:B7)
=SUM(B3:B7)
Which of these number formats would you want to apply to a cell showing the total sales for the month?
General
Currency
Text
Date
Microsoft Excel can use Headers and Footers, just like Microsoft Word.
True
False
Which of these formulas uses absolute cell references?
=5*10+20
=$A$10/100
=F18+F19/2
=D5+F3
What happens when you hide a column in Microsoft Excel?
The data in the column is deleted.
Formulas referencing cells in the column stop working
“The column doesn't appear, but the data is still there
What does filtering data in a spreadsheet do?
Shows data that did not meet the criteria
Hides the data you are looking for
Hides data that you do not want to see
Shows all the data in the spreadsheet
Which type of cell references are locked and NOT automatically updated when copied?
Worksheet
Absolute
Relative
Formula
What symbol is used to designate an absolute cell reference?
#
!
$
%
Which of the following is a way to search for a function?
Browse in the Function Library group
Click Insert Function and enter a search phrase
All of the above
If A3=10 and B6=14, what is the result of the logical expression A3=B6?
True
False
What formula would you enter in C3 that combines A3 and B3 to get a result like in C2?
=CONCATENATE(A3," ",B3
=B3,&,&,A3
=A3,&,&,B3
=CONCATENATE(B3,,,A3)
What does it mean to merge cells?
Split a single cell into 2 or more cells.
Center the contents of the cells.
Combine 2 or more cells into a single cell.
Apply a border around a set of cells.
If you copied C6 to E3, what would be the resulting cell reference in E3?
=E6
=F6
=F3
=E3
Why would you want to change the column width?
To draw attention to the data in those cells.
To make sure the column headings are always visible when scrolling.
To make sure all of the information in the column is visible.
Which of these statements are true?
You can use borders to create a group of cells or make specific cells stand out
For cells that contain text, it is better to use a pattern rather than a shade
The more shades you use on a worksheet, the more attractive it will be
All of the above
Which type of cell references are automatically updated when copied?
Worksheet
Formula
Relative
Absolute
Which of these is NOT a number format in Microsoft Excel?
Date
Roman numeral
Fraction
Percentage
Where would you click to sort in ascending order?
A
B
C
D
You can use the Formulas Tab to change the Excel View, to hide the Heading, Gridlines and Ruler.
True
False
Where would you click to access the sort and filter commands in Excel?
A
B
C
D
Which formula would you enter into C3, and then AutoFill into C4 through C6, to calculate the percent sales (Pct.) for the regions?
=B3/B7
=$B$3/B7
=$B$3/$B$7
=B3/$B$7
Which of the following can a cell contain?
a number
a word
a function
all of these
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
Double-click on the cell and edit the formula in the cell
Select the cell and edit the formula in the Formula Bar
How are a cell's content and format related?
The content and format are the same.
They are independent and not related
Changing the format affects the content
Which letter on the image is a Column?
A
B
C
D
You accidentally delete a large portion of your spreadsheet. How do you get the information back?
Press Ctrl+C
Press Ctrl+Z
Press Ctrl+V
Press Backspace
Which key should you press to select the cells shown in the image?
Del
Ctrl
Enter
Shift
Which formula is a complex formula?
=D6/5
C3+10+E3
=10-(A3-D13)
5+A1*B1
Where is the Formula Bar?
A
B
C
D
E
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data.
