FBLA: Spreadsheet Applications Quiz Questions!
7 Questions
| Total Attempts: 460
(132).jpg "FBLA: Spreadsheet Applications Quiz Questions! - Quiz")
What do you know about FBLA spreadsheet applications? Do you think you can pass this quiz? Regarding this quiz, you will be required to know which function returns the integer for the current date and time, what does the word mean to refer to as it relates to numbers, what does the count function count, and which function counts the empty cells. See how much you know about the FBLA spreadsheet application by taking this quiz.
Questions and Answers
- 1.The expression _____ returs the maximum value in the range A1:A100 and then divides the value by 100.
- A.
=MAX(A1:A100/100)
- B.
=MAX(100)/(A1:A100)
- C.
=MAX(A1:A100)/100
- D.
=MAXIMUM(A1:A100)/100
- 2.The _____ function returns the integer for the current date and time.
- A.
NOW()
- B.
CURRENT()
- C.
DATE()
- D.
TIME()
- 3.The ____ is the number in the middle of a collection of numbers.
- A.
Mean
- B.
Average
- C.
Mode
- D.
Median
- 4.Which of the following calculates the smallest in a collection of numbers?
- A.
LOW()
- B.
MIN()
- C.
SMALL()
- D.
COUNT()
- 5.What does the COUNT() function count?
- A.
Cell references
- B.
Formulas
- C.
Numbers
- D.
Text
- 6.What is a predefined formula that claculates by using arguments in a specific order?
- A.
Analyze
- B.
Range
- C.
AutoSum
- D.
Function
- 7.Which function merely counts the cells that are empty?
- A.
ADD
- B.
COUNTBLANK
- C.
COUNT
- D.
SUM
Questions: 22 | Attempts: 7486 | Last updated: Mar 22, 2022
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...
Questions: 10 | Attempts: 4505 | Last updated: Mar 22, 2022
-
Sample QuestionHow do you spell check an Excel worksheet?
A Data Analyst is skilled enough to translate numbers into comprehensible words and meanings of business data, sales and logistics. He collects the data and information and uses it to promote a company or help it make a...
Questions: 10 | Attempts: 3584 | Last updated: Mar 22, 2022
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?