MGSC 290 Exam Questions with 100% Correct Answers | Verified | Latest Update

MGSC 290 Exam Questions with 100%
Correct Answers | Verified | Latest Update
Which of the following function keys makes it easier to insert a range name in a
formula?
Correct Answer
F3



Question 2
Which of the following statements about circular references is false?
Correct Answer
a workbook cannot be saved with a circular reference



Question 3
Which of the following is True about data tables?
Correct Answer
By default, Excel does not include data tables with charts



Question 4
Which of the following features resizes column width or row height to accommodate
the width or height of the largest entry?
Correct Answer
AutoFit



Question 5
Which of the following functions calculates the net present value of an investment
using a discount rate and a series of future payments and receipts?
Correct Answer
NPV Function




Page 1 of 33

,Question 6
Which of the following can¿t be added to the Info pane in the Backstage view of a
Microsoft Excel file?
Correct Answer
timing



Question 7
Which of the following views lets you apply headers and footers and view the layout
of the spreadsheet prior to distribution?

Correct Answer
Page Layout view



Question 8
Which of the following displays after the file name in the title bar when worksheets
are grouped?
Correct Answer
Group



Question 9
When creating a cell hyperlink, which of the following is not true when selecting a
Place in this Document option?
Correct Answer
The Cell Reference and Defined Names groups cannot be expanded



Question 10
Which of the following keyboard shortcuts opens the Format Cells dialog box?
Correct Answer
Ctrl + 1




Page 2 of 33

,Question 11
Which of the following statements is not true for comments?
Correct Answer
Comments print by default



Question 12
When creating a consolidation worksheet, what must you do to the range of cells to
be consolidated?
Correct Answer
delete the contents



Question 13
Which of the following statements about SmartArt graphics is not true?
Correct Answer
A SmartArt Graphic is linked to worksheet data



Question 14
In an Excel table, which of the following contains descriptive titles or labels?
Correct Answer
header row



Question 15
Which function has one or more logical tests with corresponding results for each test?
Correct Answer
IFS




Page 3 of 33

, Question 16
Which of the following summarizes data from multiple worksheets using a
mathematical or statistical function?
Correct Answer
consolidate worksheet



Question 17
Which of the following is an example of a data visualization command?
Correct Answer
all of the above



Question 18
Which of the following is a horizontal or vertical boundary that identifies what is
plotted?
Correct Answer
axis



Question 19
Which of the following is not true when creating an error alert?
Correct Answer
Type a required title



Question 20
Which of the following statements is not true?
Correct Answer
You can hide a worksheet even if there is only one sheet in the workbook




Page 4 of 33