Microsoft Excel Vocabulary And Functions! Trivia Quiz
Microsoft Excel is a spreadsheet application produced by Microsoft that allows users to organize and calculate data with formulas. It's used for performing the basic calculation, graphing tools, creating pivot tables and macros. This quiz has been created to test your knowledge and skills about spreadsheet vocabulary, functions and formulas. So, let's try out the quiz. All the best!
- 1.
A cell formula that stays the same when copied
- A.
Absolute reference
- B.
Relative reference
- C.
Active cell
- D.
Formula
Correct Answer
A. Absolute referenceExplanation
An absolute reference in a cell formula is a reference that does not change when the formula is copied to other cells. It always refers to the same cell or range of cells, regardless of where it is copied. This is useful when you want to keep a specific cell or range constant in a formula, such as when calculating a percentage based on a fixed value.Rate this question:
-
- 2.
Saved workbook or worksheet
- A.
Document
- B.
File
- C.
Grid
- D.
Graph
Correct Answer
B. FileExplanation
The term "file" is used to refer to a saved workbook or worksheet in a computer system. It is a common way to store and organize data in a digital format. The other options, such as document, grid, and graph, do not specifically indicate the saved format of a workbook or worksheet. Therefore, "file" is the most appropriate and correct answer in this context.Rate this question:
-
- 3.
The vertical divisions of a spreadsheet
- A.
Cell
- B.
Row
- C.
Column
Correct Answer
C. ColumnExplanation
The vertical divisions of a spreadsheet are called columns. Columns are used to organize and categorize data in a spreadsheet. Each column is identified by a letter at the top of the column, such as A, B, C, etc. Columns are used to input and manipulate data vertically in a spreadsheet, making it easier to analyze and calculate information.Rate this question:
-
- 4.
A tab that identifies a worksheet
- A.
Sheet tab
- B.
Sheet
- C.
Formula
- D.
Active cell
Correct Answer
A. Sheet tabExplanation
The correct answer is "Sheet tab" because a sheet tab is a visual representation of a worksheet in a spreadsheet software. It allows users to easily navigate between different worksheets within a workbook. By clicking on a sheet tab, users can quickly access and view the content of a specific worksheet.Rate this question:
-
- 5.
Name of boxes (cells) in a spreadsheet
- A.
Graph
- B.
Cell address
- C.
Address
- D.
Worksheet
Correct Answer
B. Cell addressExplanation
The term "cell address" refers to the specific location of a cell in a spreadsheet. It is a combination of the column letter and row number that uniquely identifies a cell. This address is used to reference and access the data or formula contained within that cell.Rate this question:
-
- 6.
What tool is used to split the window into different parts of the same worksheet?
- A.
The title bar
- B.
The scroll bar
- C.
The toolbar
- D.
The split box
Correct Answer
D. The split boxExplanation
There are times when you need to compare values that are far away from each other. That's why it's an advantage to be able to split the screen in two vertically and/or horizontally and place the values close to each other on the screen. The split boxes help you do that easily.Rate this question:
-
- 7.
What key is used to select multiple ranges of cells?
- A.
Shift
- B.
CTRL
- C.
Alt
- D.
AltCar or AltGr
Correct Answer
B. CTRLExplanation
This key does allow you to select multiple ranges of cells so that youu can apply some options to them or use them for a chart.Rate this question:
-
- 8.
What tool helps you to optimize the results of a model?
- A.
Scenario manager
- B.
Solver
- C.
Target value
- D.
None of the above
Correct Answer
B. SolverExplanation
Solver is there to help you optimize your model to achieve it's greatest possible value.Rate this question:
-
- 9.
What function offers you the possibility to view different results depending on the entered condition?
- A.
=If()
- B.
=Sum()
- C.
=SumIf()
- D.
=TrueFalse()
Correct Answer
A. =If()Explanation
The correct answer is =If(). The IF function allows you to view different results based on a condition that is entered. It evaluates whether a condition is true or false and returns a specific value or performs a specific action accordingly. This function is commonly used in Excel to perform logical tests and make decisions based on the results.Rate this question:
-
- 10.
What function is used to make sure that all conditions are true before showing a TRUE answer?
- A.
=AND()
- B.
=OR()
- C.
=Vlookup()
- D.
=If()
Correct Answer
A. =AND()Explanation
This function is used when you want to make sure that many conditions are fulfilled before showing a #TRUE# result.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, 2022Quiz Edited by
ProProfs Editorial Team -
Jan 10, 2008Quiz Created by
Dbone
Back to top