INFSQUIZ2
docx
keyboard_arrow_up
School
University of Texas, Rio Grande Valley *
*We aren’t endorsed by this school
Course
3380
Subject
Mathematics
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by ColonelPencilShark7
Which of the following is
not
an arithmetic operator?
Selected Answer:
>=
A(n) ________ is a chart that fits entirely in one cell.
Selected Answer:
ro
w
Question 2
0 out of 1 points
The ________ function checks whether one or more conditions are met, and then returns a value corresponding to the first TRUE condition.
Selected Answer:
[None Given]
Question 3
0 out of 1 points
The values in parentheses in the SUM function (and other functions) are known as ________.
Selected Answer:
functio
n
Question 4
1 out of 1 points
The ________ command enables you to specify rows and columns that will be duplicated on each printed page.
Selected Answer:
Print Titles
Question 5
1 out of 1 points
Median is an example of a statistical function.
Selected Answer:
Tru
e
Question 6
1 out of 1 points
A logical test must return a true or false.
Selected Answer:
Tru
e
Question 7
1 out of 1 points
The IFS function, unlike the IF function, returns the first FALSE condition.
Selected Answer:
Fals
e
Question 8
0 out of 1 points
It is important, when using the IFS function, to include a default value that displays if none of the conditions are met.
Selected Answer:
Fals
e
Question 9
1 out of 1 points
The ________ is the temporary storage location for cell contents copied from a worksheet.
Selected Answer:
Clipboard
Question 10
1 out of 1 points
Which of the following is
not
a way to insert the SUM function into a cell?
Selected Answer:
Ctrl + =
Question 11
1 out of 1 points
What is an Excel table?
Selected Answer:
A series of rows and columns that contains related data that can be managed independently from other data in a worksheet
Question 12
1 out of 1 points
What is the keyboard shortcut for Flash Fill?
Selected Answer:
Ctrl + E
Question 13
1 out of 1 points
The COUNTIF function has two arguments: ________.
Selected Answer:
the range of cells to check and the criteria
Question 14
1 out of 1 points
The MEDIAN function finds ________.
Selected Answer:
the middle value in a range of cells
Question 15
0 out of 1 points
Which of the following is
not
considered a statistical function?
Selected Answer:
AVERAGE
Question 16
1 out of 1 points
In a large worksheet, which two Excel commands help to make the worksheets attractive and easier to read?
Selected Answer:
Print Titles and Scale to Fit
Question 17
0 out of 1 points
The COUNT function counts the number of cells in a range that ________.
Selected Answer:
contain a number or text
Question 18
1 out of 1 points
Which of the following is
false
about worksheet tabs?
Selected Answer:
The active worksheet tab displays in red font.
Question 19
1 out of 1 points
When using the Freeze Panes feature, what is a pane bounded by?
Selected Answer:
Vertical or horizontal bars
Question 20
1 out of 1 points
What is a summary sheet?
Selected Answer:
A worksheet where totals from other worksheets are displayed
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help