Home
Subjects
Explanations
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
MIS 112 Midterm
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (60)
When a row of data is very ______ and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows
Wide
Different table formatting styles can be previewed by mousing over different options within "Table Styles" (i.e., you can see what the appearance will be like without actually applying a new style). Is this statement accurate?
Yes, the statement is accurate
You can use a data Form to add, find, and edit rows in a range or table. Is this correct?
Yes, all these are valid form operations
In an Excel Form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character?
Yes, the "?" symbol is used to find/match a single character
How many sort options/commands do we have in Excel under the 'Data' tab?
3
Which of the following types of Cell Formating can be achieved using the Format Cells feature of Excel?
All the other options are correct
(alignment, fill, protection)
Which of the following is TRUE about sorting a table?
Sorting a table re-arranges the rows based on the contents of a particular column.
Which of the following is an INVALID horizontal text alignment option provided in Excel?
Bottom
A formula refers to a value in the Total Row of a table. What will happen to the formula result if the option for "Total Row" (from the Excel ribbon: Table Tools / Design tab) is unchecked?
The formula returns an error.
Which of the following actions should be taken while creating a table to display Table Headers?
Check 'My table has headers'
For a range called Data, what does the function =COUNTIF(Data, "<>0") return?
number of cells not equal to 0
What does the following formula do? =COUNTIF(Data, TODAY())
Returns the number of cells containing the current date in the range named Data.
What will be the result of this formula =IF(A1<100000,A1
5%,A1
7.5%) , if the cell A1 has a value of 90000?
4500
The formula =COUNTIF(range, "
budget
") will count the number of cells in the specified range containing the word "budget" in certain positions within the text. Which of the following best describes the cells counted?
The word "budget" can appear anywhere within the cell.
cells_example.xlsx
Please see the attached workbook. What does the small red triangle on the upper right corner of cell B1 denote?
a comment exists for that cell
To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut: __________.
Shift+F2
What would you type in the Find and Replace dialog box (Home (tab) -> Editing (command group) -> Find & Select) to find all four-digit entries that begin with 5 and end with 2?
5??2
What does selecting the option "Current region" within the: Go To Special Dialog Box (Home (tab) -> Editing (command group) -> Find & Select) do?
Selects a rectangular range of cells around the active cell
DA_Test.xlsx
Examine the attached worksheet. Using the ANOVA: Single Factor Data Analysis Tool (available through the Analysis ToolPak Add-in) on A1:C6, which of the following options is the correct value for the p-value of the data in the worksheet?
0.00388865177938274
DA_Test.xlsx
Examine the attached worksheet. Using the Covariance Data Analysis Tool (available through the Analysis ToolPak Add-in) on A1:C6, which of the following options is the approximate value of the covariance coefficient for Control and Relaxation Therapy?
1
Which of the following is NOT one of the Excel functions to determine whether a cell contains an error value?
ISLOGICAL
formulas_sum_reference.xlsx
In the attached spreadsheet, please use an appropriate formula to compute the total of the Cells C2 through C11 (surrounded by a red border in the worksheet). What is this total?
14787.45
A formula in Excel can consist of which of the following?
all of the choices provided are valid
(text, cell references, and mathematical operators)
The formula in the attached image shows an example of which of the following?
circular reference warning
Consider the function =COUNTIF(A1:A200, ">200"). The information between the parentheses in a function are known as the ____________ .
arguments
Which of the following does the function =NOW() return?
current date and time
Which operator in Excel combines multiple range references into a single reference (e.g., if I want to sum up the values in non-contiguous cell-ranges across the worksheet)?
"," (comma)
Examine the image provided. What does the middle button (circled in red) in the row of "Paste Value" do?
Paste Values --> % 123
pastes values and number formatting
Which of the following shows the correct syntax for referencing cell "A2" in another worksheet?
=A1*Sheet2!A2
Which of the following is NOT an advantage of using defined range names to work with ranges in Excel?
Moving to areas of the worksheet is controlled
cells_image.png
Please examine the attached image. A part of the workbook is boxed in red.
Fill in the blanks:
The boxed area is called ____. What is displayed in this boxed area when a range of cells is selected? _______
Name box. The number of rows and columns in the selection is displayed here.
cells_sales.xlsx
Please see the attached workbook.
If you copy cell "B6" and paste it as a formula in cell "C6," will it produce the correct total for Year 2?
Yes, the formula range will be adjusted automatically
Which of the following is TRUE with respect to charts?
After you create a chart, you have great deal of flexibility in customizing it.
Which type of chart does not allow format changes to the Plot area?
None of the (other) options provided is correct
(Treemap, Bar chart, Thermometer chart)
Fill in the blank: Every chart type has a set of ____ that you can choose from (with settings for chart elements such as a title, data labels, axes, and so on).
Layouts
charts_example.xlsx
Examine the attached workbook. Which ribbon tab provides the option to resize charts? (e.g., change the height & width)
Format
PS2_Chart1
Please examine the attached workbook. The chart was created based on data in cells A1 through C6. If new data is added in cells A7 through C7, will the chart include the new data automatically?
No
What is the maximum number of characters a worksheet name can contain?
31
Which of the following is a VALID method of hiding rows or columns?
Home (ribbon tab), (then) Format (in the Cells group) --> Hide & Unhide (from the drop down list)
What are the minimum and maximum zoom ranges that can be displayed in an open Excel worksheet (respectively)?
10%, 400%
Which of the following characters is VALID for use in an Excel workbook file name?
_
Which of the following options scrolls the screen so that the active cell is visible?
Ctrl+Backspace
What is the primary purpose of "Protected View?"
Protect you from malware
In Row 2 (Col B), which of the following formatting types has been applied to "3419.25041" to make it appear as "$3,419.25" ?
Currency
In Excel, Shift + Spacebar (keyboard shortcut) is used to _______.
select a row
Is it possible to convert a cell with text data into a .png format ?
Yes
Which of the following methods is a VALID way to get into cell edit mode?
Selecting the cell that you want to edit, and then clicking in the Formula bar
In the attached Excel workbook PS1_Comments_Calculation.xlsx , which of the following formulas can be used to calculate Sophie's total score in both the exams?
=B4+C4
If you copy the whole cell "B8" (not only its formula) and paste it into cell "D8" (shaded in green), will it produce the correct total sales value for Quarter 3?
Yes
Which of the following formulas will display both the current date and time when entered into a cell in an Excel worksheet?
= NOW()
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel?
Ctrl + N
please refer to the figure. What Excel element is shown in the red box?
Quick Access toolbar
While comparing two sheets using the "View Side by Side" feature, there is an option which lets you scroll the two sheets in sync. What is that option called ?
Synchronous Scrolling
Please refer to the figure. Within the "Number" tab, how many categories are available for displaying numbers?
12
Please refer to the figure. In an Excel worksheet, what column name comes directly after Column Z?
AA
Please examine the attached workbook. Given the data in Sheet1, which of the following steps should be followed to obtain the data in Sheet2 ?
Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose
After pressing "Alt + H" while in an open Excel worksheet, a number of Key Tips are displayed. Which ribbon tab do these Key Tips relate to?
Home
Please refer to the figure. Which of the following Excel tabs is NOT visible in a worksheet by default?
Developer
Which of the following statements is true?
A workbook can have many worksheets.
Please refer to the figure. How many worksheets are contained in the workbook shown?
5
Sets with similar terms
MIS 111 LAB exam 1
69 terms
MIS 111L Final Exam Review
73 terms
MIS Problem Sets
53 terms
Problem Set Q's
111 terms
Other sets by this creator
BNAD Final Exam
41 terms
Metacognition
6 terms
MIS 111- Exam 1
100 terms
MIS 111- Exam 1
100 terms
Other Quizlet sets
Chapter 7: Real Estate Math (National)
20 terms
ACC chapter 12 questions from book
10 terms
CHP 3 LO3
16 terms
Anesthesia Week 2
34 terms