Spreadsheet Basic Functions! Trivia Quiz
10 Questions
| Total Attempts: 351
Do you have a perfect understanding of basic spreadsheet functions? Spreadsheets are mostly used to create budgets, produce graphs and charts, and for storing and sorting data in many organizations. This quiz is designed to assess mastery in the area of spreadsheet fundamentals. Do give it a try and get to see if you might need a refresher course when it comes to using this software application.
Questions and Answers
- 1.What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25% and her daily work count 50%?
- A.
Average
- B.
If
- C.
Max
- D.
Min
- 2.What function will display the word “Yes” when the value in cell A1 is greater than the value in Cell B1 and “No” when otherwise?
- A.
If
- B.
Lookup
- C.
Max
- D.
Min
- 3.Which function can an accounting department use in Cell A2 that will result in the current date?
- A.
Count
- B.
CountA
- C.
DAYS360
- D.
NOW
- 4.What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost?
- A.
Average
- B.
Max
- C.
Min
- D.
Sum
- 5.Which function can a credit card company use to determine the time that has elapsed since a customer’s payment was received?
- A.
Count
- B.
CountA
- C.
DAYS360
- D.
NOW
- 6.A spreadsheet is created with drop-down items that a user can select from. This is an example of which function?
- A.
Count
- B.
Fill Series
- C.
List
- D.
Lookup
- 7.What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?
- A.
Count
- B.
CountA
- C.
Fill Series
- D.
If
- 8.What operation will Eve use to keep rows and columns visible so that they don’t scroll off the screen as she moves around the worksheet?
- A.
Embed
- B.
Fill Series
- C.
Freeze Panes
- D.
Link
- 9.What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation?
- A.
Embed
- B.
Import
- C.
Link
- D.
Target
- 10.Mr. Evans sorted the student-athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation?
- A.
Ascending
- B.
Descending
- C.
Primary
- D.
Secondary
Matching questions on general concepts in spreadsheets.
Questions: 6 | Attempts: 2749 | Last updated: Mar 22, 2022
-
Sample QuestionTables in spreadsheets are better than tables in word processors because they
Spreadsheets are a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. Spreadsheets have been used by people to prepare budgets, charts, graphs and for storing data. The quiz...
Questions: 12 | Attempts: 2181 | Last updated: Mar 22, 2022
-
Sample QuestionWhat software application is the most effective tool to create charts of data?
Spreadsheet Formulas and Functions Quiz #3 from Atomic learning exercises
Questions: 15 | Attempts: 1396 | Last updated: Mar 22, 2022
-
Sample QuestionYou do not need to take the time to create a formula for specific set of cells you can use the ________ __________ to do it for you.
Back to top