MGSC 290 Exam Questions with Verified Answers - Latest Update.

MGSC 290 Exam Questions with Verified
Answers | Latest Update
Question 1
which of the following groups all sheets in a workbook?
Correct Answer
right click any sheet tab and choose select all sheets



Question 2
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 3
which of the following functions finds the largest value in a range of cells
Correct Answer
MAX



Question 4
which of the following field validation rules prevents the user from typing 0 into a
field
Correct Answer
<>0




Page 1 of 40

,Question 5
which of the following commands lets you display a label on multiple lines within a
cell
Correct Answer
wrap text



Question 6
which of the following keystrokes are considered completion keys when executing
functions as array formulas

Correct Answer
Ctrl+Shift+Enter



Question 7
Which of the following statements is True
Correct Answer
The number of sheets you can insert in a workbook is limited only by the amount of
memory available



Question 8
by default what file extension is given to Excel 2016 workbook files
Correct Answer
.xlsx



Question 9
when troubleshooting a macro, which of the following should you do if the workbook
is protected
Correct Answer
unprotect the workbook before running or recording a macro




Page 2 of 40

,Question 10
which of the following functions counts the number of cells in a range that contain
any data type, text, or numbers
Correct Answer
COUNTA



Question 11
where is the take a screenshot command located
Correct Answer
insert tab, illustrations group



Question 12
which of the following commands should you use to prevent column and row
headings from scrolling off the screen
Correct Answer
freeze panes command



Question 13
how does excel treat criteria entered on the same row
Correct Answer
AND condition



Question 14
which of the following displays in a cell when you click the autosum
Correct Answer
=SUM()




Page 3 of 40

, Question 15
which of the following refers to the task of obtaining data from another software
program or another file format
Correct Answer
importing data



Question 16
which of the following is not a constant in the formula =45*B3-7
Correct Answer
B3



Question 17
What must you do to enter a number as a label in a cell
Correct Answer
Type an apostrophe before the number



Question 18
which of the following statements is not true about calculated fields
Correct Answer
a calculated field is a field in the source data



Question 19
as long as a workbook is open where are the macros avialable
Correct Answer
any open workbook



Question 20
which of the following is helpful for inserting formulas and editing data
Correct Answer
formula bar




Page 4 of 40