Question 32<\/p>
A form created from more than one table uses the primary table for the main form.<\/p>
True<\/p>
False<\/p>
Question 33<\/p>
The default query type for Access is the Crosstab query.<\/p>
True<\/p>
False<\/p>
Range names must begin with _____.<\/p>
<\/p>
a.<\/p>
a number<\/p>
<\/p>
b.<\/p>
a hash tag<\/p>
<\/p>
c.<\/p>
an asterisk<\/p>
<\/p>
d.<\/p>
a letter or an underscore<\/p>
Question 35<\/p>
Case-Based Critical Thinking Questions<\/p>
<\/p>
Case 7-1<\/p>
Ted knows that macros can be helpful to him in his work with Excel spreadsheets, but he also knows they have their hazards, so he comes to you for guidance about what kind of security settings he should put in place, and at what times.<\/p>
<\/p>
While just getting his feet wet with Excel, you suggest to Ted that he might want to begin without having his installation of Excel have any macros run at all. Which of the following options would he select in the Trust Center?<\/p>
<\/p>
a.<\/p>
Disable all macros without notification<\/p>
<\/p>
b.<\/p>
Cancel all macros<\/p>
<\/p>
c.<\/p>
Disable all macros except digitally signed macros<\/p>
<\/p>
d.<\/p>
Disable a macro with notification<\/p>
<\/p>
<\/p>
<\/p>
Question 36<\/p>
If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.<\/p>
<\/p>
a.<\/p>
#NULL<\/p>
<\/p>
b.<\/p>
#VALUE<\/p>
<\/p>
c.<\/p>
#ERROR<\/p>
<\/p>
d.<\/p>
#N\/A<\/p>
Question 37<\/p>
____ order arranges labels in reverse alphabetical order, from Z to A.<\/p>
<\/p>
a.<\/p>
Descending<\/p>
<\/p>
b.<\/p>
Reverse<\/p>
<\/p>
c.<\/p>
Major<\/p>
<\/p>
d.<\/p>
Ascending<\/p>
Question 38<\/p>
In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.<\/p>
<\/p>
a.<\/p>
rows and headers<\/p>
<\/p>
b.<\/p>
grids and columns<\/p>
<\/p>
c.<\/p>
rows and columns<\/p>
<\/p>
d.<\/p>
footers and grids<\/p>
Question 39<\/p>
If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.<\/p>
<\/p>
a.<\/p>
Done<\/p>
<\/p>
b.<\/p>
Good<\/p>
<\/p>
c.<\/p>
OK<\/p>
<\/p>
d.<\/p>
Completed<\/p>
Question 40<\/p>
The following are Excel-supported error alert types: _____.<\/p>
<\/p>
a.<\/p>
Security, Warning, and Alert<\/p>
<\/p>
b.<\/p>
Stop, Warning, and Alert<\/p>
<\/p>
c.<\/p>
Stop, Warning, and Information<\/p>
<\/p>
d.<\/p>
Alert, Warning, and Information<\/p>
<\/p>
<\/p>
Question 41<\/p>
If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled.<\/p>
<\/p>
a.<\/p>
Status Bar<\/p>
<\/p>
b.<\/p>
Mini toolbar<\/p>
<\/p>
c.<\/p>
Message Bar<\/p>
<\/p>
d.<\/p>
Quick Launch toolbar<\/p>
Question 42<\/p>
A table name cannot include ____.<\/p>
<\/p>
a.<\/p>
letters<\/p>
<\/p>
b.<\/p>
spaces<\/p>
<\/p>
c.<\/p>
numbers<\/p>
<\/p>
d.<\/p>
underscores<\/p>
Question 43<\/p>
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.<\/p>
<\/p>
a.<\/p>
ranges<\/p>
<\/p>
b.<\/p>
groups<\/p>
<\/p>
c.<\/p>
controls<\/p>
<\/p>
d.<\/p>
tabs<\/p>
Question 44<\/p>
Another name for the middle value is the ____ value.<\/p>
<\/p>
a.<\/p>
mode<\/p>
<\/p>
b.<\/p>
median<\/p>
<\/p>
c.<\/p>
center<\/p>
<\/p>
d.<\/p>
relative<\/p>
Question 45<\/p>
With the Last Quarter criteria filter, quarters are defined as, for example, ____.<\/p>
<\/p>
a.<\/p>
May, June, July<\/p>
<\/p>
b.<\/p>
April, May, June<\/p>
<\/p>
c.<\/p>
March, April, May, June<\/p>
<\/p>
d.<\/p>
March, April, May<\/p>
<\/p>
<\/p>
Question 46<\/p>
The amount of money being loaned is known as the ____.<\/p>
<\/p>
a.<\/p>
proposed principal<\/p>
<\/p>
b.<\/p>
loan amount<\/p>
<\/p>
c.<\/p>
mortgage<\/p>
<\/p>
d.<\/p>
principal<\/p>
Question 47<\/p>
A ________ contains the actual values that are plotted on the chart.<\/p>
<\/p>
a.<\/p>
data source<\/p>
<\/p>
b.<\/p>
category values<\/p>
<\/p>
c.<\/p>
data series<\/p>
<\/p>
d.<\/p>
legend<\/p>
Question 48<\/p>
PMT(rate<\/em>,nper<\/em>,pv<\/em>[,fv<\/em>=0] [,type<\/em>=0])<\/p> <\/p> In the figure above,fv<\/em>andtype<\/em>are ____.<\/p> <\/p> a.<\/p> optional arguments<\/p> <\/p> b.<\/p> required arguments<\/p> <\/p> c.<\/p> comparison operators<\/p> <\/p> d.<\/p> financial functions<\/p> Question 49<\/p> When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.<\/p> <\/p> a.<\/p> source<\/p> <\/p> b.<\/p> destination<\/p> <\/p> c.<\/p> both a. and b.<\/p> <\/p> d.<\/p> neither a. nor b.<\/p> Question 50<\/p> Which of the following is NOT a valid defined name?<\/p> <\/p> a.<\/p> NetIncome<\/p> <\/p> b.<\/p> Net_Income<\/p> <\/p> c.<\/p> Net-Income<\/p> <\/p> d.<\/p> netincome<\/p> <\/p> <\/p> Question 51<\/p> Each time you make a conditional format, you are defining a conditional formatting _____.<\/p> <\/p> a.<\/p> rule<\/p> <\/p> b.<\/p> condition<\/p> <\/p> c.<\/p> object<\/p> <\/p> d.<\/p> theme<\/p> Question 52<\/p> The COUNTIF function is sometimes referred to as a(n) _____ count.<\/p> <\/p> a.<\/p> network<\/p> <\/p> b.<\/p> criterion<\/p> <\/p> c.<\/p> basic<\/p> <\/p> d.<\/p> conditional<\/p> Question 53<\/p> The Conditional Formatting button provides access to the _____.<\/p> <\/p> a.<\/p> Criteria option<\/p> <\/p> b.<\/p> Manage Rules option<\/p> <\/p> c.<\/p> Replicate Values conditional format<\/p> <\/p> d.<\/p> Organize Rules option<\/p> Question 54<\/p> If all of the logical conditions are true, the AND function returns the logical value _____.<\/p> <\/p> a.<\/p> FALSE<\/p> <\/p> b.<\/p> ON<\/p> <\/p> c.<\/p> OFF<\/p> <\/p> d.<\/p> TRUE<\/p> Question 55<\/p> With the DATEDIF function, the _____ interval code means months.<\/p> <\/p> a.<\/p> m<\/p> <\/p> b.<\/p> mo<\/p> <\/p> c.<\/p> mth<\/p> <\/p> d.<\/p> mon<\/p> <\/p> <\/p> Question 56<\/p> AutoFit changes the column width or row height to display the longest or tallest entry within the column or row._________________________<\/p> <\/p> True<\/p> False<\/p> Question 57<\/p> To set a page break in Excel, select the _____.<\/p> <\/p> a.<\/p> row above where you want to insert a page break<\/p> <\/p> b.<\/p> first cell above the row where you want to insert a page break<\/p> <\/p> c.<\/p> first cell below the row where you want to insert a page break<\/p> <\/p> d.<\/p> row below where you want to insert a page break<\/p> Question 58<\/p> Akeyboard shortcutis a key or combination of keys that you press to access a feature or perform a command. _________________________<\/p> True<\/p> False<\/p> Question 59<\/p> When you insert a new row, the existing rows are shifted down and the new row has the samewidthas the row above it. _________________________<\/p> True<\/p> False<\/p> Question 60<\/p> A common business practice is to include a worksheet namedDocumentationthat contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. _________________________<\/p> True<\/p> False<\/p> <\/p> Question 61<\/p> To move the active cell up one row, press ____.<\/p> <\/p> a.<\/p> Ctrl + Tab<\/p> <\/p> b.<\/p> Shift + Enter<\/p> <\/p> c.<\/p> Shift + Tab<\/p> <\/p> d.<\/p> Ctrl + Enter<\/p> Question 62<\/p> Case Based Critical-Thinking Questions<\/p> <\/p> Case 2-1<\/p> Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation.<\/p> <\/p> <\/p> <\/p> Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.<\/p> <\/p> a.<\/p> type the data in A1 and Merge cells A1:A5<\/p> <\/p> b.<\/p> type the data in any column in row 1 and then choose Center from the Format menu<\/p> <\/p> c.<\/p> type the data in C1<\/p> <\/p> d.<\/p> type the data in A1 and Merge cells A1:E1<\/p> Question 63<\/p> The characters +, -, *, and \/ are examples of ____.<\/p> <\/p> a.<\/p> arithmetic operators<\/p> <\/p> b.<\/p> calculations<\/p> <\/p> c.<\/p> formulas<\/p> <\/p> d.<\/p> values<\/p>",
"transcribed_text": "",
"related_book": {
"title": "Auditing and Assurance Services",
"isbn": "978-1259197109, 77632281, 77862341, 1259197107, 9780077632281, 978-0077862343",
"edition": "6th edition",
"authors": "Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws",
"cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/332.jpg",
"uri": "\/textbooks\/auditing-and-assurance-services-6th-edition-332",
"see_more_uri": ""
},
"free_related_book": {
"isbn": "0198557671",
"uri": "\/textbooks\/fractals-in-chemistry-1st-edition-9780198557678",
"name": "Fractals In Chemistry",
"edition": "1st Edition"
},
"question_posted": "2024-06-13 00:12:33",
"see_more_questions_link": "\/study-help\/questions\/business-management-leadership-2023-June-05",
"step_by_step_answer": "The Answer is in the image, click to view ...",
"students_also_viewed": [
{
"url": "\/refer-to-the-data-of-exercise-349-in-exercise-a-estimate-the",
"description": "Refer to the data of Exercise 3.49. In exercise a. Estimate the interquartile range and the sample standard deviation. b. Which measure of variation would you recommend using as a measure of the...",
"stars": 3
},
{
"url": "\/study-help\/starting-out-with-java-from-control-structures\/write-a-program-that-declares-the-following-a-string-variable",
"description": "Write a program that declares the following: A String variable named name An int variable named age A double variable named annual Pay Store your age, name, and desired annual income as literals...",
"stars": 3
},
{
"url": "\/study-help\/psychology\/if-you-were-a-clinical-psychologist-practicing-cognitive-therapy-which-1983878",
"description": "If you were a clinical psychologist practicing cognitive therapy, which of Albert Elliss ABCDE columns would you expect clients to have the most trouble filling in?",
"stars": 3
},
{
"url": "\/beth-electronics-makes-cd-players-in-three-processes-assembly-programming",
"description": "Beth Electronics makes CD players in three processes: assembly, programming, and packaging. Direct materials are added at the beginning of the assembly process. Conversion costs are incurred evenly...",
"stars": 3
},
{
"url": "\/study-help\/questions\/e519-algo-calculating-contribution-margin-and-contribution-ratio-preparing-contribution-9840738",
"description": "E5-19 (Algo) Calculating Contribution Margin and Contribution Ratio, Preparing Contribution Margin Income Statement (LO 5-5] Riverside Inc. makes one model of wooden canoe. Partial information for it...",
"stars": 3
},
{
"url": "\/study-help\/questions\/john-and-paul-are-stranded-on-a-deserted-island-where-5368892",
"description": "John and Paul are stranded on a deserted island where they survive by catching fish and picking coconuts. In one day John can catch 5 fish OR pick 15 coconuts or he can divide his time between the...",
"stars": 3
},
{
"url": "\/study-help\/questions\/mike-was-the-policy-owner-and-life-insured-of-a-2002211",
"description": "Mike was the policy owner and life insured of a 20-year term life insurance policy, with a $500,000 face value, on which he had named his spouse, Rachel, as the beneficiary. Unfortunately, Mike was...",
"stars": 3
},
{
"url": "\/study-help\/questions\/sheridan-co-issued-700000-of-5year6-bonds-at-96-on-1998749",
"description": "sheridan co issued 700,000 of 5-year,6% bonds at 96 on Jan 1 2027. the bonds pay interest annually. compute the total cost of borrowing for these bonds compute the total cost of borrowing for these...",
"stars": 3
},
{
"url": "\/study-help\/questions\/endor-company-begins-the-year-with-180000-of-goods-in-1808897",
"description": "Endor Company begins the year with $180,000 of goods in inventory. At year-end, the amount in inventory has increased to $197,000. Cost of goods sold for the year is $1,300,000. Compute Endor's...",
"stars": 3
},
{
"url": "\/study-help\/questions\/the-finishing-department-of-the-maherajah-competition-water-ski-company-1463064",
"description": "The Finishing Department of the Maherajah Competition Water Ski Company has the following production and cost data for May 2022: 1. Transferred out: 2,155 water skis. 2. Ending work in process: 625...",
"stars": 3
},
{
"url": "\/study-help\/questions\/using-technology-it-was-determined-that-the-total-sum-of-1372451",
"description": "Using technology, it was determined that the total sum of squares (SST) was 819.2, the sum of squares regression (SSR) was 794.19, and the sum of squares due to error (SSE) was 25.013. Calculate R2...",
"stars": 3
},
{
"url": "\/study-help\/questions\/the-first-step-for-a-congregation-to-begin-supporting-ministry-4725845",
"description": "the first step for a congregation to begin supporting ministry leaders",
"stars": 3
}
],
"next_back_navigation": {
"previous": "\/study-help\/questions\/you-have-been-put-in-charge-of-hiring-for-new-2877169",
"next": "\/study-help\/questions\/watch-httpswwwtedcomtalksstefangrossselbeckbusinessmodelinnovationbeatingyourselfatyourowngame-and-reflect-on-how-his-insights-with-topics-2877171"
},
"breadcrumbs": [
{
"name": "Study help",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers"
},
{
"name": "Business",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business"
},
{
"name": "Economics",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-economics"
},
{
"name": "Question 32 A form created from more than one table uses the",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions\/question-32-a-form-created-from-more-than-one-table-2877170"
}
],
"skill_details": {
"skill_id": "12",
"skill_name": "Economics",
"parent_id": "1"
}
}}
}