Excel Assessment - Level 1
This assessment will be used to measure your knowledge of Excel.
Questions and Answers
- 1.
C4:D11 is an example of a .
- A.
Formula
- B.
Range
- C.
Column
- D.
Cell
Correct Answer
B. RangeExplanation
C4:D11 is an example of a range because it represents a group or collection of cells in a spreadsheet. A range is defined by specifying the starting cell and the ending cell, separated by a colon. In this case, the range starts at cell C4 and ends at cell D11, encompassing all the cells in between.Rate this question:
-
- 2.
What symbol is missing in the beginning of this formula? SUM(B2:B11)
- A.
;
- B.
*
- C.
=
- D.
/
- E.
//
Correct Answer
C. =Explanation
The symbol that is missing in the beginning of the formula is the equals sign (=). The equals sign is used in formulas to indicate that a calculation or function is being performed. In this case, the formula is SUM(B2:B11), which calculates the sum of the values in cells B2 to B11.Rate this question:
-
- 3.
There are multiple ways to insert a hyperlink into a cell.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because in most spreadsheet programs, such as Microsoft Excel or Google Sheets, you can insert a hyperlink into a cell by selecting the cell, right-clicking on it, and choosing the "Insert Hyperlink" option. Alternatively, you can use the keyboard shortcut Ctrl+K to open the hyperlink dialog box and enter the desired link. This allows users to easily add clickable links to their spreadsheet cells, which can be useful for referencing external websites, documents, or other resources.Rate this question:
-
- 4.
Data can be sorted by ____________ ? (Please check all answers that apply)
- A.
Font type
- B.
Value
- C.
Cell Color
- D.
Alphabetically
- E.
All of the above
Correct Answer(s)
B. Value
C. Cell Color
D. AlphabeticallyExplanation
Data can be sorted by value, cell color, and alphabetically. Sorting by value means arranging the data in ascending or descending order based on the numerical values. Sorting by cell color involves arranging the data based on the color of the cells, which can be useful for categorizing or highlighting specific data. Sorting alphabetically means arranging the data in alphabetical order based on the text or characters. Therefore, all of the given options are correct for sorting data.Rate this question:
-
- 5.
The two orientation styles of a page layout are landscape and .
Correct Answer(s)
PortraitExplanation
The two orientation styles of a page layout are landscape and portrait. Landscape refers to a layout where the width of the page is greater than its height, while portrait refers to a layout where the height of the page is greater than its width. These two styles offer different options for displaying and arranging content, allowing for flexibility in design and presentation.Rate this question:
- 6.
If you need a total of C1:D2, which of the following would you use? (Check all answers that apply)
- A.
Sum(C1:D2)
- B.
Total(C1:D2)
- C.
C1+D2
- D.
C1+C2+D1+D2
Correct Answer(s)
A. Sum(C1:D2)
D. C1+C2+D1+D2Explanation
To calculate the total of the range C1:D2, you can use the formula Sum(C1:D2). This formula will add up all the values within the range and give you the sum. Additionally, you can also use the formula C1+C2+D1+D2 to manually add up the individual values in the range. Both of these methods will give you the total of the range C1:D2.Rate this question:
-
- 7.
Select the best description(s) for applying a macro to a sheet.
- A.
Insert -> Sheet Options -> Insert Macro
- B.
View -> Record Macro -> Stop Recording
- C.
Developer -> Design Mode -> Run Macro -> Stop Macro
- D.
Developer -> Record Macro -> Stop Recording
- E.
Both B and D
Correct Answer
E. Both B and DExplanation
Both options B and D are correct because they both involve recording a macro. In option B, the user goes to the View tab, selects Record Macro, and then stops recording. In option D, the user goes to the Developer tab, selects Record Macro, and then stops recording. Both options involve the process of recording a macro, which allows the user to automate a series of actions in Excel.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
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 14, 2012Quiz Created by
Management
Back to top