CGS 2518 EXAM 2 QUESTIONS WITH CORRECT ANSWERS

What tool is used to view existing range names?
(a)Name Box
(b)Scenario Manager
(c)Name Manager
(d)Solver


Give this one a try later!


c) Name Manager




After creating a blank PivotTable, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
(a)Filters area
(b)Columns area
(c)Values area
(d)Rows area

, Give this one a try later!


(c)Values area




A column contains names in uppercase, which is hard to read. Which function displays
the names where the first letter of each word is capitalized?
(a)INITIALCAPS
(b)LOWER
(c)PROPER
(d)TITLECASE


Give this one a try later!


(c)PROPER




The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?
(a)=YEAR(C1)
(b)=MONTH(C1)
(c)=DAYS(B1,C1)
(d)=DAY(C1)


Give this one a try later!


(d)=DAY(C1)




You created a PivotChart showing sales by quarter by sales rep. How do you remove
a sales rep from the chart without deleting the data?
(a)Make the employee's data points and axis titles invisible.
(b)You cannot delete the rep from the chart without first deleting the data.