Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

CGS2518 > Exam 1 Multiple Choice > Flashcards

Exam 1 Multiple Choice Flashcards

(50 cards)

Start Studying
1
Q

Which step is not part of planning a worksheet design?

A

Enter labels, values and formulas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the period range. Which paste option would you select?

A

Values and Source Formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Given the formula =B1*B2+B3/B4^2, what operation is calculated first?

A

B4^2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How can you display formulas within the cells instead of the cell results?

A

Press Ctrl+

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a fast way to apply several formats at one time?

A

Apply a cell style

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which of the following is not an alignment option?

A

Fill Color

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which of the following characteristics is not applicable to the Accounting Number format?

A

Dollar sign immediately on the left side of the value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You selected and copied the worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?

A

Click the Past arrow in the Clipboard group and select Values & Source Formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Assume that the data on a worksheet consume a whole printed page and a couple of column on a second page. You can do all of the following except to force the data to print all on one page?

A

Increase the left and right margins

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What should you do if you see pound signs (###) instead of values or results of formulas?

A

Increase the column width

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

If cell E15 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in the formula?

A

Mixed reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

A

=AVERAGE(B5:F5)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

When you start to type =AV, what feature displays a list of functions and defined names?

A

Formula AutoComplete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?

A

=$B5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following functions should be used to insert the current date and time in a cell?

A

=NOW()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which of the following is not an argument of the IF function?

A

lookup_value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which of the following is not true about the VLOOKUP function?

A

the lookup table must be in descending order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

The function =PMT(C5,C7,-C3) is stored in C15. What must be stored in cell C5?

A

Periodic interest rate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which of the following is not an appropriate use of the SUM function?

A

=SUM(D15-C15)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the keyboard shortcut to create an absolute reference?

A

F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

22
Q

Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the category axis?

23
Q

Which of the following is not a type of sparkline?

24
Q

If you want to show exact values for a data series in a bar chart, which chart element should you display?

25
The value axis currently shows increments such as 50,000 and 100,000. What options would you select to display the values in increments of 50 and 100?
Show Axis in Thousands
26
You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs?
100% stacked column chart
27
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?
Click Switch Row/Column in the Data group on the Design Lab
28
What do you click to remove a data series from a chart so that you can focus on other data series?
Chart Filters
29
Which of the following does not display automatically when you create a clustered column chart?
Data labels
30
After you create a line type sparkline, what option should you select to display dots for each data point?
Markers
31
Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May 4, 2018) is stored in cell B2. You want to know how many days until the end of the semester. Which function should you use?
=DAYS(B2, B1)
32
The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should you use to extract just 12?
=DAY(C1)
33
Your workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out, Available if it is still readily available, or Limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out. What function would produce the same results as =OR(B1="Available", B1="Limited")?
=NOT(B1="Sold Out")
34
A workbook contains a list of members in the Computer Club. You want to identify the number of students who are freshmen who are Information Systems majors. Without filtering the dataset, what function should you use?
DCOUNT
35
A worksheet contains the times in which runners completed a race, with the times organized from fastest to slowest. You will use the MATCH function to identify what place a runner came in given a time of 4:05 (four minutes and five seconds). Which argument should contain the specific runner's time?
Lookup_value
36
What function would you use to calculate the total interest paid for the first year of a mortgage?
CUMIPMT
37
When you are performing an advanced filter, where do you enter the range for the dataset?
List range
38
The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to calculate the interest on the last monthly payment at the end of the 15th year. What value should be referenced for the per argument in the IPMT function?
180
39
A local police office wants to create a rule that if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record, the officer will fine the speeder the higher of $200 or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is entered in cell B5, the person's speed is entered in cell B10, and the person's number of previous tickets is entered in cell B11. What function derives the correct answer?
=IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)
40
What function would you use to calculate the total number of periods in a loan or investment?
NPER
41
A workbook contains sales information for the first quarter and you are interested in finding the total sales generated in January by the sales rep Jim Anderson. What function is best suited to handle the task?
SUMIFS
42
What function would you use to identify a value's rank as a percent, excluding 0 and 1?
PERCENTRANK.EXC
43
What does a negative COVARIANCE indicate?
an inverse relationship between the datasets
44
A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $674, $650, and $600. Using the RANK.AVG function that is considered a best practice, what is the rank of the third of the third values which are both 985?
None of the above (3.5)
45
What function would you use to calculate the strength of a relationship between two or more variables?
CORREL
46
You hypothesize that there is a relationship between lack of regular exercise and illness. To research this theory, you have complied a sample set of data that contains numbers of days in which an hour or more of exercise is completed as well as number of days sick within a calendar year. What tools in Excel could you use to investigate the relationships between the data?
CORREL
47
Which of the following functions has the ability to calculate the u(MU) of a dataset based on a user defined set of criteria?
AVERAGEIFS
48
What is the difference between STDEV.S and STDEV.P?
STDEV.S calculates standard deviation of a sample; STDEV.P calculates the standard deviation of a population
49
What is the difference between a sample and a population?
A population contains all data possible for evaluation, while a sample contains a portion of the data.
50
What keystroke combination is required to calculate a Frequency data array?
Ctrl+Shift+Enter

CGS2518 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions