November 10, 2020
Excel Pre-Assessment
Excel Pre-Assessment
Quiz Summary
0 of 7 questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
Results
Results
0 of 7 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
-
Not categorized
0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
-
Current -
Review / Skip -
Correct -
Incorrect
-
Question 1 of 71. Question
Match these terms used in Excel with the correct definitions. Drag and drop the correct definition to the matching term.
Sort elements
- A rectangle or block housed in a worksheet. Can be color coded, display text, numbers and the results of calculations, based on what you want to accomplish.
- An Excel spreadsheet file. Stores all of the data that you have entered and allows you to sort or calculate the results.
- Documents within a workbook that are represented as tabs on the bottom of the screen.
- A sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign.
- A section of command tabs above the worksheet.
- A set of coordinates that identifies a specific cell.
- A collection of cells that have been identified as a group based on a variety of criteria.
-
cell reference
-
workbook
-
formula
-
cell
-
ribbon
-
cell range
-
worksheet
Correct
Incorrect
-
Question 2 of 72. Question
To sort a column in Excel you select the column and cell range and then select..
Correct
Incorrect
-
-
Question 3 of 73. Question
Looking at the following worksheet of values, select the most appropriate formula to total the values in column C.
Correct
Incorrect
-
-
Question 4 of 74. Question
Consider the following scenario. You are asked to multiply the value in the first cell (A1) by the value in the second cell (B1) and divide that total by the value in the third cell (C1). Select the formula that best represents this calculation.
Correct
Incorrect
-
-
Question 5 of 75. Question
To add a header or footer to an Excel spreadsheet you should select the ___tab and select Header & Footer
Correct
Incorrect
-
-
Question 6 of 76. Question
Sometimes an Excel cell will contain text that bleeds over the size of the cell. See example below. Which formatting command would you use to contain all of the text in a single cell (A1).
Correct
Incorrect
-
-
Question 7 of 77. Question
This command in Excel allows you to keep the top row or left column visible, while you scroll through a spreadsheet.
Correct
Incorrect
-